/// <summary>
/// 查询对象（为配送业务提供）
/// </summary>
/// <param name="res"></param>
/// <param name="param"></param>
private void GetModelForPs(BaseResult res, Hashtable param)
{
var psck1 = DAL.GetItem <Td_Ps_Ck_1>(typeof(Td_Ps_Ck_1), param);
PsckQueryModel model = new PsckQueryModel();
if (psck1 != null)
{
param.Clear();
param.Add("id_bill", psck1.id);
model.PsCk2List = DAL.QueryList <Td_Ps_Ck_2_Query>(typeof(Td_Ps_Ck_2), param).ToList();
if (model.PsCk2List.Any())
{
var id_sps = (from d in model.PsCk2List select d.id_sp).ToArray();
var id_shop_rk = psck1.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.PsCk2List.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;
}
});
}
}
#region
//if (!string.IsNullOrEmpty(psck1.id_create))
//{
// param.Clear();
// List<string> arr = new List<string>();
// arr.Add(psck1.id_create);
// if (!string.IsNullOrEmpty(psck1.id_user_sh))
// {
// arr.Add(psck1.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 == psck1.id_create);
// if (user_zdr != null) model.zdr = user_zdr.username;
// if (!string.IsNullOrEmpty(psck1.id_user_sh))
// {
// var user_shr = users.FirstOrDefault(a => a.id == psck1.id_user_sh);
// if (user_shr != null) model.shr = user_shr.username;
// }
// }
//}
#endregion
}
model.PsCk1 = psck1;
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 psck1 = DAL.GetItem <Td_Ps_Ck_1>(typeof(Td_Ps_Ck_1), param);
PsckQueryModel model = new PsckQueryModel();
if (psck1 != null)
{
param.Clear();
param.Add("id_bill", psck1.id);
param.Add("sort", " sort_id ");
model.PsCk2List = DAL.QueryList <Td_Ps_Ck_2_Query>(typeof(Td_Ps_Ck_2), param).ToList();
if (!string.IsNullOrEmpty(psck1.id_create))
{
param.Clear();
List <string> arr = new List <string>();
arr.Add(psck1.id_create);
if (!string.IsNullOrEmpty(psck1.id_user_sh))
{
arr.Add(psck1.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 == psck1.id_create);
if (user_zdr != null)
{
model.zdr = user_zdr.username;
}
if (!string.IsNullOrEmpty(psck1.id_user_sh))
{
var user_shr = users.FirstOrDefault(a => a.id == psck1.id_user_sh);
if (user_shr != null)
{
model.shr = user_shr.username;
}
}
}
}
}
model.PsCk1 = psck1;
res.Data = model;
return(res);
}
