public XSDJ_MXModel GetMXModel(string XSDJBH, string XH) { XSDJ_MXModel model = new XSDJ_MXModel(); Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary.Add("XSDJBH", XSDJBH); dictionary.Add("XH", XH); DataTable table = this.baseDAO.querySQLDataTable("aisino.Fwkp.Wbjk.XSDJMXGetModel", dictionary); if (table.Rows.Count > 0) { DataRow row = table.Rows[0]; model.XSDJBH = GetSafeData.ValidateValue <string>(row, "XSDJBH"); model.XH = GetSafeData.ValidateValue <int>(row, "XH"); model.SL = GetSafeData.ValidateValue <double>(row, "SL"); model.DJ = GetSafeData.ValidateValue <double>(row, "DJ"); model.JE = GetSafeData.ValidateValue <double>(row, "JE"); model.SLV = GetSafeData.ValidateValue <double>(row, "SLV"); model.SE = GetSafeData.ValidateValue <double>(row, "SE"); model.SPMC = GetSafeData.ValidateValue <string>(row, "SPMC"); model.SPSM = GetSafeData.ValidateValue <string>(row, "SPSM"); model.GGXH = GetSafeData.ValidateValue <string>(row, "GGXH"); model.JLDW = GetSafeData.ValidateValue <string>(row, "JLDW"); model.HSJBZ = GetSafeData.ValidateValue <bool>(row, "HSJBZ"); model.DJHXZ = GetSafeData.ValidateValue <int>(row, "DJHXZ"); model.FPZL = GetSafeData.ValidateValue <string>(row, "FPZL"); model.FPDM = GetSafeData.ValidateValue <string>(row, "FPDM"); model.FPHM = GetSafeData.ValidateValue <int>(row, "FPHM"); model.SCFPXH = GetSafeData.ValidateValue <int>(row, "SCFPXH"); } return(model); }
private List <XSDJMXModel> ConvertImportXSDJ(XSDJ XsdjImport) { List <XSDJMXModel> list = new List <XSDJMXModel>(); for (int i = 0; i < XsdjImport.Dj.Count; i++) { XSDJMXModel item = new XSDJMXModel { BH = XsdjImport.Dj[i].Djh, GFMC = XsdjImport.Dj[i].Gfmc, GFSH = XsdjImport.Dj[i].Gfsh, GFDZDH = XsdjImport.Dj[i].Gfdzdh, GFYHZH = XsdjImport.Dj[i].Gfyhzh, XSBM = "", YDXS = false, DJRQ = XsdjImport.Dj[i].Djrq.Date, DJYF = XsdjImport.Dj[i].Djrq.Month, DJZT = XsdjImport.Dj[i].DJZT, KPZT = "N", BZ = XsdjImport.Dj[i].Bz, FHR = XsdjImport.Dj[i].Fhr, SKR = XsdjImport.Dj[i].Skr, QDHSPMC = XsdjImport.Dj[i].Qdspmc, XFYHZH = XsdjImport.Dj[i].Xfyhzh, XFDZDH = XsdjImport.Dj[i].Xfdzdh, CFHB = false, DJZL = XsdjImport.Dj[i].Djzl, SFZJY = false, HYSY = XsdjImport.Dj[i].HYSY }; double num2 = 0.0; for (int j = 0; j < XsdjImport.Dj[i].Mingxi.Count; j++) { XSDJ_MXModel model2 = new XSDJ_MXModel { XSDJBH = XsdjImport.Dj[i].Mingxi[j].DJBH, XH = Convert.ToInt16((int)(j + 1)), SL = XsdjImport.Dj[i].Mingxi[j].Sl, DJ = XsdjImport.Dj[i].Mingxi[j].Dj, JE = Convert.ToDouble(XsdjImport.Dj[i].Mingxi[j].Bhsje), SLV = Convert.ToDouble(XsdjImport.Dj[i].Mingxi[j].Slv), SE = Convert.ToDouble(XsdjImport.Dj[i].Mingxi[j].Se), SPMC = XsdjImport.Dj[i].Mingxi[j].Hwmc, SPSM = XsdjImport.Dj[i].Mingxi[j].Spsm, GGXH = XsdjImport.Dj[i].Mingxi[j].Gg, JLDW = XsdjImport.Dj[i].Mingxi[j].Jldw, HSJBZ = (XsdjImport.Dj[i].Mingxi[j].Jgfs == "0") ? false : true, DJHXZ = XsdjImport.Dj[i].Mingxi[j].Djhxz, FPZL = XsdjImport.Dj[i].Mingxi[j].Fpzl.ToString(), FPDM = "", FPHM = 0, SCFPXH = 0 }; num2 += Convert.ToDouble(XsdjImport.Dj[i].Mingxi[j].Bhsje); item.ListXSDJ_MX.Add(model2); } item.JEHJ = num2; list.Add(item); } return(list); }
public List <XSDJ_MXModel> GetMergedMX(List <string> listBH) { int num; Dictionary <string, object> dictionary = new Dictionary <string, object>(); List <object> list = new List <object>(); for (num = 0; num < listBH.Count; num++) { list.Add(listBH[num]); } dictionary.Add("BH", list); DataTable table = this.baseDAO.querySQLDataTable("aisino.Fwkp.Wbjk.HBGetMXForMerge", dictionary); int count = table.Rows.Count; List <XSDJ_MXModel> list2 = new List <XSDJ_MXModel>(); for (num = 0; num < table.Rows.Count; num++) { DataRow row = table.Rows[num]; XSDJ_MXModel item = new XSDJ_MXModel { XSDJBH = GetSafeData.ValidateValue <string>(row, "XSDJBH"), XH = num + 1, SL = GetSafeData.ValidateValue <double>(row, "SL"), DJ = GetSafeData.ValidateValue <double>(row, "DJ"), JE = GetSafeData.ValidateValue <double>(row, "JE"), SLV = GetSafeData.ValidateValue <double>(row, "SLV"), SE = GetSafeData.ValidateValue <double>(row, "SE"), SPMC = GetSafeData.ValidateValue <string>(row, "SPMC"), SPSM = GetSafeData.ValidateValue <string>(row, "SPSM"), GGXH = GetSafeData.ValidateValue <string>(row, "GGXH"), JLDW = GetSafeData.ValidateValue <string>(row, "JLDW"), HSJBZ = GetSafeData.ValidateValue <bool>(row, "HSJBZ"), DJHXZ = GetSafeData.ValidateValue <int>(row, "DJHXZ"), FPZL = GetSafeData.ValidateValue <string>(row, "FPZL"), FPDM = GetSafeData.ValidateValue <string>(row, "FPDM"), FPHM = GetSafeData.ValidateValue <int>(row, "FPHM"), SCFPXH = GetSafeData.ValidateValue <int>(row, "SCFPXH") }; list2.Add(item); } return(list2); }
private string AddMXtoYL(XSDJ_MXModel mingxi) { Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary.Add("XSDJBH", mingxi.XSDJBH); dictionary.Add("XH", mingxi.XH); dictionary.Add("SL", mingxi.SL); dictionary.Add("DJ", mingxi.DJ); dictionary.Add("JE", mingxi.JE); dictionary.Add("SLV", mingxi.SLV); dictionary.Add("SE", mingxi.SE); dictionary.Add("SPMC", mingxi.SPMC); dictionary.Add("SPSM", mingxi.SPSM); dictionary.Add("GGXH", mingxi.GGXH); dictionary.Add("JLDW", mingxi.JLDW); dictionary.Add("HSJBZ", mingxi.HSJBZ); dictionary.Add("DJHXZ", mingxi.DJHXZ); if (this.baseDAO.updateSQL("aisino.Fwkp.Wbjk.XSDJMXAddYL", dictionary) > 0) { return("OK"); } return("eMX"); }
public XSDJMXModel GetXSDJandMXs(string XSDJBH, bool MXAll, bool DanJia) { XSDJMXModel model = new XSDJMXModel(); Dictionary <string, object> dictionary = new Dictionary <string, object>(); dictionary.Add("BH", XSDJBH); DataTable table = this.baseDAO.querySQLDataTable("aisino.Fwkp.Wbjk.XSDJGetModel", dictionary); if (table.Rows.Count > 0) { DataRow row = table.Rows[0]; model.BH = GetSafeData.ValidateValue <string>(row, "BH"); model.GFMC = GetSafeData.ValidateValue <string>(row, "GFMC"); model.GFSH = GetSafeData.ValidateValue <string>(row, "GFSH"); model.GFDZDH = GetSafeData.ValidateValue <string>(row, "GFDZDH"); model.GFYHZH = GetSafeData.ValidateValue <string>(row, "GFYHZH"); model.XSBM = GetSafeData.ValidateValue <string>(row, "XSBM"); model.YDXS = GetSafeData.ValidateValue <bool>(row, "YDXS"); model.JEHJ = GetSafeData.ValidateValue <double>(row, "JEHJ"); model.DJRQ = GetSafeData.ValidateValue <DateTime>(row, "DJRQ"); model.DJYF = GetSafeData.ValidateValue <int>(row, "DJYF"); model.DJZT = GetSafeData.ValidateValue <string>(row, "DJZT"); model.KPZT = GetSafeData.ValidateValue <string>(row, "KPZT"); model.BZ = GetSafeData.ValidateValue <string>(row, "BZ"); model.FHR = GetSafeData.ValidateValue <string>(row, "FHR"); model.SKR = GetSafeData.ValidateValue <string>(row, "SKR"); model.QDHSPMC = GetSafeData.ValidateValue <string>(row, "QDHSPMC"); model.XFYHZH = GetSafeData.ValidateValue <string>(row, "XFYHZH"); model.XFDZDH = GetSafeData.ValidateValue <string>(row, "XFDZDH"); model.CFHB = GetSafeData.ValidateValue <bool>(row, "CFHB"); model.DJZL = GetSafeData.ValidateValue <string>(row, "DJZL"); model.SFZJY = GetSafeData.ValidateValue <bool>(row, "SFZJY"); model.HYSY = GetSafeData.ValidateValue <bool>(row, "HYSY"); } else { return(null); } DataTable mXDJ = this.GetMXDJ(XSDJBH); foreach (DataRow row in mXDJ.Rows) { XSDJ_MXModel item = new XSDJ_MXModel { XSDJBH = GetSafeData.ValidateValue <string>(row, "XSDJBH"), XH = GetSafeData.ValidateValue <int>(row, "XH"), SL = GetSafeData.ValidateValue <double>(row, "SL"), DJ = GetSafeData.ValidateValue <double>(row, "DJ"), JE = GetSafeData.ValidateValue <double>(row, "JE"), SLV = GetSafeData.ValidateValue <double>(row, "SLV"), SE = GetSafeData.ValidateValue <double>(row, "SE"), SPMC = GetSafeData.ValidateValue <string>(row, "SPMC"), SPSM = GetSafeData.ValidateValue <string>(row, "SPSM"), GGXH = GetSafeData.ValidateValue <string>(row, "GGXH"), JLDW = GetSafeData.ValidateValue <string>(row, "JLDW"), HSJBZ = GetSafeData.ValidateValue <bool>(row, "HSJBZ"), DJHXZ = GetSafeData.ValidateValue <int>(row, "DJHXZ"), FPZL = GetSafeData.ValidateValue <string>(row, "FPZL"), FPDM = GetSafeData.ValidateValue <string>(row, "FPDM"), FPHM = GetSafeData.ValidateValue <int>(row, "FPHM"), SCFPXH = GetSafeData.ValidateValue <int>(row, "SCFPXH") }; if (!DanJia) { bool flag = ((item.SLV == 0.05) && (model.DJZL == "s")) && model.HYSY; if (item.DJHXZ == 4) { item.SL = 0.0; item.DJ = 0.0; } else if (!flag && item.HSJBZ) { if (!(item.SL == 0.0)) { item.DJ = item.JE / item.SL; } else { item.DJ = item.JE; } } } if (MXAll || string.IsNullOrEmpty(item.FPDM)) { model.ListXSDJ_MX.Add(item); } } return(model); }
private void listView1_MouseClick(object sender, MouseEventArgs e) { try { ListViewItem itemAt = this.listView1.GetItemAt(e.X, e.Y); if (itemAt.Name != "MX") { FPGenerateResult tag = (FPGenerateResult)itemAt.Tag; if (tag.DJZL != "j") { int num2; int index = itemAt.Index + 1; if ((index < this.listView1.Items.Count) && (this.listView1.Items[index].Name == "MX")) { for (num2 = 0; num2 < (tag.ListXSDJ_MX.Count + 1); num2++) { this.listView1.Items.RemoveAt(index); } } else { ListViewItem item = new ListViewItem { ForeColor = Color.Red, Name = "MX", Font = new Font("宋体", 10f) }; item.SubItems.Add("序号"); item.SubItems.Add("货物名称"); item.SubItems.Add("规格型号"); item.SubItems.Add("单位"); item.SubItems.Add("数量"); item.SubItems.Add("单价"); item.SubItems.Add("金额"); item.SubItems.Add("税额"); item.SubItems.Add("税率"); this.listView1.Items.Insert(index, item); for (num2 = 0; num2 < tag.ListXSDJ_MX.Count; num2++) { decimal num4; XSDJ_MXModel model = tag.ListXSDJ_MX[num2]; ListViewItem item3 = new ListViewItem { Name = "MX", ForeColor = Color.Blue, Font = new Font("宋体", 10f) }; int num3 = num2 + 1; item3.SubItems.Add(num3.ToString()); item3.SubItems.Add(model.SPMC); item3.SubItems.Add(model.GGXH); item3.SubItems.Add(model.JLDW); string text = (model.SL == 0.0) ? "" : (num4 = (decimal)model.SL).ToString(); item3.SubItems.Add(text); string str2 = (model.DJ == 0.0) ? "" : (num4 = (decimal)model.DJ).ToString(); item3.SubItems.Add(str2); item3.SubItems.Add(model.JE.ToString("F")); item3.SubItems.Add(model.SE.ToString("F")); string str3 = ""; if (model.SLV == 0.0) { str3 = "0%"; } else if (((tag.DJZL == "s") && (model.SLV == 0.05)) && tag.HYSY) { str3 = "中外合作油气田"; } else if (!((model.SLV != 0.015) || tag.HYSY)) { str3 = model.SLV.ToString("0.0%"); } else { str3 = model.SLV.ToString("0%"); } item3.SubItems.Add(str3); this.listView1.Items.Insert((index + 1) + num2, item3); } } } } } catch (Exception exception) { HandleException.HandleError(exception); } }