示例#1
0
    protected void btnEdit_M_Click(object sender, EventArgs e)
    {
        //預設欄位Focus
        SetClinetFocus(SLP_STORE.ClientID);
        ReadOnlyMode(true);
        btnSave.Visible = false;
        btnPASS.Visible = false;
        btnNOPASS.Visible = false;
        btnCopy.Visible = false;

        GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Find, true, "STM251.aspx?Code=STM25", null, WUI_GMToolbarV.ClickAction.LinkURL);
        GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.FindExport, false, "", this.btnEdit_M, WUI_GMToolbarV.ClickAction.ButtonClick);
        GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.New, false, string.Empty, this.btnEdit_M, WUI_GMToolbarV.ClickAction.ButtonClick);
        GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Save, true, string.Empty, this.btnEdt, WUI_GMToolbarV.ClickAction.ButtonClick);
        GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Edit, false, string.Empty, this.btnEdit_M, WUI_GMToolbarV.ClickAction.ButtonClick);
        GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Delete, false, string.Empty, this.btnEdit_M, WUI_GMToolbarV.ClickAction.ButtonClick);
        GMToolbar1.ButtonEnableControl(WUI_GMToolbarV.ButtonType.Copy, false, string.Empty, this.btnCopy, WUI_GMToolbarV.ClickAction.ButtonClick);



        if (txtPAY_RFNO.Text == txtRFNO.Text && radSTORE_TYPE_STORE.Checked)
        {
            #region 總部門市資料唯讀
            STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB);
            DataTable Dt_rtn;
            ParameterList.Clear();
            ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", false));
            ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.Text, "date", false));
            ParameterList.Add(GetValueSetParameter(this.txtPAY_RFNO.Text, "string", false));
            ParameterList.Add(GetValueSetParameter(this.txtRFNO.Text, "string", false));
            Dt_rtn = BCO.QueryAccountHead(ParameterList);

            if (Dt_rtn != null && Dt_rtn.Rows.Count > 0)
            {
                #region 總部資料唯讀
                SLP_STORE.ReadOnly = true;
                txtPAY_RFNO.ReadOnly = true;
                txtPAY_RFNO.CssClass = "readtxtbox";
                txtRFNO.ReadOnly = true;
                txtRFNO.CssClass = "readtxtbox";
                this.radSTORE_TYPE_HEAD.Enabled = false;
                this.radSTORE_TYPE_STORE.Enabled = false;
                this.SLP_EFF_DATE_FROM.ReadOnly = true;
                this.radSTORE_TYPE_HEAD.Enabled = false;
                this.radSTORE_TYPE_STORE.Enabled = false;
                this.txtTITLE.ReadOnly = true;
                txtTITLE.CssClass = "readtxtbox";
                this.txtINV_ADDR.ReadOnly = true;
                txtINV_ADDR.CssClass = "readtxtbox";
                this.txtPERSON.ReadOnly = true;
                txtPERSON.CssClass = "readtxtbox";
                this.SLP_PROFIT_NO.ReadOnly = true;
                this.txtPAY_ACCOUNT.ReadOnly = true;
                txtPAY_ACCOUNT.CssClass = "readtxtbox";
                this.SLP_DUIT_UNIT.ReadOnly = true;
                this.ddlPAYMENT_STORE.Enabled = false;
                this.txtAC_NAME.ReadOnly = true;
                txtAC_NAME.CssClass = "readtxtbox";
                this.txtINVOICE_MAILADD.ReadOnly = true;
                txtINVOICE_MAILADD.CssClass = "readtxtbox";
                this.SLP_INVOICE_SEND.ReadOnly = true;
                this.SLP_INVOICE_TYPE.ReadOnly = true;
                this.ddlPAY_TYPE.Enabled = false;
                this.SLP_CLS_DATE.ReadOnly = true;

                if (GridView1.Rows.Count > 0)
                {
                    foreach (GridViewRow dr in GridView1.Rows)
                    {
                        ((Button)dr.FindControl("btnDel")).Enabled = false;   //GRID刪除
                        ((Button)dr.FindControl("btnEdit")).Enabled = false;  //GRID編輯
                    }
                }
                btnAdd.Enabled = false;//新增
                #endregion
            }
            #endregion
        }
        else if (radSTORE_TYPE_HEAD.Checked)
        {
            txtPAY_RFNO.ReadOnly = true;
            txtPAY_RFNO.CssClass = "readtxtbox";
            txtRFNO.ReadOnly = true;
            txtRFNO.CssClass = "readtxtbox";
        }
    }
