/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ERM.MDL.T_FileList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FileRecording_Templet set ");
strSql.Append("cjdag='" + model.cjdag + "',");
strSql.Append("datawindow_id='" + model.datawindow_id + "',");
strSql.Append("extension1='" + model.extension1 + "',");
strSql.Append("extension2='" + model.extension2 + "',");
strSql.Append("extension3='" + model.extension3 + "',");
strSql.Append("gclx='" + model.gclx + "',");
strSql.Append("gdwj='" + model.gdwj + "',");
strSql.Append("id='" + model.id + "',");
strSql.Append("isvisible=" + model.isvisible + ",");
strSql.Append("jldw='" + model.jldw + "',");
strSql.Append("jsdw='" + model.jsdw + "',");
strSql.Append("OrderIndex=" + model.OrderIndex + ",");
strSql.Append("ProjectNO='" + model.ProjectNO + "',");
strSql.Append("pTreePath='" + model.pTreePath + "',");
strSql.Append("selected=" + model.selected + ",");
strSql.Append("sgdw='" + model.sgdw + "',");
strSql.Append("sjdw='" + model.sjdw + "',");
strSql.Append("table_name='" + model.table_name + "',");
strSql.Append("table_standerd='" + model.table_standerd + "',");
strSql.Append("TreePath='" + model.TreePath + "',");
strSql.Append("wjmj='" + model.wjmj + "',");
strSql.Append("zrr='" + model.zrr + "'");
strSql.Append(" where id='" + model.id + "' and ProjectNO='" + model.ProjectNO + "' ");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 用来被查找子窗口调用、进行查询的具体方法
/// </summary>
public string DoFind(string nodeid, string codeno, string title, bool check1, bool check2)
{
string ret = nodeid;
if (dsFildResult == null || dsFildResult.Count <= 0 || findKey == "" || findKey != title)
{
dsFildResult = treesData.DoFind(nodeid.Trim(','), MyCommon.ToSqlString(title), MyCommon.ToSqlString(codeno), check1, check2, Globals.ProjectNO);
findKey = title;
}
if (dsFildResult == null || dsFildResult.Count <= 0)
{
ret = "";
TXMessageBoxExtensions.Info("没有找到相关资料！");
}
else
{
MDL.T_FileList obj = new ERM.MDL.T_FileList();
if (dsFildResult.Count > 0)
{
obj = dsFildResult[0];
dsFildResult.RemoveAt(0);
ExpendParentNode(obj);
}
}
return(ret);
}
/// 用递归的方法读取树
/// </summary>
/// <param name="treeView">需要把数据绑定到的TreeView控件</param>
/// <param name="tableName">树的数据所在的表</param>
public void GetTree(TreeView treeView, string fileRecording_templet, string cell_tempet, bool withImage, string projectNo, bool IsAll)
{
treeView.Nodes.Clear();
ds = vars.GetTrees(true, Globals.ProjectNO);
DataView dataView = new DataView(ds.Tables[0]);
dataView.RowFilter = "id='01'";
if (dataView.Count == 0)
{
return;
}
DataRowView tRow = dataView[0];
ERM.MDL.T_FileList M_FileRecording_Templet = this.Command_GetFile(tRow);//获取文件对象模型
TreeNodeEx node = new TreeNodeEx();
node.Name = M_FileRecording_Templet.id; //节点唯一ID,用来检索
node.Text = M_FileRecording_Templet.gdwj; //标题
node.Tag = M_FileRecording_Templet; //是否最后一个节点,范例路径,是否用户定义表格,附件
node.Checked = M_FileRecording_Templet.isvisible == 1?true:false; //是否可见
if (withImage)
{
node.ImageIndex = 0; //0为根目录图片号
node.SelectedImageIndex = 0; //0为根目录图片号
}
treeView.BeginUpdate();
treeView.Nodes.Add(node);
LoadChildNodes(node, node.Name, withImage, IsAll);
node.IsFirstExpand = false;
treeView.EndUpdate();
treeView.Nodes[0].Expand();
}
private void AddNewNode(string Action, string txtLocalPath, string StrTitle)
{
TreeNodeEx theNode = (TreeNodeEx)treeView1.SelectedNode;
int orderindex = (new BLL.T_CellAndEFile_BLL()).GetMaxOrderIndex(theNode.Name, Globals.ProjectNO);//treesData.GetNextIndex(theNode.Name, Globals.ProjectNO);
string ParentID = theNode.Name;
string Filepath = txtLocalPath;
string Title = StrTitle;
string ProjectNO = Globals.ProjectNO;
fileModel = new ERM.MDL.T_FileList();
fileModel.gdwj = Title;
fileModel.wjtm = Title;
fileModel.FileID = Guid.NewGuid().ToString();
fileModel.ParentID = ParentID;
fileModel.ProjectNO = ProjectNO;
fileModel.OrderIndex = (new BLL.T_FileList_BLL()).GetMaxOrderIndex(ParentID, Globals.ProjectNO) + 1;
fileModel.isvisible = 1;
fileModel.fileStatus = "0";
fileModel.FL = 0;
(new BLL.T_FileList_BLL()).Add(fileModel);
MDL.T_CellAndEFile cellMode = new ERM.MDL.T_CellAndEFile();
cellMode.CellID = Guid.NewGuid().ToString();
if (!System.IO.File.Exists(Filepath))
{
TXMessageBoxExtensions.Info("文件不存在！");
return;
}
System.IO.File.Copy(Filepath, Globals.ProjectPath + "ODOC\\" + cellMode.CellID + ".cll", true);
cellMode.filepath = "ODOC\\" + cellMode.CellID + ".cll";
cellMode.orderindex = orderindex + 1;
cellMode.FileID = fileModel.FileID;
cellMode.isvisible = 1;
cellMode.EFileType = true;//电子文件类型，0=false 系统的，-1=true 用户上传的
cellMode.ProjectNO = ProjectNO;
cellMode.title = Title;
cellBLL.Add(cellMode);
TreeNodeEx newNode = new TreeNodeEx();
newNode.Name = cellMode.FileID;
newNode.ImageIndex = 2;
newNode.SelectedImageIndex = 2;
newNode.Text = cellMode.title;
theNode.Nodes.Add(newNode);
theNode.Expand();
}
/// <summary>
/// 修改文件登记
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int EditFileRegist(ERM.MDL.T_FileList model)
{
try
{
BLL.T_FileList_BLL fileBLL = new ERM.BLL.T_FileList_BLL();
fileBLL.Update(model);
return(1);
}
catch
{
return(0);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ERM.MDL.T_FileList Find(string id, string ProjectNO)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" cjdag,datawindow_id,extension1,extension2,extension3,gclx,gdwj,id,isvisible,jldw,jsdw,OrderIndex,ProjectNO,pTreePath,selected,sgdw,sjdw,table_name,table_standerd,TreePath,wjmj,zrr ");
strSql.Append(" from FileRecording_Templet ");
strSql.Append(" where id='" + id + "' and ProjectNO='" + ProjectNO + "' ");
ERM.MDL.T_FileList model = new ERM.MDL.T_FileList();
DataSet ds = DbHelperOleDb.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
model.cjdag = ds.Tables[0].Rows[0]["cjdag"].ToString();
model.datawindow_id = ds.Tables[0].Rows[0]["datawindow_id"].ToString();
model.extension1 = ds.Tables[0].Rows[0]["extension1"].ToString();
model.extension2 = ds.Tables[0].Rows[0]["extension2"].ToString();
model.extension3 = ds.Tables[0].Rows[0]["extension3"].ToString();
model.gclx = ds.Tables[0].Rows[0]["gclx"].ToString();
model.gdwj = ds.Tables[0].Rows[0]["gdwj"].ToString();
model.id = ds.Tables[0].Rows[0]["id"].ToString();
if (ds.Tables[0].Rows[0]["isvisible"].ToString() != "")
{
model.isvisible = int.Parse(ds.Tables[0].Rows[0]["isvisible"].ToString());
}
model.jldw = ds.Tables[0].Rows[0]["jldw"].ToString();
model.jsdw = ds.Tables[0].Rows[0]["jsdw"].ToString();
if (ds.Tables[0].Rows[0]["OrderIndex"].ToString() != "")
{
model.OrderIndex = int.Parse(ds.Tables[0].Rows[0]["OrderIndex"].ToString());
}
model.ProjectNO = ds.Tables[0].Rows[0]["ProjectNO"].ToString();
model.pTreePath = ds.Tables[0].Rows[0]["pTreePath"].ToString();
if (ds.Tables[0].Rows[0]["selected"].ToString() != "")
{
model.selected = int.Parse(ds.Tables[0].Rows[0]["selected"].ToString());
}
model.sgdw = ds.Tables[0].Rows[0]["sgdw"].ToString();
model.sjdw = ds.Tables[0].Rows[0]["sjdw"].ToString();
model.table_name = ds.Tables[0].Rows[0]["table_name"].ToString();
model.table_standerd = ds.Tables[0].Rows[0]["table_standerd"].ToString();
model.TreePath = ds.Tables[0].Rows[0]["TreePath"].ToString();
model.wjmj = ds.Tables[0].Rows[0]["wjmj"].ToString();
model.zrr = ds.Tables[0].Rows[0]["zrr"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ERM.MDL.T_FileList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_FileList set ");
strSql.Append("bgqx='" + model.bgqx + "',");
strSql.Append("bz='" + model.bz + "',");
strSql.Append("bzdw='" + model.bzdw + "',");
strSql.Append("CreateDate='" + model.CreateDate + "',");
strSql.Append("CreateDate2='" + model.CreateDate2 + "',");
strSql.Append("dw='" + model.dw + "',");
strSql.Append("fbl='" + model.fbl + "',");
strSql.Append("FileID='" + model.FileID + "',");
strSql.Append("filepath='" + model.filepath + "',");
strSql.Append("fileStatus='" + model.fileStatus + "',");
strSql.Append("gg='" + model.gg + "',");
strSql.Append("mj='" + model.mj + "',");
strSql.Append("parentid='" + model.parentid + "',");
strSql.Append("ProjectNO='" + model.ProjectNO + "',");
strSql.Append("psdd='" + model.psdd + "',");
strSql.Append("pssj='" + model.pssj + "',");
strSql.Append("psz='" + model.psz + "',");
strSql.Append("PtreePath='" + model.PtreePath + "',");
strSql.Append("sb='" + model.sb + "',");
strSql.Append("sl=" + model.sl + ",");
strSql.Append("TreePath='" + model.TreePath + "',");
strSql.Append("wh='" + model.wh + "',");
strSql.Append("wjbsm='" + model.wjbsm + "',");
strSql.Append("wjcj='" + model.wjcj + "',");
strSql.Append("wjdx='" + model.wjdx + "',");
strSql.Append("wjgbdm='" + model.wjgbdm + "',");
strSql.Append("wjgs='" + model.wjgs + "',");
strSql.Append("wjlxdm='" + model.wjlxdm + "',");
strSql.Append("wjmc='" + model.wjmc + "',");
strSql.Append("wjtm='" + model.wjtm + "',");
strSql.Append("xjpp='" + model.xjpp + "',");
strSql.Append("xjxh='" + model.xjxh + "',");
strSql.Append("zrr='" + model.zrr + "',");
strSql.Append("ztlx='" + model.ztlx + "',");
strSql.Append("dpz='" + model.dpz + "',");
strSql.Append("dtz='" + model.dtz + "',");
strSql.Append("tzz='" + model.tzz + "',");
strSql.Append("wzz='" + model.wzz + "',");
strSql.Append("zpz='" + model.zpz + "'");
strSql.Append(" where TreePath='" + model.TreePath + "' ");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 打印调的方法
/// </summary>
/// <param name="dt"></param>
/// <param name="showmsg"></param>
//public void Test(DataTable dt, bool showmsg)
//{
// if (Globals.SH == 0)
// {
// TXMessageBoxExtensions.Info("您没有提交权限！");
// return;
// }
// if (dt.Rows.Count > 0)
// {
// string CurPrinterName = PrinterOperate.GetDefaultPrinterName();
// if (CurPrinterName != PrinterOperate.UsePrinterName)//如果当前打印机不是EASYPDF就要设置
// {
// PrinterOperate.SetPrinter(PrinterOperate.UsePrinterName);
// }
// frmRefreshHead frm = new frmRefreshHead(Mydel, dt);
// frm.SetTitle = "提交中…";
// frm.SetMsg = "正在处理数据，请稍候…";
// if (frm.ShowDialog() != DialogResult.OK)
// {
// if (!string.IsNullOrEmpty(frm.ErrorMsg))
// {
// TXMessageBoxExtensions.Info(frm.ErrorMsg);
// }
// }
// else
// {
// if (showmsg)
// TXMessageBoxExtensions.Info("提交完成！");
// }
// if (CurPrinterName != PrinterOperate.UsePrinterName)
// {
// PrinterOperate.SetPrinter(CurPrinterName);
// }//设置打印机后，设回来
// }
// else
// {
// TXMessageBoxExtensions.Info("没有找到需要提交的文件！");
// }
//}
/// <summary>
/// 新建目录，0为同级，1为子级
/// </summary>
/// <param name="level">0为同级，1为子级</param>
private void NewFloder(int level)
{
try
{
TreeNodeEx parentNode = (TreeNodeEx)treeView1.SelectedNode;
if (parentNode == null)
{
return;
}
TreeNodeEx tempNode = null;//传个空值用
frmMainGetTempletFromStandard frm = new frmMainGetTempletFromStandard(tempNode, false, parentNode);
DialogResult ret = frm.ShowDialog();
if (ret == DialogResult.OK)
{
string Title = MyCommon.ToSqlString(frm.StrTitle.Trim());
int orderindex = (new BLL.T_FileList_BLL()).GetMaxOrderIndex(parentNode.Name, Globals.ProjectNO);
string ProjectNO = Globals.ProjectNO;
fileModel = new ERM.MDL.T_FileList();
fileModel.gdwj = Title;
fileModel.wjtm = Title;
fileModel.FileID = Guid.NewGuid().ToString();
fileModel.ParentID = parentNode.Name;
fileModel.ProjectNO = ProjectNO;
fileModel.OrderIndex = orderindex + 1;
fileModel.fileStatus = "0";
fileModel.FL = 0;
BLL.T_FileList_BLL fileBLL = new ERM.BLL.T_FileList_BLL();
fileModel.isvisible = 0;
fileBLL.Add(fileModel);
TreeNodeEx newNode = new TreeNodeEx();
newNode.Name = fileModel.FileID;
newNode.Text = fileModel.wjtm;
newNode.ImageIndex = 1;
newNode.SelectedImageIndex = 1;
parentNode.Nodes.Add(newNode);
}
}
catch
{
}
}
private ERM.MDL.T_FileList Command_GetFile(DataRowView tRow)
{
ERM.MDL.T_FileList M_FileRecording_Templet = new ERM.MDL.T_FileList();
M_FileRecording_Templet.id = tRow["id"].ToString(); //节点唯一ID
M_FileRecording_Templet.gdwj = tRow["title"].ToString(); //标题
M_FileRecording_Templet.zrr = tRow["zrr"].ToString(); //责任人
M_FileRecording_Templet.OrderIndex = Convert.ToInt32(tRow["orderindex"]); //顺序号
M_FileRecording_Templet.isvisible = Convert.ToInt16(tRow["isvisible"]); //是否可见
M_FileRecording_Templet.gclx = tRow["gclx"].ToString();
M_FileRecording_Templet.jsdw = tRow["jsdw"].ToString();
M_FileRecording_Templet.jldw = tRow["jldw"].ToString();
M_FileRecording_Templet.sgdw = tRow["sgdw"].ToString();
M_FileRecording_Templet.sjdw = tRow["sjdw"].ToString();
M_FileRecording_Templet.wjmj = tRow["wjmj"].ToString();
M_FileRecording_Templet.cjdag = tRow["cjdag"].ToString();
M_FileRecording_Templet.table_name = tRow["table_name"].ToString();
M_FileRecording_Templet.ProjectNO = CPROJECTNO;
return(M_FileRecording_Templet);
}
/// <summary>
/// 按案卷上报
/// </summary>
/// <returns></returns>
private bool?ConfirmSplitForfrmArchive()
{
if (txtLoc.Text == "")
{
TXMessageBoxExtensions.Info("请选择导出文件的存储路径！");
txtLoc.Focus();
return(null);
}
string destFilename = Globals.Projectname;
destFolder = txtLoc.Text;
string dest_temp = Path.GetDirectoryName(txtLoc.Text);
if (!Directory.Exists(dest_temp))
{
TXMessageBoxExtensions.Info("存储的路径不存在！");
return(null);
}
double projectSize = Convert.ToDouble(DirectoryInfoCommon.GetDirectorySpace(Application.StartupPath + "\\Project\\" + Globals.ProjectNO) / Convert.ToDouble(1024 * 1024 * 1024));
ReadWriteAppConfig config = new ReadWriteAppConfig();
if (config.Read("Upload_ProjectSize") == "")
{
config.Write("Upload_ProjectSize", "4");
}
string upload_size = config.Read("Upload_ProjectSize");
if (projectSize > Convert.ToDouble(upload_size))
{
DialogResult dresult = TXMessageBoxExtensions.Question("上报工程大于" + upload_size + "G，当前工程大小为：" + System.Math.Round(projectSize, 2) + "G \r\n\n 【温馨提示：工程太大，生成移交文件需要比较长得时间】 \r\n\n 是否继续生成移交？");
if (dresult != DialogResult.OK)
{
return(null);
}
}
else if (MyCommon.CheckDisk(destFolder) < projectSize)
{
//硬盘空间不足
TXMessageBoxExtensions.Info("上报工程大小为：" + System.Math.Round(projectSize, 2) + "G 保存目录硬盘空间不足,无法生成！ \r\n 【温馨提示：请选择比较空闲的盘符】");
txtLoc.Focus();
return(null);
}
tempFullName = dest_temp + "\\" + Guid.NewGuid().ToString();
if (System.IO.Directory.Exists(tempFullName))
{
MyCommon.DeleteAndCreateEmptyDirectory(tempFullName, false);
}
MyCommon.DeleteAndCreateEmptyDirectory(tempFullName);
MyCommon.DeleteAndCreateEmptyDirectory(destFolder, false);
MyCommon.DeleteAndCreateEmptyDirectory(destFolder, true);
panelBottom.Visible = true;
panelTop.Visible = false;
Application.DoEvents();
butClose.Enabled = false;
ERM.CBLL.CreateSip projectFactory = new ERM.CBLL.CreateSip(Globals.ProjectNO);
//DataSet dsFinalArchive = projectFactory.GetListArchive(Globals.ProjectNO, "");
DataSet dsFinalArchive = new Archive().pb_setXmlInfo();
if (dsFinalArchive.Tables.Count < 1 || dsFinalArchive.Tables[0].Rows.Count < 1)
{
TXMessageBoxExtensions.Info("没有任何案卷可以移交！");
return(false);
}
int count_FinalArchive = dsFinalArchive.Tables[0].Rows.Count;
bool checkfile_flag = true;
for (int i = 0; i < count_FinalArchive; i++)
{
BLL.T_FileList_BLL fileBLL = new ERM.BLL.T_FileList_BLL();
IList <MDL.T_FileList> fileList = fileBLL.FindByArchiveID2(dsFinalArchive.Tables[0].Rows[i]["案卷ID"].ToString(), Globals.ProjectNO);
foreach (MDL.T_FileList obj in fileList)
{
if (obj.selected == 1 || obj.filepath == null || obj.filepath == "")
{
ConvertAllEFileToPDF(obj.FileID);
}
else
{
string tFilePath = obj.filepath.Replace("MPDF\\", "");
string sourMfile = Globals.ProjectPath + obj.filepath;
if (!System.IO.File.Exists(sourMfile))
{
ConvertAllEFileToPDF(obj.FileID);
}
}
IList <MDL.T_CellAndEFile> cellList = (new ERM.BLL.T_CellAndEFile_BLL()).FindByGdFileID(obj.FileID, Globals.ProjectNO);
ERM.MDL.T_FileList file_model = (new ERM.BLL.T_FileList_BLL()).Find(obj.FileID, Globals.ProjectNO);
if ((file_model.filepath == null || file_model.filepath == "") &&
cellList.Count > 0)
{
TXMessageBoxExtensions.Info("提示：文件【" + obj.gdwj + "】电子文件信息有误！无法移交，请审查");
checkfile_flag = false;
break;
}
}
if (!checkfile_flag)
{
break;
}
}
if (!checkfile_flag)
{
return(false);
}
progressBar2.Maximum = count_FinalArchive;
progressBar2.Minimum = 0;
progressBar2.MarqueeAnimationSpeed = 1000;
progressBar2.Step = 1;
lblMsg.Text = "正在输出元数据信息...";
Application.DoEvents();
GetListArchiveXML(projectFactory, tempFullName);
try
{
for (int i = 0; i < count_FinalArchive; i++)
{
if (!Directory.Exists(tempFullName))
{
MyCommon.DeleteAndCreateEmptyDirectory(tempFullName, true);
}
//20120530 屏蔽XML文件
GetProjectXML(projectFactory, tempFullName);
if (Convert.ToBoolean(Properties.Settings.Default.SipIncludeDoc))
{
//20120530 屏蔽XML文件
GetListArchiveXMLEx(dsFinalArchive.Tables[0].Rows[i]["案卷ID"].ToString(), tempFullName);
GetDocumentXMLEx(dsFinalArchive.Tables[0].Rows[i]["案卷ID"].ToString(), tempFullName);
BLL.T_FileList_BLL fileBLL = new ERM.BLL.T_FileList_BLL();
IList <MDL.T_FileList> fileList = fileBLL.FindByArchiveID2(dsFinalArchive.Tables[0].Rows[i]["案卷ID"].ToString(), Globals.ProjectNO);
foreach (MDL.T_FileList obj in fileList)
{
//20120530 屏蔽XML文件
//getDocModel(obj);
getDocModel_NEW(obj, tempFullName);
}
}
lblMsg.Text = "正在对数据包进行封装...";
Application.DoEvents();
if (System.IO.File.Exists(tempFullName + "\\index.dat"))//Application.StartupPath + "\\temp\\index.dat"
{
System.IO.File.Move(tempFullName + "\\index.dat", destFolder + "\\index.dat");
string gcInfo = System.IO.File.ReadAllText(tempFullName + "\\a#sgwj_gc.xml", Encoding.GetEncoding("gb2312"));
string docList = System.IO.File.ReadAllText(destFolder + "\\index.dat");
gcInfo = gcInfo.Replace("</项目工程信息>", "<ArchiveFileList>" + docList + "</ArchiveFileList></项目工程信息>");
System.IO.File.WriteAllText(destFolder + "\\index.dat", gcInfo, Encoding.GetEncoding("gb2312"));
}
SevenZip.SevenZipCompressor.SetLibraryPath(Application.StartupPath + "\\7z.dll");
SevenZip.SevenZipCompressor tmp = new SevenZip.SevenZipCompressor();
{
tmp.ArchiveFormat = SevenZip.OutArchiveFormat.Zip;
tmp.CompressDirectory(tempFullName, destFolder + "\\" + dsFinalArchive.Tables[0].Rows[i]["案卷ID"].ToString() + ".sip");
}
MyCommon.DeleteAndCreateEmptyDirectory(tempFullName, false);
progressBar2.Value = progressBar2.Value + 1;
}
}
catch (Exception ex)
{
MyCommon.DeleteAndCreateEmptyDirectory(tempFullName, false);
TXMessageBoxExtensions.Info("封装数据时发生意外错误！错误002");
MyCommon.WriteLog("生成移交文件时失败！错误信息：" + ex.Message);
return(false);
}
butClose.Text = "关闭";
butClose.Enabled = true;
TXMessageBoxExtensions.Info("已经成功生成上报文件！");
return(true);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ERM.MDL.T_FileList model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.cjdag != null)
{
strSql1.Append("cjdag,");
strSql2.Append("'" + model.cjdag + "',");
}
if (model.datawindow_id != null)
{
strSql1.Append("datawindow_id,");
strSql2.Append("'" + model.datawindow_id + "',");
}
if (model.extension1 != null)
{
strSql1.Append("extension1,");
strSql2.Append("'" + model.extension1 + "',");
}
if (model.extension2 != null)
{
strSql1.Append("extension2,");
strSql2.Append("'" + model.extension2 + "',");
}
if (model.extension3 != null)
{
strSql1.Append("extension3,");
strSql2.Append("'" + model.extension3 + "',");
}
if (model.gclx != null)
{
strSql1.Append("gclx,");
strSql2.Append("'" + model.gclx + "',");
}
if (model.gdwj != null)
{
strSql1.Append("gdwj,");
strSql2.Append("'" + model.gdwj + "',");
}
if (model.id != null)
{
strSql1.Append("id,");
strSql2.Append("'" + model.id + "',");
}
if (model.isvisible != null)
{
strSql1.Append("isvisible,");
strSql2.Append("" + model.isvisible + ",");
}
if (model.jldw != null)
{
strSql1.Append("jldw,");
strSql2.Append("'" + model.jldw + "',");
}
if (model.jsdw != null)
{
strSql1.Append("jsdw,");
strSql2.Append("'" + model.jsdw + "',");
}
if (model.OrderIndex != null)
{
strSql1.Append("OrderIndex,");
strSql2.Append("" + model.OrderIndex + ",");
}
if (model.ProjectNO != null)
{
strSql1.Append("ProjectNO,");
strSql2.Append("'" + model.ProjectNO + "',");
}
if (model.pTreePath != null)
{
strSql1.Append("pTreePath,");
strSql2.Append("'" + model.pTreePath + "',");
}
if (model.selected != null)
{
strSql1.Append("selected,");
strSql2.Append("" + model.selected + ",");
}
if (model.sgdw != null)
{
strSql1.Append("sgdw,");
strSql2.Append("'" + model.sgdw + "',");
}
if (model.sjdw != null)
{
strSql1.Append("sjdw,");
strSql2.Append("'" + model.sjdw + "',");
}
if (model.table_name != null)
{
strSql1.Append("table_name,");
strSql2.Append("'" + model.table_name + "',");
}
if (model.table_standerd != null)
{
strSql1.Append("table_standerd,");
strSql2.Append("'" + model.table_standerd + "',");
}
if (model.TreePath != null)
{
strSql1.Append("TreePath,");
strSql2.Append("'" + model.TreePath + "',");
}
if (model.wjmj != null)
{
strSql1.Append("wjmj,");
strSql2.Append("'" + model.wjmj + "',");
}
if (model.zrr != null)
{
strSql1.Append("zrr,");
strSql2.Append("'" + model.zrr + "',");
}
strSql.Append("insert into FileRecording_Templet(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 获取树的节点，跟其他方法合用
/// </summary>
/// <param name="nodes">TreeNodeCollection</param>
/// <param name="nodeID">要查询的节点</param>
private void LoadChildNodes(TreeNodeEx pParentNode, string parentID, bool withImage, bool IsAll)
{
if (ds == null)
{
return;
}
DataView dataView = new DataView(ds.Tables[0]);
dataView.RowFilter = "ParentID='" + parentID + "'";
TreeNodeEx[] tNodes = new TreeNodeEx[dataView.Count];
int tNodesCount = 0;
foreach (DataRowView drv in dataView)
{
TreeNodeEx node = new TreeNodeEx();
if (this.Command_IsSelectFile(Convert.ToInt32(drv["imageindex"])))
{
ERM.MDL.T_FileList M_FileRecording_Templet = this.Command_GetFile(drv); //获取文件对象模型
node.Name = M_FileRecording_Templet.id; //节点唯一ID,用来检索
node.Text = M_FileRecording_Templet.gdwj; //标题
node.Tag = M_FileRecording_Templet; //是否最后一个节点,范例路径,是否用户定义表格,附件
node.Checked = M_FileRecording_Templet.isvisible == 1 ? true : false; //是否可见
}
else if (this.Command_IsSelectModel(Convert.ToInt32(drv["imageindex"])))
{
ERM.MDL.T_CellAndEFile M_Cell_Templet = this.Command_GetModel(drv); //获取文件对象模型
node.Name = M_Cell_Templet.id; //节点唯一ID,用来检索
node.Text = M_Cell_Templet.title; //标题
node.Tag = M_Cell_Templet; //是否最后一个节点,范例路径,是否用户定义表格,附件
node.Checked = M_Cell_Templet.isvisible == 1 ? true : false; //是否可见
node.NodeKey = M_Cell_Templet.codeno;
node.NodeValue = M_Cell_Templet.filepath;
}
else if (this.Command_IsSelectRoot(Convert.ToInt32(drv["imageindex"])))
{
ERM.MDL.T_FileList M_FileRecording_Templet = this.Command_GetFile(drv); //获取文件对象模型
node.Name = M_FileRecording_Templet.id; //节点唯一ID,用来检索
node.Text = M_FileRecording_Templet.gdwj; //标题
node.Tag = M_FileRecording_Templet; //是否最后一个节点,范例路径,是否用户定义表格,附件
node.Checked = M_FileRecording_Templet.isvisible == 1 ? true : false; //是否可见
}
if (withImage)
{
node.ImageIndex = Convert.ToInt32(drv["imageindex"]);
node.SelectedImageIndex = Convert.ToInt32(drv["imageindex"]);
}
node.Text = drv["title"].ToString();
if (node.ImageIndex != 2)
{
if (IsAll)
{
LoadChildNodes(node, node.Name, true, true);
node.IsFirstExpand = false;
}
else
{
TreeNodeEx node1 = new TreeNodeEx();
node1.Name = "临时数据";
node1.Text = "临时数据";
node.Nodes.Add(node1);
}
}
tNodes.SetValue(node, tNodesCount++);
}
if (80 < tNodes.Length) //如果其含有的子节点数大于80个,启动BeginUpdate方法
{
pParentNode.TreeView.BeginUpdate();
pParentNode.Nodes.AddRange(tNodes);
pParentNode.TreeView.EndUpdate();
}
else
{
pParentNode.Nodes.AddRange(tNodes);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ERM.MDL.T_FileList model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.bgqx != null)
{
strSql1.Append("bgqx,");
strSql2.Append("'" + model.bgqx + "',");
}
if (model.bz != null)
{
strSql1.Append("bz,");
strSql2.Append("'" + model.bz + "',");
}
if (model.bzdw != null)
{
strSql1.Append("bzdw,");
strSql2.Append("'" + model.bzdw + "',");
}
if (model.CreateDate != null)
{
strSql1.Append("CreateDate,");
strSql2.Append("'" + model.CreateDate + "',");
}
if (model.CreateDate2 != null)
{
strSql1.Append("CreateDate2,");
strSql2.Append("'" + model.CreateDate2 + "',");
}
if (model.dw != null)
{
strSql1.Append("dw,");
strSql2.Append("'" + model.dw + "',");
}
if (model.fbl != null)
{
strSql1.Append("fbl,");
strSql2.Append("'" + model.fbl + "',");
}
if (model.FileID != null)
{
strSql1.Append("FileID,");
strSql2.Append("'" + model.FileID + "',");
}
if (model.filepath != null)
{
strSql1.Append("filepath,");
strSql2.Append("'" + model.filepath + "',");
}
if (model.fileStatus != null)
{
strSql1.Append("fileStatus,");
strSql2.Append("'" + model.fileStatus + "',");
}
if (model.gg != null)
{
strSql1.Append("gg,");
strSql2.Append("'" + model.gg + "',");
}
if (model.mj != null)
{
strSql1.Append("mj,");
strSql2.Append("'" + model.mj + "',");
}
if (model.parentid != null)
{
strSql1.Append("parentid,");
strSql2.Append("'" + model.parentid + "',");
}
if (model.ProjectNO != null)
{
strSql1.Append("ProjectNO,");
strSql2.Append("'" + model.ProjectNO + "',");
}
if (model.psdd != null)
{
strSql1.Append("psdd,");
strSql2.Append("'" + model.psdd + "',");
}
if (model.pssj != null)
{
strSql1.Append("pssj,");
strSql2.Append("'" + model.pssj + "',");
}
if (model.psz != null)
{
strSql1.Append("psz,");
strSql2.Append("'" + model.psz + "',");
}
if (model.PtreePath != null)
{
strSql1.Append("PtreePath,");
strSql2.Append("'" + model.PtreePath + "',");
}
if (model.sb != null)
{
strSql1.Append("sb,");
strSql2.Append("'" + model.sb + "',");
}
if (model.sl != null)
{
strSql1.Append("sl,");
strSql2.Append("" + model.sl + ",");
}
if (model.TreePath != null)
{
strSql1.Append("TreePath,");
strSql2.Append("'" + model.TreePath + "',");
}
if (model.wh != null)
{
strSql1.Append("wh,");
strSql2.Append("'" + model.wh + "',");
}
if (model.wjbsm != null)
{
strSql1.Append("wjbsm,");
strSql2.Append("'" + model.wjbsm + "',");
}
if (model.wjcj != null)
{
strSql1.Append("wjcj,");
strSql2.Append("'" + model.wjcj + "',");
}
if (model.wjdx != null)
{
strSql1.Append("wjdx,");
strSql2.Append("'" + model.wjdx + "',");
}
if (model.wjgbdm != null)
{
strSql1.Append("wjgbdm,");
strSql2.Append("'" + model.wjgbdm + "',");
}
if (model.wjgs != null)
{
strSql1.Append("wjgs,");
strSql2.Append("'" + model.wjgs + "',");
}
if (model.wjlxdm != null)
{
strSql1.Append("wjlxdm,");
strSql2.Append("'" + model.wjlxdm + "',");
}
if (model.wjmc != null)
{
strSql1.Append("wjmc,");
strSql2.Append("'" + model.wjmc + "',");
}
if (model.wjtm != null)
{
strSql1.Append("wjtm,");
strSql2.Append("'" + model.wjtm + "',");
}
if (model.xjpp != null)
{
strSql1.Append("xjpp,");
strSql2.Append("'" + model.xjpp + "',");
}
if (model.xjxh != null)
{
strSql1.Append("xjxh,");
strSql2.Append("'" + model.xjxh + "',");
}
if (model.zrr != null)
{
strSql1.Append("zrr,");
strSql2.Append("'" + model.zrr + "',");
}
if (model.ztlx != null)
{
strSql1.Append("ztlx,");
strSql2.Append("'" + model.ztlx + "',");
}
if (model.dpz != null)
{
strSql1.Append("dpz,");
strSql2.Append("'" + model.dpz + "',");
}
if (model.dtz != null)
{
strSql1.Append("dtz,");
strSql2.Append("'" + model.dtz + "',");
}
if (model.tzz != null)
{
strSql1.Append("tzz,");
strSql2.Append("'" + model.tzz + "',");
}
if (model.wzz != null)
{
strSql1.Append("wzz,");
strSql2.Append("'" + model.wzz + "',");
}
if (model.zpz != null)
{
strSql1.Append("zpz,");
strSql2.Append("'" + model.zpz + "',");
}
strSql.Append("insert into T_FileList(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
DbHelperOleDb.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ERM.MDL.T_FileList Find(string FileID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" bgqx,bz,bzdw,CreateDate,CreateDate2,dw,fbl,FileID,filepath,fileStatus,gg,mj,parentid,ProjectNO,psdd,pssj,psz,PtreePath,sb,sl,TreePath,wh,wjbsm,wjcj,wjdx,wjgbdm,wjgs,wjlxdm,wjmc,wjtm,xjpp,xjxh,zrr,ztlx,dpz,dtz,tzz,wzz,zpz ");
strSql.Append(" from T_FileList ");
strSql.Append(" where FileID='" + FileID + "' ");
ERM.MDL.T_FileList model = new ERM.MDL.T_FileList();
DataSet ds = DbHelperOleDb.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
model.bgqx = ds.Tables[0].Rows[0]["bgqx"].ToString();
model.bz = ds.Tables[0].Rows[0]["bz"].ToString();
model.bzdw = ds.Tables[0].Rows[0]["bzdw"].ToString();
if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
if (ds.Tables[0].Rows[0]["CreateDate2"].ToString() != "")
{
model.CreateDate2 = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate2"].ToString());
}
model.dw = ds.Tables[0].Rows[0]["dw"].ToString();
model.fbl = ds.Tables[0].Rows[0]["fbl"].ToString();
model.FileID = ds.Tables[0].Rows[0]["FileID"].ToString();
model.filepath = ds.Tables[0].Rows[0]["filepath"].ToString();
model.fileStatus = ds.Tables[0].Rows[0]["fileStatus"].ToString();
model.gg = ds.Tables[0].Rows[0]["gg"].ToString();
model.mj = ds.Tables[0].Rows[0]["mj"].ToString();
model.parentid = ds.Tables[0].Rows[0]["parentid"].ToString();
model.ProjectNO = ds.Tables[0].Rows[0]["ProjectNO"].ToString();
model.psdd = ds.Tables[0].Rows[0]["psdd"].ToString();
if (ds.Tables[0].Rows[0]["pssj"].ToString() != "")
{
model.pssj = DateTime.Parse(ds.Tables[0].Rows[0]["pssj"].ToString());
}
model.psz = ds.Tables[0].Rows[0]["psz"].ToString();
model.PtreePath = ds.Tables[0].Rows[0]["PtreePath"].ToString();
model.sb = ds.Tables[0].Rows[0]["sb"].ToString();
if (ds.Tables[0].Rows[0]["sl"].ToString() != "")
{
model.sl = int.Parse(ds.Tables[0].Rows[0]["sl"].ToString());
}
model.TreePath = ds.Tables[0].Rows[0]["TreePath"].ToString();
model.wh = ds.Tables[0].Rows[0]["wh"].ToString();
model.wjbsm = ds.Tables[0].Rows[0]["wjbsm"].ToString();
model.wjcj = ds.Tables[0].Rows[0]["wjcj"].ToString();
model.wjdx = ds.Tables[0].Rows[0]["wjdx"].ToString();
model.wjgbdm = ds.Tables[0].Rows[0]["wjgbdm"].ToString();
model.wjgs = ds.Tables[0].Rows[0]["wjgs"].ToString();
model.wjlxdm = ds.Tables[0].Rows[0]["wjlxdm"].ToString();
model.wjmc = ds.Tables[0].Rows[0]["wjmc"].ToString();
model.wjtm = ds.Tables[0].Rows[0]["wjtm"].ToString();
model.xjpp = ds.Tables[0].Rows[0]["xjpp"].ToString();
model.xjxh = ds.Tables[0].Rows[0]["xjxh"].ToString();
model.zrr = ds.Tables[0].Rows[0]["zrr"].ToString();
model.ztlx = ds.Tables[0].Rows[0]["ztlx"].ToString();
model.dpz = ds.Tables[0].Rows[0]["dpz"].ToString();
model.dtz = ds.Tables[0].Rows[0]["dtz"].ToString();
model.tzz = ds.Tables[0].Rows[0]["tzz"].ToString();
model.wzz = ds.Tables[0].Rows[0]["wzz"].ToString();
model.zpz = ds.Tables[0].Rows[0]["zpz"].ToString();
return(model);
}
else
{
return(null);
}
}
