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