125 lines
5.2 KiB
C#
125 lines
5.2 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 MTEM = SuperMap.RealEstate.MainTenance.Storage.Business;
|
||
|
||
namespace SuperMap.RealEstate.MainTenance.Storage
|
||
{
|
||
/// <summary>
|
||
/// T_EQUIPMENTMANAGE_ 的WebUserControl
|
||
/// <summary>
|
||
public partial class EQUIPMENTMANAGE : UserControl<Business.EQUIPMENTMANAGE>
|
||
{
|
||
protected void Page_Load(object sender, EventArgs e)
|
||
{
|
||
}
|
||
|
||
//在此加入界面的数据初始化(Page_Load之前)，如DropDownList的数据源绑定等
|
||
public override void InitializeWebControl()
|
||
{
|
||
|
||
//绑定经销商
|
||
//DEALER_ID.Items.Clear();
|
||
//DEALER_ID.Items.Add(new ListItemEx("请选择", "1=1"));
|
||
this.DEALER_ID.Items.Clear();
|
||
this.DEALER_ID.Items.Add(new ListItemEx
|
||
{
|
||
Value = "",
|
||
Text = ""
|
||
});
|
||
foreach (DataRow _DataRow in new MTEM.EQUIPMENTMANAGE(Transaction).ExecuteDataTable(
|
||
@"SELECT WM_CONCAT(MERCHANTS_ID) AS MERCHANTS_ID,MERCHANTS_NAME FROM HIGHWAY_STORAGE.T_MERCHANTS A
|
||
WHERE MERCHANTS_STATE = 1 GROUP BY MERCHANTS_NAME").Select("", "MERCHANTS_NAME"))
|
||
{
|
||
ListItemEx _ListItemEx = new ListItemEx();
|
||
_ListItemEx.Text = _DataRow["MERCHANTS_NAME"].ToString();
|
||
_ListItemEx.Value = _DataRow["MERCHANTS_ID"].ToString();
|
||
DEALER_ID.Items.Add(_ListItemEx); //经销商
|
||
}
|
||
//绑定生产商
|
||
this.MANUFACTRER_ID.Items.Clear();
|
||
this.MANUFACTRER_ID.Items.Add(new ListItemEx
|
||
{
|
||
Value = "",
|
||
Text = ""
|
||
});
|
||
foreach (DataRow _DataRow in new MTEM.EQUIPMENTMANAGE(Transaction).ExecuteDataTable(
|
||
@"SELECT WM_CONCAT(MERCHANTS_ID) AS MERCHANTS_ID,MERCHANTS_NAME FROM HIGHWAY_STORAGE.T_MERCHANTS A
|
||
WHERE MERCHANTS_STATE = 1 GROUP BY MERCHANTS_NAME").Select("", "MERCHANTS_NAME"))
|
||
{
|
||
ListItemEx _ListItemEx = new ListItemEx();
|
||
_ListItemEx.Text = _DataRow["MERCHANTS_NAME"].ToString();
|
||
_ListItemEx.Value = _DataRow["MERCHANTS_ID"].ToString();
|
||
MANUFACTRER_ID.Items.Add(_ListItemEx); //生产商
|
||
}
|
||
|
||
|
||
//设备类别
|
||
EQUIPMENT_TYPE.Clear();
|
||
DictionaryHelper.BindingDropDownList("EQUIPMENT_TYPE", EQUIPMENT_TYPE.Items, this.Transaction);
|
||
//设备标识
|
||
EQUIPMENT_IDENTIFI.Clear();
|
||
DictionaryHelper.BindingDropDownList("EQUIPMENT_IDENTIFI", EQUIPMENT_IDENTIFI.Items, this.Transaction);
|
||
|
||
///设备状态
|
||
//EQUIPMENTMANAGE_STATE.Clear();
|
||
//DictionaryHelper.BindingDropDownList("isvalid", EQUIPMENTMANAGE_STATE.Items, this.Transaction);
|
||
//EQUIPMENTMANAGE_STATE.SelectedValue = "1";
|
||
|
||
//获得服务区信息
|
||
Business.CommonHelper.BindingServerDropDownList(SERVERPART_ID.Items, Page.PassportInfo, 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.EQUIPMENTMANAGE_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.EQUIPMENTMANAGE> 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;//服务区名
|
||
//e.CurrObject.SERVERPART_ID = Convert.ToInt32(SERVERPART_ID.SelectedValue);//操作人员赋值
|
||
//给生产商名字赋值
|
||
if (MANUFACTRER_ID.SelectedValue != "")
|
||
{
|
||
e.CurrObject.MANUFACTRER_NAME = MANUFACTRER_ID.SelectedItem.Text;
|
||
}
|
||
//给经销商名字赋值
|
||
if (DEALER_ID.SelectedValue != "")
|
||
{
|
||
e.CurrObject.DEALER_NAME = DEALER_ID.SelectedItem.Text;
|
||
}
|
||
base.OnDataAction_BeforeSave(e);
|
||
}
|
||
}
|
||
}
|