示例#2
0
    protected void txt_RFNO_Onblur()
    {
        if (txtPAY_RFNO.Text == txtRFNO.Text)
        {
            string mode = "";
            string v_STORE = "";
            string v_eff_date_from = "";

            #region 帶出總部資料
            STMModel.MaintainStoreAccount BCO = new STMModel.MaintainStoreAccount(ConnectionDB);
            DataTable Dt_rtn;
            ParameterList.Clear();
            ParameterList.Add(GetValueSetParameter(this.SLP_STORE.Text, "string", false));
            ParameterList.Add(GetValueSetParameter(this.SLP_EFF_DATE_FROM.Text, "date", false));
            ParameterList.Add(GetValueSetParameter(this.txtPAY_RFNO.Text, "string", false));
            ParameterList.Add(GetValueSetParameter(this.txtRFNO.Text, "string", false));
            Dt_rtn = BCO.QueryAccountHead(ParameterList);

            if (Dt_rtn == null || (Dt_rtn != null && Dt_rtn.Rows.Count <= 0))
            {
                //無資料
            }
            else
            {
                #region 帶出總部資料

                v_STORE = Dt_rtn.Rows[0]["STORE"].ToString();
                v_eff_date_from = Dt_rtn.Rows[0]["EFF_DATE_FROM"].ToString();
                this.SLP_EFF_DATE_TO.Text = Dt_rtn.Rows[0]["EFF_DATE_TO"].ToString();
                this.radSTORE_TYPE_HEAD.Checked = false;
                this.radSTORE_TYPE_STORE.Checked = true;
                this.txtTITLE.Text = Dt_rtn.Rows[0]["TITLE"].ToString();
                this.txtINV_ADDR.Text = Dt_rtn.Rows[0]["INV_ADDR"].ToString();
                this.txtPERSON.Text = Dt_rtn.Rows[0]["PERSON"].ToString();
                this.SLP_PROFIT_NO.Text = Dt_rtn.Rows[0]["PROFIT_NO"].ToString();
                this.txtPAY_ACCOUNT.Text = Dt_rtn.Rows[0]["PAY_ACCOUNT"].ToString();
                this.SLP_DUIT_UNIT.Text = Dt_rtn.Rows[0]["DUTY_UNIT"].ToString();
                this.ddlPAYMENT_STORE.SelectedValue = Dt_rtn.Rows[0]["PAYMENT_STORE"].ToString();
                this.txtAC_NAME.Text = Dt_rtn.Rows[0]["AC_NAME"].ToString();
                this.txtINVOICE_MAILADD.Text = Dt_rtn.Rows[0]["INVOICE_MAIL_ADD"].ToString();
                this.SLP_INVOICE_SEND.Text = Dt_rtn.Rows[0]["INVOICE_SEND"].ToString();
                this.SLP_INVOICE_TYPE.Text = Dt_rtn.Rows[0]["INVOICE_TYPE"].ToString();
                this.ddlPAY_TYPE.SelectedValue = Dt_rtn.Rows[0]["PAY_TYPE"].ToString();
                this.SLP_CLS_DATE.Text = Dt_rtn.Rows[0]["CLS_DATE"].ToString();
                #endregion

                #region 帶出總部資料唯讀
                SLP_STORE.ReadOnly = true;
                txtPAY_RFNO.ReadOnly = true;
                txtPAY_RFNO.CssClass = "readtxtbox";
                txtRFNO.ReadOnly = true;
                txtRFNO.CssClass = "readtxtbox";
                this.radSTORE_TYPE_HEAD.Enabled = false;
                this.radSTORE_TYPE_STORE.Enabled = false;
                this.SLP_EFF_DATE_FROM.ReadOnly = true;
                this.radSTORE_TYPE_HEAD.Enabled = false;
                this.radSTORE_TYPE_STORE.Enabled = false;
                this.txtTITLE.ReadOnly = true;
                txtTITLE.CssClass = "readtxtbox";
                this.txtINV_ADDR.ReadOnly = true;
                txtINV_ADDR.CssClass = "readtxtbox";
                this.txtPERSON.ReadOnly = true;
                txtPERSON.CssClass = "readtxtbox";
                this.SLP_PROFIT_NO.ReadOnly = true;
                this.txtPAY_ACCOUNT.ReadOnly = true;
                txtPAY_ACCOUNT.CssClass = "readtxtbox";
                this.SLP_DUIT_UNIT.ReadOnly = true;
                this.ddlPAYMENT_STORE.Enabled = false;
                this.txtAC_NAME.ReadOnly = true;
                txtAC_NAME.CssClass = "readtxtbox";
                this.txtINVOICE_MAILADD.ReadOnly = true;
                txtINVOICE_MAILADD.CssClass = "readtxtbox";
                this.SLP_INVOICE_SEND.ReadOnly = true;
                this.SLP_INVOICE_TYPE.ReadOnly = true;
                this.ddlPAY_TYPE.Enabled = false;
                this.SLP_CLS_DATE.ReadOnly = true;
                #endregion
            }
            #endregion

            #region 帶出設定屬性
            if (v_STORE.Length != 0 && v_eff_date_from.Length != 0)
            {
                STMModel.MaintainStoreAccount BCO_root = new STMModel.MaintainStoreAccount(ConnectionDB);

                DataTable Dt_root;

                ParameterList.Clear();
                ParameterList.Add(v_STORE);
                ParameterList.Add((DateTime.Parse(v_eff_date_from)).ToString("yyyy/MM/dd"));

                Dt_root = BCO_root.QuerySwitch(STMModel.MaintainStoreAccount.QueryType.ROOT, ParameterList);

                if (Dt_root == null || (Dt_root != null && Dt_root.Rows.Count <= 0))
                {
                    //無資料
                }
                else
                {
                    DataSet ds_root = (DataSet)Session["STM252_root" + PageTimeStamp.Value];

                    ds_root.Clear();

                    for (int i = 0; i < Dt_root.Rows.Count; i++)
                    {
                        DataRow dr = ds_root.Tables[0].NewRow();

                        dr["STORE"] = this.SLP_STORE.Text;
                        dr["EFF_DATE_FROM"] = this.SLP_EFF_DATE_FROM.Text;
                        dr["ROOT_NO"] = Dt_root.Rows[i]["ROOT_NO"].ToString();
                        dr["ROOT_NO_EXPLAIN"] = Dt_root.Rows[i]["ROOT_NO_EXPLAIN"].ToString();
                        dr["HEAD_DOC"] = Dt_root.Rows[i]["HEAD_DOC"].ToString();
                        dr["HEAD_DOC_EXPLAIN"] = Dt_root.Rows[i]["HEAD_DOC_EXPLAIN"].ToString();
                        dr["SINGLE_DOC"] = Dt_root.Rows[i]["SINGLE_DOC"].ToString();
                        dr["SINGLE_DOC_EXPLAIN"] = Dt_root.Rows[i]["SINGLE_DOC_EXPLAIN"].ToString();
                        dr["PAYMENT_TYPE"] = Dt_root.Rows[i]["PAYMENT_TYPE"].ToString();
                        dr["PAYMENT_TYPE_EXPLAIN"] = Dt_root.Rows[i]["PAYMENT_TYPE_EXPLAIN"].ToString();

                        ds_root.Tables[0].Rows.Add(dr);
                    }

                    GridView1.DataSource = ds_root;
                    string SessionIDName_root = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
                    Session[SessionIDName_root] = ds_root;
                    GridView1.DataBind();
                    Session["STM252_root" + PageTimeStamp.Value] = ds_root;

                    if (GridView1.Rows.Count > 0)
                    {
                        foreach (GridViewRow dr in GridView1.Rows)
                        {
                            ((Button)dr.FindControl("btnDel")).Enabled = false;   //GRID刪除
                            ((Button)dr.FindControl("btnEdit")).Enabled = false;  //GRID編輯
                        }
                    }

                    btnAdd.Enabled = false;//新增
                }
            }
            #endregion

            #region 帶出收款天數
            if (v_STORE.Length != 0 && v_eff_date_from.Length != 0)
            {
                STMModel.MaintainStoreAccount BCO_Charge = new STMModel.MaintainStoreAccount(ConnectionDB);

                DataTable Dt_charge;
                ParameterList.Clear();

                ParameterList.Add(v_STORE);
                ParameterList.Add((DateTime.Parse(v_eff_date_from)).ToString("yyyy/MM/dd"));

                Dt_charge = BCO_Charge.QuerySwitch(STMModel.MaintainStoreAccount.QueryType.CHARGE, ParameterList);

                if (Dt_charge == null || (Dt_charge != null && Dt_charge.Rows.Count <= 0))
                {
                    //無資料
                }
                else
                {
                    DataSet ds = (DataSet)Session["STM252_" + PageTimeStamp.Value];

                    ds.Clear();

                    for (int i = 0; i < Dt_charge.Rows.Count; i++)
                    {
                        DataRow dr = ds.Tables[0].NewRow();

                        dr["ID"] = DateTime.Now.ToFileTime().ToString() + i.ToString();
                        dr["STORE"] = this.SLP_STORE.Text;
                        dr["EFF_DATE_FROM"] = this.SLP_EFF_DATE_FROM.Text;
                        dr["ROOT_NO"] = Dt_charge.Rows[i]["ROOT_NO"].ToString();
                        dr["ROOT_NO_EXPLAIN"] = Dt_charge.Rows[i]["ROOT_NO_EXPLAIN"].ToString();
                        dr["PMA"] = Dt_charge.Rows[i]["PMA"].ToString();
                        dr["PMA_EXPLAIN"] = Dt_charge.Rows[i]["PMA_EXPLAIN"].ToString();
                        dr["COL_DAYS"] = Dt_charge.Rows[i]["COL_DAYS"].ToString();
                        dr["COL_DAYS_EXPLAIN"] = Dt_charge.Rows[i]["COL_DAYS_EXPLAIN"].ToString();

                        ds.Tables[0].Rows.Add(dr);
                    }
                    Session["STM252_" + PageTimeStamp.Value] = ds;

                    GridView2.DataSource = ds;
                    string SessionIDName2 = string.Format("{0}_{1}", PAGE_DT_02, PageTimeStamp.Value);
                    Session[SessionIDName2] = ds;
                    GridView2.DataBind();
                }
            }
            #endregion

            UpdatePanelLineItem.Update();
            UpdatePanel3.Update();
            UpdatePanel4.Update();
            UpdatePanel7.Update();
        }
    }