/// <summary> /// 更新记录信息 /// </summary> /// <param name="Model"></param> /// <returns></returns> public int UpdateCompanyRecord(CompanyRecordInfo Model) { StringBuilder sql = new StringBuilder(); sql.Append("update [" + ShopMssqlHelper.TablePrefix + "CompanyRecord] set ChangeNum=" + Model.ChangeNum + ",Reason=" + Model.Reason + ",PostId=" + Model.PostId); return(DbSQLHelper.ExecuteSql(sql.ToString())); }
/// <summary> /// 添加记录信息 /// </summary> /// <param name="Model"></param> /// <returns></returns> public int AddCompanyRecord(CompanyRecordInfo Model) { StringBuilder sql = new StringBuilder(); sql.Append("insert into [" + ShopMssqlHelper.TablePrefix + "CompanyRecord] (CompanyId,ChangeNum,PostId,Reson) values(@CompanyId,@ChangeNum,@PostId,@Reson)"); SqlParameter[] par = (SqlParameter[])this.ValueParas(Model); return(DbSQLHelper.ExecuteSql(sql.ToString(), par)); }
public void PrepareUserModel(SqlDataReader dr, List <CompanyRecordInfo> CompanyRecordList) { while (dr.Read()) { CompanyRecordInfo Item = new CompanyRecordInfo(); Item.CompanyId = int.Parse(dr["ComapnyId"].ToString()); Item.ChangeNum = int.Parse(dr["ChangeNum"].ToString()); Item.PostId = dr["PostId"].ToString(); Item.Reason = dr["Reason"].ToString(); Item.CreateDate = DateTime.Parse(dr["CreateDate"].ToString()); CompanyRecordList.Add(Item); } }
/// <summary> /// 该数据访问对象的属性值装载到数据库更新参数数组 /// </summary> /// <remarks></remarks> protected IDbDataParameter[] ValueParas(CompanyRecordInfo Model) { SqlParameter[] par = { new SqlParameter("@CompanyId", SqlDbType.Int), new SqlParameter("@ChangeNum", SqlDbType.Int), new SqlParameter("@PostId", SqlDbType.VarChar), new SqlParameter("@Reason", SqlDbType.VarChar, 50) }; par[0].Value = Model.CompanyId; par[1].Value = Model.ChangeNum; par[2].Value = Model.PostId; par[3].Value = Model.Reason; return(par); }
public void PrepareCondition(MssqlCondition mssqlCondition, CompanyRecordInfo RecordSearch) { mssqlCondition.Add("[CompanyId]", RecordSearch.CompanyId, ConditionType.In); }
/// <summary> /// 查询公司变化记录 带分页 /// </summary> /// <param name="currentPage"></param> /// <param name="pageSize"></param> /// <param name="RecordSearch"></param> /// <param name="count"></param> /// <returns></returns> public List <CompanyRecordInfo> CompanyRecordList(int currentPage, int pageSize, CompanyRecordInfo RecordSearch, ref int count) { List <CompanyRecordInfo> RecordList = new List <CompanyRecordInfo>(); ShopMssqlPagerClass class2 = new ShopMssqlPagerClass(); class2.TableName = ShopMssqlHelper.TablePrefix + "CompanyRecord"; class2.Fields = "[CompanyID],[ChangeNum],[PostId],[Reason],[CreateDate]"; class2.CurrentPage = currentPage; class2.PageSize = pageSize; class2.OrderField = "[CreateDate]"; class2.OrderType = OrderType.Desc; this.PrepareCondition(class2.MssqlCondition, RecordSearch); class2.Count = count; count = class2.Count; using (SqlDataReader reader = class2.ExecuteReader()) { this.PrepareUserModel(reader, RecordList); } return(RecordList); }
/// <summary> /// 查询公司变化记录 带分页 /// </summary> /// <param name="currentPage"></param> /// <param name="pageSize"></param> /// <param name="RecordSearch"></param> /// <param name="count"></param> /// <returns></returns> public static List <CompanyRecordInfo> CompanyRecordList(int currentPage, int pageSize, CompanyRecordInfo RecordSearch, ref int count) { return(dal.CompanyRecordList(currentPage, pageSize, RecordSearch, ref count)); }
/// <summary> /// 更新公司记录信息 /// </summary> /// <param name="Model"></param> /// <returns></returns> public static int UpdateCompanyRecord(CompanyRecordInfo Model) { return(dal.UpdateCompanyRecord(Model)); }
/// <summary> /// 添加公司记录信息 /// </summary> /// <param name="Model"></param> /// <returns></returns> public static int AddCompanyRecord(CompanyRecordInfo Model) { return(dal.AddCompanyRecord(Model)); }