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); }
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); }
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); } }
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); } }
private void frmQuery_Load(object sender, EventArgs e) { txtQuery.Text = iLoginEx.ReadUserProfileValue("SO311_frmQuery", "txtQuery"); }
/// <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(); }
private void frmReport_Load(object sender, EventArgs e) { cboReport.Text = iLoginEx.ReadUserProfileValue("SO311", "cboReport"); }