/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_FlowWork> getTbl_FlowWorksBySql(string sql)
{
IList <Tbl_FlowWork> list = new List <Tbl_FlowWork>();
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_FlowWork tbl_flow = new Tbl_FlowWork();
tbl_flow.ID = Convert.ToInt32(dr["ID"]);
tbl_flow.UserName = Convert.ToString(dr["UserName"]);
tbl_flow.WorkName = Convert.ToString(dr["WorkName"]);
tbl_flow.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_flow.FlowID = Convert.ToInt32(dr["FlowID"]);
tbl_flow.FormContent = Convert.ToString(dr["FormContent"]);
tbl_flow.NodeID = Convert.ToInt32(dr["NodeID"]);
tbl_flow.NodeNo = Convert.ToString(dr["NodeNo"]);
tbl_flow.NodeStatus = Convert.ToString(dr["NodeStatus"]);
tbl_flow.Status = Convert.ToString(dr["Status"]);
tbl_flow.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_flow.DealUser = Convert.ToString(dr["DealUser"]);
tbl_flow.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_flow.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_flow);
}
}
return(list);
}
public int AddTbl_FlowWork(Tbl_FlowWork tbl_flow)
{
string sql = "insert into [Tbl_FlowWork] ([UserName],[WorkName],[ProjectID],[FlowID],[FormContent],[NodeID],[NodeNo],[NodeUser],[NodeStatus],[Status],[DealUser]) values (@UserName,@WorkName,@ProjectID,@FlowID,@FormContent,@NodeID,@NodeNo,@NodeUser,@NodeStatus,@Status,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@UserName", tbl_flow.UserName),
new SqlParameter("@WorkName", tbl_flow.WorkName),
new SqlParameter("@ProjectID", tbl_flow.ProjectID),
new SqlParameter("@FlowID", tbl_flow.FlowID),
new SqlParameter("@FormContent", tbl_flow.FormContent),
new SqlParameter("@NodeID", tbl_flow.NodeID),
new SqlParameter("@NodeNo", tbl_flow.NodeNo),
new SqlParameter("@NodeUser", tbl_flow.NodeUser),
new SqlParameter("@NodeStatus", tbl_flow.NodeStatus),
new SqlParameter("@Status", tbl_flow.Status),
new SqlParameter("@DealUser", tbl_flow.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_FlowWorkById(Tbl_FlowWork tbl_flow)
{
string sql = "update [Tbl_FlowWork] set [UserName]=@UserName,[WorkName]=@WorkName,[FlowID]=@FlowID,[FormContent]=@FormContent,[NodeID]=@NodeID,[NodeNo]=@NodeNo,[NodeUser]=@NodeUser,[NodeStatus]=@NodeStatus,[Status]=@Status,[DealUser]=@DealUser,[DealTime]=@DealTime where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_flow.ID),
new SqlParameter("@UserName", tbl_flow.UserName),
new SqlParameter("@WorkName", tbl_flow.WorkName),
new SqlParameter("@FlowID", tbl_flow.FlowID),
new SqlParameter("@FormContent", tbl_flow.FormContent),
new SqlParameter("@NodeID", tbl_flow.NodeID),
new SqlParameter("@NodeNo", tbl_flow.NodeNo),
new SqlParameter("@NodeUser", tbl_flow.NodeUser),
new SqlParameter("@NodeStatus", tbl_flow.NodeStatus),
new SqlParameter("@Status", tbl_flow.Status),
new SqlParameter("@DealUser", tbl_flow.DealUser),
new SqlParameter("@DealTime", tbl_flow.DealTime.ToString())
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int UpdateTbl_FlowWork(Tbl_FlowWork tbl_flow)
{
WebCommon.Public.WriteLog("修改工作：" + tbl_flow.WorkName);
//如果节点状态更新项目表的节点信息
if (tbl_flow.ProjectID > 0)
{
WebModels.Tbl_Project project = WebBLL.Tbl_ProjectManager.GetTbl_ProjectById(tbl_flow.ProjectID);
if (tbl_flow.Status == "结束")
{
project.NodeNo = "上传合同";
project.NodeUser = project.ProjectManager;
//project.ProjectNo = "";
}
else
{
project.NodeUser = tbl_flow.NodeUser;
//project.ProjectNo = "";
}
WebBLL.Tbl_ProjectManager.UpdateTbl_Project(project);
}
tbl_flow.DealUser = WebCommon.Public.GetUserName();
tbl_flow.DealTime = DateTime.Now;
return(new Tbl_FlowWorkService().UpdateTbl_FlowWorkById(tbl_flow));
}
public static int AddTbl_FlowWork(Tbl_FlowWork tbl_flow)
{
WebCommon.Public.WriteLog("添加工作：" + tbl_flow.WorkName);
return(new Tbl_FlowWorkService().AddTbl_FlowWork(tbl_flow));
}
