/// <summary> /// 删除点相关的内容 /// </summary> /// <returns></returns> private void DeletePointRealeatTables() { Maticsoft.BLL.cjplp cjplpBLL = new Maticsoft.BLL.cjplp(); Maticsoft.BLL.ps_comb ps_combBLL = new Maticsoft.BLL.ps_comb(); Maticsoft.BLL.ps_discharger ps_dischargerBLL = new Maticsoft.BLL.ps_discharger(); Maticsoft.BLL.ps_gate ps_gateBLL = new Maticsoft.BLL.ps_gate(); Maticsoft.BLL.ps_manhole ps_manholeBLL = new Maticsoft.BLL.ps_manhole(); Maticsoft.BLL.ps_outfall ps_outfallBLL = new Maticsoft.BLL.ps_outfall(); Maticsoft.BLL.ps_point ps_pointBLL = new Maticsoft.BLL.ps_point(); Maticsoft.BLL.ps_pumpstation ps_pumpstationBLL = new Maticsoft.BLL.ps_pumpstation(); Maticsoft.BLL.ps_retention ps_retentionBLL = new Maticsoft.BLL.ps_retention(); Maticsoft.BLL.ps_valve ps_valveBLL = new Maticsoft.BLL.ps_valve(); Maticsoft.BLL.ps_weir ps_weirBLL = new Maticsoft.BLL.ps_weir(); Maticsoft.BLL.ps_wwtp ps_wwtpBLL = new Maticsoft.BLL.ps_wwtp(); //删除选择的内容 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"; } } //删除cjplp原始数据库的点 List <Maticsoft.Model.cjplp> deleteCjplpsModelList = cjplpBLL.GetModelList(strWhere); for (int j = 0; j < deleteCjplpsModelList.Count; j++) { cjplpBLL.Delete(deleteCjplpsModelList[j].Exp_NoOri); } //删除cjplp原始数据库的点 List <Maticsoft.Model.ps_comb> deleteps_combModelList = ps_combBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_combModelList.Count; j++) { cjplpBLL.Delete(deleteps_combModelList[j].Exp_NoOri); } //删除cjplp原始数据库的点 List <Maticsoft.Model.ps_discharger> deleteps_dischargerModelList = ps_dischargerBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_dischargerModelList.Count; j++) { cjplpBLL.Delete(deleteps_dischargerModelList[j].Exp_NoOri); } //删除cjplp原始数据库的点 List <Maticsoft.Model.ps_gate> deleteps_gateModelList = ps_gateBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_gateModelList.Count; j++) { cjplpBLL.Delete(deleteps_gateModelList[j].Exp_NoOri); } //删除cjplp原始数据库的点 List <Maticsoft.Model.ps_manhole> deleteps_manholeModelList = ps_manholeBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_manholeModelList.Count; j++) { cjplpBLL.Delete(deleteps_manholeModelList[j].Exp_NoOri); } //删除cjplp原始数据库的点 List <Maticsoft.Model.ps_outfall> deleteps_outfallModelList = ps_outfallBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_outfallModelList.Count; j++) { cjplpBLL.Delete(deleteps_outfallModelList[j].Exp_NoOri); } //删除cjplp原始数据库的点 List <Maticsoft.Model.ps_point> deleteps_pointModelList = ps_pointBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_pointModelList.Count; j++) { cjplpBLL.Delete(deleteps_pointModelList[j].Exp_NoOri); } //删除cjplp原始数据库的点 List <Maticsoft.Model.ps_pumpstation> deleteps_pumpstationModelList = ps_pumpstationBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_pumpstationModelList.Count; j++) { cjplpBLL.Delete(deleteps_pumpstationModelList[j].Exp_NoOri); } //删除cjplp原始数据库的点 List <Maticsoft.Model.ps_retention> deleteps_retentionModelList = ps_retentionBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_retentionModelList.Count; j++) { cjplpBLL.Delete(deleteps_retentionModelList[j].Exp_NoOri); } //删除cjplp原始数据库的点 List <Maticsoft.Model.ps_valve> deleteps_valveModelList = ps_valveBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_valveModelList.Count; j++) { cjplpBLL.Delete(deleteps_valveModelList[j].Exp_NoOri); } //删除cjplp原始数据库的点 List <Maticsoft.Model.ps_weir> deleteps_weirModelList = ps_weirBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_weirModelList.Count; j++) { cjplpBLL.Delete(deleteps_weirModelList[j].Exp_NoOri); } //删除cjplp原始数据库的点 List <Maticsoft.Model.ps_wwtp> deleteps_wwtpModelList = ps_wwtpBLL.GetModelList(strWhere); for (int j = 0; j < deleteps_wwtpModelList.Count; j++) { cjplpBLL.Delete(deleteps_wwtpModelList[j].Exp_NoOri); } //同步编码表 // AsynData.asynRecordTabl(); } // return cjplpBLL; }