private void aisinoDataGrid1_DataGridRowDbClickEvent(object sender, DataGridRowEventArgs e) { try { this.SelectBM = e.CurrentRow.Cells["BM"].Value.ToString(); this.SelectBMMC = e.CurrentRow.Cells["MC"].Value.ToString(); DAL.BMSPFLManager manager = new DAL.BMSPFLManager(); if (this.Isxtsp) { bool isSPBMSel = BMType.BM_SP == this.GetBMType(); if (manager.CanUseThisSPFLBM(this.SelectBM, isSPBMSel, true)) { base.DialogResult = DialogResult.OK; base.Close(); base.Dispose(); } } else { bool flag2 = BMType.BM_SP == this.GetBMType(); if (manager.CanUseThisSPFLBM(this.SelectBM, flag2, false)) { base.DialogResult = DialogResult.OK; base.Close(); base.Dispose(); } } } catch (Exception exception) { this.log.Error(exception.ToString()); ExceptionHandler.HandleError(exception); } }
private void ComBoxSPFL_TextChanged(object sender, EventArgs e) { if (this.comBoxSPFL.Text.Trim() != "") { int selectionStart = this.comBoxSPFL.SelectionStart; this.comBoxSPFL.Text = StringUtils.GetSubString(this.comBoxSPFL.Text, 0x13).Trim(); this.comBoxSPFL.SelectionStart = selectionStart; this.comboBoxYHZC.SelectedIndex = 1; object[] objArray = ServiceFactory.InvokePubService("Aisino.Fwkp.Bmgl.GetSLV_BY_BM", new object[] { this.comBoxSPFL.Text.Trim() }); if (((objArray != null) && ((objArray[0] as DataTable).Rows.Count > 0)) && ((objArray[0] as DataTable).Rows[0]["SLV"].ToString() != "")) { DAL.BMSPFLManager manager = new DAL.BMSPFLManager(); if (!manager.CanUseThisSPFLBM(this.comBoxSPFL.Text.Trim(), false, false)) { MessageBox.Show("查无此分类编码或此分类编码不可用,请重新输入!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Hand); this.comBoxSPFL.Focus(); this.comboBoxYHZC.SelectedIndex = 1; this.comboBoxYHZC.Enabled = false; return; } } this.AdjustComboBoxYHZC(); this.AdjustComboBoxYHZCMC(); } }
private bool SimpleValidated() { bool flag = true; if (this.textBoxWaitMC.Text.Trim().Length == 0) { this.textBoxWaitMC.Focus(); flag = false; } if (this.textBoxJM.Text.Trim().Trim().Length != 0) { string input = this.textBoxJM.Text.Trim(); if ((input[0] < 'A') || (input[0] > 'Z')) { this.textBoxJM.Focus(); flag = false; MessageManager.ShowMsgBox("INP-235501"); return(flag); } string pattern = "^[A-Z0-9]+$"; Regex regex = new Regex(pattern); if (!regex.IsMatch(input)) { this.textBoxJM.Focus(); flag = false; MessageManager.ShowMsgBox("INP-235502"); return(flag); } } if (Flbm.IsYM()) { DAL.BMSPFLManager manager = new DAL.BMSPFLManager(); if (!manager.CanUseThisSPFLBM(this.comBoxSPFL.Text.Trim(), false, false)) { MessageBox.Show("查无此分类编码或此分类编码不可用,请重新输入!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Hand); this.comBoxSPFL.Focus(); this.SPFLMC.Text = ""; return(false); } this.SPFLMC.Text = manager.GetSPFLMCBYBM(this.comBoxSPFL.Text.Trim()); if (("是" == this.comboBoxYHZC.SelectedItem.ToString()) && (this.comboBoxYHZCMC.Text == "")) { MessageBox.Show("优惠类型不能为空,请重新选择!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Hand); this.comboBoxYHZCMC.Focus(); return(false); } } else { flag = true; } if (!flag) { MessageManager.ShowMsgBox("INP-235309"); } return(flag); }
public void ChooseYHZCMCForFYXM() { DataTable table = new DAL.BMFYXMManager().QueryFYXMYHZCIsAndYHZCMCIsEmpty(); if (table != null) { DAL.BMSPFLManager manager2 = new DAL.BMSPFLManager(); List <string> sqlID = new List <string>(); List <Dictionary <string, object> > param = new List <Dictionary <string, object> >(); for (int i = 0; i < table.Rows.Count; i++) { Dictionary <string, object> item = new Dictionary <string, object>(); string str = GetSafeData.ValidateValue <string>(table.Rows[i], "BM"); string bm = GetSafeData.ValidateValue <string>(table.Rows[i], "SPFL"); string str3 = GetSafeData.ValidateValue <string>(table.Rows[i], "YHZC"); string sPFLMCBYBM = manager2.GetSPFLMCBYBM(bm); string str5 = ""; object[] objArray = ServiceFactory.InvokePubService("Aisino.Fwkp.Bmgl.GetSLV_BY_BM", new object[] { bm }); if ((objArray != null) && (objArray.Length > 0)) { string[] strArray = (objArray[0] as DataTable).Rows[0]["ZZSTSGL"].ToString().Split(new char[] { ',', '、', ';', ',', ';' }); if (strArray.Length > 0) { str5 = strArray[0]; if ((!Flbm.IsDK() && (strArray.Length == 1)) && strArray[0].Contains("1.5%")) { str3 = "否"; str5 = ""; } if ((!Flbm.IsDK() && (strArray.Length > 1)) && strArray[0].Contains("1.5%")) { str5 = strArray[1]; } } else { str3 = "否"; } } else { str3 = "否"; } item.Add("BM", str); item.Add("SPFL", bm); item.Add("SPFLMC", sPFLMCBYBM); item.Add("YHZC", str3); item.Add("YHZCMC", str5); sqlID.Add("aisino.Fwkp.Bmgl.BMSPFL.UpdateFYXMSPFL"); param.Add(item); } new DAL.BMSPFLManager().UpdateSPFLTable(sqlID, param, false); } }
public void checkspspfl() { DataTable table = new DAL.BMSPManager().QuerySPSPFLLNotEmptyAndNotXT(); if (table != null) { DAL.BMSPFLManager manager2 = new DAL.BMSPFLManager(); List <string> sqlID = new List <string>(); List <Dictionary <string, object> > param = new List <Dictionary <string, object> >(); for (int i = 0; i < table.Rows.Count; i++) { Dictionary <string, object> item = new Dictionary <string, object>(); string str = GetSafeData.ValidateValue <string>(table.Rows[i], "BM"); string bm = GetSafeData.ValidateValue <string>(table.Rows[i], "SPFL"); string str3 = GetSafeData.ValidateValue <string>(table.Rows[i], "LSLVBS"); string str4 = GetSafeData.ValidateValue <string>(table.Rows[i], "YHZC"); string str5 = GetSafeData.ValidateValue <string>(table.Rows[i], "YHZCMC"); string sPFLMCBYBM = string.Empty; item.Add("BM", str); if (manager2.CanUseThisSPFLBM(bm, true, false)) { item.Add("SPFL", bm); sPFLMCBYBM = manager2.GetSPFLMCBYBM(bm); item.Add("SPFLMC", sPFLMCBYBM); if (manager2.CanUseThisYHZC(bm)) { item.Add("YHZC", str4); item.Add("YHZCMC", str5); item.Add("LSLVBS", str3); } else { item.Add("YHZC", "否"); item.Add("YHZCMC", ""); item.Add("LSLVBS", ""); } } else { item.Add("SPFL", ""); item.Add("SPFLMC", ""); item.Add("YHZC", ""); item.Add("YHZCMC", ""); item.Add("LSLVBS", ""); } sqlID.Add("aisino.Fwkp.Bmgl.BMSPFL.UpdateSPSPFL"); param.Add(item); } new DAL.BMSPFLManager().UpdateSPFLTable(sqlID, param, false); } }
private List <Dictionary <string, object> > HandleWJJD(List <Dictionary <string, object> > listSPFL) { List <Dictionary <string, object> > list = listSPFL; DataTable sJBM = new DAL.BMSPFLManager().GetSJBM(); try { for (int i = 0; i < list.Count; i++) { list[i]["WJ"] = this.GetWJ(list[i]["BM"].ToString(), list, sJBM); } } catch (Exception) { throw; } return(list); }
protected override object[] doService(object[] param) { if (param.Length == 2) { string bm = (string)param[0]; bool isSPBMSel = (bool)param[1]; DAL.BMSPFLManager manager = new DAL.BMSPFLManager(); return(new object[] { manager.CanUseThisSPFLBM(bm, isSPBMSel, false) }); } if (param.Length >= 3) { string str2 = (string)param[0]; bool flag2 = (bool)param[1]; bool isXTSP = (bool)param[2]; DAL.BMSPFLManager manager2 = new DAL.BMSPFLManager(); return(new object[] { manager2.CanUseThisSPFLBM(str2, flag2, isXTSP) }); } return(null); }
private void aisinoDataGrid1_DataGridRowKeyDown(object sender, KeyEventArgs e) { try { if ((e.KeyCode == Keys.Enter) && (this.aisinoDataGrid1.SelectedRows.Count > 0)) { string str = this.aisinoDataGrid1.SelectedRows[0].Cells["WJ"].Value.ToString(); this.SelectBM = this.aisinoDataGrid1.SelectedRows[0].Cells["BM"].Value.ToString(); this.SelectBMMC = this.aisinoDataGrid1.SelectedRows[0].Cells["MC"].Value.ToString(); string str2 = this.aisinoDataGrid1.SelectedRows[0].Cells["HZX"].Value.ToString().Trim(); DAL.BMSPFLManager manager = new DAL.BMSPFLManager(); if (this.Isxtsp) { if (((str == "1") && (str2 == "N")) && manager.CanUseThisSPFLBM(this.SelectBM, true, true)) { base.DialogResult = DialogResult.OK; base.Close(); base.Dispose(); } } else { bool isSPBMSel = BMType.BM_SP == this.GetBMType(); if (((str == "1") && (str2 == "N")) && manager.CanUseThisSPFLBM(this.SelectBM, isSPBMSel, false)) { base.DialogResult = DialogResult.OK; base.Close(); base.Dispose(); } } } } catch (Exception exception) { this.log.Error(exception.ToString()); ExceptionHandler.HandleError(exception); } }
public ImportResult ImportDataZC(string codeFile) { new Dictionary <string, object>(); ImportResult result = new ImportResult(); XmlDocument document = new XmlDocument(); try { try { document.Load(codeFile); } catch { throw new Exception("不符合机动车编码格式"); } XmlNode documentElement = document.DocumentElement; try { if (documentElement.Attributes["TYPE"].Value != "JDCBIANMA") { throw new Exception("不符合机动车编码格式"); } } catch { throw new Exception("不符合机动车编码格式"); } XmlNodeList list = null; list = documentElement.SelectNodes("/Data/CLXX/Row"); List <Dictionary <string, string> > list2 = new List <Dictionary <string, string> >(); foreach (XmlNode node2 in list) { Dictionary <string, string> item = new Dictionary <string, string>(); if (Flbm.IsYM()) { if (node2.Attributes["SPFLBM"] == null) { item.Add("SPFLBM", ""); } else { item.Add(node2.Attributes["SPFLBM"].Name, node2.Attributes["SPFLBM"].Value); } } item.Add(node2.Attributes["SCQYMC"].Name, node2.Attributes["SCQYMC"].Value); item.Add(node2.Attributes["DJ"].Name, node2.Attributes["DJ"].Value); item.Add(node2.Attributes["CDMC"].Name, node2.Attributes["CDMC"].Value); item.Add(node2.Attributes["CPXH"].Name, node2.Attributes["CPXH"].Value); item.Add(node2.Attributes["CLLXMC"].Name, node2.Attributes["CLLXMC"].Value); item.Add(node2.Attributes["CLDLMC"].Name, node2.Attributes["CLDLMC"].Value); item.Add(node2.Attributes["CPBM"].Name, node2.Attributes["CPBM"].Value); list2.Add(item); } DAL.BMSPFLManager manager = new DAL.BMSPFLManager(); foreach (Dictionary <string, string> dictionary2 in list2) { BMCLModel car = new BMCLModel(); string searchid = ""; searchid = this.bmclDAL.AutoNodeLogic(dictionary2["CLDLMC"]); car.SJBM = searchid; car.BM = this.TuiJianBM(searchid); car.MC = dictionary2["CLLXMC"]; car.SCCJMC = dictionary2["SCQYMC"]; car.CPXH = dictionary2["CPXH"]; car.CD = dictionary2["CDMC"]; if (Flbm.IsYM() && manager.CanUseThisSPFLBM(dictionary2["SPFLBM"], false, false)) { car.SPFL = dictionary2["SPFLBM"]; car.SPFLMC = manager.GetSPFLMCBYBM(car.SPFL); if (!manager.CanUseThisYHZC(car.SPFL)) { car.YHZC = "否"; car.YHZCMC = ""; } } car.KJM = CommonFunc.GenerateKJM(car.MC); car.WJ = 1; string str2 = this.AddCustomerToAuto(car, car.SJBM); if ("OverWrite" == str2) { result.Correct++; result.DtResult.Rows.Add(new object[] { car.BM, car.MC, "正确传入", "覆盖记录:" + car.BM }); } else if ("Insert" == str2) { result.Correct++; result.DtResult.Rows.Add(new object[] { car.BM, car.MC, "正确传入", "插入成功:" + car.BM }); } else { result.Failed++; result.DtResult.Rows.Add(new object[] { car.BM, car.MC, "失败", "数据库读写错误" }); } } } catch { throw; } result.ImportTable = "车辆编码.DB"; return(result); }
public ImportResult ImportData(string codeFile) { ImportResult result2; try { string[] strArray = File.ReadAllLines(codeFile, ToolUtil.GetEncoding()); if (strArray.Length == 0) { throw new CustomException("此文件没有内容"); } string str = ""; int index = 0; bool flag = true; while (flag) { if (strArray[index].StartsWith("{车辆编码}")) { string str2 = strArray[index]; if (!str2.Contains("\"")) { throw new CustomException("此文件首行车辆编码没有指定分隔符,分隔符使用双引号标注"); } str = str2.Substring(str2.IndexOf("\"")).Trim().Trim(new char[] { '"' }); flag = false; index++; } else { index++; if (index == strArray.Length) { throw new CustomException("此文件不符合车辆编码文本格式"); } } } ImportResult result = new ImportResult(); Stack <lastBMJG> stack = new Stack <lastBMJG>(); string str4 = this.TuiJianBM(""); string str5 = ""; bool flag2 = false; for (int i = index; i < strArray.Length; i++) { BMCLModel model; string lineText = strArray[i].Trim(); if (((lineText.Length == 0) || lineText.StartsWith("//")) || !lineText.Contains(str)) { continue; } string[] strArray2 = GetSafeData.Split(lineText, str); if (strArray2.Length < 3) { throw new CustomException("文本首行指定的分隔符与实际分隔符不一致,\n格式不正确等原因导致不能导入此文件!"); } model = new BMCLModel { BM = strArray2[0], MC = strArray2[1], JM = strArray2[2], }; model.KJM = CommonFunc.GenerateKJM(model.MC); string str7 = ""; string str8 = ""; ResultType none = ResultType.None; if (strArray2.Length > 3) { if (strArray2.Length < 6) { throw new CustomException(string.Format("第{0}行数据不全", i)); } model.WJ = 1; string str9 = ""; if (str == "~~") { str9 = strArray2[3].Replace(",", "\r\n").Replace("#|#", "\r\n"); } else if (str == " ") { str9 = strArray2[3].Replace("#|#", "\r\n"); } else { str9 = strArray2[3]; } model.CPXH = str9; string str10 = ""; if (str == "~~") { str10 = strArray2[4].Replace(",", "\r\n").Replace("#|#", "\r\n"); } else if (str == " ") { str10 = strArray2[4].Replace("#|#", "\r\n"); } else { str10 = strArray2[4]; } model.CD = str10; string str11 = ""; if (str == "~~") { str11 = strArray2[5].Replace(",", "\r\n").Replace("#|#", "\r\n"); } else if (str == " ") { str11 = strArray2[5].Replace("#|#", "\r\n"); } else { str11 = strArray2[5]; } model.SCCJMC = str11; if (Flbm.IsYM() && (strArray2.Length > 6)) { DAL.BMSPFLManager manager = new DAL.BMSPFLManager(); string bm = ""; if (str == "~~") { bm = strArray2[6].Replace(",", "\r\n").Replace("#|#", "\r\n"); } else if (str == " ") { bm = strArray2[6].Replace("#|#", "\r\n"); } else { bm = strArray2[6]; } if (strArray2.Length > 7) { string str13 = ""; if (str == "~~") { str13 = strArray2[7].Replace(",", "\r\n").Replace("#|#", "\r\n"); } else if (str == " ") { str13 = strArray2[7].Replace("#|#", "\r\n"); } else { str13 = strArray2[7]; } if (manager.CanUseThisSPFLBM(bm, false, false)) { model.SPFL = bm; model.SPFLMC = manager.GetSPFLMCBYBM(bm); if (manager.CanUseThisYHZC(bm)) { if ((str13.Trim() == "是") || (str13.Trim() == "否")) { model.YHZC = str13; if (model.YHZC == "否") { model.YHZCMC = ""; } } else { model.YHZC = "否"; model.YHZCMC = ""; } if (strArray2.Length > 9) { bool flag3 = false; if (str13.Trim() == "是") { object[] objArray = ServiceFactory.InvokePubService("Aisino.Fwkp.Bmgl.GetSLV_BY_BM", new object[] { model.SPFL }); if ((objArray != null) && (objArray.Length > 0)) { string[] strArray3 = (objArray[0] as DataTable).Rows[0]["ZZSTSGL"].ToString().Split(new char[] { ',', '、', ';', ',', ';' }); if (strArray3.Length > 0) { foreach (string str14 in strArray3) { if (strArray2[9].Trim() == str14) { model.YHZC = "是"; string str15 = ""; if (str == "~~") { str15 = strArray2[9].Replace(",", "\r\n").Replace("#|#", "\r\n"); } else if (str == " ") { str15 = strArray2[9].Replace("#|#", "\r\n"); } else { str15 = strArray2[9]; } model.YHZCMC = str15; flag3 = true; } if (!Flbm.IsDK() && strArray2[9].Trim().Contains("1.5%")) { model.YHZC = "否"; model.YHZCMC = ""; } } } } if (!flag3) { model.YHZC = "否"; model.YHZCMC = ""; } } else if (str13.Trim() == "否") { model.YHZC = "否"; model.YHZCMC = ""; } else { model.YHZC = "否"; model.YHZCMC = ""; } } } else { model.YHZC = "否"; model.YHZCMC = ""; } } } } } while (stack.Count > 0) { flag2 = false; if (model.BM.Length > stack.Peek().BM.Length) { if (!model.BM.StartsWith(stack.Peek().BM)) { goto Label_07AE; } model.SJBM = stack.Peek().BM; if (stack.Peek().Result == ResultType.Invalid) { str7 = "无效"; str8 = "上级编码无效"; none = ResultType.Invalid; result.Invalid++; } else if (stack.Peek().Result == ResultType.Failed) { str7 = "失败"; str8 = "上级编码失败"; none = ResultType.Failed; result.Failed++; } else { if (stack.Peek().Result != ResultType.Duplicated) { goto Label_07AE; } str5 = this.TuiJianBM(stack.Peek().BM); if (model.BM.Length == str5.Length) { goto Label_07AE; } str7 = "无效"; str8 = "编码长度必须与原有同级编码长度一致"; result.Invalid++; none = ResultType.Invalid; } goto Label_0940; } stack.Pop(); } flag2 = true; Label_07AE: if ((flag2 && (str4 != "001")) && (model.BM.Length != str4.Length)) { str7 = "无效"; str8 = "编码长度必须与原有同级编码长度一致"; result.Invalid++; none = ResultType.Invalid; } else if ("0" != this.CheckCustomer(model)) { str7 = "无效"; str8 = "编码或名称为空"; result.Invalid++; none = ResultType.Invalid; } else if (!Regex.IsMatch(model.BM, "^[0-9a-z]{1,16}$")) { str7 = "无效"; str8 = "编码需小于16位,且仅由数字和小写字母组成"; result.Invalid++; none = ResultType.Invalid; } else if (this.bmclDAL.ExistCustomer(model)) { if (str7.Length == 0) { str7 = "重复"; result.Duplicated++; } if (str8.Length == 0) { str8 = "编码重复"; none = ResultType.Duplicated; } else { str8 = str8 + "且编码重复"; none = ResultType.Invalid; } } else { string[] spellCode = StringUtils.GetSpellCode(model.MC); for (int j = 0; j < spellCode.Length; j++) { string text1 = spellCode[j]; } if (this.bmclDAL.AddCustomer(model) == "0") { str7 = "正确传入"; result.Correct++; none = ResultType.Correct; } else { str7 = "失败"; result.Failed++; none = ResultType.Failed; } } Label_0940 :; result.DtResult.Rows.Add(new object[] { model.BM, model.MC, str7, str8 }); stack.Push(new lastBMJG(model.BM, none)); } result.ImportTable = "车辆编码.DB"; result2 = result; } catch { throw; } return(result2); }
public ImportResult ImportDataSPFL(string codeFile) { Dictionary <string, object> dictionary; ImportResult result = new ImportResult(); XmlDocument document = new XmlDocument(); try { document.Load(codeFile); XmlNode documentElement = document.DocumentElement; if ((documentElement.Attributes["id"].Value != "spbm") && (documentElement.Attributes["id"].Value != "SPBM")) { throw new Exception("导入税收分类编码文件格式不正确!"); } } catch { throw new Exception("导入税收分类编码文件格式不正确!"); } string innerText = document.GetElementsByTagName("MWJY")[0].InnerText; string text1 = document.GetElementsByTagName("COUNT")[0].InnerText; string str = string.Empty; XmlNodeList elementsByTagName = document.GetElementsByTagName("BBH"); if ((elementsByTagName == null) || (elementsByTagName.Count < 1)) { throw new Exception("导入税收分类编码版本号异常!"); } string maxBMBBBH = this.GetMaxBMBBBH(); string s = elementsByTagName[0].InnerText; if (float.Parse(maxBMBBBH) >= float.Parse(s)) { throw new Exception("导入文件中税收分类编码版本号过低,系统不允许导入!"); } List <string> sqlID = new List <string>(); List <Dictionary <string, object> > listSPFL = new List <Dictionary <string, object> >(); XmlNodeList list6 = document.GetElementsByTagName("BMXX"); for (int i = 0; i < list6.Count; i++) { dictionary = new Dictionary <string, object>(); XmlNodeList childNodes = list6[i].ChildNodes; if (childNodes != null) { dictionary.Add("BMB_BBH", s); foreach (XmlNode node2 in childNodes) { switch (node2.Name) { case "SPBM": { dictionary.Add("HBBM", node2.InnerText); str = str + node2.InnerText; string bM = this.GetBM(node2.InnerText); dictionary.Add("BM", bM); dictionary.Add("SJBM", this.GetSJBM(bM)); continue; } case "SPMC": { dictionary.Add("MC", node2.InnerText); continue; } case "SM": { dictionary.Add("SM", node2.InnerText); continue; } case "ZZSSL": { dictionary.Add("SLV", node2.InnerText); str = str + node2.InnerText; continue; } case "GJZ": { dictionary.Add("GJZ", node2.InnerText); continue; } case "HZX": { dictionary.Add("HZX", node2.InnerText); continue; } case "BB": { dictionary.Add("BBH", node2.InnerText); continue; } case "KYZT": { dictionary.Add("KYZT", node2.InnerText); continue; } case "ZZSTSGL": { dictionary.Add("ZZSTSGL", node2.InnerText); str = str + node2.InnerText; continue; } case "ZZSZCYJ": { dictionary.Add("ZZSZCYJ", node2.InnerText); continue; } case "ZZSTSNRDM": { dictionary.Add("ZZSTSNRDM", node2.InnerText); continue; } case "XFSGL": { dictionary.Add("XFSGL", node2.InnerText); continue; } case "XFSZCYJ": { dictionary.Add("XFSZCYJ", node2.InnerText); continue; } case "XFSTSNRDM": { dictionary.Add("XFSTSNRDM", node2.InnerText); continue; } case "TJJBM": { dictionary.Add("TJJBM", node2.InnerText); continue; } case "HGJCKSPPM": { dictionary.Add("HGJCKSPPM", node2.InnerText); continue; } case "QYSJ": { dictionary.Add("QYSJ", node2.InnerText); continue; } case "GDQJZSJ": { dictionary.Add("GDQJZSJ", node2.InnerText); continue; } case "GXSJ": { if (node2.InnerText.Trim().Length <= 8) { break; } dictionary.Add("GXSJ", DateTime.Parse(node2.InnerText)); continue; } default: { continue; } } DateTime time = DateTime.ParseExact(node2.InnerText, "yyyyMMdd", CultureInfo.CurrentCulture, DateTimeStyles.AllowWhiteSpaces); dictionary.Add("GXSJ", time); } sqlID.Add("aisino.Fwkp.Bmgl.BMSPFL.ReplaceSPFL"); listSPFL.Add(dictionary); } } if ((listSPFL != null) && (listSPFL.Count > 1)) { listSPFL = this.HandleWJJD(listSPFL); } XmlNodeList list8 = document.GetElementsByTagName("ZZSYHZC"); if ((list8 != null) && (list8.Count > 1)) { //Dictionary<string, object> dictionary2; //dictionary2 = new Dictionary<string, object> { // "aisino.Fwkp.Bmgl.BMSPFL.DeleteYHZC", // dictionary2 //}; foreach (XmlNode node3 in list8) { dictionary = new Dictionary <string, object>(); XmlNodeList list9 = node3.ChildNodes; if ((list9 != null) && (list9.Count >= 1)) { dictionary = new Dictionary <string, object>(); foreach (XmlNode node4 in list9) { string name = node4.Name; if (name != null) { if (!(name == "YHZCMC")) { if (name == "SL") { goto Label_06B5; } } else { dictionary.Add("Yhzcmc", node4.InnerText); str = str + node4.InnerText; } } continue; Label_06B5: dictionary.Add("SLv", node4.InnerText); str = str + node4.InnerText; } sqlID.Add("aisino.Fwkp.Bmgl.BMSPFL.InsertYHZC"); listSPFL.Add(dictionary); } } } str = str + "0123456789"; string str6 = this.UserMd5(str); DAL.BMSPFLManager manager = new DAL.BMSPFLManager(); if (!(str6 == innerText)) { throw new Exception("密文校验失败!"); } if (!manager.UpdateSPFLTable(sqlID, listSPFL, false)) { throw new Exception("税收分类编码导入失败!"); } this.checkspspfl(); this.checkclspfl(); this.checkfyxmspfl(); new SPFLService().UpdateBMBBBH(s); MessageBoxHelper.Show("税收分类编码导入成功!", "正确", MessageBoxButtons.OK, MessageBoxIcon.None); result.ImportTable = "税收分类编码.DB"; return(result); }
public string GetMaxBMBBBH() { DAL.BMSPFLManager manager = new DAL.BMSPFLManager(); return(manager.GetSBBPBBH()); }
public void AutoImportDatabase(string codeFile) { Dictionary <string, object> dictionary; XmlDocument document = new XmlDocument(); document.Load(codeFile); string innerText = document.GetElementsByTagName("MWJY")[0].InnerText; string text1 = document.GetElementsByTagName("COUNT")[0].InnerText; string str = string.Empty; XmlNodeList elementsByTagName = document.GetElementsByTagName("BBH"); if (elementsByTagName != null) { int count = elementsByTagName.Count; } string maxBMBBBH = this.GetMaxBMBBBH(); string s = elementsByTagName[0].InnerText; float.Parse(s); float.Parse(maxBMBBBH); List <string> sqlID = new List <string>(); List <Dictionary <string, object> > listSPFL = new List <Dictionary <string, object> >(); XmlNodeList list6 = document.GetElementsByTagName("BMXX"); for (int i = 0; i < list6.Count; i++) { dictionary = new Dictionary <string, object>(); XmlNodeList childNodes = list6[i].ChildNodes; if (childNodes != null) { dictionary.Add("BMB_BBH", s); foreach (XmlNode node in childNodes) { switch (node.Name) { case "SPBM": { dictionary.Add("HBBM", node.InnerText); str = str + node.InnerText; string bM = this.GetBM(node.InnerText); dictionary.Add("BM", bM); dictionary.Add("SJBM", this.GetSJBM(bM)); continue; } case "SPMC": { dictionary.Add("MC", node.InnerText); continue; } case "SM": { dictionary.Add("SM", node.InnerText); continue; } case "ZZSSL": { dictionary.Add("SLV", node.InnerText); str = str + node.InnerText; continue; } case "GJZ": { dictionary.Add("GJZ", node.InnerText); continue; } case "HZX": { dictionary.Add("HZX", node.InnerText); continue; } case "BB": { dictionary.Add("BBH", node.InnerText); continue; } case "KYZT": { dictionary.Add("KYZT", node.InnerText); continue; } case "ZZSTSGL": { dictionary.Add("ZZSTSGL", node.InnerText); str = str + node.InnerText; continue; } case "ZZSZCYJ": { dictionary.Add("ZZSZCYJ", node.InnerText); continue; } case "ZZSTSNRDM": { dictionary.Add("ZZSTSNRDM", node.InnerText); continue; } case "XFSGL": { dictionary.Add("XFSGL", node.InnerText); continue; } case "XFSZCYJ": { dictionary.Add("XFSZCYJ", node.InnerText); continue; } case "XFSTSNRDM": { dictionary.Add("XFSTSNRDM", node.InnerText); continue; } case "TJJBM": { dictionary.Add("TJJBM", node.InnerText); continue; } case "HGJCKSPPM": { dictionary.Add("HGJCKSPPM", node.InnerText); continue; } case "QYSJ": { dictionary.Add("QYSJ", node.InnerText); continue; } case "GDQJZSJ": { dictionary.Add("GDQJZSJ", node.InnerText); continue; } case "GXSJ": { if (node.InnerText.Trim().Length <= 8) { break; } dictionary.Add("GXSJ", DateTime.Parse(node.InnerText)); continue; } default: { continue; } } DateTime time = DateTime.ParseExact(node.InnerText, "yyyyMMdd", CultureInfo.CurrentCulture, DateTimeStyles.AllowWhiteSpaces); dictionary.Add("GXSJ", time); } sqlID.Add("aisino.Fwkp.Bmgl.BMSPFL.ReplaceSPFL"); listSPFL.Add(dictionary); } } if ((listSPFL != null) && (listSPFL.Count > 1)) { listSPFL = this.HandleWJJD(listSPFL); } XmlNodeList list8 = document.GetElementsByTagName("ZZSYHZC"); if ((list8 != null) && (list8.Count > 1)) { //Dictionary<string, object> dictionary2; //dictionary2 = new Dictionary<string, object> { // "aisino.Fwkp.Bmgl.BMSPFL.DeleteYHZC", // dictionary2 //}; foreach (XmlNode node2 in list8) { dictionary = new Dictionary <string, object>(); XmlNodeList list9 = node2.ChildNodes; if ((list9 != null) && (list9.Count >= 1)) { dictionary = new Dictionary <string, object>(); foreach (XmlNode node3 in list9) { string name = node3.Name; if (name != null) { if (!(name == "YHZCMC")) { if (name == "SL") { goto Label_0634; } } else { dictionary.Add("Yhzcmc", node3.InnerText); str = str + node3.InnerText; } } continue; Label_0634: dictionary.Add("SLv", node3.InnerText); str = str + node3.InnerText; } sqlID.Add("aisino.Fwkp.Bmgl.BMSPFL.InsertYHZC"); listSPFL.Add(dictionary); } } } str = str + "0123456789"; string str6 = this.UserMd5(str); DAL.BMSPFLManager manager = new DAL.BMSPFLManager(); if ((str6 == innerText) && manager.UpdateSPFLTable(sqlID, listSPFL, false)) { new SPFLService().UpdateBMBBBH(s); } }