public PageInfo <T> Get <T>(DeliveryCompanyCriteria deliveryCompanyCriteria)
{
string columnList = @"
Id ,
DeliveryCompanyName ,
DeliveryCompanyCode ,
IsEnable ,
SettleType ,
ClienterFixMoney ,
ClienterSettleRatio ,
DeliveryCompanySettleMoney ,
DeliveryCompanyRatio ,
BusinessQuantity ,
ClienterQuantity ,
CreateTime ,
CreateName ,
ModifyName ,
ModifyTime";
var sbSqlWhere = new StringBuilder(" 1=1 ");
IDbParameters dbParameters = DbHelper.CreateDbParameters();
if (!string.IsNullOrEmpty(deliveryCompanyCriteria.DeliveryCompanyName))
{
sbSqlWhere.AppendFormat(" AND DeliveryCompanyName='{0}' ", deliveryCompanyCriteria.DeliveryCompanyName.Trim());
//dbParameters.Add("DeliveryCompanyName",DbType.String,200).Value= deliveryCompanyCriteria.DeliveryCompanyName.Trim();
}
string tableList = @" dbo.DeliveryCompany(nolock) ";
string orderByColumn = " Id DESC";
return(new PageHelper().GetPages <T>(SuperMan_Read, deliveryCompanyCriteria.PageIndex, sbSqlWhere.ToString(), orderByColumn, columnList, tableList, deliveryCompanyCriteria.PageSize, true));
}
public ActionResult PostDeliveryCompany(int pageindex = 1)
{
DeliveryCompanyCriteria deliveryCompanyCriteria = new DeliveryCompanyCriteria();
TryUpdateModel(deliveryCompanyCriteria);
int UserType = UserContext.Current.AccountType == 1 ? 0 : UserContext.Current.Id; //如果管理后台的类型是所有权限就传0，否则传管理后台id
var dcList = new DeliveryCompanyProvider().Get(deliveryCompanyCriteria); //获取物流公司
return(PartialView("_DeliveryCompanyList", dcList));
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns></returns>
public ActionResult DeliveryCompany()
{
int UserType = UserContext.Current.AccountType == 1 ? 0 : UserContext.Current.Id;//如果管理后台的类型是所有权限就传0，否则传管理后台id
DeliveryCompanyCriteria deliveryCompanyCriteria = new DeliveryCompanyCriteria();
TryUpdateModel(deliveryCompanyCriteria);
var dcList = new DeliveryCompanyProvider().Get(deliveryCompanyCriteria);//获取物流公司
return(View(dcList));
}
/// <summary>
/// 获取物流公司
/// </summary>
/// <returns></returns>
public PageInfo <DeliveryCompanyModel> Get(DeliveryCompanyCriteria deliveryCompanyCriteria)
{
return(dao.Get <DeliveryCompanyModel>(deliveryCompanyCriteria));
}
