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);
        }
    }
}