public T_FileListTemplate FindByProjectCategory(String projectCategory) { String stmtId = "T_FileListTemplate.FindByProjectCategory"; T_FileListTemplate result = MyISqlMap.QueryForObject <T_FileListTemplate>(stmtId, projectCategory); return(result); }
public System.Data.DataSet GetChildDS(T_FileListTemplate obj) { String stmtId = "T_FileListTemplate.GetChildDS"; System.Data.DataSet result = DAL.MyBatis.QueryForDataSet(stmtId, obj); return(result); }
public IList <T_FileListTemplate> FindByKeyString(T_FileListTemplate obj) { String stmtId = "T_FileListTemplate.FindByKeyString"; IList <T_FileListTemplate> result = MyISqlMap.QueryForList <T_FileListTemplate>(stmtId, obj); return(result); }
public IList <T_FileListTemplate> GetFileByGDIDList(T_FileListTemplate obj) { String stmtId = "T_FileListTemplate.GetFileByGDIDList"; IList <T_FileListTemplate> result = MyISqlMap.QueryForList <T_FileListTemplate>(stmtId, obj); return(result); }
public void DeleteGdList(String fileID) { String stmtId = "T_FileListTemplate.DeleteGdList"; T_FileListTemplate obj = new T_FileListTemplate(); obj.FileID = fileID; MyISqlMap.Delete(stmtId, obj); }
public bool Exists(String fileID, String projectNO) { MDL.T_FileListTemplate obj = new T_FileListTemplate(); obj.FileID = fileID; String stmtId = "T_FileListTemplate.Exists"; bool result = MyISqlMap.QueryForObject <bool>(stmtId, obj); return(result); }
public System.Data.DataTable GetFileByGDID(string ProjectNO, string GDID) { String stmtId = "T_FileListTemplate.GetFileByGDID"; MDL.T_FileListTemplate obj = new T_FileListTemplate(); obj.GDID = GDID; System.Data.DataTable result = DAL.MyBatis.QueryForDataTable(stmtId, obj); return(result); }
public System.Data.DataTable GetAllFLDS(string ProjectNO, int FL) { String stmtId = "T_FileListTemplate.GetAllFLDS"; MDL.T_FileListTemplate obj = new T_FileListTemplate(); System.Data.DataTable result = DAL.MyBatis.QueryForDataTable(stmtId, obj); return(result); }
public IList <T_FileListTemplate> FindByArchiveID(String archiveID, string projectNO) { String stmtId = "T_FileListTemplate.FindByArchiveID"; MDL.T_FileListTemplate obj = new T_FileListTemplate(); IList <T_FileListTemplate> result = MyISqlMap.QueryForList <T_FileListTemplate>(stmtId, obj); return(result); }
public void Delete(T_FileListTemplate obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_FileListTemplate.Delete"; MyISqlMap.Delete(stmtId, obj); }
public int Update(T_FileListTemplate obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_FileListTemplate.Update"; return(MyISqlMap.Update(stmtId, obj)); }
public void Insert(T_FileListTemplate obj) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_FileListTemplate.Insert"; MyISqlMap.Insert(stmtId, obj); }
public int UpdateFileListArchive(T_FileListTemplate obj, ref string sqltmp) { if (obj == null) { throw new ArgumentNullException("obj"); } String stmtId = "T_FileListTemplate.UpdateFileListArchive"; sqltmp = ERM.DAL.MyBatis.QueryForSql(stmtId, obj); return(MyISqlMap.Update(stmtId, obj)); }
public int GetMaxTemplateOrderIndex() { MDL.T_FileListTemplate obj = new T_FileListTemplate(); String stmtId = "T_FileListTemplate.GetMaxTemplateOrderIndex"; object result = MyISqlMap.QueryForObject(stmtId, obj); if (result == null) { result = "0"; } return(int.Parse(result.ToString())); }
public int GetWzCount(string archiveID, string ProjectNO) { MDL.T_FileListTemplate obj = new T_FileListTemplate(); String stmtId = "T_FileListTemplate.GetWzCount"; object result = MyISqlMap.QueryForObject(stmtId, obj); if (result == null) { result = "0"; } return(int.Parse(result.ToString())); }
public int GetMaxGdFileOrderIndex(string GDID, string ProjectNO) { String stmtId = "T_FileListTemplate.GetMaxGdFileOrderIndex"; MDL.T_FileListTemplate obj = new T_FileListTemplate(); obj.GDID = GDID; object result = MyISqlMap.QueryForObject(stmtId, obj); if (result == null) { result = "0"; } return(int.Parse(result.ToString())); }
public string GetMixDate(string ProjectNO, string ArchiveID) { String stmtId = "T_FileListTemplate.GetMixDate"; MDL.T_FileListTemplate obj = new T_FileListTemplate(); object result = MyISqlMap.QueryForObject(stmtId, obj); if (result == null) { result = ""; } return(result.ToString()); }
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> private void Search() { this.btnSearch.Enabled = false; fileTemp = new T_FileListTemplate(); fileTemp.ProjectCategory = this.cboType.SelectedValue.ToString(); fileTemp.gdwj = this.txtTitle.Text.Trim(); fileTemp.GDID = this.cboCategory.SelectedValue.ToString(); if (!MyCommon.IsMatchCode(this.txtTitle.Text.Trim())) { TXMessageBoxExtensions.Info("没有查到记录!"); this.btnSearch.Enabled = true; return; } DataBind(); this.btnSearch.Enabled = true; }
public int CopyFileToFileTemplate(string FileID, int OrderIndex) { String stmtId = "T_FileListTemplate.CopyFileToFileTemplate"; MDL.T_FileListTemplate obj = new T_FileListTemplate(); obj.FileID = FileID; obj.OrderIndex = OrderIndex; object result = MyISqlMap.QueryForObject(stmtId, obj); if (result == null) { result = "0"; } return(int.Parse(result.ToString())); ; }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { try { if (ID == "") { //新增 fileTemplate.FileID = Guid.NewGuid().ToString(); T_FileListTemplate fileTemplate1 = t_FileListTemplate_BLL.FindByProjectCategory(this.cboType.SelectedValue.ToString()); fileTemplate.ParentID = fileTemplate1.FileID; if (SetValue()) { t_FileListTemplate_BLL.Insert(fileTemplate); } else { return; } } else { //编辑 fileTemplate.FileID = ID; if (SetValue()) { t_FileListTemplate_BLL.Update(fileTemplate); } else { return; } } refreshs(); TXMessageBoxExtensions.Info("保存成功!"); this.Close(); } catch (Exception ex) { TXMessageBoxExtensions.Info(ex.Message.ToString()); } }
public void Add(T_FileListTemplate obj) { Insert(obj); }
public void UpdateOrder(T_FileListTemplate obj) { String stmtId = "T_FileListTemplate.UpdateOrderIndex"; MyISqlMap.QueryForObject(stmtId, obj); }