public string SoBox(string boxsn)
{
SerializableDictionary <string, string> res = new SerializableDictionary <string, string>();
nrWebClass.LiLanzDAL dbhelper = new nrWebClass.LiLanzDAL();
Int32 id = 0, khid = 0;
IDataReader dr = dbhelper.ExecuteReader(String.Format("SELECT top 1 id from yx_t_kcdjspid where zxxh='{0}'", boxsn));
if (dr.Read())
{
id = dr.GetInt32(0);
}
else
{
res.Add("status", "200");
res.Add("msg", "找不到装箱信息。");
return(JsonConvert.SerializeObject(res));
}
dr = dbhelper.ExecuteReader(String.Format("SELECT khid from YX_T_kcdjb where id={0}", id));
if (dr.Read())
{
khid = dr.GetInt32(0);
}
else
{
res.Add("status", "200");
res.Add("msg", "找不到出库单。");
return(JsonConvert.SerializeObject(res));
}
dr = dbhelper.ExecuteReader(String.Format("select khmc from yx_T_khb where khid={0}", khid));
if (dr.Read())
{
res.Add("cname", dr.GetString(0));
}
dr = dbhelper.ExecuteReader(String.Format("select mdd,ckdz,lxdh,shr from yx_T_khb_hyxx where khid={0}", khid));
if (dr.Read())
{
res.Add("addr", dr.GetString(0));
res.Add("AddrDetail", dr.GetString(1));
res.Add("phone", dr.GetString(2));
res.Add("contact", dr.GetString(3));
}
return(JsonConvert.SerializeObject(res));
}
public string InstuctList(string zlbh, string itemCode)
{
List <PLMInstruct> list = new List <PLMInstruct>();
string sql = @" SELECT top (100) zlmxid,ypbh,ypzlbh,case when a.shbs=0 then '未审' when a.shbs=1 then '已审' else '审核中' end as shzt,g.dm+'.'+g.mc from yf_t_cpkfzlb a
inner join YF_T_Cpkfjh jh on a.id=jh.id
inner join yx_v_splb g on jh.splbid=g.id
where ypzlbh like '{0}%' ";
sql = string.Format(sql, zlbh);
if (itemCode.Trim().Length > 0)
{
sql += string.Format(" AND ypbh like '{0}%'", itemCode);
}
using (IDataReader reader = dal.ExecuteReader(sql))
{
while (reader.Read())
{
PLMInstruct pstruct = new PLMInstruct();
pstruct.Zlmxid = reader.GetInt32(0);
pstruct.Yphh = reader.GetString(1);
pstruct.Zlbh = reader.GetString(2);
pstruct.CheckStatus = reader.GetString(3);
pstruct.Cname = reader.GetString(4);
list.Add(pstruct);
}
}
return(xmlHelper.ToString <List <PLMInstruct> >(list));
}
