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