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