Esempio n. 1
0
        private void frmDetailed_Load(object sender, EventArgs e)
        {
            dtpbegin.Text    = iLoginEx.ReadUserProfileValue("SO321", "dtpbegind");
            dtpend.Text      = iLoginEx.ReadUserProfileValue("SO321", "dtpendd");
            cbDetail.Checked = iLoginEx.ReadUserProfileValue("SO321", "cbDetail") == "1" ? true : false;
            string sql = "";

            switch (zz_Index)
            {
            case 10:           //业务员
                sql = "and c.cPersonName ='" + cPersonName + "' and cy.addate between '" + iLoginEx.iYear() + "-01-01' and '" + iLoginEx.iYear() + "-12-31'";

                break;

            case 1:            //客户
                sql = "and b.ccusname ='" + cPersonName + "' and cy.addate between '" + iLoginEx.iYear() + "-01-01' and '" + iLoginEx.iYear() + "-12-31'";
                break;

            case 9:            //成品分类
                if (cPersonName == "配件")
                {
                    sql = "and cy.cinvccode ='' and cy.addate between '" + iLoginEx.iYear() + "-01-01' and '" + iLoginEx.iYear() + "-12-31'";
                }
                else if (cPersonName == "硬盘")
                {
                    sql = "and cy.cinvccode ='H' and cy.addate between '" + iLoginEx.iYear() + "-01-01' and '" + iLoginEx.iYear() + "-12-31'";
                }
                else
                {
                    sql = "and cls.cInvCName ='" + cPersonName + "' and cy.addate between '" + iLoginEx.iYear() + "-01-01' and '" + iLoginEx.iYear() + "-12-31'";
                }
                break;
            }
            dgvLoadInfo(sql);
        }
Esempio n. 2
0
        private void frmQuery_Load(object sender, EventArgs e)
        {
            chkInMonths.Checked           = iLoginEx.ReadUserProfileValue("Query", "chkInMonths") == "0" ? false : true;
            txtInMonths.Text              = iLoginEx.ReadUserProfileValue("Query", "InMonths") == "" ? "2" : iLoginEx.ReadUserProfileValue("Query", "InMonths");
            chkOutMonths.Checked          = iLoginEx.ReadUserProfileValue("Query", "chkOutMonths") == "0" ? false : true;
            txtOutMonths.Text             = iLoginEx.ReadUserProfileValue("Query", "OutMonths") == "" ? "1" : iLoginEx.ReadUserProfileValue("Query", "OutMonths");
            txtPercent.Text               = iLoginEx.ReadUserProfileValue("Query", "Percent") == "" ? "33" : iLoginEx.ReadUserProfileValue("Query", "Percent");
            chkInMonths2.Checked          = iLoginEx.ReadUserProfileValue("Query", "chkInMonths2") == "1" ? true : false;
            txtInMonths2.Text             = iLoginEx.ReadUserProfileValue("Query", "txtInMonths2") == "" ? "1" : iLoginEx.ReadUserProfileValue("Query", "txtInMonths2");
            chkOutMonths2.Checked         = iLoginEx.ReadUserProfileValue("Query", "chkOutMonths2") == "1" ? true : false;
            txtOutMonths2.Text            = iLoginEx.ReadUserProfileValue("Query", "txtOutMonths2") == "" ? "1" : iLoginEx.ReadUserProfileValue("Query", "txtOutMonths2");
            chkComprehensiveStock.Checked = iLoginEx.ReadUserProfileValue("Query", "chkComprehensiveStock") == "1" ? true : false;

            chkOut_Month();
            chkInMonths_CheckedChanged(null, null);
            chkInMonths2_CheckedChanged(null, null);
        }
Esempio n. 3
0
        private void StockQuery_Load(object sender, EventArgs e)
        {
            try
            {
                txtcInvCCode.Text          = iLoginEx.ReadUserProfileValue("StockQuery", "cInvCCode");                                                                                             //物料分类
                txtcWhCode.Text            = iLoginEx.ReadUserProfileValue("StockQuery", "cWhCode");                                                                                               //仓库代码
                txtcInvCode.Text           = iLoginEx.ReadUserProfileValue("StockQuery", "cInvCode");                                                                                              //物料编码
                txtQtyL.Text               = iLoginEx.ReadUserProfileValue("StockQuery", "QtyL");                                                                                                  //数量L
                txtQtyH.Text               = iLoginEx.ReadUserProfileValue("StockQuery", "QtyH");                                                                                                  //数量H
                txtPriceL.Text             = iLoginEx.ReadUserProfileValue("StockQuery", "PriceL");                                                                                                //单价L
                txtPriceH.Text             = iLoginEx.ReadUserProfileValue("StockQuery", "PriceH");                                                                                                //单价H
                txtAmtL.Text               = iLoginEx.ReadUserProfileValue("StockQuery", "AmtL");                                                                                                  //库存金额L
                txtAmtH.Text               = iLoginEx.ReadUserProfileValue("StockQuery", "AmtH");                                                                                                  //库存金额H
                cmbQureyType.SelectedIndex = iLoginEx.ReadUserProfileValue("StockQuery", "QureyType").Length == 0 ? 0 : Convert.ToInt32(iLoginEx.ReadUserProfileValue("StockQuery", "QureyType")); //0=现存量;1=综合查询
                cmbABC.SelectedIndex       = iLoginEx.ReadUserProfileValue("StockQuery", "InvABC").Length == 0 ? 0 : Convert.ToInt32(iLoginEx.ReadUserProfileValue("StockQuery", "InvABC"));       //ABC分类

                txtPriceL.Enabled = iLoginEx.CheckAuthorityDetail(iLoginEx.UserId(), AuthID, LoginEx.AuthorityDetailType.Price);
                txtPriceH.Enabled = iLoginEx.CheckAuthorityDetail(iLoginEx.UserId(), AuthID, LoginEx.AuthorityDetailType.Price);
                txtAmtL.Enabled   = iLoginEx.CheckAuthorityDetail(iLoginEx.UserId(), AuthID, LoginEx.AuthorityDetailType.Price);
                txtAmtH.Enabled   = iLoginEx.CheckAuthorityDetail(iLoginEx.UserId(), AuthID, LoginEx.AuthorityDetailType.Price);
                if (!iLoginEx.CheckAuthorityDetail(iLoginEx.UserId(), AuthID, LoginEx.AuthorityDetailType.Price))
                {
                    txtPriceL.Text = "";
                    txtPriceH.Text = "";
                    txtAmtL.Text   = "";
                    txtAmtH.Text   = "";
                }
            }
            catch (Exception ex)
            {
                frmMessege frmmsg = new frmMessege(ex.ToString(), "StockQuery_Load()");
                frmmsg.ShowDialog(this);
            }
        }
