134 lines
5.8 KiB
C#
134 lines
5.8 KiB
C#
using System;
|
||
using System.Data;
|
||
using System.Linq;
|
||
using System.Web.UI;
|
||
using System.Web.UI.WebControls;
|
||
using SuperMap.RealEstate.CoreFrameWork;
|
||
using SuperMap.RealEstate.CoreFrameWork.Dictionary.Business;
|
||
using SuperMap.RealEstate.ServiceModel;
|
||
using SuperMap.RealEstate.Utility;
|
||
using SuperMap.RealEstate.Web.UI;
|
||
using SuperMap.RealEstate.Web.UI.WebControls;
|
||
using SuperMap.RealEstate.Web.Utility;
|
||
using Business = SuperMap.RealEstate.MainTenance.Storage.Business;
|
||
|
||
namespace SuperMap.RealEstate.MainTenance.Storage
|
||
{
|
||
/// <summary>
|
||
/// T_EQUIPMENTREPERTORY_ 的WebUserControl
|
||
/// <summary>
|
||
public partial class EQUIPMENTREPERTORY : UserControl<Business.EQUIPMENTREPERTORY>
|
||
{
|
||
private string Equipments = string.Empty;
|
||
|
||
protected void Page_Load(object sender, EventArgs e)
|
||
{
|
||
foreach (DataRow _DataRow in new Business.EQUIPMENTREPERTORY(Transaction).ExecuteDataTable(
|
||
@"SELECT WM_CONCAT(EQUIPMENTMANAGE_ID) AS EQUIPMENTMANAGE_ID,EQUIPMENT_NAME
|
||
FROM MAINTENANCE_STORAGE.T_EQUIPMENTMANAGE A
|
||
WHERE EQUIPMENTMANAGE_STATE = 1 AND SERVERPART_ID = " + SERVERPART_ID.SelectedValue +
|
||
" GROUP BY EQUIPMENT_NAME").Select("", "EQUIPMENT_NAME"))
|
||
{
|
||
ListItemEx _ListItemEx = new ListItemEx();
|
||
_ListItemEx.Text = _DataRow["EQUIPMENT_NAME"].ToString();
|
||
_ListItemEx.Value = _DataRow["EQUIPMENTMANAGE_ID"].ToString();
|
||
EQUIPMENT_ID.Items.Add(_ListItemEx);
|
||
}
|
||
if (CurrObject != null && CurrObject.EQUIPMENT_ID != null)
|
||
{
|
||
EQUIPMENT_ID.SelectedValue = CurrObject.EQUIPMENT_ID.ToString();
|
||
}
|
||
}
|
||
|
||
//在此加入界面的数据初始化(Page_Load之前)，如DropDownList的数据源绑定等
|
||
public override void InitializeWebControl()
|
||
{
|
||
//获得服务区信息
|
||
Business.CommonHelper.BindingServerDropDownList(SERVERPART_ID.Items, Page.PassportInfo, Transaction);
|
||
|
||
//绑定部门
|
||
Business.CommonHelper.BindingTypeDropDownList(USERDEPARTMENT_ID.Items, Transaction, "-1", 0);
|
||
|
||
#region 关联部门时传参以及赋值
|
||
if (!string.IsNullOrEmpty(Request["DEPARTMENT_ID"]))
|
||
{
|
||
USERDEPARTMENT_ID.SelectedValue = Request["DEPARTMENT_ID"].ToDecrypt();
|
||
// USERDEPARTMENT_ID.SelectedValue = "15";
|
||
}
|
||
if (!string.IsNullOrEmpty(Request["DEPARTMENT_NAME"]))
|
||
{
|
||
USERDEPARTMENT_NAME.Text = Request["DEPARTMENT_NAME"].ToDecrypt();
|
||
}
|
||
#endregion
|
||
|
||
///库存状态
|
||
EQUIPMENTREPERTORY_STATE.Clear();
|
||
DictionaryHelper.BindingDropDownList("isvalid", EQUIPMENTREPERTORY_STATE.Items, this.Transaction);
|
||
EQUIPMENTREPERTORY_STATE.SelectedValue = "1";
|
||
|
||
//使用状况
|
||
USER_CONDITION.Clear();
|
||
DictionaryHelper.BindingDropDownList("USER_CONDITION", USER_CONDITION.Items, this.Transaction);
|
||
|
||
//折旧方法
|
||
DEPRECIATION_METHOD.Clear();
|
||
DictionaryHelper.BindingDropDownList("DEPRECIATION_METHOD", DEPRECIATION_METHOD.Items, this.Transaction);
|
||
if (string.IsNullOrEmpty(Request["ID"]))
|
||
{
|
||
STAFF_NAME.Text = Page.PassportInfo.Name;
|
||
OPERATE_DATE.Text = DateTime.Now.ToShortDateString();
|
||
}
|
||
}
|
||
|
||
//载入数据
|
||
public override bool LoadData()
|
||
{
|
||
//如果是工作流组件请自行修改载入的逻辑，以下是功能模块的默认代码
|
||
if (!String.IsNullOrEmpty(Request["ID"]))
|
||
{
|
||
CurrObject.EQUIPMENTREPERTORY_ID_Encrypt = Request["ID"];
|
||
return this.Select();
|
||
}
|
||
//默认返回值，工作流组件返回True,功能模块返回False。
|
||
return (WorkFlowPage != null);
|
||
}
|
||
|
||
//OnDataAction_XXXXX 有一个系列可用,在此加入界面的逻辑处理
|
||
//e.CancelDataAction 来处理是否取消该动作;
|
||
//失败的原因可以用Page.Alert()传递到页面
|
||
public override void OnDataAction_BeforeSave(DataActionEventArgs<Business.EQUIPMENTREPERTORY> e)
|
||
{
|
||
e.CurrObject.OPERATE_DATE = DateTime.Now;
|
||
e.CurrObject.STAFF_ID = Page.PassportInfo.ID;
|
||
e.CurrObject.STAFF_NAME = Page.PassportInfo.Name;
|
||
e.CurrObject.SERVERPART_NAME = SERVERPART_ID.SelectedItem.Text;//服务区名
|
||
if (EQUIPMENT_ID.SelectedValue != "")
|
||
{
|
||
e.CurrObject.EQUIPMENT_NAME = EQUIPMENT_ID.SelectedItem.Text;
|
||
}
|
||
if (USERDEPARTMENT_ID.SelectedValue != "")
|
||
{
|
||
e.CurrObject.USERDEPARTMENT_NAME = USERDEPARTMENT_ID.SelectedItem.Text;
|
||
}
|
||
base.OnDataAction_BeforeSave(e);
|
||
}
|
||
|
||
protected void SERVERPART_ID_CallBackSetControl(object sender, ClientSetEventArgs e)
|
||
{
|
||
EQUIPMENT_ID.Items.Clear();
|
||
foreach (DataRow _DataRow in new Business.EQUIPMENTREPERTORY(Transaction).ExecuteDataTable(
|
||
@"SELECT WM_CONCAT(EQUIPMENTMANAGE_ID) AS EQUIPMENTMANAGE_ID,EQUIPMENT_NAME
|
||
FROM MAINTENANCE_STORAGE.T_EQUIPMENTMANAGE A
|
||
WHERE EQUIPMENTMANAGE_STATE = 1 AND SERVERPART_ID = " + SERVERPART_ID.SelectedValue +
|
||
" GROUP BY EQUIPMENT_NAME").Select("", "EQUIPMENT_NAME"))
|
||
{
|
||
ListItemEx _ListItemEx = new ListItemEx();
|
||
_ListItemEx.Text = _DataRow["EQUIPMENT_NAME"].ToString();
|
||
_ListItemEx.Value = _DataRow["EQUIPMENTMANAGE_ID"].ToString();
|
||
EQUIPMENT_ID.Items.Add(_ListItemEx);
|
||
}
|
||
e.SetDropDownListEx(EQUIPMENT_ID);
|
||
}
|
||
}
|
||
}
|