using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using GThinking.N_MISPRO;
using GThinking.N_MISPRO.Data;
using GThinking.N_MODEL.Page;
using GThinking.N_MISPRO.Utility;
using GThinking.N_PUBLIC;
using System.Collections.Generic;


namespace GThinking.N_XLXSBJ
{
    public partial class XLBJD_BJSMInfo : SingleCardBase
    {
        XLBJD_BJSM entity = new XLBJD_BJSM();
        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860000;
            this.UMName = "线缆销售报价单";
            this.CurMaster = Master;
            this.CurEntity = entity;
            this.PageHeight = 400;
            this.PageWidth = 500;

            Master.EnableAttachBtn = false;
            Master.EnableCancelBtn = false;
            Master.EnableCopyBtn = false;
            Master.EnableDeleteBtn = false;
            Master.EnableEditBtn = false;
            Master.EnableInsertBtn = false;
            Master.EnablePrintBtn = false;
            Master.EnableRefreshBtn = false;
            Master.EnableSaveBtn = false;

            base.InitPage();

            if (!IsPostBack)
            {
                if (this.PageHeight > 400)
                    txtBJSM.Height = Unit.Parse(Convert.ToString(this.PageHeight - 400 + 270) + "px");
                if (this.PageWidth == 500)
                {
                    cbxCYSM.Width = Unit.Parse(Convert.ToString(NumberUtils.RoundX((this.PageWidth - 80) * txtBJSM.Width.Value / 100, 0) + 10) + "px");
                }
                else
                {
                    cbxCYSM.Width = Unit.Parse(Convert.ToString(NumberUtils.RoundX((this.PageWidth - 80) * txtBJSM.Width.Value / 100, 0) - 7) + "px");
                }
            }

            if (!IsPostBack)
            {
                InitControl();
            }
        }

        #region 模板继承事件

        protected override void SetControlState()
        {
            base.SetControlState();
            if (PageParam.GetRTrimString("CanEdit").Equals("Y"))
            {
                btnQR.Visible = true;
                btnQX.Visible = true;
                cbxCYSM.Enabled = true;
                txtBJSM.Enabled = true;
            }
            else
            {
                btnQR.Visible = false;
                btnQX.Visible = false;
                cbxCYSM.Enabled = false;
                txtBJSM.Enabled = false;
            }
        }

        #endregion

        #region 自定义函数

