using System;
using System.Data;
using System.Linq;
using System.Web.UI;
using System.Web.UI.WebControls;
using SuperMap.RealEstate.CoreFrameWork;
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.SendRec.Storage.Business;
using StorageHighWay = SuperMap.RealEstate.HighWay.Storage.Business;

namespace SuperMap.RealEstate.SendRec.Modules.PrintBill
{
    /// <summary>
    /// T_APPLYPROINST_申请 的WebUserControl
    /// <summary>
    public partial class APPLYPROINST : UserControl<Business.APPLYPROINST>
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack) return;
            if (Request["ID"] != null)
            {
                Business.APPLYPROINST _APPLYPROINST = new Business.APPLYPROINST(this.Transaction);
                _APPLYPROINST.APPLYPROINST_ID_Encrypt = Request["ID"];
                if (_APPLYPROINST.Select())
                {
                    string DataTableName = string.Empty;
                    switch (_APPLYPROINST.APPLYPROINST_TYPE)
                    {
                        case 1000:
                            DataTableName = "APPLYCOMMODITY";
                            break;
                        case 2000:
                        case 3000:
                            DataTableName = "RECCOMMODITY";
                            break;
                    }
                    DataTable dt = _APPLYPROINST.ExecuteDataTable("SELECT COUNT(DISTINCT " + DataTableName +
                        "_ID),NVL(SUM(UNITCOUNT * PURCHASE_COUNT),0),NVL(SUM(UNITCOUNT * PURCHASE_COUNT * PURCHASE_PRICE),0)" +
                        " FROM SENDREC_STORAGE.T_" + DataTableName + " WHERE APPLYPROINST_ID = " + _APPLYPROINST.APPLYPROINST_ID);
                    RECORD_COUNT.Text = dt.Rows[0][0].ToString();
                    TOTAL_AMOUNT.Text = dt.Rows[0][1].ToString();
                    PURCHASE_TOTALPRICE.Text = dt.Rows[0][2].ToString();
                }
            }
        }

        //在此加入界面的数据初始化(Page_Load之前)，如DropDownList的数据源绑定等
        public override void InitializeWebControl()
        {
            APPLYPROINST_TYPE.Clear();
            DictionaryHelper.BindingDropDownList("APPLYPROINST_TYPE", APPLYPROINST_TYPE.Items, this.Transaction);

            SERVERPART_ID.Clear();
            ListItemEx _ListItemEx = null;
            //ListItemEx _ListItemEx = new ListItemEx();
            //_ListItemEx.Text = StorageHighWay.CommonHelper.GetConfigValue("topCompanyName");
            //_ListItemEx.Value = "0";
            //SERVERPART_ID.Items.Add(_ListItemEx);
            foreach (StorageHighWay.SERVERPART _SERVERPART in (new StorageHighWay.SERVERPART(this.Transaction)).GetPassportServerPart(Page.PassportInfo.CityAuthority))
            {
                _ListItemEx = new ListItemEx();
                _ListItemEx.Text = _SERVERPART.SERVERPART_NAME;
                _ListItemEx.Value = _SERVERPART.SERVERPART_ID.ToString();
                SERVERPART_ID.Items.Add(_ListItemEx);
            }
        }
        
        //载入数据
        public override bool LoadData()
        {

            APPLYPROINST_DATE.Text = System.DateTime.Now.ToString();

            PASSPORT_NAME.Text = Page.PassportInfo.Name;

            PASSPORT_ID.Text = Page.PassportInfo.ID.ToString();

            APPLYPROINST_STATE.Text = "1000";

            APPLYPROISNT_FLAG.Text = "0";

            
            //如果是工作流组件请自行修改载入的逻辑，以下是功能模块的默认代码
            if (!String.IsNullOrEmpty(Request["ID"]))
            {
               
                CurrObject.APPLYPROINST_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.APPLYPROINST> e)
        {
            base.OnDataAction_BeforeSave(e);
        }


        public override bool SaveEx(ClientSetEventArgs ClientSet)
        {
            bool flag = base.SaveEx(ClientSet);
            
            return flag;
        }
    }
}