public File(string tempPath, T_FileList obj, int archIndex, int fileIndex) { this.tempPath = tempPath; this.obj = obj; this.archIndex = archIndex; this.fileIndex = fileIndex; }
public System.Data.DataSet GetChildDS(T_FileList obj) { String stmtId = "T_FileList.GetChildDS"; System.Data.DataSet result = DAL.MyBatis.QueryForDataSet(stmtId, obj); return(result); }
public IList <T_FileList> GetFileByGDIDList(T_FileList obj) { String stmtId = "T_FileList.GetFileByGDIDList"; IList <T_FileList> result = MyISqlMap.QueryForList <T_FileList>(stmtId, obj); return(result); }
public void CopyFileList(string _projectNO, string _projectCategory) { BLL.T_FileList_BLL B1 = new T_FileList_BLL(); IList <MDL.T_FileList> fileList = (new BLL.T_FileList_BLL()).FindByProjectNO(_projectNO); if (fileList.Count <= 0) { T_FileList file = new T_FileList(); T_GdList gd = new T_GdList(); gd.ProjectNo = _projectNO; gd.ProjectCategory = _projectCategory; file.ProjectNO = _projectNO; file.ProjectCategory = _projectCategory; String stmtId = "T_FileList.CopyFileList"; MyISqlMap.QueryForObject <int>(stmtId, file); stmtId = "T_CellAndEFile.CopyCellFileList"; MyISqlMap.QueryForObject <int>(stmtId, _projectNO); stmtId = "T_GdList.CopyGdList"; MyISqlMap.QueryForObject <int>(stmtId, gd); } }
//public void DeleteGdTemplate(String fileID) //{ // String stmtId = "T_FileList.DeleteGdTemplate"; // T_FileList obj = new T_FileList(); // obj.FileID = fileID; // MyISqlMap.Delete(stmtId, obj); //} public IList <T_FileList> FindByKeyString(T_FileList obj) { String stmtId = "T_FileList.FindByKeyString"; IList <T_FileList> result = MyISqlMap.QueryForList <T_FileList>(stmtId, obj); return(result); }
//public void DeleteFileListTemplate(String fileID) //{ // String stmtId = "T_FileList.DeleteFileListTemplate"; // T_FileList obj = new T_FileList(); // obj.FileID = fileID; // MyISqlMap.Delete(stmtId, obj); //} public void DeleteGdList(String fileID) { String stmtId = "T_FileList.DeleteGdList"; T_FileList obj = new T_FileList(); obj.FileID = fileID; MyISqlMap.Delete(stmtId, obj); }
public System.Data.DataTable GetAllFLDS(string ProjectNO, int FL) { String stmtId = "T_FileList.GetAllFLDS"; MDL.T_FileList obj = new T_FileList(); obj.FL = FL; obj.ProjectNO = ProjectNO; System.Data.DataTable result = DAL.MyBatis.QueryForDataTable(stmtId, obj); return(result); }
public void Delete(T_FileList obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_FileList.Delete"; MyISqlMap.Delete(stmtId, obj); }
public bool Exists(String fileID, String projectNO) { MDL.T_FileList obj = new T_FileList(); obj.FileID = fileID; obj.ProjectNO = projectNO; String stmtId = "T_FileList.Exists"; bool result = MyISqlMap.QueryForObject <bool>(stmtId, obj); return(result); }
public int Update(T_FileList obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_FileList.Update"; return(MyISqlMap.Update(stmtId, obj)); }
public System.Data.DataTable GetFileByGDID(string ProjectNO, string GDID) { String stmtId = "T_FileList.GetFileByGDID"; MDL.T_FileList obj = new T_FileList(); obj.GDID = GDID; obj.ProjectNO = ProjectNO; System.Data.DataTable result = DAL.MyBatis.QueryForDataTable(stmtId, obj); return(result); }
public void Insert(T_FileList obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_FileList.Insert"; MyISqlMap.Insert(stmtId, obj); }
public T_FileList Find(String fileID, String projectNO) { MDL.T_FileList obj = new T_FileList(); obj.FileID = fileID; obj.ProjectNO = projectNO; String stmtId = "T_FileList.Find"; T_FileList result = MyISqlMap.QueryForObject <T_FileList>(stmtId, obj); return(result); }
public int UpdateFileListArchive(T_FileList obj, ref string sqltmp) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_FileList.UpdateFileListArchive"; sqltmp = ERM.DAL.MyBatis.QueryForSql(stmtId, obj); return(MyISqlMap.Update(stmtId, obj)); }
/// <summary> /// 查找 /// </summary> /// <param name="nodeid"></param> /// <param name="title"></param> /// <param name="codeno"></param> /// <param name="filerecord"></param> /// <param name="cellTemplet"></param> /// <returns></returns> public IList <MDL.T_FileList> DoFind(string nodeid, string title, string codeno, bool filerecord, bool cellTemplet, string ProjectNO) { BLL.T_FileList_BLL fileBLL = new ERM.BLL.T_FileList_BLL(); MDL.T_FileList fileMDL = new T_FileList(); fileMDL.wjtm = title; fileMDL.table_name = title; fileMDL.ProjectNO = ProjectNO; IList <MDL.T_FileList> fileList = fileBLL.FindByKeyString(fileMDL); return(fileList); }
public IList <T_FileList> FindByParentID(String parentID, string projectNO) { String stmtId = "T_FileList.FindByParentID"; MDL.T_FileList obj = new T_FileList(); obj.ParentID = parentID; obj.ProjectNO = projectNO; IList <T_FileList> result = MyISqlMap.QueryForList <T_FileList>(stmtId, obj); return(result); }
public int GetMaxTemplateOrderIndex() { MDL.T_FileList obj = new T_FileList(); String stmtId = "T_FileList.GetMaxTemplateOrderIndex"; object result = MyISqlMap.QueryForObject(stmtId, obj); if (result == null) { result = "0"; } return(int.Parse(result.ToString())); }
public void Delete(String fileID, String projectNO) { if (fileID == null || projectNO == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_FileList.Delete"; T_FileList obj = new T_FileList(); obj.FileID = fileID; obj.ProjectNO = projectNO; MyISqlMap.Delete(stmtId, obj); }
public int GetWzCount(string archiveID, string ProjectNO) { MDL.T_FileList obj = new T_FileList(); obj.ArchiveID = archiveID; obj.ProjectNO = ProjectNO; String stmtId = "T_FileList.GetWzCount"; object result = MyISqlMap.QueryForObject(stmtId, obj); if (result == null) { result = "0"; } return(int.Parse(result.ToString())); }
/// <summary> /// 调整 电子文件表中记录 在案卷中的顺序号 /// </summary> /// <param name="Node"></param> public void MoveFinalAttachment_ArchIndex(TreeNode Node, string ArchiveID, string ProjectNO) { ERM.BLL.T_FileList_BLL fileList_bll = new ERM.BLL.T_FileList_BLL();//文件操作类 2011-3-17 from YQ if (Node != null && Node.Parent != null) { int orderindex2 = 1; for (int i = 0; i < Node.Parent.Nodes.Count; i++) { string FileID = Node.Parent.Nodes[i].Name.ToString();//文件登记表中的ID T_FileList moveFileList = fileList_bll.Find(FileID, ProjectNO); moveFileList.ArchiveIndex = orderindex2++; fileList_bll.Update(moveFileList); } } }
public string GetMixDate(string ProjectNO, string ArchiveID) { String stmtId = "T_FileList.GetMixDate"; MDL.T_FileList obj = new T_FileList(); obj.ArchiveID = ArchiveID; obj.ProjectNO = ProjectNO; object result = MyISqlMap.QueryForObject(stmtId, obj); if (result == null) { result = ""; } return(result.ToString()); }
public int GetMaxGdFileOrderIndex(string GDID, string ProjectNO) { String stmtId = "T_FileList.GetMaxGdFileOrderIndex"; MDL.T_FileList obj = new T_FileList(); obj.GDID = GDID; obj.ProjectNO = ProjectNO; object result = MyISqlMap.QueryForObject(stmtId, obj); if (result == null) { result = "0"; } return(int.Parse(result.ToString())); }
public IList <T_FileList> FindByArchiveID2(String archiveID, string projectNO) { T_Projects_BLL bll = new T_Projects_BLL(); //T_Projects projects = bll.Find(projectNO); String stmtId = "T_FileList.FindByArchiveID2"; MDL.T_FileList obj = new T_FileList(); obj.ArchiveID = archiveID; obj.ProjectNO = projectNO; //obj.ProjectCategory = projects.ProjectCategory; IList <T_FileList> result = MyISqlMap.QueryForList <T_FileList>(stmtId, obj); return(result); }
public int CopyFileToFileTemplate(string FileID, int OrderIndex) { String stmtId = "T_FileList.CopyFileToFileTemplate"; MDL.T_FileList obj = new T_FileList(); obj.FileID = FileID; obj.OrderIndex = OrderIndex; object result = MyISqlMap.QueryForObject(stmtId, obj); if (result == null) { result = "0"; } return(int.Parse(result.ToString())); ; }
public string SetValue(TreeNodeEx node, int index, string FileID, ITreeFactory itf) { T_FileList model = new T_FileList(); model.TreePath = OpeartPath(node); model.wjcj = node.Level.ToString(); // model.wjbsm = this.wjbsm.Text; if (!String.IsNullOrEmpty(node.Text) && node.Text.LastIndexOf("]") > 0) { model.wjtm = node.Text.Substring(node.Text.LastIndexOf("]") + 1); } else { model.wjtm = node.Text; } model.wjmc = model.wjtm; // model.wjlx =cmb_wjlx.Text; //if (this.dptCreateDate.CustomFormat == "") //{ // if (index == 0) // { // model.CreateDate = DateTime.Now.ToString(); // } // else // { // model.CreateDate = dptCreateDate.Value.ToString(); // } //} if (index == 0) { model.CreateDate = DateTime.Now.ToString(); } else { model.CreateDate = dptCreateDate.TextEx; } //if (this.dptCreateDate2.CustomFormat == "") //{ // model.CreateDate2 = dptCreateDate2.Value.ToString(); //} model.CreateDate2 = dptCreateDate2.TextEx; model.ztlx = ztlx.Text; if (!String.IsNullOrEmpty(this.sl.Text)) { model.sl = MyCommon.ToInt(this.sl.Text); } else { model.sl = 0; } model.gg = gg.Text.ToString(); // model.bgqx = this.bgqx.Text; // model.mj = this.mj.Text; model.wjgbdm = this.gb.Text.Trim(); // model.wjlxdm = this.wjlx.Text.Trim(); //model.wjdx = this.wjdx.Text.Trim(); model.stys = Convert.ToInt32(this.txtstys.Text.Trim()); model.wzys = Convert.ToInt32(this.txtWzys.Text.Trim()); //model.psdd = this.psdd.Text.Trim(); //model.pssj = this.dptpssj.TextEx;//Value.ToShortDateString(); //model.psz = this.psz.Text.Trim(); //model.fbl = this.fbl.Text.Trim(); //model.xjpp = this.xjpp.Text.Trim(); //model.xjxh = this.xjxh.Text.Trim(); //model.sb = this.sb.Text.Trim(); //model.wjgs = this.wjgs.Text; model.bz = this.fz.Text; model.zrr = this.cmbzrz.SelectedText; model.fileStatus = "1"; model.ProjectNO = Globals.ProjectNO; model.CreateDate = this.dptCreateDate.Text; model.CreateDate2 = this.dptCreateDate2.Text; int nTzz = 0; int nDtz = 0; if (!String.IsNullOrEmpty(this.tzz.GetText)) { nTzz = MyCommon.ToInt(this.tzz.GetText); } if (!String.IsNullOrEmpty(this.dtz.GetText)) { nDtz = MyCommon.ToInt(this.dtz.GetText); } int TzResult = nTzz + nDtz; model.dw = TzResult.ToString(); int nZpz = 0; int nDpz = 0; if (!String.IsNullOrEmpty(this.zpz.GetText)) { nZpz = MyCommon.ToInt(this.zpz.GetText); } if (!String.IsNullOrEmpty(this.dpz.GetText)) { nDpz = MyCommon.ToInt(this.dpz.GetText); } int ZpResult = nZpz + nDpz; model.wzz = ZpResult.ToString(); if (String.IsNullOrEmpty(this.tzz.GetText)) { model.tzz = "0"; } else { model.tzz = this.tzz.GetText; } if (String.IsNullOrEmpty(this.dtz.GetText)) { model.dtz = "0"; } else { model.dtz = this.dtz.GetText; } if (String.IsNullOrEmpty(this.zpz.GetText)) { model.zpz = "0"; } else { model.zpz = this.zpz.GetText; } if (String.IsNullOrEmpty(this.dpz.GetText)) { model.dpz = "0"; } else { model.dpz = this.dpz.GetText; } if (!String.IsNullOrEmpty(FileID)) { model.FileID = FileID; } else { model.FileID = Guid.NewGuid().ToString(); } try { BLL.T_FileList_BLL fileBLL = new ERM.BLL.T_FileList_BLL(); fileBLL.Update(model); return(model.FileID); } catch { return(null); } }
public void Add(T_FileList obj) { Insert(obj); }
public void UpdateOrder(T_FileList obj) { String stmtId = "T_FileList.UpdateOrderIndex"; MyISqlMap.QueryForObject(stmtId, obj); }