/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_ProjectDocument> getTbl_ProjectDocumentsBySql(string sql)
{
IList <Tbl_ProjectDocument> list = new List <Tbl_ProjectDocument>();
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_ProjectDocument tbl_projectdocument = new Tbl_ProjectDocument();
tbl_projectdocument.ID = Convert.ToInt32(dr["ID"]);
tbl_projectdocument.UserName = Convert.ToString(dr["UserName"]);
tbl_projectdocument.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_projectdocument.ParentID = Convert.ToInt32(dr["ParentID"]);
tbl_projectdocument.ClassName = Convert.ToString(dr["ClassName"]);
tbl_projectdocument.PD_Type = Convert.ToString(dr["PD_Type"]);
tbl_projectdocument.PD_File = Convert.ToString(dr["PD_File"]);
tbl_projectdocument.PD_FileNo = Convert.ToString(dr["PD_FileNo"]);
tbl_projectdocument.Remark = Convert.ToString(dr["Remark"]);
tbl_projectdocument.Status = Convert.ToString(dr["Status"]);
tbl_projectdocument.PD_Name = Convert.ToString(dr["PD_Name"]);
tbl_projectdocument.PD_Users = Convert.ToString(dr["PD_Users"]);
tbl_projectdocument.AddDate = Convert.ToDateTime(dr["AddDate"]);
tbl_projectdocument.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_projectdocument.DealUser = Convert.ToString(dr["DealUser"]);
tbl_projectdocument.DealTime = Convert.ToDateTime(dr["DealTime"]);
list.Add(tbl_projectdocument);
}
}
return(list);
}
public static int UpdateTbl_ProjectDocument(Tbl_ProjectDocument tbl_projectdocument)
{
WebCommon.Public.WriteLog("修改网上提资：" + tbl_projectdocument.PD_Name);
//发送提醒消息给这个专业的人
if (tbl_projectdocument.PD_Type != "新增提资" && tbl_projectdocument.Status == "已确认")
{
foreach (WebModels.Tbl_User user in WebBLL.Tbl_UserManager.GetTbl_UserBySpecialty(tbl_projectdocument.ClassName))
{
WebCommon.Public.WriteAlert(user.UserName, "提资变更", "名称：" + tbl_projectdocument.PD_Name + " 版本：" + tbl_projectdocument.PD_FileNo, "views/ProjectDocument_Edit.aspx?type=read&ID=" + tbl_projectdocument.ID.ToString());
}
}
tbl_projectdocument.DealUser = WebCommon.Public.GetUserName();
tbl_projectdocument.DealTime = DateTime.Now;
return(new Tbl_ProjectDocumentService().UpdateTbl_ProjectDocumentById(tbl_projectdocument));
}
public int AddTbl_ProjectDocument(Tbl_ProjectDocument tbl_projectdocument)
{
string sql = "insert into [Tbl_ProjectDocument] ([UserName],[ProjectID],[ParentID],[ClassName],[PD_Type],[PD_File],[PD_FileNo],[Remark],[Status],[PD_Name],[PD_Users],[DealUser]) values (@UserName,@ProjectID,@ProjectID,@ClassName,@PD_Type,@PD_File,@PD_FileNo,@Remark,@Status,@PD_Name,@PD_Users,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@UserName", tbl_projectdocument.UserName),
new SqlParameter("@ProjectID", tbl_projectdocument.ProjectID),
new SqlParameter("@ParentID", tbl_projectdocument.ParentID),
new SqlParameter("@ClassName", tbl_projectdocument.ClassName),
new SqlParameter("@PD_Type", tbl_projectdocument.PD_Type),
new SqlParameter("@PD_File", tbl_projectdocument.PD_File),
new SqlParameter("@PD_FileNo", tbl_projectdocument.PD_FileNo),
new SqlParameter("@PD_Name", tbl_projectdocument.PD_Name),
new SqlParameter("@PD_Users", tbl_projectdocument.PD_Users),
new SqlParameter("@Remark", tbl_projectdocument.Remark),
new SqlParameter("@Status", tbl_projectdocument.Status),
new SqlParameter("@DealUser", tbl_projectdocument.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_ProjectDocumentById(Tbl_ProjectDocument tbl_projectdocument)
{
string sql = "update [Tbl_ProjectDocument] set [UserName]=@UserName,[ProjectID]=@ProjectID,[ParentID]=@ParentID,[ClassName]=@ClassName,[PD_Type]=@PD_Type,[PD_File]=@PD_File,[PD_FileNo]=@PD_FileNo,[Remark]=@Remark,[Status]=@Status,[PD_Name]=@PD_Name,[PD_Users]=@PD_Users,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_projectdocument.ID),
new SqlParameter("@UserName", tbl_projectdocument.UserName),
new SqlParameter("@ProjectID", tbl_projectdocument.ProjectID),
new SqlParameter("@ParentID", tbl_projectdocument.ParentID),
new SqlParameter("@ClassName", tbl_projectdocument.ClassName),
new SqlParameter("@PD_Type", tbl_projectdocument.PD_Type),
new SqlParameter("@PD_File", tbl_projectdocument.PD_File),
new SqlParameter("@PD_FileNo", tbl_projectdocument.PD_FileNo),
new SqlParameter("@Remark", tbl_projectdocument.Remark),
new SqlParameter("@Status", tbl_projectdocument.Status),
new SqlParameter("@PD_Name", tbl_projectdocument.PD_Name),
new SqlParameter("@PD_Users", tbl_projectdocument.PD_Users),
new SqlParameter("@DealUser", tbl_projectdocument.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public static int AddTbl_ProjectDocument(Tbl_ProjectDocument tbl_projectdocument)
{
WebCommon.Public.WriteLog("添加网上提资：" + tbl_projectdocument.PD_Name);
return(new Tbl_ProjectDocumentService().AddTbl_ProjectDocument(tbl_projectdocument));
}
