/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_FlowWorkLog> getTbl_FlowWorkLogsBySql(string sql)
{
IList <Tbl_FlowWorkLog> list = new List <Tbl_FlowWorkLog>();
DataSet ds = DBHelper.ExecuteDataset(this.connection, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
Tbl_FlowWorkLog tbl_FlowWorkLog = new Tbl_FlowWorkLog();
tbl_FlowWorkLog.ID = Convert.ToInt32(dr["ID"]);
tbl_FlowWorkLog.UserName = Convert.ToString(dr["UserName"]);
tbl_FlowWorkLog.LogType = Convert.ToString(dr["LogType"]);
tbl_FlowWorkLog.ParentID = Convert.ToInt32(dr["ParentID"]);
tbl_FlowWorkLog.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_FlowWorkLog.FlowID = Convert.ToInt32(dr["FlowID"]);
tbl_FlowWorkLog.FlowWorkID = Convert.ToInt32(dr["FlowWorkID"]);
tbl_FlowWorkLog.FlowNodeID = Convert.ToInt32(dr["FlowNodeID"]);
tbl_FlowWorkLog.FileLog = Convert.ToString(dr["FileLog"]);
tbl_FlowWorkLog.Remark = Convert.ToString(dr["Remark"]);
tbl_FlowWorkLog.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_FlowWorkLog.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_FlowWorkLog.DealUser = Convert.ToString(dr["DealUser"]);
tbl_FlowWorkLog.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_FlowWorkLog);
}
}
return(list);
}
public static int UpdateTbl_FlowWorkLog(Tbl_FlowWorkLog tbl_FlowWorkLog)
{
WebCommon.Public.WriteLog("修改设计文件：" + tbl_FlowWorkLog.ProjectID);
tbl_FlowWorkLog.DealUser = WebCommon.Public.GetUserName();
tbl_FlowWorkLog.DealTime = DateTime.Now;
return(new Tbl_FlowWorkLogService().UpdateTbl_FlowWorkLogById(tbl_FlowWorkLog));
}
public int UpdateTbl_FlowWorkLogById(Tbl_FlowWorkLog tbl_FlowWorkLog)
{
string sql = "update [Tbl_FlowWorkLog] set [UserName]=@UserName,[LogType]=@LogType,[ProjectID]=@ProjectID,[FlowID]=@FlowID,[FlowWorkID]=@FlowWorkID,[FlowNodeID]=@FlowNodeID,[FileLog]=@FileLog,[Remark]=@Remark,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_FlowWorkLog.ID),
new SqlParameter("@LogType", tbl_FlowWorkLog.LogType),
new SqlParameter("@UserName", tbl_FlowWorkLog.UserName),
new SqlParameter("@ProjectID", tbl_FlowWorkLog.ProjectID),
new SqlParameter("@FlowID", tbl_FlowWorkLog.FlowID),
new SqlParameter("@FlowWorkID", tbl_FlowWorkLog.FlowWorkID),
new SqlParameter("@FlowNodeID", tbl_FlowWorkLog.FlowNodeID),
new SqlParameter("@FileLog", tbl_FlowWorkLog.FileLog),
new SqlParameter("@Remark", tbl_FlowWorkLog.Remark),
new SqlParameter("@DealUser", tbl_FlowWorkLog.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int AddTbl_FlowWorkLog(Tbl_FlowWorkLog tbl_FlowWorkLog)
{
string sql = "insert into [Tbl_FlowWorkLog] ([UserName],[LogType],[ParentID],[ProjectID],[FlowID],[FlowWorkID],[FlowNodeID],[FileLog],[Remark],[DealUser]) values (@UserName,@LogType,@ParentID,@ProjectID,@FlowID,@FlowWorkID,@FlowNodeID,@FileLog,@Remark,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@UserName", tbl_FlowWorkLog.UserName),
new SqlParameter("@LogType", tbl_FlowWorkLog.LogType),
new SqlParameter("@ParentID", tbl_FlowWorkLog.ParentID),
new SqlParameter("@ProjectID", tbl_FlowWorkLog.ProjectID),
new SqlParameter("@FlowID", tbl_FlowWorkLog.FlowID),
new SqlParameter("@FlowWorkID", tbl_FlowWorkLog.FlowWorkID),
new SqlParameter("@FlowNodeID", tbl_FlowWorkLog.FlowNodeID),
new SqlParameter("@FileLog", tbl_FlowWorkLog.FileLog),
new SqlParameter("@Remark", tbl_FlowWorkLog.Remark),
new SqlParameter("@DealUser", tbl_FlowWorkLog.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_FlowWorkLog(Tbl_FlowWorkLog tbl_FlowWorkLog)
{
WebCommon.Public.WriteLog("添加设计文件：" + tbl_FlowWorkLog.ProjectID);
return(new Tbl_FlowWorkLogService().AddTbl_FlowWorkLog(tbl_FlowWorkLog));
}