public static int DeleteTbl_PlanManage(int ID) { Tbl_PlanManage tbl_planmanage = GetTbl_PlanManageById(ID); WebCommon.Public.WriteLog("删除计划进度"); return(new Tbl_PlanManageService().DeleteTbl_PlanManageById(ID)); }
/// <summary> ///根据Sql语句返回集合 /// </summary> private IList <Tbl_PlanManage> getTbl_PlanManagesBySql(string Sql) { IList <Tbl_PlanManage> list = new List <Tbl_PlanManage>(); 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_PlanManage tbl_planmanage = new Tbl_PlanManage(); tbl_planmanage.ID = Convert.ToInt32(dr["ID"]); tbl_planmanage.PlanDate = Convert.ToString(dr["PlanDate"]); tbl_planmanage.PlanContent = Convert.ToString(dr["PlanContent"]); tbl_planmanage.NodeUser = Convert.ToString(dr["NodeUser"]); tbl_planmanage.Status = Convert.ToString(dr["Status"]); tbl_planmanage.DealUser = Convert.ToString(dr["DealUser"]); tbl_planmanage.DealFlag = Convert.ToInt32(dr["DealFlag"]); tbl_planmanage.DealTime = Convert.ToDateTime(dr["DealTime"]); tbl_planmanage.AddDate = Convert.ToDateTime(dr["AddDate"]); list.Add(tbl_planmanage); } } return(list); }
public int AddTbl_PlanManage(Tbl_PlanManage tbl_planmanage) { string Sql = "insert into [Tbl_PlanManage] ([PlanDate],[PlanContent],[NodeUser],[Status],[DealUser],[DealFlag],[DealTime],[AddDate]) values (@PlanDate,@PlanContent,@NodeUser,@Status,@DealUser,@DealFlag,@DealTime,@AddDate)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@PlanDate", tbl_planmanage.PlanDate), new SqlParameter("@PlanContent", tbl_planmanage.PlanContent), new SqlParameter("@NodeUser", tbl_planmanage.NodeUser), new SqlParameter("@Status", tbl_planmanage.Status), new SqlParameter("@DealUser", tbl_planmanage.DealUser), new SqlParameter("@DealFlag", tbl_planmanage.DealFlag), new SqlParameter("@DealTime", tbl_planmanage.DealTime), new SqlParameter("@AddDate", tbl_planmanage.AddDate) }; return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, Sql, sp)); }
public int UpdateTbl_PlanManageById(Tbl_PlanManage tbl_planmanage) { string Sql = "update [Tbl_PlanManage] set [PlanDate]=@PlanDate,[PlanContent]=@PlanContent,[NodeUser]=@NodeUser,[Status]=@Status,[DealUser]=@DealUser,[DealFlag]=@DealFlag,[DealTime]=@DealTime,[AddDate]=@AddDate where [ID]=@ID"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@PlanDate", tbl_planmanage.PlanDate), new SqlParameter("@PlanContent", tbl_planmanage.PlanContent), new SqlParameter("@NodeUser", tbl_planmanage.NodeUser), new SqlParameter("@Status", tbl_planmanage.Status), new SqlParameter("@DealUser", tbl_planmanage.DealUser), new SqlParameter("@DealFlag", tbl_planmanage.DealFlag), new SqlParameter("@DealTime", tbl_planmanage.DealTime), new SqlParameter("@AddDate", tbl_planmanage.AddDate), new SqlParameter("@ID", tbl_planmanage.ID) }; return(DBHelper.ExecuteNonQuery(this.connection, CommandType.Text, Sql, sp)); }
public static int UpdateTbl_PlanManage(Tbl_PlanManage tbl_planmanage) { WebCommon.Public.WriteLog("修改计划进度"); return(new Tbl_PlanManageService().UpdateTbl_PlanManageById(tbl_planmanage)); }
public static int AddTbl_PlanManage(Tbl_PlanManage tbl_planmanage) { WebCommon.Public.WriteLog("添加计划进度"); return(new Tbl_PlanManageService().AddTbl_PlanManage(tbl_planmanage)); }