/// <summary>
///根据SQL语句获取集合
/// </summary>
private IList <Tbl_ProjectArchiveRequest> getTbl_ProjectArchiveRequestsBySql(string sql)
{
IList <Tbl_ProjectArchiveRequest> list = new List <Tbl_ProjectArchiveRequest>();
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_ProjectArchiveRequest tbl_projectarchiverequest = new Tbl_ProjectArchiveRequest();
tbl_projectarchiverequest.ID = Convert.ToInt32(dr["ID"]);
tbl_projectarchiverequest.ProjectID = Convert.ToInt32(dr["ProjectID"]);
tbl_projectarchiverequest.ClassName1 = Convert.ToString(dr["ClassName1"]);
tbl_projectarchiverequest.ClassName2 = Convert.ToString(dr["ClassName2"]);
tbl_projectarchiverequest.ClassName3 = Convert.ToString(dr["ClassName3"]);
tbl_projectarchiverequest.PA_Type1 = Convert.ToString(dr["PA_Type1"]);
tbl_projectarchiverequest.PA_Type2 = Convert.ToString(dr["PA_Type2"]);
tbl_projectarchiverequest.NodeNo = Convert.ToString(dr["NodeNo"]);
tbl_projectarchiverequest.NodeUser = Convert.ToString(dr["NodeUser"]);
tbl_projectarchiverequest.ProjectArchiveID = Convert.ToInt32(dr["ProjectArchiveID"]);
tbl_projectarchiverequest.Remark = Convert.ToString(dr["Remark"]);
tbl_projectarchiverequest.RequestType = Convert.ToString(dr["RequestType"]);
tbl_projectarchiverequest.Status = Convert.ToString(dr["Status"]);
tbl_projectarchiverequest.UserName = Convert.ToString(dr["UserName"]);
tbl_projectarchiverequest.DealFlag = Convert.ToInt32(dr["DealFlag"]);
tbl_projectarchiverequest.DealTime = Convert.ToDateTime(dr["DealTime"]);
tbl_projectarchiverequest.DealUser = Convert.ToString(dr["DealUser"]);
tbl_projectarchiverequest.AddDate = Convert.ToDateTime(dr["AddDate"]);
list.Add(tbl_projectarchiverequest);
}
}
return(list);
}
public static int AddTbl_ProjectArchiveRequest(Tbl_ProjectArchiveRequest tbl_projectarchiverequest)
{
WebCommon.Public.WriteLog("Ìí¼Óµµ°¸ÉóÅú£º" + tbl_projectarchiverequest.ProjectArchiveID);
//·¢ËÍÌáÐÑÏûÏ¢
WebCommon.Public.WriteAlert(tbl_projectarchiverequest.NodeUser, tbl_projectarchiverequest.RequestType + "ÉóºË", "ÄÚÈÝ£º" + tbl_projectarchiverequest.ClassName1 + " " + tbl_projectarchiverequest.ClassName2 + " " + tbl_projectarchiverequest.ClassName3 + " " + tbl_projectarchiverequest.Remark, "views/alert.aspx");
return(new Tbl_ProjectArchiveRequestService().AddTbl_ProjectArchiveRequest(tbl_projectarchiverequest));
}
public static int UpdateTbl_ProjectArchiveRequest(Tbl_ProjectArchiveRequest tbl_projectarchiverequest)
{
WebCommon.Public.WriteLog("Ð޸ĵµ°¸ÉóÅú£º" + tbl_projectarchiverequest.ProjectArchiveID);
//·¢ËÍÌáÐÑÏûÏ¢
if (tbl_projectarchiverequest.Status != "됢")
{
WebCommon.Public.WriteAlert(tbl_projectarchiverequest.UserName, tbl_projectarchiverequest.RequestType + "ÉóºË", "״̬£º" + tbl_projectarchiverequest.Status + " " + tbl_projectarchiverequest.Remark, "views/alert.aspx");
}
tbl_projectarchiverequest.DealUser = WebCommon.Public.GetUserName();
tbl_projectarchiverequest.DealTime = DateTime.Now;
return(new Tbl_ProjectArchiveRequestService().UpdateTbl_ProjectArchiveRequestById(tbl_projectarchiverequest));
}
public int AddTbl_ProjectArchiveRequest(Tbl_ProjectArchiveRequest tbl_projectarchiverequest)
{
string sql = "insert into [Tbl_ProjectArchiveRequest] ([ProjectID],[ClassName1],[ClassName2],[ClassName3],[NodeNo],[NodeUser],[PA_Type1],[PA_Type2],[ProjectArchiveID],[Remark],[RequestType],[Status],[UserName],[DealUser]) values (@ProjectID,@ClassName1,@ClassName2,@ClassName3,@NodeNo,@NodeUser,@PA_Type1,@PA_Type2,@ProjectArchiveID,@Remark,@RequestType,@Status,@UserName,@DealUser)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ProjectID", tbl_projectarchiverequest.ProjectID),
new SqlParameter("@ClassName1", tbl_projectarchiverequest.ClassName1),
new SqlParameter("@ClassName2", tbl_projectarchiverequest.ClassName2),
new SqlParameter("@ClassName3", tbl_projectarchiverequest.ClassName3),
new SqlParameter("@PA_Type1", tbl_projectarchiverequest.PA_Type1),
new SqlParameter("@PA_Type2", tbl_projectarchiverequest.PA_Type2),
new SqlParameter("@NodeNo", tbl_projectarchiverequest.NodeNo),
new SqlParameter("@NodeUser", tbl_projectarchiverequest.NodeUser),
new SqlParameter("@ProjectArchiveID", tbl_projectarchiverequest.ProjectArchiveID),
new SqlParameter("@Remark", tbl_projectarchiverequest.Remark),
new SqlParameter("@RequestType", tbl_projectarchiverequest.RequestType),
new SqlParameter("@Status", tbl_projectarchiverequest.Status),
new SqlParameter("@UserName", tbl_projectarchiverequest.UserName),
new SqlParameter("@DealUser", tbl_projectarchiverequest.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
public int UpdateTbl_ProjectArchiveRequestById(Tbl_ProjectArchiveRequest tbl_projectarchiverequest)
{
string sql = "update [Tbl_ProjectArchiveRequest] set [ProjectID]=@ProjectID,[ClassName1]=@ClassName1,[ClassName2]=@ClassName2,[ClassName3]=@ClassName3,[NodeNo]=@NodeNo,[NodeUser]=@NodeUser,[PA_Type1]=@PA_Type1,[PA_Type2]=@PA_Type2,[ProjectArchiveID]=@ProjectArchiveID,[Remark]=@Remark,[RequestType]=@RequestType,[UserName]=@UserName,[Status]=@Status,[DealUser]=@DealUser where DealFlag=0 and [ID]=@ID";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ID", tbl_projectarchiverequest.ID),
new SqlParameter("@ProjectID", tbl_projectarchiverequest.ProjectID),
new SqlParameter("@ClassName1", tbl_projectarchiverequest.ClassName1),
new SqlParameter("@ClassName2", tbl_projectarchiverequest.ClassName2),
new SqlParameter("@ClassName3", tbl_projectarchiverequest.ClassName3),
new SqlParameter("@PA_Type1", tbl_projectarchiverequest.PA_Type1),
new SqlParameter("@PA_Type2", tbl_projectarchiverequest.PA_Type2),
new SqlParameter("@NodeNo", tbl_projectarchiverequest.NodeNo),
new SqlParameter("@NodeUser", tbl_projectarchiverequest.NodeUser),
new SqlParameter("@ProjectArchiveID", tbl_projectarchiverequest.ProjectArchiveID),
new SqlParameter("@Remark", tbl_projectarchiverequest.Remark),
new SqlParameter("@RequestType", tbl_projectarchiverequest.RequestType),
new SqlParameter("@Status", tbl_projectarchiverequest.Status),
new SqlParameter("@UserName", tbl_projectarchiverequest.UserName),
new SqlParameter("@DealUser", tbl_projectarchiverequest.DealUser)
};
return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, sql, sp));
}
