/// <summary> /// 更新记录信息 /// </summary> /// <param name="Model"></param> /// <returns></returns> public int UpdateCompanyPostPlan(CompanyPostPlanInfo Model) { StringBuilder sql = new StringBuilder(); sql.Append("update [" + ShopMssqlHelper.TablePrefix + "CompanyPostPlan] set StartDate=" + Model.StartDate + ",PostId=" + Model.PostId); return(DbSQLHelper.ExecuteSql(sql.ToString())); }
public int AddCompanyPostPlan(CompanyPostPlanInfo Model) { StringBuilder sql = new StringBuilder(); sql.Append("insert into [" + ShopMssqlHelper.TablePrefix + "CompanyPostPlan] (CompanyId,StartDate,PostId) values(@CompanyId,@StartDate,@PostId)"); SqlParameter[] par = (SqlParameter[])this.ValueParas(Model); return(DbSQLHelper.ExecuteSql(sql.ToString(), par)); }
/// <summary> /// 该数据访问对象的属性值装载到数据库更新参数数组 /// </summary> /// <remarks></remarks> protected IDbDataParameter[] ValueParas(CompanyPostPlanInfo Model) { SqlParameter[] par = { new SqlParameter("@CompanyId", SqlDbType.Int), new SqlParameter("@StartDate", SqlDbType.VarChar, 50), new SqlParameter("@PostId", SqlDbType.VarChar, 50) }; par[0].Value = Model.CompanyId; par[1].Value = Model.StartDate; par[2].Value = Model.PostId; return(par); }
public void PrepareModel(SqlDataReader dr, List <CompanyPostPlanInfo> CompanyPostPlanList) { while (dr.Read()) { CompanyPostPlanInfo Item = new CompanyPostPlanInfo(); Item.Id = int.Parse(dr["Id"].ToString()); Item.CompanyId = int.Parse(dr["ComapnyId"].ToString()); Item.StartDate = DateTime.Parse(dr["StartDate"].ToString()); Item.PostId = dr["PostId"].ToString(); Item.CreateDate = DateTime.Parse(dr["CreateDate"].ToString()); CompanyPostPlanList.Add(Item); } }
/// <summary> /// 返回数据 /// </summary> /// <param name="row"></param> /// <returns></returns> public CompanyPostPlanInfo GetModel(SqlDataReader dr) { CompanyPostPlanInfo Model = new CompanyPostPlanInfo(); if (dr.HasRows) { Model.Id = int.Parse(dr["Id"].ToString()); Model.CompanyId = int.Parse(dr["CompanyId"].ToString()); Model.StartDate = DateTime.Parse(dr["StartDate"].ToString()); Model.CreateDate = DateTime.Parse(dr["CreateDate"].ToString()); return(Model); } else { return(null); } }
public List <CompanyPostPlanInfo> CompanyPostPlanList(CompanyPostPlanInfo Model) { StringBuilder sql = new StringBuilder(); sql.Append("select * from [" + ShopMssqlHelper.TablePrefix + "CompanyPostPlan] "); List <CompanyPostPlanInfo> CompanyPostPlanList = new List <CompanyPostPlanInfo>(); MssqlCondition mssqlCondition = new MssqlCondition(); this.PrepareCondition(mssqlCondition, Model); if (mssqlCondition.ToString() != string.Empty) { sql.Append("where " + mssqlCondition.ToString()); sql.Append(" Order by StartDate"); using (SqlDataReader reader = DbSQLHelper.ExecuteReader(sql.ToString())) { this.PrepareModel(reader, CompanyPostPlanList); } } return(CompanyPostPlanList); }
/// <summary> /// 查询公司岗位计划记录 带分页 /// </summary> /// <param name="currentPage"></param> /// <param name="pageSize"></param> /// <param name="RecordSearch"></param> /// <param name="count"></param> /// <returns></returns> public static List <CompanyPostPlanInfo> CompanyPostPlanList(int currentPage, int pageSize, CompanyPostPlanInfo RuleSearch, ref int count) { return(dal.CompanyPostPlanList(currentPage, pageSize, RuleSearch, ref count)); }
/// <summary> /// 查询公司岗位计划记录 /// </summary> /// <param name="currentPage"></param> /// <param name="pageSize"></param> /// <param name="RecordSearch"></param> /// <param name="count"></param> /// <returns></returns> public static List <CompanyPostPlanInfo> CompanyPostPlanList(CompanyPostPlanInfo RuleSearch) { return(dal.CompanyPostPlanList(RuleSearch)); }
/// <summary> /// 更新公司岗位计划信息 /// </summary> /// <param name="Model"></param> /// <returns></returns> public static int UpdateCompanyPostPlan(CompanyPostPlanInfo Model) { return(dal.UpdateCompanyPostPlan(Model)); }
/// <summary> /// 添加公司岗位计划信息 /// </summary> /// <param name="Model"></param> /// <returns></returns> public static int AddCompanyPostPlan(CompanyPostPlanInfo Model) { return(dal.AddCompanyPostPlan(Model)); }
/// <summary> /// 查询公司变化记录 带分页 /// </summary> /// <param name="currentPage"></param> /// <param name="pageSize"></param> /// <param name="RecordSearch"></param> /// <param name="count"></param> /// <returns></returns> public List <CompanyPostPlanInfo> CompanyPostPlanList(int currentPage, int pageSize, CompanyPostPlanInfo RuleSearch, ref int count) { List <CompanyPostPlanInfo> RuleList = new List <CompanyPostPlanInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "CompanyPostPlan"; class2.Fields = "*"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[Id]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, RuleSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareModel(reader, RuleList); } return(RuleList); }
public void PrepareCondition(MssqlCondition mssqlCondition, CompanyPostPlanInfo RuleSearch) { mssqlCondition.Add("[CompanyId]", RuleSearch.CompanyId, ConditionType.Equal); mssqlCondition.Add("[PostId]", "|" + RuleSearch.PostId + "|", ConditionType.Like); }