public bool CCFileUpdate(CC_File model) { model.UpdateTime = DateTime.Now; if (fileInstance.Update(model) > 0) { return true; } return false; }
public bool CCFileInsert(CC_File model) { model.CreateTime = DateTime.Now; model.UpdateTime = DateTime.Now; if (fileInstance.Add(model) > 0) { return true; } return false; }
public List<CC_File> GetListByWhereExtend(string strCondition) { List<CC_File> ret = new List<CC_File>(); string sql = "SELECT CCF_ID,CCF_Code,CCF_DCode,CCF_CompNo,CCF_Name,CCF_iType,CCF_Directory,CCF_Bak,CCF_DownTime,CCF_RCount,CCF_RDirectory,CCF_ROwner,CCF_RDate,CCF_RBak,cc.Stat,cc.Creator,cc.CreateTime,cc.UpdateTime,cc.DeleteTime FROM CC_File cc JOIN Prod_Doc pp on pp.PRDQ_Code=CCF_DCode WHERE 1=1 AND ((cc.Stat is null) or (cc.Stat=0) ) "; if (!string.IsNullOrEmpty(strCondition)) { strCondition.Replace('\'', '"'); //防sql注入 sql += strCondition; } SqlDataReader dr = null; try { dr = (SqlDataReader)idb.ReturnReader(sql); while (dr.Read()) { CC_File cC_File = new CC_File(); if (dr["CCF_ID"] != DBNull.Value) cC_File.CCF_ID = Convert.ToDecimal(dr["CCF_ID"]); if (dr["CCF_Code"] != DBNull.Value) cC_File.CCF_Code = Convert.ToString(dr["CCF_Code"]); if (dr["CCF_DCode"] != DBNull.Value) cC_File.CCF_DCode = Convert.ToString(dr["CCF_DCode"]); if (dr["CCF_CompNo"] != DBNull.Value) cC_File.CCF_CompNo = Convert.ToString(dr["CCF_CompNo"]); if (dr["CCF_Name"] != DBNull.Value) cC_File.CCF_Name = Convert.ToString(dr["CCF_Name"]); if (dr["CCF_iType"] != DBNull.Value) cC_File.CCF_iType = Convert.ToString(dr["CCF_iType"]); if (dr["CCF_Directory"] != DBNull.Value) cC_File.CCF_Directory = Convert.ToString(dr["CCF_Directory"]); if (dr["CCF_Bak"] != DBNull.Value) cC_File.CCF_Bak = Convert.ToString(dr["CCF_Bak"]); if (dr["CCF_DownTime"] != DBNull.Value) cC_File.CCF_DownTime = Convert.ToString(dr["CCF_DownTime"]); if (dr["CCF_RCount"] != DBNull.Value) cC_File.CCF_RCount = Convert.ToInt32(dr["CCF_RCount"]); if (dr["CCF_RDirectory"] != DBNull.Value) cC_File.CCF_RDirectory = Convert.ToString(dr["CCF_RDirectory"]); if (dr["CCF_ROwner"] != DBNull.Value) cC_File.CCF_ROwner = Convert.ToString(dr["CCF_ROwner"]); if (dr["CCF_RDate"] != DBNull.Value) cC_File.CCF_RDate = Convert.ToDateTime(dr["CCF_RDate"]); if (dr["CCF_RBak"] != DBNull.Value) cC_File.CCF_RBak = Convert.ToString(dr["CCF_RBak"]); if (dr["Stat"] != DBNull.Value) cC_File.Stat = Convert.ToInt32(dr["Stat"]); if (dr["Creator"] != DBNull.Value) cC_File.Creator = Convert.ToDateTime(dr["Creator"]); if (dr["CreateTime"] != DBNull.Value) cC_File.CreateTime = Convert.ToDateTime(dr["CreateTime"]); if (dr["UpdateTime"] != DBNull.Value) cC_File.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]); if (dr["DeleteTime"] != DBNull.Value) cC_File.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]); ret.Add(cC_File); } } catch (System.Exception ex) { throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return ret; }
/// <summary> /// 文档删除 /// </summary> /// <param name="file"></param> /// <returns></returns> public bool DeleteDocument(CC_File file) { file.Stat = 1; if (fileInstance.Update(file) > 0) { return true; } return false; }
public bool AddCCFile(CC_File model) { model.CreateTime = DateTime.Now; model.UpdateTime = DateTime.Now; return CCFileInsert(model); }
/// <summary> /// 更新CC_File对象(即:一条记录 /// </summary> public int Update(CC_File cC_File) { StringBuilder sbParameter=new StringBuilder(); StringBuilder sb=new StringBuilder(); sb.Append(@"UPDATE CC_File SET "); if(cC_File.CCF_Code_IsChanged){sbParameter.Append("CCF_Code=@CCF_Code, ");} if(cC_File.CCF_DCode_IsChanged){sbParameter.Append("CCF_DCode=@CCF_DCode, ");} if(cC_File.CCF_CompNo_IsChanged){sbParameter.Append("CCF_CompNo=@CCF_CompNo, ");} if(cC_File.CCF_Name_IsChanged){sbParameter.Append("CCF_Name=@CCF_Name, ");} if(cC_File.CCF_iType_IsChanged){sbParameter.Append("CCF_iType=@CCF_iType, ");} if(cC_File.CCF_Directory_IsChanged){sbParameter.Append("CCF_Directory=@CCF_Directory, ");} if(cC_File.CCF_Bak_IsChanged){sbParameter.Append("CCF_Bak=@CCF_Bak, ");} if(cC_File.CCF_DownTime_IsChanged){sbParameter.Append("CCF_DownTime=@CCF_DownTime, ");} if(cC_File.CCF_RCount_IsChanged){sbParameter.Append("CCF_RCount=@CCF_RCount, ");} if(cC_File.CCF_RDirectory_IsChanged){sbParameter.Append("CCF_RDirectory=@CCF_RDirectory, ");} if(cC_File.CCF_ROwner_IsChanged){sbParameter.Append("CCF_ROwner=@CCF_ROwner, ");} if(cC_File.CCF_RDate_IsChanged){sbParameter.Append("CCF_RDate=@CCF_RDate, ");} if(cC_File.CCF_RBak_IsChanged){sbParameter.Append("CCF_RBak=@CCF_RBak, ");} if(cC_File.Stat_IsChanged){sbParameter.Append("Stat=@Stat, ");} if(cC_File.Creator_IsChanged){sbParameter.Append("Creator=@Creator, ");} if(cC_File.CreateTime_IsChanged){sbParameter.Append("CreateTime=@CreateTime, ");} if(cC_File.UpdateTime_IsChanged){sbParameter.Append("UpdateTime=@UpdateTime, ");} if(cC_File.DeleteTime_IsChanged){sbParameter.Append("DeleteTime=@DeleteTime ");} sb.Append(sbParameter.ToString().Trim().TrimEnd(',')); sb.Append( " WHERE 1=1 AND ((Stat is null) or (Stat=0)) and CCF_ID=@CCF_ID; " ); string sql=sb.ToString(); if(cC_File.CCF_Code_IsChanged) { if (string.IsNullOrEmpty(cC_File.CCF_Code)) { idb.AddParameter("@CCF_Code", DBNull.Value); } else { idb.AddParameter("@CCF_Code", cC_File.CCF_Code); } } if(cC_File.CCF_DCode_IsChanged) { if (string.IsNullOrEmpty(cC_File.CCF_DCode)) { idb.AddParameter("@CCF_DCode", DBNull.Value); } else { idb.AddParameter("@CCF_DCode", cC_File.CCF_DCode); } } if(cC_File.CCF_CompNo_IsChanged) { if (string.IsNullOrEmpty(cC_File.CCF_CompNo)) { idb.AddParameter("@CCF_CompNo", DBNull.Value); } else { idb.AddParameter("@CCF_CompNo", cC_File.CCF_CompNo); } } if(cC_File.CCF_Name_IsChanged) { if (string.IsNullOrEmpty(cC_File.CCF_Name)) { idb.AddParameter("@CCF_Name", DBNull.Value); } else { idb.AddParameter("@CCF_Name", cC_File.CCF_Name); } } if(cC_File.CCF_iType_IsChanged) { if (string.IsNullOrEmpty(cC_File.CCF_iType)) { idb.AddParameter("@CCF_iType", DBNull.Value); } else { idb.AddParameter("@CCF_iType", cC_File.CCF_iType); } } if(cC_File.CCF_Directory_IsChanged) { if (string.IsNullOrEmpty(cC_File.CCF_Directory)) { idb.AddParameter("@CCF_Directory", DBNull.Value); } else { idb.AddParameter("@CCF_Directory", cC_File.CCF_Directory); } } if(cC_File.CCF_Bak_IsChanged) { if (string.IsNullOrEmpty(cC_File.CCF_Bak)) { idb.AddParameter("@CCF_Bak", DBNull.Value); } else { idb.AddParameter("@CCF_Bak", cC_File.CCF_Bak); } } if(cC_File.CCF_DownTime_IsChanged) { if (string.IsNullOrEmpty(cC_File.CCF_DownTime)) { idb.AddParameter("@CCF_DownTime", DBNull.Value); } else { idb.AddParameter("@CCF_DownTime", cC_File.CCF_DownTime); } } if(cC_File.CCF_RCount_IsChanged) { if (cC_File.CCF_RCount == 0) { idb.AddParameter("@CCF_RCount", 0); } else { idb.AddParameter("@CCF_RCount", cC_File.CCF_RCount); } } if(cC_File.CCF_RDirectory_IsChanged) { if (string.IsNullOrEmpty(cC_File.CCF_RDirectory)) { idb.AddParameter("@CCF_RDirectory", DBNull.Value); } else { idb.AddParameter("@CCF_RDirectory", cC_File.CCF_RDirectory); } } if(cC_File.CCF_ROwner_IsChanged) { if (string.IsNullOrEmpty(cC_File.CCF_ROwner)) { idb.AddParameter("@CCF_ROwner", DBNull.Value); } else { idb.AddParameter("@CCF_ROwner", cC_File.CCF_ROwner); } } if(cC_File.CCF_RDate_IsChanged) { if (cC_File.CCF_RDate == DateTime.MinValue) { idb.AddParameter("@CCF_RDate", DBNull.Value); } else { idb.AddParameter("@CCF_RDate", cC_File.CCF_RDate); } } if(cC_File.CCF_RBak_IsChanged) { if (string.IsNullOrEmpty(cC_File.CCF_RBak)) { idb.AddParameter("@CCF_RBak", DBNull.Value); } else { idb.AddParameter("@CCF_RBak", cC_File.CCF_RBak); } } if(cC_File.Stat_IsChanged) { if (cC_File.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", cC_File.Stat); } } if(cC_File.Creator_IsChanged) { if (cC_File.Creator == DateTime.MinValue) { idb.AddParameter("@Creator", DBNull.Value); } else { idb.AddParameter("@Creator", cC_File.Creator); } } if(cC_File.CreateTime_IsChanged) { if (cC_File.CreateTime == DateTime.MinValue) { idb.AddParameter("@CreateTime", DBNull.Value); } else { idb.AddParameter("@CreateTime", cC_File.CreateTime); } } if(cC_File.UpdateTime_IsChanged) { if (cC_File.UpdateTime == DateTime.MinValue) { idb.AddParameter("@UpdateTime", DBNull.Value); } else { idb.AddParameter("@UpdateTime", cC_File.UpdateTime); } } if(cC_File.DeleteTime_IsChanged) { if (cC_File.DeleteTime == DateTime.MinValue) { idb.AddParameter("@DeleteTime", DBNull.Value); } else { idb.AddParameter("@DeleteTime", cC_File.DeleteTime); } } idb.AddParameter("@CCF_ID", cC_File.CCF_ID); int Re = 0; //SQL日志记录 var RunMethod = System.Reflection.MethodBase.GetCurrentMethod(); System.Collections.Hashtable param = new System.Collections.Hashtable(); string Ex = string.Empty; foreach (System.Collections.DictionaryEntry item in idb.GetParameters()) { param.Add(item.Key, item.Value); } try { Re = idb.ExeCmd(sql); Ex = Re.ToString(); } catch (Exception ex) { Ex = ex.Message; } finally { SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType +"." + RunMethod.Name,Ex); } return Re;
public bool UpdateCCFile(CC_File model) { //model.CreateTime = DateTime.Now; model.UpdateTime = DateTime.Now; return CCFileUpdate(model); }
/// <summary> /// 添加CC_File对象(即:一条记录) /// </summary> public int Add(CC_File cC_File) { string sql = "INSERT INTO CC_File (CCF_Code,CCF_DCode,CCF_CompNo,CCF_Name,CCF_iType,CCF_Directory,CCF_Bak,CCF_DownTime,CCF_RCount,CCF_RDirectory,CCF_ROwner,CCF_RDate,CCF_RBak,Stat,Creator,CreateTime,UpdateTime,DeleteTime) VALUES (@CCF_Code,@CCF_DCode,@CCF_CompNo,@CCF_Name,@CCF_iType,@CCF_Directory,@CCF_Bak,@CCF_DownTime,@CCF_RCount,@CCF_RDirectory,@CCF_ROwner,@CCF_RDate,@CCF_RBak,@Stat,@Creator,@CreateTime,@UpdateTime,@DeleteTime)"; if (string.IsNullOrEmpty(cC_File.CCF_Code)) { idb.AddParameter("@CCF_Code", DBNull.Value); } else { idb.AddParameter("@CCF_Code", cC_File.CCF_Code); } if (string.IsNullOrEmpty(cC_File.CCF_DCode)) { idb.AddParameter("@CCF_DCode", DBNull.Value); } else { idb.AddParameter("@CCF_DCode", cC_File.CCF_DCode); } if (string.IsNullOrEmpty(cC_File.CCF_CompNo)) { idb.AddParameter("@CCF_CompNo", DBNull.Value); } else { idb.AddParameter("@CCF_CompNo", cC_File.CCF_CompNo); } if (string.IsNullOrEmpty(cC_File.CCF_Name)) { idb.AddParameter("@CCF_Name", DBNull.Value); } else { idb.AddParameter("@CCF_Name", cC_File.CCF_Name); } if (string.IsNullOrEmpty(cC_File.CCF_iType)) { idb.AddParameter("@CCF_iType", DBNull.Value); } else { idb.AddParameter("@CCF_iType", cC_File.CCF_iType); } if (string.IsNullOrEmpty(cC_File.CCF_Directory)) { idb.AddParameter("@CCF_Directory", DBNull.Value); } else { idb.AddParameter("@CCF_Directory", cC_File.CCF_Directory); } if (string.IsNullOrEmpty(cC_File.CCF_Bak)) { idb.AddParameter("@CCF_Bak", DBNull.Value); } else { idb.AddParameter("@CCF_Bak", cC_File.CCF_Bak); } if (string.IsNullOrEmpty(cC_File.CCF_DownTime)) { idb.AddParameter("@CCF_DownTime", DBNull.Value); } else { idb.AddParameter("@CCF_DownTime", cC_File.CCF_DownTime); } if (cC_File.CCF_RCount == 0) { idb.AddParameter("@CCF_RCount", 0); } else { idb.AddParameter("@CCF_RCount", cC_File.CCF_RCount); } if (string.IsNullOrEmpty(cC_File.CCF_RDirectory)) { idb.AddParameter("@CCF_RDirectory", DBNull.Value); } else { idb.AddParameter("@CCF_RDirectory", cC_File.CCF_RDirectory); } if (string.IsNullOrEmpty(cC_File.CCF_ROwner)) { idb.AddParameter("@CCF_ROwner", DBNull.Value); } else { idb.AddParameter("@CCF_ROwner", cC_File.CCF_ROwner); } if (cC_File.CCF_RDate == DateTime.MinValue) { idb.AddParameter("@CCF_RDate", DBNull.Value); } else { idb.AddParameter("@CCF_RDate", cC_File.CCF_RDate); } if (string.IsNullOrEmpty(cC_File.CCF_RBak)) { idb.AddParameter("@CCF_RBak", DBNull.Value); } else { idb.AddParameter("@CCF_RBak", cC_File.CCF_RBak); } if (cC_File.Stat == 0) { idb.AddParameter("@Stat", 0); } else { idb.AddParameter("@Stat", cC_File.Stat); } if (cC_File.Creator == DateTime.MinValue) { idb.AddParameter("@Creator", DBNull.Value); } else { idb.AddParameter("@Creator", cC_File.Creator); } if (cC_File.CreateTime == DateTime.MinValue) { idb.AddParameter("@CreateTime", DBNull.Value); } else { idb.AddParameter("@CreateTime", cC_File.CreateTime); } if (cC_File.UpdateTime == DateTime.MinValue) { idb.AddParameter("@UpdateTime", DBNull.Value); } else { idb.AddParameter("@UpdateTime", cC_File.UpdateTime); } if (cC_File.DeleteTime == DateTime.MinValue) { idb.AddParameter("@DeleteTime", DBNull.Value); } else { idb.AddParameter("@DeleteTime", cC_File.DeleteTime); } int Re = 0; //SQL日志记录 var RunMethod = System.Reflection.MethodBase.GetCurrentMethod(); System.Collections.Hashtable param = new System.Collections.Hashtable(); string Ex = string.Empty; foreach (System.Collections.DictionaryEntry item in idb.GetParameters()) { param.Add(item.Key, item.Value); } try { Re = idb.ExeCmd(sql); Ex = Re.ToString(); } catch (Exception ex) { Ex = ex.Message; } finally { SysRunLog.InsertRunSql(sql, param, RunMethod.DeclaringType +"." + RunMethod.Name,Ex); } return Re; }
/// <summary> /// 获取指定的CC_File对象(即:一条记录 /// </summary> public CC_File GetByKey(decimal cCF_ID) { CC_File cC_File = new CC_File(); string sql = "SELECT CCF_ID,CCF_Code,CCF_DCode,CCF_CompNo,CCF_Name,CCF_iType,CCF_Directory,CCF_Bak,CCF_DownTime,CCF_RCount,CCF_RDirectory,CCF_ROwner,CCF_RDate,CCF_RBak,Stat,Creator,CreateTime,UpdateTime,DeleteTime FROM CC_File WHERE 1=1 AND ((Stat is null) or (Stat=0) ) AND CCF_ID=@CCF_ID "; idb.AddParameter("@CCF_ID", cCF_ID); SqlDataReader dr=null; try { dr=(SqlDataReader)idb.ReturnReader(sql); while(dr.Read()) { if (dr["CCF_ID"] != DBNull.Value) cC_File.CCF_ID = Convert.ToDecimal(dr["CCF_ID"]); if (dr["CCF_Code"] != DBNull.Value) cC_File.CCF_Code = Convert.ToString(dr["CCF_Code"]); if (dr["CCF_DCode"] != DBNull.Value) cC_File.CCF_DCode = Convert.ToString(dr["CCF_DCode"]); if (dr["CCF_CompNo"] != DBNull.Value) cC_File.CCF_CompNo = Convert.ToString(dr["CCF_CompNo"]); if (dr["CCF_Name"] != DBNull.Value) cC_File.CCF_Name = Convert.ToString(dr["CCF_Name"]); if (dr["CCF_iType"] != DBNull.Value) cC_File.CCF_iType = Convert.ToString(dr["CCF_iType"]); if (dr["CCF_Directory"] != DBNull.Value) cC_File.CCF_Directory = Convert.ToString(dr["CCF_Directory"]); if (dr["CCF_Bak"] != DBNull.Value) cC_File.CCF_Bak = Convert.ToString(dr["CCF_Bak"]); if (dr["CCF_DownTime"] != DBNull.Value) cC_File.CCF_DownTime = Convert.ToString(dr["CCF_DownTime"]); if (dr["CCF_RCount"] != DBNull.Value) cC_File.CCF_RCount = Convert.ToInt32(dr["CCF_RCount"]); if (dr["CCF_RDirectory"] != DBNull.Value) cC_File.CCF_RDirectory = Convert.ToString(dr["CCF_RDirectory"]); if (dr["CCF_ROwner"] != DBNull.Value) cC_File.CCF_ROwner = Convert.ToString(dr["CCF_ROwner"]); if (dr["CCF_RDate"] != DBNull.Value) cC_File.CCF_RDate = Convert.ToDateTime(dr["CCF_RDate"]); if (dr["CCF_RBak"] != DBNull.Value) cC_File.CCF_RBak = Convert.ToString(dr["CCF_RBak"]); if (dr["Stat"] != DBNull.Value) cC_File.Stat = Convert.ToInt32(dr["Stat"]); if (dr["Creator"] != DBNull.Value) cC_File.Creator = Convert.ToDateTime(dr["Creator"]); if (dr["CreateTime"] != DBNull.Value) cC_File.CreateTime = Convert.ToDateTime(dr["CreateTime"]); if (dr["UpdateTime"] != DBNull.Value) cC_File.UpdateTime = Convert.ToDateTime(dr["UpdateTime"]); if (dr["DeleteTime"] != DBNull.Value) cC_File.DeleteTime = Convert.ToDateTime(dr["DeleteTime"]); } }catch (System.Exception ex){ throw ex; } finally { if (dr != null) { dr.Close(); } if (idb.GetConnection() != null && idb.GetConnection().State == ConnectionState.Open) { idb.GetConnection().Close(); } } return cC_File; }
/// <summary> /// /// </summary> /// <param name="cc">当前文档</param> public void SaveRefPath(CC_File cc) { Bll_File fileInstance = new Bll_File(); //如果存在该文档 if (RefCompList.Keys.Contains(cc.CCF_DCode)) { var compList = RefCompList[cc.CCF_DCode]; foreach (var comp in compList) { string lastpath = GlabolConfiguration.SeverPath + "\\" + comp.PRDC_CompNo; if (!Directory.Exists(lastpath)) { try { Directory.CreateDirectory(lastpath); } catch (Exception ex) { //写入数据库日志 PlateLog.WriteError(SessionConfig.UserID, SessionConfig.UserName, "", "CompManage 多零件同步", ex.Message, PlateLog.LogMessageType.Error, ex); } } //fileInstance.ftp.GotoDirectory("."); //if (!fileInstance.ftp.DirectoryExist(comp.PRDC_CompNo)) //{ // fileInstance.ftp.MakeDirectory(comp.PRDC_CompNo); //} //fileInstance.ftp.GotoDirectory("." + Path.GetDirectoryName(cc.CCF_Directory)); //var flag = fileInstance.ftp.CopyFileToAnotherDirectoryOverWrite(Path.GetFileName(cc.CCF_Directory), "./" + comp.PRDC_CompNo); File.Copy(GlabolConfiguration.SeverPath + cc.CCF_Directory.Replace('/', '\\'), lastpath + "\\" + cc.CCF_Name + ".pdf"); } } }
public void StartScan(string filename, string dcode) { //ScanHelperXP scan = new ScanHelperXP(); CC_File file; PDFHelper pdf = new PDFHelper(); bool flag = true; var list = new List<Image>(); try { if (comboStat.SelectedValue != null && comboStat.SelectedValue.ToString() == "Duplex") { list = scan.StartScan(1); } else { list = scan.StartScan(); } //Image img = Image.FromFile("D:\\test.png"); //list.Add(img); //Image img2 = Image.FromFile("D:\\2.bmp"); //list.Add(img2); //Image img3 = Image.FromFile("D:\\2.bmp"); //list.Add(img3); //Image img4 = Image.FromFile("D:\\2.bmp"); //list.Add(img4); //Image img5 = Image.FromFile("D:\\2.bmp"); //list.Add(img5); } catch (Exception ex) { //如果发生异常则之后则后面则不再提示信息 flag = false; Alert.Show(ex.Message); } if (list != null && list.Count != 0) { var templist = list.ToList(); string path = LocalPath + "\\" + filename + ".pdf"; MethodInvoker mi = delegate { try { pdf.MakePDF(path, templist); } catch (Exception ex) { //Alert.Show("生成文档失败"); } //Alert.Show("文档生成成功!"); file = new CC_File(); file.CCF_DCode = dcode; file.CCF_Name = filename; file.CCF_Directory = path; list = null; CCFileList.Add(file); SaveDictionary(); SavePath(); Alert.Show("文档生成成功!"); }; mi.BeginInvoke(null, null); } else { if (flag) { Alert.Show("未找到可扫描文件请确认扫描仪是否可用!"); } } }
/// <summary> /// 零件文档扫描 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void scanBtn_Click(object sender, EventArgs e) { UltraGridRow row = this.comGrid.ActiveRow; if (row == null) { return; } Prod_Doc doc = row.ListObject as Prod_Doc; if (string.IsNullOrEmpty(doc.PRDQ_Code)) { Alert.Show("请先填写报告编号!"); return; } if (doc.PRDQ_IsScan == 1 && !row.IsAddRow) { ConfirmWin confirmWin = new ConfirmWin(); confirmWin.ShowDialog(); if (!confirmWin.IsAllow) { Alert.Show("当前文档已扫描,不能进行重复扫描覆盖操作!"); return; } } string dcode = doc.PRDQ_Code; string compNo = string.Empty; if (compNoEditor != null) { compNo = compNoEditor.Text; } string filename = compNo + "_" + dcode + "_" + DateTime.Now.ToString("yyyy-MM-dd"); CC_File file = new CC_File(); try { //file =StartScan(filename, dcode); StartScan(filename, dcode); row.Appearance.BackColor = Color.Wheat; doc.PRDQ_IsScan = 1; } catch (Exception ex) { Alert.Show(ex.Message); } //if (file != null) //{ // //if (doc.PRDQ_ID != 0) // //{ // // file.Stat = 0; // //} // //CCFileList.Add(file); //} }
/// <summary> /// 零件文档扫描 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void scanBtn_Click(object sender, EventArgs e) { UltraGridRow row = this.prodDocGrid.ActiveRow; if (row == null) { return; } Prod_Doc doc = row.ListObject as Prod_Doc; if (string.IsNullOrEmpty(doc.PRDQ_Code)) { Alert.Show("请先填写报告编号!"); return; } if (doc.PRDQ_IsScan == 1) { ConfirmWin confirmWin = new ConfirmWin(); confirmWin.ShowDialog(); if (!confirmWin.IsAllow) { Alert.Show("当前文档已扫描,不能进行重复扫描覆盖操作!"); return; } } string dcode = doc.PRDQ_Code; //string filename = GModel.PRM_Code + "_" + dcode + "_" + DateTime.Now.ToString("yyyy-MM-dd"); //var file = StartScan(filename, dcode); //if (file != null) //{ // if (doc.PRDQ_ID != 0) // { // file.Stat = 1; // } // CCFileList.Add(file); // Alert.Show("扫描完成!"); // row.Appearance.BackColor = Color.Wheat; // doc.PRDQ_IsScan = 1; //} var com = bmHelper.FindCtl<UltraTextEditor>(this.pnlGrid.Controls, "PRM_Code"); string prodcode = com.Text; if (string.IsNullOrEmpty(prodcode)) { Alert.Show("请输入编号!"); return; } string filename = prodcode + "_" + dcode + "_" + DateTime.Now.ToString("yyyy-MM-dd"); CC_File file = new CC_File(); try { StartScan(filename, dcode); row.Appearance.BackColor = Color.Wheat; doc.PRDQ_IsScan = 1; } catch (Exception ex) { Alert.Show(ex.Message); } }
//public CC_File StartScan(string filename, string dcode) //{ // ScanHelper scan = new ScanHelper(); // CC_File file; // PDFHelper pdf = new PDFHelper(); // var list = scan.StartScan(); // if (list != null && list.Count != 0) // { // pdf.MakePDF(LocalPath + filename + ".pdf", list); // file = new CC_File(); // file.CCF_DCode = dcode; // file.CCF_Name = filename; // file.CCF_iType = "Prod"; // file.CCF_Directory = LocalPath + filename + ".pdf"; // return file; // } // else // { // Alert.Show("请确认是否已把扫描文档放到Feeder"); // return null; // } //} public void StartScan(string filename, string dcode) { bool flag = true; CC_File file; PDFHelper pdf = new PDFHelper(); List<Image> list = new List<Image>(); try { list = scan.StartScan(); } catch (Exception ex) { flag = false; Alert.Show(ex.Message); } if (list != null && list.Count != 0) { var templist = list.ToList(); string path = LocalPath + "\\" + filename + ".pdf"; MethodInvoker mi = delegate { try { pdf.MakePDF(path, templist); } catch { } //AutoClosedMessageBox.Show(" 文档生成成功!", " 提示", 15, 2000); file = new CC_File(); file.CCF_DCode = dcode; file.CCF_Name = filename; file.CCF_iType = "ProdRepair"; file.CCF_Directory = path; list = null; CCFileList.Add(file); SavePath(); Alert.Show("文档生成成功!"); }; mi.BeginInvoke(null, null); //GC.Collect(); //return file; } else { if (flag) { Alert.Show("请确认是否已把扫描文档放到Feeder"); } //return null; } }
void scanRepairBtn_Click(object sender, EventArgs e) { UltraGridRow row = this.repairGrid.ActiveRow; if (row == null) { return; } Prod_Maintain doc = row.ListObject as Prod_Maintain; if (string.IsNullOrEmpty(doc.PRM_Code)) { Alert.Show("请先填写报告编号!"); return; } string dcode = doc.PRM_Code; var com = bmHelper.FindCtl<UltraTextEditor>(this.gpBse.Controls, "PRP_ProdCode"); string prodcode = string.Empty; if (com != null) { prodcode = com.Text; } if (string.IsNullOrEmpty(prodcode)) { Alert.Show("请先输入成品编号!"); return; } string filename = prodcode + "_" + dcode + "_" + DateTime.Now.ToString("yyyy-MM-dd"); CC_File file = new CC_File(); try { StartScan(filename, dcode); row.Appearance.BackColor = Color.Wheat; } catch (Exception ex) { Alert.Show(ex.Message); } }
/// <summary> /// /// </summary> /// <param name="cc">当前文档</param> public void SaveRefPath(CC_File cc) { Bll_File fileInstance = new Bll_File(); //如果存在该文档 if (RefCompList.Keys.Contains(cc.CCF_DCode)) { var compList = RefCompList[cc.CCF_DCode]; foreach (var comp in compList) { string lastpath = GlabolConfiguration.SeverPath + "\\" + comp.PRDC_CompNo; if (!Directory.Exists(lastpath)) { try { Directory.CreateDirectory(lastpath); } catch (Exception ex) { //写入数据库日志 PlateLog.WriteError(SessionConfig.UserID, SessionConfig.UserName, "", "CompManage 多零件同步", ex.Message, PlateLog.LogMessageType.Error, ex); } } File.Copy(GlabolConfiguration.SeverPath + cc.CCF_Directory.Replace('/', '\\'), lastpath + "\\" + cc.CCF_Name + ".pdf"); } } }