Esempio n. 4
0
        private void frmQuery_Load(object sender, EventArgs e)
        {
            try
            {
                selectSQL       = "";
                dtDateH.Enabled = false;
                dtDateL.Enabled = false;
                chkDate.Checked = true;

                DateTime dt         = DateTime.Now;
                DateTime startMonth = dt.AddDays(1 - dt.Day);              //本月月初
                DateTime endMonth   = startMonth.AddMonths(1).AddDays(-1); //本月月末//

                dtDateL.Value = startMonth;
                dtDateH.Value = endMonth;
                dtDateL.Value = iLoginEx.ReadUserProfileValue("APS21Query", "dtDateL").Length == 0 ? startMonth : Convert.ToDateTime(iLoginEx.ReadUserProfileValue("APS21Query", "dtDateL"));
                dtDateH.Value = iLoginEx.ReadUserProfileValue("APS21Query", "dtDateH").Length == 0 ? startMonth : Convert.ToDateTime(iLoginEx.ReadUserProfileValue("APS21Query", "dtDateH"));

                chkDate.Checked           = iLoginEx.ReadUserProfileValue("APS21Query", "chkDate") == "1" ? true : false;
                chkShowPreparedMO.Checked = iLoginEx.ReadUserProfileValue("APS21Query", "chkShowPreparedMO") == "1" ? true : false;
                chkShowFinishedMO.Checked = iLoginEx.ReadUserProfileValue("APS21Query", "chkShowFinishedMO") == "1" ? true : false;
                chkNoShowColor.Checked    = iLoginEx.ReadUserProfileValue("APS21Query", "chkNoShowColor") == "1" ? true : false;
                chkSkipFinish.Checked     = iLoginEx.ReadUserProfileValue("APS21Query", "chkSkipFinish") == "1" ? true : false;
                chkALLMaking.Checked      = iLoginEx.ReadUserProfileValue("APS21Query", "chkALLMaking") == "1" ? true : false;
                txtcPersonCode.Text       = iLoginEx.ReadUserProfileValue("APS21Query", "txtcPersonCode");
                txtcInvStd.Text           = iLoginEx.ReadUserProfileValue("APS21Query", "txtcInvStd");
                txtcInvCode.Text          = iLoginEx.ReadUserProfileValue("APS21Query", "txtcInvCode");
                txtMoCode.Text            = iLoginEx.ReadUserProfileValue("APS21Query", "txtMoCode");
                txtcSOCode.Text           = iLoginEx.ReadUserProfileValue("APS21Query", "txtcSOCode");


                if (chkALLMaking.Checked)
                {
                    chkSkipFinish.Enabled  = false;
                    txtcInvCode.Enabled    = false;
                    txtcInvStd.Enabled     = false;
                    txtcSOCode.Enabled     = false;
                    txtcPersonCode.Enabled = false;
                    txtMoCode.Enabled      = false;
                    chkDate.Enabled        = false;
                    dtDateH.Enabled        = false;
                    dtDateL.Enabled        = false;
                }
                else
                {
                    chkSkipFinish.Enabled  = true;
                    txtcInvCode.Enabled    = true;
                    txtcInvStd.Enabled     = true;
                    txtcSOCode.Enabled     = true;
                    txtcPersonCode.Enabled = true;
                    txtMoCode.Enabled      = true;
                    chkDate.Enabled        = true;
                    if (chkDate.Checked)
                    {
                        dtDateH.Enabled = true;
                        dtDateL.Enabled = true;
                    }
                }
            }
            catch (Exception ex)
            {
                frmMessege frmmsg = new frmMessege(ex.ToString(), "frmQuery_Load()");
                frmmsg.ShowDialog(this);
            }
        }
Esempio n. 5
0
 private void frmQuery_Load(object sender, EventArgs e)
 {
     txtQuery.Text = iLoginEx.ReadUserProfileValue("SO311_frmQuery", "txtQuery");
 }
Esempio n. 6
0
        /// <summary>
        /// 加载数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void frmDVRHSI_Load(object sender, EventArgs e)
        {
            txtQuery_DVRHSI.Text = iLoginEx.ReadUserProfileValue("SO321", "txtQuery_DVRHSI");

            DgvSaleInfo();
        }
Esempio n. 7
0
 private void frmReport_Load(object sender, EventArgs e)
 {
     cboReport.Text = iLoginEx.ReadUserProfileValue("SO311", "cboReport");
 }