/// <summary> /// 删除派工单,同时删除其中包含的附件 /// 上传派工单的日志和日志包含的附件 /// </summary> /// <param name="guidid"></param> /// <returns></returns> public bool DeleteData(String guidid) { bool succ = false; JConnect.GetConnect().BeginTrans(); try { //1--删除派工单 List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("Guidid", guidid)); Tb_TaskDA da1 = new Tb_TaskDA(); DataRow dr1 = da1.GetFirstDataRow(condition, "*"); if (dr1 != null) { //删除相关附件 String filename1 = dr1["RelaFile"].ToString(); if (String.IsNullOrEmpty(filename1) == false) { filename1 = System.Web.HttpContext.Current.Server.MapPath(filename1); if (File.Exists(filename1)) { File.Delete(filename1); } } //删除数据 da1.DeleteData(condition); } //2--删除派工单的日志 condition.Clear(); condition.Add(new SearchField("parentGuid", guidid)); Tb_Task_LogDA da2 = new Tb_Task_LogDA(); DataTable dt1 = da2.GetListData(condition, -1, -1, "", "*"); foreach (DataRow dr0 in dt1.Rows) { String filename1 = dr0["RelateFile"].ToString(); if (String.IsNullOrEmpty(filename1) == false) { filename1 = System.Web.HttpContext.Current.Server.MapPath(filename1); if (File.Exists(filename1)) { File.Delete(filename1); } } } da2.DeleteData(condition); JConnect.GetConnect().CommitTrans(); succ = true; } catch (Exception err) { JConnect.GetConnect().RollBackTrans(); WebFrame.Util.JTool.WriteErrorLog(err.ToString()); } return(succ); }
public int NewLog(String ProjectGuidID, String Stitle, String Content, String Kind, System.Web.UI.WebControls.FileUpload f1, ref String RelateFile, ref String RelaTrueName) { int succ = 0; String FileDir = "/Attachment/UseAttachment/"; String truename1 = String.Empty; bool saveFile = false; try { Dictionary <String, object> dic1 = new Dictionary <string, object>(); dic1["guidID"] = WebFrame.Util.JString.GetUnique32ID(); dic1["parentGuid"] = ProjectGuidID; dic1["Stitle"] = Stitle; if (String.IsNullOrEmpty(Content) == false) { dic1["Content"] = (new StringBuilder()).Append(Content); } dic1["AddTime"] = DateTime.Now; dic1["AddUserID"] = WebFrame.FrameLib.UserID; dic1["AddUserNet"] = WebFrame.FrameLib.UserName; dic1["kind"] = Kind; if (f1 != null && f1.HasFile) { String ext1 = Path.GetExtension(f1.FileName); truename1 = WebFrame.Util.JString.GetUnique32ID() + ext1; f1.SaveAs(System.Web.HttpContext.Current.Server.MapPath(FileDir + truename1)); dic1["RelateFile"] = FileDir + truename1; dic1["RelaTrueName"] = Path.GetFileName(f1.FileName); //文件名和文件路径 RelateFile = dic1["RelateFile"].ToString(); RelaTrueName = dic1["RelaTrueName"].ToString(); saveFile = true; } Tb_Task_LogDA da1 = new Tb_Task_LogDA(); da1.NewData(dic1); succ = 1; } catch (Exception err) { //删除已上传的文件 if (saveFile && File.Exists(System.Web.HttpContext.Current.Server.MapPath(FileDir + truename1))) { File.Delete(System.Web.HttpContext.Current.Server.MapPath(FileDir + truename1)); } throw err; } return(succ); }
/// <summary> /// 功能:执行普通的SQL语句 /// </summary> public void ExcuteSql(String sql) { try { Tb_Task_LogDA da1 = new Tb_Task_LogDA(); da1.ExcuteSql(sql); } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } }
/// <summary> /// 根据条件,修改一个数据 /// </summary> /// <param name="condition">修改数据的条件</param> /// <param name="data1">新的数据</param> public void EditData(List <SearchField> condition, Dictionary <String, object> data1) { try { Tb_Task_LogDA da1 = new Tb_Task_LogDA(); da1.EditData(condition, data1); this.executeResultCount = da1.ExecuteResultCount; } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } }
/// <summary> /// 根据条件删除数据 /// </summary> /// <param name="condition">删除数据条件</param> public void DeleteData(List <SearchField> condition) { try { Tb_Task_LogDA da1 = new Tb_Task_LogDA(); da1.DeleteData(condition); this.executeResultCount = da1.ExecuteResultCount; } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } }
/// <summary> /// 新增一条数据 /// </summary> /// <param name="data1">Dictionary数据</param> public void NewData(Dictionary <String, object> data1) { try { Tb_Task_LogDA da1 = new Tb_Task_LogDA(); da1.NewData(data1); this.executeResultCount = da1.ExecuteResultCount; } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } }
/// <summary> /// 判断是否有符合条件的数据 /// </summary> ///<param name="condition">查询条件</param> /// <returns></returns> public bool HasData(List <SearchField> condition) { bool result = false; try { Tb_Task_LogDA da1 = new Tb_Task_LogDA(); result = da1.HasData(condition); } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } return(result); }
/// <summary> /// 得到满足条件的第一行数据(返回值为Dictionary) /// </summary> /// <param name="condition">查询条件</param> /// <param name="Fields">数据字段</param> /// <returns>Dictionary字典</returns> public Dictionary <string, object> GetFirstDictionary(List <SearchField> condition, params String[] Fields) { Dictionary <string, object> data1 = null; try { Tb_Task_LogDA da1 = new Tb_Task_LogDA(); data1 = da1.GetFirstDictionary(condition, Fields); this.executeResultCount = da1.ExecuteResultCount; } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } return(data1); }
/// <summary> /// 得到日志的数量 /// </summary> /// <param name="ParentGuidid"></param> /// <returns></returns> public static int GetLogCount(String ParentGuidid) { int result = 0; if (String.IsNullOrEmpty(ParentGuidid) == false) { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("TaskID", ParentGuidid)); Tb_Task_LogDA da1 = new Tb_Task_LogDA(); DataRow dr1 = da1.GetFirstDataRow(condition, "count(*) as count0"); if (dr1 != null) { result = int.Parse(dr1[0].ToString()); } } return(result); }
/// <summary> /// 根据条件得到列表数据 /// </summary> /// <param name="condition">查询条件</param> /// <param name="PageSize">页大小</param> /// <param name="CurPage">当前页</param> /// <param name="Fields">数据字段</param> /// <param name="orderBy">排序表达式</param> /// <param name="TotalRow">数据总行数</param> /// <param name="Fields">要显示的字段</param> /// <returns>列表数据</returns> public DataTable GetListData(List <SearchField> condition, int PageSize, int CurPage, String orderBy, out int TotalRow, params String[] Fields) { TotalRow = 0; DataTable dt1 = null; try { Tb_Task_LogDA da1 = new Tb_Task_LogDA(); dt1 = da1.GetListData(condition, PageSize, CurPage, orderBy, out TotalRow, Fields); this.executeResultCount = da1.ExecuteResultCount; return(dt1); } catch (Exception err) { this.ErrorInfo = err.Message.Replace("\r", "").Replace("\t", "").Replace("\n", ""); } return(dt1); }