/// <summary> /// 判断当前用户能否对数据进行维护 /// </summary> /// <param name="Guidid"></param> /// <returns></returns> public static bool IsCanEdit(String Guidid) { bool result = false; if (FrameLib.UserID == "admin") { result = true; } else { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("guidID", Guidid)); Tb_Project_LogDA da1 = new Tb_Project_LogDA(); Dictionary <String, object> dic1 = da1.GetFirstDictionary(condition, "*"); if (dic1 != null && dic1.Count > 0) { if (dic1["AddUserID"].ToString() != "admin") { String parentGuid = dic1["parentGuid"].ToString(); //项目编号 Tb_ProjectDA da2 = new Tb_ProjectDA(); condition.Clear(); condition.Add(new SearchField("prjNum", parentGuid)); dic1.Clear(); dic1 = da2.GetFirstDictionary(condition, "GuidID"); if (dic1 != null && dic1.Count > 0) { result = (new Tb_ProjectBU()).IsCanEditProject(dic1["GuidID"].ToString(), WebFrame.FrameLib.UserID); } } } } return(result); }
/// <summary> /// 功能:执行普通的SQL语句 /// </summary> public void ExcuteSql(String sql) { try { Tb_Project_LogDA da1 = new Tb_Project_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_Project_LogDA da1 = new Tb_Project_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_Project_LogDA da1 = new Tb_Project_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_Project_LogDA da1 = new Tb_Project_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_Project_LogDA da1 = new Tb_Project_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_Project_LogDA da1 = new Tb_Project_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="projectGuidid"></param> /// <returns></returns> public static int GetProjectLogCount(String projectGuidid) { int count1 = 0; List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("parentGuid", projectGuidid)); condition.Add(new SearchField("kind", "0")); Tb_Project_LogDA da1 = new Tb_Project_LogDA(); DataRow dr1 = da1.GetFirstDataRow(condition, "count(*) as count0"); if (dr1 != null) { int.TryParse(dr1[0].ToString(), out count1); } return(count1); }
/// <summary> /// 项目延期 /// </summary> /// <param name="PrjNum"></param> /// <param name="delay"></param> /// <param name="Remark"></param> /// <returns></returns> public bool DelayProjectData(String GuidID, DateTime delay, String Remark) { bool succ = false; JConnect.GetConnect().BeginTrans(); try { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("GuidID", GuidID)); condition.Add(new SearchField("Status", "1", SearchFieldType.NumericType)); //1--更改项目状态 Tb_ProjectDA da1 = new Tb_ProjectDA(); if (da1.HasData(condition)) { Dictionary <String, object> dic1 = new Dictionary <string, object>(); //dic1["Status"] = "3"; dic1["endDate"] = delay; da1.EditData(condition, dic1); //2--新增项目日志 dic1.Clear(); dic1["guidid"] = WebFrame.Util.JString.GetUnique32ID(); dic1["parentGuid"] = GuidID; dic1["Stitle"] = "项目延期"; dic1["Content"] = "项目延期至" + delay.ToString("yyyy-MM-dd") + " 延期说明:" + Remark; dic1["AddTime"] = DateTime.Now; dic1["AddUserID"] = FrameLib.UserID; dic1["AddUserName"] = FrameLib.UserName; dic1["Content"] = Remark; dic1["kind"] = "0"; Tb_Project_LogDA da2 = new Tb_Project_LogDA(); da2.NewData(dic1); succ = true; } JConnect.GetConnect().CommitTrans(); } catch (Exception err) { JConnect.GetConnect().RollBackTrans(); WebFrame.Util.JTool.WriteErrorLog(err.ToString()); } return(succ); }
/// <summary> /// 将项目标记为重新返工 /// </summary> /// <param name="GuidID"></param> /// <param name="Remark"></param> /// <returns></returns> public bool ReturnWorkProject(String GuidID, String Remark) { bool succ = false; JConnect.GetConnect().BeginTrans(); try { List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("GuidID", GuidID)); condition.Add(new SearchField("Status=3 or Status=2", "", SearchOperator.UserDefine)); //1--更改项目状态 Tb_ProjectDA da1 = new Tb_ProjectDA(); if (da1.HasData(condition)) { Dictionary <String, object> dic1 = new Dictionary <string, object>(); dic1["Status"] = "1"; dic1["FinishDate"] = DateTime.Now; da1.EditData(condition, dic1); //2--新增项目日志 dic1.Clear(); dic1["guidid"] = WebFrame.Util.JString.GetUnique32ID(); dic1["parentGuid"] = GuidID; dic1["Stitle"] = "项目返工"; dic1["AddTime"] = DateTime.Now; dic1["AddUserID"] = FrameLib.UserID; dic1["AddUserName"] = FrameLib.UserName; dic1["Content"] = Remark; dic1["kind"] = "0"; Tb_Project_LogDA da2 = new Tb_Project_LogDA(); da2.NewData(dic1); succ = true; } JConnect.GetConnect().CommitTrans(); } catch (Exception err) { JConnect.GetConnect().RollBackTrans(); WebFrame.Util.JTool.WriteErrorLog(err.ToString()); } return(succ); }
/// <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_Project_LogDA da1 = new Tb_Project_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); }
/// <summary> /// 得到项目的最新日志信息 /// </summary> /// <param name="ProjectGuid"></param> /// <returns></returns> public static String GetProjectLastLogInfo(String ProjectGuid) { String result = String.Empty; Tb_Project_LogDA da1 = new Tb_Project_LogDA(); List <SearchField> condition = new List <SearchField>(); condition.Add(new SearchField("parentGuid", ProjectGuid)); DataTable dt1 = da1.GetListData(condition, 1, 1, "AddTime desc", "Stitle"); if (dt1 != null && dt1.Rows.Count > 0) { result = dt1.Rows[0][0].ToString(); } if (String.IsNullOrEmpty(result)) { result = "暂无日志"; } return(result); }