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);
}
