public MDL.T_GdList FindID(String ID) { String stmtId = "T_GdList.FindID"; MDL.T_GdList temp_MDL = new MDL.T_GdList(); temp_MDL.ID = ID; MDL.T_GdList result = MyISqlMap.QueryForObject <MDL.T_GdList>(stmtId, temp_MDL); return(result); }
public void Update(MDL.T_GdList obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_GdList.Update"; MyISqlMap.Update(stmtId, obj); }
public MDL.T_GdList FindIDAndProjectNo(String ID, string ProjectNo) { String stmtId = "T_GdList.FindIDAndProjectNo"; MDL.T_GdList temp_MDL = new MDL.T_GdList(); temp_MDL.ID = ID; temp_MDL.ProjectNo = ProjectNo; MDL.T_GdList result = MyISqlMap.QueryForObject <MDL.T_GdList>(stmtId, temp_MDL); return(result); }
public void Delete(String ID) { if (ID == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_GdList.Delete"; MDL.T_GdList obj = new MDL.T_GdList(); obj.ID = ID; MyISqlMap.Delete(stmtId, obj); }
public void Insert(MDL.T_GdList obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_GdList.Insert"; obj.ProjectCategory = new T_Projects_BLL().Find(obj.ProjectNo).ProjectCategory; MyISqlMap.Insert(stmtId, obj); }
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 int GetMaxTemplateOrderIndex(string ProjectNo) { MDL.T_GdList obj = new MDL.T_GdList(); String stmtId = "T_GdList.GetMaxTemplateOrderIndex"; obj.ProjectNo = ProjectNo; object result = MyISqlMap.QueryForObject(stmtId, obj); if (result == null) { result = "0"; } return(int.Parse(result.ToString())); }
/// <summary> /// 获取显示的归档列表 /// </summary> private void CreateCheckBokList() { IList <MDL.T_GdList> gd_list = (new BLL.T_GdList_BLL()).FindByProjectNo(Globals.ProjectNO); TXCheckBox ckb_gd = null; Point p = new Point(); p.X = 30; for (int i = 0; i < gd_list.Count; i++) { MDL.T_GdList gd_mdl = gd_list[i]; if (gd_mdl.IsShow == 0) { gd_list.Remove(gd_mdl); i--; continue; } if (i > 0 && i % 7 == 0) { p.X += 247; p.Y = 15; } else { if (i == 0) { p.Y = 15; } else { p.Y += 40; } } ckb_gd = new TXCheckBox(); ckb_gd.Name = gd_mdl.ID; ckb_gd.Text = gd_mdl.GdName; ckb_gd.Location = p; if (string.Compare(ckb_gd.Name, _gdID) == 0) { ckb_gd.Checked = true; } this.pl_gd.Controls.Add(ckb_gd); ckb_gd.CheckedChanged += new EventHandler(this.CheckBox_CheckedChanged); } }
public void CopyFileAndEFileList(string s_projectNO, string t_projectNO) { MDL.T_FileList obj = new MDL.T_FileList(); obj.ProjectNO = s_projectNO; obj.ParentID = t_projectNO; String stmtId = "T_FileList.CopyFileListByProjectNO"; MyISqlMap.QueryForObject <int>(stmtId, obj); MDL.T_CellAndEFile obj2 = new MDL.T_CellAndEFile(); obj2.ProjectNO = s_projectNO; obj2.FileID = t_projectNO; stmtId = "T_CellAndEFile.CopyCellFileListByProjectNO"; MyISqlMap.QueryForObject <int>(stmtId, obj2); MDL.T_GdList obj3 = new MDL.T_GdList(); obj3.ProjectNo = s_projectNO; obj3.ID = t_projectNO; stmtId = "T_GdList.CopyGdFileByProjectNO"; MyISqlMap.QueryForObject <int>(stmtId, obj3); }
private void CreateFile(string TableName, string ID, string TempSavePath) { if (TableName == "T_FileList") { BLL.T_FileList_BLL fileBLL = new ERM.BLL.T_FileList_BLL(); MDL.T_FileList fileMDL = fileBLL.Find(ID, Globals.ProjectNO); if (fileMDL != null) { List <MDL.T_FileList> fileList = new List <ERM.MDL.T_FileList>(); fileList.Add(fileMDL); DataTable ds = MyCommon.ToDataTable <MDL.T_FileList>(fileList); ds.TableName = "T_FileList_" + ID; ds.WriteXml(TempSavePath + "\\T_FileList\\" + ID + ".xml", XmlWriteMode.WriteSchema); lblTitle.Text = @"正在导出:" + fileMDL.wjtm; if (!string.IsNullOrEmpty(fileMDL.filepath) && System.IO.File.Exists(Globals.ProjectPath + fileMDL.filepath))//pdf文件 { System.IO.File.Copy(Globals.ProjectPath + fileMDL.filepath, TempSavePath + "\\T_CellAndEFile\\" + fileMDL.filepath, true); } } else { MDL.T_GdList gdList_MDL = (new BLL.T_GdList_BLL()).FindIDAndProjectNo(ID, Globals.ProjectNO); if (gdList_MDL != null) { List <MDL.T_GdList> GdList = new List <ERM.MDL.T_GdList>(); GdList.Add(gdList_MDL); DataTable ds = MyCommon.ToDataTable <MDL.T_GdList>(GdList); ds.TableName = "T_GdList_" + ID; ds.WriteXml(TempSavePath + "\\T_GdList\\" + ID + ".xml", XmlWriteMode.WriteSchema); lblTitle.Text = @"正在导出:" + gdList_MDL.GdName; } } if (curIndex < progressBar1.Maximum) { progressBar1.Value = curIndex++; } else { progressBar1.Value = progressBar1.Maximum - 1; } Application.DoEvents(); } else if (TableName == "T_CellAndEFile") { BLL.T_CellAndEFile_BLL cellBLL = new ERM.BLL.T_CellAndEFile_BLL(); IList <MDL.T_CellAndEFile> cellList = cellBLL.FindByGdFileID(ID, Globals.ProjectNO); if (cellList.Count > 0) { ///移除没有保存的电子表格 // for (int i = 0; i < cellList.Count; i++) // { // if (cellList[i].DoStatus != 1) // { // cellList.RemoveAt(i); // i--; // } // } if (cellList.Count > 0) { BLL.T_CellFileTemplate_BLL cellTplBLL = new ERM.BLL.T_CellFileTemplate_BLL(); foreach (MDL.T_CellAndEFile cellMDL in cellList) { if (cellMDL.filepath == null || cellMDL.filepath.Trim() == "") { MDL.T_CellFileTemplate cellTplMDL = cellTplBLL.Find(cellMDL.CellID); if (cellTplMDL != null) { string CelllTplFile = Application.StartupPath + "\\Template" + cellTplMDL.filepath; if (System.IO.File.Exists(CelllTplFile)) { FileInfo fileInfo = new FileInfo(CelllTplFile); string NewCellFileID = cellMDL.CellID; cellMDL.filepath = "ODOC\\" + NewCellFileID + fileInfo.Extension; string NewCellFile = TempSavePath + "\\T_CellAndEFile\\ODOC\\" + NewCellFileID + fileInfo.Extension; System.IO.File.Copy(CelllTplFile, NewCellFile, true); } } } else { if (System.IO.File.Exists(Globals.ProjectPath + cellMDL.filepath))//原件 { System.IO.File.Copy(Globals.ProjectPath + cellMDL.filepath, TempSavePath + "\\T_CellAndEFile\\" + cellMDL.filepath, true); } if (System.IO.File.Exists(Globals.ProjectPath + cellMDL.fileTreePath))//pdf文件 { System.IO.File.Copy(Globals.ProjectPath + cellMDL.fileTreePath, TempSavePath + "\\T_CellAndEFile\\" + cellMDL.fileTreePath, true); } } } DataTable ds2 = MyCommon.ToDataTable <MDL.T_CellAndEFile>(cellList); ds2.TableName = "T_CellAndEFile_" + ID; ds2.WriteXml(TempSavePath + "\\T_CellAndEFile\\" + ID + ".xml", XmlWriteMode.WriteSchema); } } if (curIndex < progressBar1.Maximum) { progressBar1.Value = curIndex++; } else { progressBar1.Value = progressBar1.Maximum - 1; } Application.DoEvents(); } }