/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_FlowNodeTask> getTbl_FlowNodeTasksBySql(string sql)
{
IList <Tbl_FlowNodeTask> list = new List <Tbl_FlowNodeTask>();
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_FlowNodeTask tbl_flownodetask = new Tbl_FlowNodeTask();
tbl_flownodetask.ID = Convert.ToInt32(dr["ID"]);
tbl_flownodetask.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_flownodetask.FlowNodeID = Convert.ToInt32(dr["FlowNodeID"]);
tbl_flownodetask.UserName = Convert.ToString(dr["UserName"]);
tbl_flownodetask.EndTime = Convert.ToDateTime(dr["EndTime"]);
tbl_flownodetask.FNT_Info = Convert.ToString(dr["FNT_Info"]);
tbl_flownodetask.Status = Convert.ToString(dr["Status"]);
tbl_flownodetask.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_flownodetask.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_flownodetask.DealUser = Convert.ToString(dr["DealUser"]);
tbl_flownodetask.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_flownodetask);
}
}
return(list);
}
public static int UpdateTbl_FlowNodeTask(Tbl_FlowNodeTask tbl_flownodetask)
{
WebCommon.Public.WriteLog("修改任务：" + tbl_flownodetask.ProjectID);
tbl_flownodetask.DealUser = WebCommon.Public.GetUserName();
tbl_flownodetask.DealTime = DateTime.Now;
return(new Tbl_FlowNodeTaskService().UpdateTbl_FlowNodeTaskById(tbl_flownodetask));
}
public int AddTbl_FlowNodeTask(Tbl_FlowNodeTask tbl_flownodetask)
{
string sql = "insert into [Tbl_FlowNodeTask] ([ProjectID],[FlowNodeID],[UserName],[EndTime],[FNT_Info],[Status],[DealUser]) values (@ProjectID,@FlowNodeID,@UserName,@EndTime,@FNT_Info,@Status,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ProjectID", tbl_flownodetask.ProjectID),
new SqlParameter("@FlowNodeID", tbl_flownodetask.FlowNodeID),
new SqlParameter("@UserName", tbl_flownodetask.UserName),
new SqlParameter("@EndTime", tbl_flownodetask.EndTime),
new SqlParameter("@FNT_Info", tbl_flownodetask.FNT_Info),
new SqlParameter("@Status", tbl_flownodetask.Status),
new SqlParameter("@DealUser", tbl_flownodetask.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_FlowNodeTaskById(Tbl_FlowNodeTask tbl_flownodetask)
{
string sql = "update [Tbl_FlowNodeTask] set [ProjectID]=@ProjectID,[FlowNodeID]=@FlowNodeID,[UserName]=@UserName,[EndTime]=@EndTime,[FNT_Info]=@FNT_Info,[Status]=@Status,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_flownodetask.ID),
new SqlParameter("@ProjectID", tbl_flownodetask.ProjectID),
new SqlParameter("@FlowNodeID", tbl_flownodetask.FlowNodeID),
new SqlParameter("@UserName", tbl_flownodetask.UserName),
new SqlParameter("@EndTime", tbl_flownodetask.EndTime),
new SqlParameter("@FNT_Info", tbl_flownodetask.FNT_Info),
new SqlParameter("@Status", tbl_flownodetask.Status),
new SqlParameter("@DealUser", tbl_flownodetask.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_FlowNodeTask(Tbl_FlowNodeTask tbl_flownodetask)
{
WebCommon.Public.WriteLog("添加任务：" + tbl_flownodetask.ProjectID);
return(new Tbl_FlowNodeTaskService().AddTbl_FlowNodeTask(tbl_flownodetask));
}
