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 { /// /// T_EQUIPMENTMANAGE_ 的WebUserControl /// public partial class EQUIPMENTMANAGE : UserControl { 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 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); } } }