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