/// <summary>
/// 查询对象（为配送业务提供）
/// </summary>
/// <param name="res"></param>
/// <param name="param"></param>
private void GetModelForPs(BaseResult res, Hashtable param)
{
var dbck1 = DAL.GetItem <Td_Ps_Dbck_1>(typeof(Td_Ps_Dbck_1), param);
DbckQueryModel model = new DbckQueryModel();
if (dbck1 != null)
{
param.Clear();
param.Add("id_bill", dbck1.id);
model.dbck2List = DAL.QueryList <Td_Ps_Dbck_2_Query>(typeof(Td_Ps_Dbck_2), param).ToList();
if (model.dbck2List.Any())
{
var id_sps = (from d in model.dbck2List select d.id_sp).ToArray();
var id_shop_rk = dbck1.id_shop_rk;
param.Clear();
param.Add("id_sp_array", id_sps);
param.Add("id_shop", id_shop_rk);
var list = DAL.QueryList <Tb_Shopsp>(typeof(Tb_Shopsp), param).ToList();
if (list.Any())
{
model.dbck2List.ForEach(d =>
{
var firstOrDefault = list.FirstOrDefault(b => b.id_sp == d.id_sp);
if (firstOrDefault != null)
{
d.id_shopsp = firstOrDefault.id;
d.id_kcsp = firstOrDefault.id_kcsp;
}
});
}
}
}
model.dbck1 = dbck1;
res.Data = model;
}
public override BaseResult Get(Hashtable param)
{
BaseResult res = new BaseResult()
{
Success = true
};
if (param != null && param.Contains("forps"))
{
param.Remove("forps");
GetModelForPs(res, param);
return(res);
}
var dbck1 = DAL.GetItem <Td_Ps_Dbck_1>(typeof(Td_Ps_Dbck_1), param);
DbckQueryModel model = new DbckQueryModel();
if (dbck1 != null)
{
param.Clear();
param.Add("id_bill", dbck1.id);
param.Add("sort", " sort_id ");
model.dbck2List = DAL.QueryList <Td_Ps_Dbck_2_Query>(typeof(Td_Ps_Dbck_2), param).ToList();
if (!string.IsNullOrEmpty(dbck1.id_create))
{
param.Clear();
List <string> arr = new List <string>();
arr.Add(dbck1.id_create);
if (!string.IsNullOrEmpty(dbck1.id_user_sh))
{
arr.Add(dbck1.id_user_sh);
}
param.Add("id_users", arr.ToArray());
var users = DAL.QueryList <Tb_User>(typeof(Tb_User), param).ToList();
if (users.Any())
{
var user_zdr = users.FirstOrDefault(a => a.id == dbck1.id_create);
if (user_zdr != null)
{
model.zdr = user_zdr.username;
}
if (!string.IsNullOrEmpty(dbck1.id_user_sh))
{
var user_shr = users.FirstOrDefault(a => a.id == dbck1.id_user_sh);
if (user_shr != null)
{
model.shr = user_shr.username;
}
}
}
}
}
model.dbck1 = dbck1;
res.Data = model;
return(res);
}
