/// <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)); }