/// <summary> /// 初始化listbox菜单 /// </summary> private void InitListBoxDBBlock() { // 初始化加载 //点表 Maticsoft.BLL.cjplp cjplpBLL = new Maticsoft.BLL.cjplp(); List <Maticsoft.Model.cjplp> cjplpModelList = cjplpBLL.GetFileNames(); for (int i = 0; i < cjplpModelList.Count; i++) { //不包含则添加 if (!this.listBoxControlDBBlock.Items.Contains(cjplpModelList[i].FileName)) { this.listBoxControlDBBlock.Items.Add(cjplpModelList[i].FileName); } } //线表 Maticsoft.BLL.cjpll cjpllBLL = new Maticsoft.BLL.cjpll(); List <Maticsoft.Model.cjpll> cjpllModelList = cjpllBLL.GetFileNames(); for (int i = 0; i < cjpllModelList.Count; i++) { //不包含则添加 if (!this.listBoxControlDBBlock.Items.Contains(cjpllModelList[i].FileName)) { this.listBoxControlDBBlock.Items.Add(cjpllModelList[i].FileName); } } }
/// <summary> /// 删除线相关的内容 /// </summary> private void DeleteLineRealeatTables() { Maticsoft.BLL.cjpll cjpllBLL = new Maticsoft.BLL.cjpll(); Maticsoft.BLL.ps_pipe ps_pipeBLL = new Maticsoft.BLL.ps_pipe(); //删除选择的内容 if (this.listBoxControlDeleteBlock.Items.Count > 0) { //构造sql查询语句 string strWhere = String.Empty; ; for (int i = 0; i < listBoxControlDeleteBlock.Items.Count; i++) { if (i == listBoxControlDeleteBlock.Items.Count - 1) { strWhere += "FileName='" + listBoxControlDeleteBlock.Items[i].ToString() + "'"; } else { strWhere += "FileName='" + listBoxControlDeleteBlock.Items[i].ToString() + "' or"; } } List <Maticsoft.Model.cjpll> deleteCjplpsModelList = cjpllBLL.GetModelList(strWhere); for (int j = 0; j < deleteCjplpsModelList.Count; j++) { //删除点表 cjpllBLL.Delete(deleteCjplpsModelList[j].Exp_No0, deleteCjplpsModelList[j].Exp_No1); } List <Maticsoft.Model.ps_pipe> deleteps_pipeModelList = ps_pipeBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_pipeModelList.Count; j++) { //删除点表 cjpllBLL.Delete(deleteps_pipeModelList[j].Exp_No0, deleteps_pipeModelList[j].Exp_No1); } } // return cjpllBLL; }
/// <summary> /// 上传线表 /// </summary> private bool UpLoadLineSheet() { if (String.IsNullOrEmpty(this.textEditLineSheet.Text)) { MessageBox.Show("线表表单为空!请选择点表", "提示"); return(true); } DataSet dataSetLine = ExcelToDataSet(excelPath, this.textEditLineSheet.Text.Trim()); DataTable dataTableLine = dataSetLine.Tables[0]; dataTableLine.Columns.Add("FileName", typeof(string)); dataTableLine.Columns.Add("Uploadtime", typeof(string)); for (int i = 0; i < dataTableLine.Rows.Count; i++) { dataTableLine.Rows[i]["FileName"] = Path.GetFileNameWithoutExtension(excelPath); dataTableLine.Rows[i]["Uploadtime"] = DateTime.Now.ToString(); } Maticsoft.BLL.cjpll cjpllBLL = new Maticsoft.BLL.cjpll(); List <Maticsoft.Model.cjpll> cjpllModelList = cjpllBLL.DataTableToList(dataTableLine); Maticsoft.BLL.cjpllback cjpllBackBLL = new Maticsoft.BLL.cjpllback(); List <Maticsoft.Model.cjpllback> cjplpBackModelList = cjpllBackBLL.DataTableToList(dataTableLine); Maticsoft.BLL.exportinfo exportinfoBLL = new Maticsoft.BLL.exportinfo(); Maticsoft.Model.exportinfo exportinfoModel = new Maticsoft.Model.exportinfo(); for (int i = 0; i < cjpllModelList.Count; i++) { List <Maticsoft.Model.exportinfo> exportinfosModelList = exportinfoBLL.GetModelList(""); //不重复的数据 if (!cjpllBLL.Exists(cjpllModelList[i].Exp_No0, cjpllModelList[i].Exp_No1)) { cjpllBLL.Add(cjpllModelList[i]); } else { //存在就更新原始数据中的线表属性,因为可能修改了其它属性信息 cjpllBLL.Update(cjpllModelList[i]); //备份的数据库中,不重复的数据,则插入,否则,则更新 if (!cjpllBackBLL.Exists(cjpllModelList[i].Exp_No0, cjpllModelList[i].Exp_No1)) { cjpllBackBLL.Add(cjplpBackModelList[i]); } else { cjpllBackBLL.Update(cjplpBackModelList[i]); } } //导出配置表(exportinfo)中有配置数据,则对比 if (exportinfosModelList.Count > 0) { Int32 flag = 0; //导出表的配置 for (int j = 0; j < exportinfosModelList.Count; j++) { if (exportinfosModelList[j].Address != cjpllModelList[i].Address || !cjpllModelList[i].FileName.Contains(exportinfosModelList[j].Basin) || !cjpllModelList[i].FileName.Contains(exportinfosModelList[j].Strname) || !cjpllModelList[i].FileName.Contains(exportinfosModelList[j].Plot)) { flag++; } } if (flag == exportinfosModelList.Count) { string[] tempArr = cjpllModelList[i].FileName.Split('-'); //导出配置表(exportinfo)中没有配置数据,则直接插入 exportinfoModel.Address = cjpllModelList[i].Address; exportinfoModel.Basin = tempArr.Length > 0 ? tempArr[0] : string.Empty; exportinfoModel.Strname = tempArr.Length > 1 ? tempArr[1] : string.Empty; exportinfoModel.Plot = tempArr.Length > 2 ? tempArr[2].Substring(0, tempArr[2].IndexOf("_")) : string.Empty; exportinfoModel.FileName = cjpllModelList[i].FileName; exportinfoBLL.Add(exportinfoModel); } } else { string[] tempArr = cjpllModelList[i].FileName.Split('-'); //导出配置表(exportinfo)中没有配置数据,则直接插入 exportinfoModel.Address = cjpllModelList[i].Address; exportinfoModel.Basin = tempArr.Length > 0 ? tempArr[0] : string.Empty; exportinfoModel.Strname = tempArr.Length > 1 ? tempArr[1] : string.Empty; exportinfoModel.Plot = tempArr.Length > 2 ? tempArr[2].Substring(0, tempArr[2].IndexOf("_")) : string.Empty; exportinfoModel.FileName = cjpllModelList[i].FileName; exportinfoBLL.Add(exportinfoModel); } } return(false); }