        private void InitControl()
        {
            string sBJDID = PageParam.GetRTrimString("BJDID").Trim();
            string sKH = PageParam.GetRTrimString("KHMC").Trim();
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            SQL.Clear();
            SQL.Add("select XLXSBJD_BJSM from XLXSBJD where XLXSBJD_BJDID = :pBJDID");
            SQL.ParamByName("pBJDID").Value = sBJDID;
            DataSet ds = dberp.OpenDataSet(SQL);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (!ds.Tables[0].Rows[0]["XLXSBJD_BJSM"].ToString().Trim().Equals(""))
                {
                    txtBJSM.Text = ds.Tables[0].Rows[0]["XLXSBJD_BJSM"].ToString().Trim();
                }
                else
                {
                    SQL.Clear();
                    SQL.Add(" select XLXSBJSM_SMID,XLXSBJSM_SMZT,XLXSBJSM_SMNR from XLXSBJSM where XLXSBJSM_MRBZ = 'Y' and XLXSBJSM_ZDM = 'BJSM' ");
                    SQL.Add(" and (isnull(XLXSBJSM_KH,' ')=' ' or isnull(XLXSBJSM_KH,' ')='" + sKH.Trim() + "') ");
                    SQL.Add(" order by isnull(XLXSBJSM_KH,' ') desc ");
                    ds = dberp.OpenDataSet(SQL);
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        cbxCYSM.SelectedValue = ds.Tables[0].Rows[0]["XLXSBJSM_SMID"].ToString().Trim();
                        txtBJSM.Text = ds.Tables[0].Rows[0]["XLXSBJSM_SMNR"].ToString().Trim();
                    }
                }
            }
            else
            {
                SQL.Clear();
                SQL.Add("select XLXSBJSM_SMID,XLXSBJSM_SMZT,XLXSBJSM_SMNR from XLXSBJSM where XLXSBJSM_MRBZ = 'Y' and XLXSBJSM_ZDM = 'BJSM' ");
                SQL.Add(" and (isnull(XLXSBJSM_KH,' ')=' ' or isnull(XLXSBJSM_KH,' ')='" + sKH.Trim() + "') ");
                SQL.Add(" order by isnull(XLXSBJSM_KH,' ') desc ");
                ds = dberp.OpenDataSet(SQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    cbxCYSM.SelectedValue = ds.Tables[0].Rows[0]["XLXSBJSM_SMID"].ToString().Trim();
                    txtBJSM.Text = ds.Tables[0].Rows[0]["XLXSBJSM_SMNR"].ToString().Trim();
                }
            }

            string sSQL = " SELECT XLXSBJSM_SMID,case isnull(XLXSBJSM_SMZT,' ') when ' ' then rtrim(XLXSBJSM_SMID)||'|'||'未填写说明主题' else rtrim(XLXSBJSM_SMID)||'|'||XLXSBJSM_SMZT end as SMZT FROM XLXSBJSM ";
            sSQL += "where 1=1 and XLXSBJSM_ZDM ='BJSM' ";
            sSQL += "and (isnull(XLXSBJSM_KH,' ')=' ' or isnull(XLXSBJSM_KH,' ')='" + sKH.Trim() + "') ";
            sSQL += "order by isnull(XLXSBJSM_KH,' ') desc,XLXSBJSM_SMID desc ";
            TComboBox.SetComboBox("DBERP", cbxCYSM, sSQL, true);


        }
        #endregion

        #region 控件事件

        protected void cbxCYSM_OnSelectedIndexChanged(object sender, EventArgs e)
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            if (cbxCYSM.SelectedValue != "")
            {
                SQL.Clear();
                SQL.Add("select XLXSBJSM_SMID,XLXSBJSM_SMNR from XLXSBJSM where 1=1 AND XLXSBJSM_SMID=:pXLXSBJSM_SMID AND XLXSBJSM_ZDM = 'BJSM'");
                SQL.ParamByName("pXLXSBJSM_SMID").Value = cbxCYSM.SelectedValue.Trim();
                DataSet dsCYSM = dberp.OpenDataSet(SQL);
                if (dsCYSM.Tables[0].Rows.Count > 0)
                {
                    txtBJSM.Text = dsCYSM.Tables[0].Rows[0]["XLXSBJSM_SMNR"].ToString().Trim();
                }
                else
                {
                    txtBJSM.Text = "";
                }
            }  
        }

        protected void lblCYSM_Click(object sender, EventArgs e)
        {
            if (cbxCYSM.SelectedValue.Trim().Equals(""))
            {
                return;
            }
            TPageParams pageParams = new TPageParams();
            pageParams.UrlPath = "XLBJD_CYSMInfo.aspx";
            pageParams.AddString("SMID", cbxCYSM.SelectedValue.Trim());
            pageParams.AddString("ZDM", "BJSM");
            pageParams.CallAction = TPageCallAction.pcaBrowse;
            OpenDialog(pageParams);
        }

        protected void btnOK_OnClick(object Sender, EventArgs e)
        {
            if (txtBJSM.Text.Trim().Equals(""))
            {
                ShowMessage("报价说明-不允许为空！");
                return;
            }
            string sSMID = XLBJD_MsgDef.getNewBH("BJSM").Trim();
            string sKH = PageParam.GetRTrimString("KHMC").Trim();
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            SQL.Clear();
            SQL.Add(" insert into XLXSBJSM(XLXSBJSM_ZDM,XLXSBJSM_SMID,XLXSBJSM_SMZT,XLXSBJSM_SMNR,XLXSBJSM_WHR,XLXSBJSM_WHRID,XLXSBJSM_WHSJ,XLXSBJSM_KH)");
            SQL.Add(" values(:XLXSBJSM_ZDM,:XLXSBJSM_SMID,:XLXSBJSM_SMZT,:XLXSBJSM_SMNR,:XLXSBJSM_WHR,:XLXSBJSM_WHRID,:XLXSBJSM_WHSJ,:XLXSBJSM_KH)");
            SQL.ParamByName("XLXSBJSM_ZDM").Value = "BJSM";
            SQL.ParamByName("XLXSBJSM_SMID").Value = sSMID;
            SQL.ParamByName("XLXSBJSM_SMZT").Value = "";
            SQL.ParamByName("XLXSBJSM_SMNR").Value = txtBJSM.Text.Trim();
            SQL.ParamByName("XLXSBJSM_KH").Value = sKH;
            SQL.ParamByName("XLXSBJSM_WHRID").Value = tSession.UserId;
            SQL.ParamByName("XLXSBJSM_WHR").Value = tSession.UserName;
            SQL.ParamByName("XLXSBJSM_WHSJ").Value = DateTime.Now;
            dberp.ExecSQL(SQL);
            TPageParams pageParams = new TPageParams();
            pageParams.UrlPath = "XLBJD_CYSMInfo.aspx";
            pageParams.AddString("SMID", sSMID);
            pageParams.AddString("ZDM", "BJSM");
            pageParams.CallAction = TPageCallAction.pcaEdit;
            OpenDialogClickBtn(pageParams, btnRefresh.ClientID);
        }

        //新增之后关闭页面下拉框重新增加了赋值
        //删除之后没有回调暂无法处理
        protected void btnRefresh_OnClick(object sender, EventArgs e)
        {
            int flag = 0;
            string sBJSM = cbxCYSM.SelectedValue.Trim();
            string sKH = PageParam.GetRTrimString("KHMC").Trim();
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            SQL.Clear();
            SQL.Add(" SELECT XLXSBJSM_SMID as ID, ");
            SQL.Add(" case isnull(XLXSBJSM_SMZT,' ') when ' ' then rtrim(XLXSBJSM_SMID)||'|'||'未填写说明主题' else rtrim(XLXSBJSM_SMID)||'|'||XLXSBJSM_SMZT end as CODE, ");
            SQL.Add(" XLXSBJSM_SMNR ");
            SQL.Add(" FROM XLXSBJSM ");
            SQL.Add(" where 1=1 and XLXSBJSM_ZDM = 'BJSM' ");
            SQL.Add(" and (isnull(XLXSBJSM_KH,' ')=' ' or isnull(XLXSBJSM_KH,' ')='" + sKH.Trim() + "') ");
            SQL.Add(" order by isnull(XLXSBJSM_KH,' ') desc,XLXSBJSM_SMID desc ");
            DataSet ds = dberp.OpenDataSet(SQL);
            cbxCYSM.ClearItems();
            cbxCYSM.Items.Add(new ListItem("", ""));
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                cbxCYSM.Items.Add(new ListItem(ds.Tables[0].Rows[i]["CODE"].ToString().Trim(), ds.Tables[0].Rows[i]["ID"].ToString().Trim()));
                //if(!sBJSM.Equals(""))
                {
                    if (ds.Tables[0].Rows[i]["ID"].ToString().Trim().Equals(sBJSM))
                    {
                        flag = 1;
                    }
                }
                //else
                //{
                //    if(ds.Tables[0].Rows[i]["XLXSBJSM_SMNR"].ToString().Trim().Equals(txtBJSM.Text.Trim()))
                //    {
                //        sBJSM = ds.Tables[0].Rows[i]["ID"].ToString().Trim();
                //    }
                //}
            }

            //if (!sBJSM.Equals(""))
            {
                if (1 == flag)
                {
                    cbxCYSM.SelectedValue = sBJSM;
                }
                else
                {
                    cbxCYSM.SelectedValue = "";
                }
            }
            //else
            //{
            //    cbxCYSM.SelectedValue = sBJSM;
            //}
            FormAreaUpdate();

        }


        protected void btnQR_Click(object sender, EventArgs e)
        {
            string sBJDID = PageParam.GetRTrimString("BJDID");
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            try
            {
                dberp.BeginTrans();
                SQL.Clear();
                SQL.Add("update XLXSBJD set XLXSBJD_BJSM= :pBJSM ");
                SQL.Add("  where XLXSBJD_BJDID = :pBJDID ");
                SQL.ParamByName("pBJSM").Value = txtBJSM.Text.Trim();
                SQL.ParamByName("pBJDID").Value = sBJDID;
                dberp.ExecSQL(SQL);
                dberp.CommitTrans();
                CloseWindow();
            }
            catch (Exception ex)
            {
                ShowMessage("填写说明出现异常，请联系系统管理员！错误原因：" + ex);
                dberp.RollbackTrans();
            }    
        }

        protected void btnQX_Click(object sender, EventArgs e)
        {
            CloseWindow();
        }

        #endregion
    }
}