public bool Update(T_Projects model_Projects, T_Item model_Item, T_Project_Brige model_Brige) { BLL.T_Projects_BLL proj_bll = new T_Projects_BLL(); bool flag = proj_bll.Update(model_Projects, model_Item); if (flag) { this.Update(model_Brige); return(true); } return(false); }
public IList <MDL.T_GdList> FindByProjectNo(string ProjectNo) { String stmtId = "T_GdList.FindByProjectNo"; MDL.T_GdList obj = new MDL.T_GdList(); obj.ProjectNo = ProjectNo; T_Projects_BLL BLL = new T_Projects_BLL(); IList <MDL.T_GdList> result = MyISqlMap.QueryForList <MDL.T_GdList>(stmtId, obj); return(result); }
public bool Add(T_Projects model_Projects, T_Item model_Item, T_Project_RoadLamp model_RoadLamp) { BLL.T_Projects_BLL proj_bll = new T_Projects_BLL(); bool flag = proj_bll.Add(model_Projects, model_Item); if (flag) { this.Insert(model_RoadLamp); return(true); } return(false); }
public IList <T_FileListTemplate> FindByArchiveID2(String archiveID, string projectNO) { T_Projects_BLL bll = new T_Projects_BLL(); //T_Projects projects = bll.Find(projectNO); String stmtId = "T_FileListTemplate.FindByArchiveID2"; MDL.T_FileListTemplate obj = new T_FileListTemplate(); //obj.ProjectCategory = projects.ProjectCategory; IList <T_FileListTemplate> result = MyISqlMap.QueryForList <T_FileListTemplate>(stmtId, obj); return(result); }
/// <summary> /// 绑定所有工程方法 /// </summary> /// <param name="SetStyle">是否设定表格样式</param> private void BindGridViewData() { ERM.BLL.T_Projects_BLL ProjectsDB = new ERM.BLL.T_Projects_BLL(); IList <MDL.T_Projects> projList = ProjectsDB.GetAll();//绑定数据 DataTable tbl_proj = new DataTable(); tbl_proj.Columns.Add(new DataColumn("projectname", typeof(string))); tbl_proj.Columns.Add(new DataColumn("ProjectNO", typeof(string))); DataTable tbl_proj2 = new DataTable(); tbl_proj2.Columns.Add(new DataColumn("projectname", typeof(string))); tbl_proj2.Columns.Add(new DataColumn("ProjectNO", typeof(string))); DataRow row_1 = tbl_proj.NewRow(); row_1["projectname"] = "--请选择"; row_1["ProjectNO"] = "--请选择"; tbl_proj.Rows.Add(row_1); DataRow row_2 = tbl_proj2.NewRow(); row_2["projectname"] = "--请选择"; row_2["ProjectNO"] = "--请选择"; tbl_proj2.Rows.Add(row_2); foreach (MDL.T_Projects obj in projList) { DataRow row_temp = tbl_proj.NewRow(); row_temp["projectname"] = obj.projectname; row_temp["ProjectNO"] = obj.ProjectNO; tbl_proj.Rows.Add(row_temp); DataRow row_temp2 = tbl_proj2.NewRow(); row_temp2["projectname"] = obj.projectname; row_temp2["ProjectNO"] = obj.ProjectNO; tbl_proj2.Rows.Add(row_temp2); } cbx_Source.DataSource = tbl_proj; cbx_Source.DisplayMember = "projectname"; cbx_Source.ValueMember = "ProjectNO"; cbx_Trage.DataSource = tbl_proj2; cbx_Trage.DisplayMember = "projectname"; cbx_Trage.ValueMember = "ProjectNO"; }
public bool Update(T_Projects model_Projects, T_Item model_Item, T_Traffic model_Traffic, IList <T_Traffic_Detail> detailMDL) { BLL.T_Projects_BLL proj_bll = new T_Projects_BLL(); bool flag = proj_bll.Update(model_Projects, model_Item); if (flag) { BLL.T_Traffic_Detail_BLL detailBLL = new ERM.BLL.T_Traffic_Detail_BLL(); for (int i = 0; i < detailMDL.Count; i++) { detailBLL.Update(detailMDL[i]); } this.Update(model_Traffic); return(true); } return(false); }
public bool Add(T_Projects model_Projects, T_Item model_Item, T_Traffic model_Traffic, IList <T_Traffic_Detail> detailMDL) { BLL.T_Projects_BLL proj_bll = new T_Projects_BLL(); bool flag = proj_bll.Add(model_Projects, model_Item); if (flag) { this.Insert(model_Traffic); BLL.T_Traffic_Detail_BLL detailBLL = new ERM.BLL.T_Traffic_Detail_BLL(); for (int i = 0; i < detailMDL.Count; i++) { detailMDL[i].TrafficID = model_Traffic.ID.ToString(); detailBLL.Add(detailMDL[i]); } return(true); } return(false); }
/// <summary> /// 绑定所有工程方法 /// </summary> /// <param name="SetStyle">是否设定表格样式</param> private void BindGridViewData(bool SetStyle) { dgProject.AutoGenerateColumns = false; if (SetStyle) { SetGridStyle(); //设置样式 } dgProject.Rows.Clear(); ERM.BLL.T_Projects_BLL ProjectsDB = new ERM.BLL.T_Projects_BLL(); IList <MDL.T_Projects> projList = ProjectsDB.GetAll();//.GetList("").Tables[0].DefaultView;//绑定数据 IList <T_Dict> dict = dictBll.FindByKeyWord("ProjectCategory"); foreach (MDL.T_Projects obj in projList) { dgProject.Rows.Add(); dgProject.Rows[dgProject.Rows.Count - 1].Cells["ProjectNO"].Value = obj.ProjectNO; dgProject.Rows[dgProject.Rows.Count - 1].Cells["district"].Value = obj.district; dgProject.Rows[dgProject.Rows.Count - 1].Cells["projectname"].Value = obj.projectname; dgProject.Rows[dgProject.Rows.Count - 1].Cells["address"].Value = obj.address; dgProject.Rows[dgProject.Rows.Count - 1].Cells["begindate"].Value = obj.begindate; foreach (var item in dict) { if (item.ValueName == obj.ProjectCategory) { dgProject.Rows[dgProject.Rows.Count - 1].Cells["ProjectCategory"].Value = item.DisplayName; break; } } dgProject.Rows[dgProject.Rows.Count - 1].Cells["begindate"].Value = string.IsNullOrWhiteSpace(obj.begindate) ? "" : MyCommon.ToDate(obj.begindate).ToString("yyyy-MM-dd"); //dgProject.Rows[dgProject.Rows.Count - 1].Cells["bjdate"].Value = MyCommon.ToDate(obj.bjdate).ToString("yyyy-MM-dd"); dgProject.Rows[dgProject.Rows.Count - 1].Cells["enddate"].Value = string.IsNullOrWhiteSpace(obj.enddate) ? "" : MyCommon.ToDate(obj.enddate).ToString("yyyy-MM-dd"); if (Globals.ProjectNO != null && Globals.ProjectNO != string.Empty && Globals.ProjectNO == obj.ProjectNO) { dgProject.Rows[dgProject.Rows.Count - 1].Selected = true; } } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnProjectDelete_Click(object sender, EventArgs e) { DataGridViewSelectedRowCollection rows = this.dgProject.SelectedRows; if (rows.Count == 0) { return; } else { //询问是否删除 if (TXMessageBoxExtensions.Question("确定要删除工程:" + rows[0].Cells["ProjectName"].Value.ToString() + "吗? \n 【温馨提示:删除工程后信息将无法恢复!请慎重!!!】") == DialogResult.Cancel) { return; } else//确定删除 { string ProjectNO = rows[0].Cells["ProjectNO"].Value.ToString(); ERM.BLL.T_Projects_BLL ProjectsDB = new ERM.BLL.T_Projects_BLL(); T_Item_BLL item = new T_Item_BLL(); item.Delete(ProjectsDB.Find(ProjectNO).ItemID); ProjectsDB.Delete(ProjectNO); BLL.BLLMore bllMore = new BLLMore(); bllMore.DeleteUnitByProjectNO(ProjectNO); bllMore.DeleteFileListByProjectNO(ProjectNO); bllMore.DeleteCellFileByProjectNO(ProjectNO); bllMore.DeleteArchiveByProjectNO(ProjectNO); bllMore.DeleteGdListByProjectNO(ProjectNO); bllMore.DeleteBrigeByProjectNO(ProjectNO); bllMore.DeleteRoadLampByProjectNO(ProjectNO); bllMore.DeleteTrafficByProjectNO(ProjectNO); bllMore.DeletePointByPorjectNo(ProjectNO); bllMore.DeleteYW_CellAndEFileByPorjectNo(ProjectNO); MyCommon.DeleteAndCreateEmptyDirectory(Globals.ProjectPathParent + ProjectNO, false); BindGridViewData(false);//重新绑定数据 } } }
/// <summary> /// 复制 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Click(object sender, EventArgs e) { frm2PDFProgressMsg fmessage = new frm2PDFProgressMsg(); fmessage.Text = "工程复制中..."; try { string sourceNO = string.Empty; string sourceName = string.Empty; string targeNO = string.Empty; string targeName = string.Empty; T_Projects sourcePorj; T_Projects targePorj; (cbx_Source.SelectedItem as System.Data.DataRowView)[0].ToString(); if (cbx_Source.Items.Count == 1 || cbx_Trage.Items.Count == 1) { TXMessageBoxExtensions.Info("提示:请选择需要复制的工程!"); cbx_Source.Focus(); return; } else if ((cbx_Source.SelectedItem as System.Data.DataRowView)[0].ToString() == "--请选择") { TXMessageBoxExtensions.Info("提示:请选择复制的工程!"); cbx_Source.Focus(); return; } else if ((cbx_Trage.SelectedItem as System.Data.DataRowView)[0].ToString() == "--请选择") { TXMessageBoxExtensions.Info("提示:请选择复制的目的工程!"); cbx_Trage.Focus(); return; } else { sourceNO = (cbx_Source.SelectedItem as System.Data.DataRowView)[1].ToString(); //要编辑的主键 sourceName = (cbx_Source.SelectedItem as System.Data.DataRowView)[0].ToString(); //要编辑的主键 targeNO = (cbx_Trage.SelectedItem as System.Data.DataRowView)[1].ToString(); //要编辑的主键 targeName = (cbx_Trage.SelectedItem as System.Data.DataRowView)[0].ToString(); //要编辑的主键 //根据工程编号查询工程类别 sourcePorj = projectBLL.Find(sourceNO); targePorj = projectBLL.Find(targeNO); if (sourcePorj.ProjectCategory != targePorj.ProjectCategory) { TXMessageBoxExtensions.Info("复制的工程类别必须一致!"); return; } if (sourceNO == targeNO) { TXMessageBoxExtensions.Info("提示:同一工程不能复制!"); return; } } if (TXMessageBoxExtensions.Question("提示:确定将工程\n编号:" + sourceNO + " 名称:" + sourceName + "\n复制到工程\n编号:" + targeNO + " 名称:" + targeName + "\n【温馨提示:复制之后工程信息将无法恢复!请慎重!!!】") == DialogResult.OK) { status_flg = true; btn_Copy.Enabled = false; btn_Colse.Enabled = false; fmessage = new frm2PDFProgressMsg(); fmessage.Text = "工程复制中..."; fmessage.progressBar1.Maximum = 4; fmessage.label2.Text = "正在删除工程编号:" + targeNO + "信息..."; fmessage.progressBar1.Value = 1; fmessage.Show(); Application.DoEvents(); //删除目的工程下信息 BLL.BLLMore bllMore = new BLL.BLLMore(); bllMore.DeleteUnitByProjectNO(targeNO); bllMore.DeleteFileListByProjectNO(targeNO); bllMore.DeleteCellFileByProjectNO(targeNO); bllMore.DeleteArchiveByProjectNO(targeNO); bllMore.DeleteGdFileByProjectNO(targeNO);//删除归档类别 #region add deleteProject bllMore.DeleteTrafficByProjectNO(targeNO); bllMore.DeleteRoadLampByProjectNO(targeNO); bllMore.DeleteBrigeByProjectNO(targeNO); bllMore.DeletePointByPorjectNo(targeNO); #endregion MyCommon.DeleteAndCreateEmptyDirectory(Globals.ProjectPathParent + targeNO); //将源工程信息Copy到目的工程 fmessage.label2.Text = "正在更新工程编号:" + targeNO + "信息..."; fmessage.progressBar1.Value = 2; Application.DoEvents(); BLL.T_Projects_BLL Proj_bll = new ERM.BLL.T_Projects_BLL(); ERM.MDL.T_Projects targe_proj_MDL = Proj_bll.Find(targeNO); ERM.MDL.T_Projects source_proj_MDL = Proj_bll.Find(sourceNO); targe_proj_MDL.address = source_proj_MDL.address; targe_proj_MDL.area1 = source_proj_MDL.area1; targe_proj_MDL.area2 = source_proj_MDL.area2; targe_proj_MDL.begindate = source_proj_MDL.begindate; targe_proj_MDL.bgyfmj = source_proj_MDL.bgyfmj; targe_proj_MDL.bjdate = source_proj_MDL.bjdate; targe_proj_MDL.category = source_proj_MDL.category; targe_proj_MDL.cfmj = source_proj_MDL.cfmj; targe_proj_MDL.createdate = source_proj_MDL.createdate; targe_proj_MDL.district = source_proj_MDL.district; targe_proj_MDL.dxsmj = source_proj_MDL.dxsmj; targe_proj_MDL.enddate = source_proj_MDL.enddate; targe_proj_MDL.floors1 = source_proj_MDL.floors1; targe_proj_MDL.floors2 = source_proj_MDL.floors2; targe_proj_MDL.ghcode = source_proj_MDL.ghcode; targe_proj_MDL.high = source_proj_MDL.high; targe_proj_MDL.hjqk = source_proj_MDL.hjqk; targe_proj_MDL.jldwshr = source_proj_MDL.jldwshr; targe_proj_MDL.jsdwshr = source_proj_MDL.jsdwshr; targe_proj_MDL.passwd = source_proj_MDL.passwd; targe_proj_MDL.price1 = source_proj_MDL.price1; targe_proj_MDL.price2 = source_proj_MDL.price2; targe_proj_MDL.projecttype = source_proj_MDL.projecttype; targe_proj_MDL.qtyfmj = source_proj_MDL.qtyfmj; targe_proj_MDL.sgbzz = source_proj_MDL.sgbzz; targe_proj_MDL.sgcode = source_proj_MDL.sgcode; targe_proj_MDL.stru = source_proj_MDL.stru; targe_proj_MDL.syyfmj = source_proj_MDL.syyfmj; targe_proj_MDL.tbr = source_proj_MDL.tbr; targe_proj_MDL.tempid = source_proj_MDL.tempid; targe_proj_MDL.ts1 = source_proj_MDL.ts1; targe_proj_MDL.ts2 = source_proj_MDL.ts2; targe_proj_MDL.ts3 = source_proj_MDL.ts3; targe_proj_MDL.ts4 = source_proj_MDL.ts4; targe_proj_MDL.tstotal = source_proj_MDL.tstotal; targe_proj_MDL.ydpzcode = source_proj_MDL.ydpzcode; targe_proj_MDL.ydxkcode = source_proj_MDL.ydxkcode; targe_proj_MDL.zjy = source_proj_MDL.zjy; targe_proj_MDL.zygz = source_proj_MDL.zygz; targe_proj_MDL.zzmj = source_proj_MDL.zzmj; targe_proj_MDL.ztcw = source_proj_MDL.ztcw; targe_proj_MDL.dstcw = source_proj_MDL.dstcw; targe_proj_MDL.dxtcw = source_proj_MDL.dxtcw; targe_proj_MDL.kzsfcd = source_proj_MDL.kzsfcd; targe_proj_MDL.ts5 = source_proj_MDL.ts5; targe_proj_MDL.XMJL = source_proj_MDL.XMJL; targe_proj_MDL.yjdw = source_proj_MDL.yjdw; targe_proj_MDL.XCJL = source_proj_MDL.XCJL; Proj_bll.Update(targe_proj_MDL); //坐标信息 IList <T_Point> t_point_source = new T_Point_BLL().GetList(sourceNO); foreach (var item in t_point_source) { item.ID = Guid.NewGuid().ToString(); item.ProjectNo = targeNO; new T_Point_BLL().Insert(item); } //电子文件 bllMore.CopyFileAndEFileList(sourceNO, targeNO); BLL.T_Archive_BLL archive_bll = new ERM.BLL.T_Archive_BLL(); //案卷信息 BLL.T_FileList_BLL filelist_bll = new ERM.BLL.T_FileList_BLL(); //文件表 BLL.T_CellAndEFile_BLL cellAndEfile = new ERM.BLL.T_CellAndEFile_BLL(); //电子文件 //单位 BLL.T_Units_BLL units_bll = new ERM.BLL.T_Units_BLL(); //施工单位 IList <MDL.T_Units> IUnits = units_bll.FindByProjectNO(sourceNO); if (IUnits != null && IUnits.Count > 0) { foreach (MDL.T_Units units in IUnits) { units.UnitID = Guid.NewGuid().ToString(); units.ProjectNO = targeNO; units_bll.Add(units);//保存 } } //扩展信息 switch (sourcePorj.ProjectCategory) { case "Traffic": T_Traffic_BLL trafficBll = new T_Traffic_BLL(); T_Traffic traffic = trafficBll.QueryTraffic_ByProjID(sourceNO); if (traffic != null) { traffic.ID = Guid.NewGuid().ToString(); traffic.ProjectID = targeNO; trafficBll.Insert(traffic); } break; case "RoadLamp": T_Project_RoadLamp_BLL roadLampBll = new T_Project_RoadLamp_BLL(); T_Project_RoadLamp roadLamp = roadLampBll.QueryRoadLamp_ByProjID(sourceNO); if (roadLamp != null) { roadLamp.ProjectID = targeNO; roadLamp.ID = Guid.NewGuid().ToString(); roadLampBll.Insert(roadLamp); } break; case "Brige": T_Project_Brige_BLL brigeBll = new T_Project_Brige_BLL(); T_Project_Brige brige = brigeBll.QueryBrige_ByProjID(sourceNO); if (brige != null) { brige.ID = Guid.NewGuid().ToString(); brige.ProjectID = targeNO; brigeBll.Insert(brige); } break; } fmessage.progressBar1.Value = 3; Application.DoEvents(); //迁移文件夹 string mprojectPath = Application.StartupPath + "\\Project\\" + sourceNO; string tprojectPath = Application.StartupPath + "\\Project\\" + targeNO; string[] DirectoryList = new string[] { "MPDF", "ODOC", "PDF" }; if (System.IO.Directory.Exists(tprojectPath)) { MyCommon.DeleteAndCreateEmptyDirectory(tprojectPath, false); MyCommon.DeleteAndCreateEmptyDirectory(tprojectPath, true); } else { MyCommon.DeleteAndCreateEmptyDirectory(tprojectPath, true); } string tempText = fmessage.label2.Text; char[] tempChar = tempText.ToCharArray(); int tempIndex = 0; foreach (string dic in DirectoryList) { MyCommon.DeleteAndCreateEmptyDirectory(tprojectPath + "\\" + dic, true); fmessage.label2.Text = ""; if (System.IO.Directory.Exists(mprojectPath)) { if (System.IO.Directory.Exists(mprojectPath + "\\" + dic)) { string[] files = System.IO.Directory.GetFiles(mprojectPath + "\\" + dic); foreach (string filename in files) { fmessage.label2.Text += tempChar[tempIndex]; Application.DoEvents(); tempIndex++; if (tempIndex >= tempChar.Length) { tempIndex = 0; fmessage.label2.Text = ""; } System.IO.FileInfo fileinfo = new System.IO.FileInfo(filename); if (System.IO.File.Exists(filename)) { System.IO.File.Copy(filename, tprojectPath + "\\" + dic + "\\" + fileinfo.Name, true); } } } } } fmessage.progressBar1.Value = 4; Application.DoEvents(); fmessage.Close(); btn_Copy.Enabled = true; btn_Colse.Enabled = true; TXMessageBoxExtensions.Info("提示:复制成功!"); BindGridViewData(); } } catch (Exception ex) { if (fmessage != null) { fmessage.Close(); } TXMessageBoxExtensions.Info("提示:复制失败!"); MyCommon.WriteLog("复制工程错误:" + ex.Message); btn_Copy.Enabled = true; btn_Colse.Enabled = true; } }
/// <summary> /// 保存 /// </summary> /// <returns></returns> private bool SaveData() { if (string.IsNullOrEmpty(this.txtConStructionProjectName.Text)) { TXMessageBoxExtensions.Info("提示:项目名称不能为空!"); this.tabControl1.SelectedTab = tabPage4; txtConStructionProjectName.Focus(); return(false); } if (string.IsNullOrEmpty(this.txtConstructionProjectAdd.Text)) { TXMessageBoxExtensions.Info("提示:项目地址不能为空!"); this.tabControl1.SelectedTab = tabPage4; txtConstructionProjectAdd.Focus(); return(false); } if (string.IsNullOrEmpty(this.txtCreateUnit.Text)) { TXMessageBoxExtensions.Info("提示:项目建设单位不能为空!"); this.tabControl1.SelectedTab = tabPage4; txtCreateUnit.Focus(); return(false); } if (string.IsNullOrEmpty(this.txtPZDW.Text)) { TXMessageBoxExtensions.Info("提示:立项批准单位不能为空!"); this.tabControl1.SelectedTab = tabPage4; txtPZDW.Focus(); return(false); } if (this.cboProjectType.SelectedIndex == -1) { TXMessageBoxExtensions.Info("提示:工程类型必须选择!"); this.tabControl1.SelectedTab = tabPage4; return(false); } if (txtProjectNo.Text.Trim() == "") { TXMessageBoxExtensions.Info("提示:工程编号必须填写!"); this.tabControl1.SelectedTab = tabPage1; this.txtProjectNo.Focus(); return(false); } if (!MyCommon.isYesProjectNo(txtProjectNo.Text.Trim())) { TXMessageBoxExtensions.Info("提示:工程编号格式错误!\n【温馨提示:工程编号只允许输入数字,字母,下划线,横线】"); this.tabControl1.SelectedTab = tabPage1; txtProjectNo.Focus(); return(false); } if (string.IsNullOrEmpty(txtProjectName.Text)) { TXMessageBoxExtensions.Info("提示:工程名称不能为空!"); this.tabControl1.SelectedTab = tabPage1; txtProjectName.Focus(); return(false); } if (cboDistrict.SelectedValue.ToString() == "" || string.IsNullOrEmpty(this.txtAddress.Text)) { TXMessageBoxExtensions.Info("提示:工程地址不能为空!"); this.tabControl1.SelectedTab = tabPage1; txtAddress.Focus(); return(false); } if (dtpBeginDate.TextEx == "") { TXMessageBoxExtensions.Info("提示:开工日期必须填写!\n"); this.tabControl1.SelectedTab = tabPage1; dtpBeginDate.Focus(); return(false); } if (dtpEndDate.TextEx == "") { TXMessageBoxExtensions.Info("提示:竣工日期必须填写!\n"); this.tabControl1.SelectedTab = tabPage1; dtpEndDate.Focus(); return(false); } //验证单位 if (!isCheckUnit(new List <TXTextBoxEX>() { this.txtJsdw, this.txtLxpzdw, this.txtSjdw, this.txtKcdw, this.txtSgdw, this.txtJldw }, new string[] { "建设", "立项批准", "设计", "勘察", "施工", "监理" })) { return(false); } if (txtGhcode.Text == "") { TXMessageBoxExtensions.Info("提示:工程规划许可证号必须填写!\n"); this.tabControl1.SelectedTab = tabPage1; txtGhcode.Focus(); return(false); } if (ProjectNO == "")//不是编辑 { ERM.BLL.T_Projects_BLL ProjectDB = new ERM.BLL.T_Projects_BLL(); if (ProjectDB.Exists(txtProjectNo.Text.Trim())) { TXMessageBoxExtensions.Info("提示:工程编号有重复的请重新填写!"); this.tabControl1.SelectedTab = tabPage1; txtProjectNo.Focus(); return(false); } if (txtProjectName.Text.Trim() != "" && ProjectDB.ExistsName(txtProjectName.Text.Trim())) { TXMessageBoxExtensions.Info("提示:工程名称有重复的请重新填写!"); this.tabControl1.SelectedTab = tabPage1; txtProjectName.Focus(); return(false); } } if ((!String.IsNullOrEmpty(this.dtpBeginDate.TextEx)) && dtpBeginDate.TextEx != "") { if (this.dtpEndDate.TextEx != "" && (!this.dtpBeginDate.TextEx.Equals(this.dtpEndDate.TextEx)) && (MyCommon.ToDate(dtpBeginDate.TextEx) > MyCommon.ToDate(dtpEndDate.TextEx))) { TXMessageBoxExtensions.Info("提示:工程基本信息:开工日期 必须小于 竣工日期!"); this.tabControl1.SelectedTab = tabPage1; this.dtpEndDate.Focus(); return(false); } } projectMDL = obj.GetInfo(ProjectNo, projectMDL, 1) as T_Projects; projectMDL.ProjectNO = MyCommon.ToSqlString(txtProjectNo.Text); //工程编号 projectMDL.district = MyCommon.ToSqlString(cboDistrict.Text); //所属区域 projectMDL.projectname = MyCommon.ToSqlString(txtProjectName.Text); //工程名称 projectMDL.address = MyCommon.ToSqlString(txtAddress.Text); //工程地址 projectMDL.ajdh = MyCommon.ToSqlString(txtysbah.Text); //验收备案号 projectMDL.ProjectCategory = cboProjectType.SelectedValue.ToString(); projectMDL.begindate = dtpBeginDate.TextEx; //开工时间 projectMDL.enddate = dtpEndDate.TextEx; //竣工时间 projectMDL.ghcode = MyCommon.ToSqlString(txtGhcode.Text); projectMDL.sgcode = MyCommon.ToSqlString(txtSgcode.Text); projectMDL.tbr = Globals.Fullname; //projectMDL.ydpzcode = MyCommon.ToSqlString(txtYdpzcode.Text); projectMDL.ydxkcode = MyCommon.ToSqlString(txtYdghxkCode.Text); SetItemInfo(itemMDL.ItemID, 1); if (this.ProjectNO == "") { projectMDL.createdate = DateTime.Now.ToString("yyyy.MM.dd"); itemMDL.ItemID = Guid.NewGuid().ToString(); projectMDL.ItemID = itemMDL.ItemID; SaveUnit(); if (!obj.Add(projectMDL, itemMDL)) { TXMessageBoxExtensions.Info("保存失败!"); return(false); } this.ProjectNO = txtProjectNo.Text; txtProjectNo.Enabled = false; try { System.IO.Directory.CreateDirectory(Globals.ProjectPathParent + MyCommon.ToSqlString(txtProjectNo.Text)); } catch { TXMessageBoxExtensions.Info("发生错误,请检查存放电子文件的目录是否存在及可写!"); } } else { SaveUnit(); if (!obj.Updates(projectMDL, itemMDL)) { TXMessageBoxExtensions.Info("保存失败!"); return(false); } } return(true); }