/// <summary> /// get moban chanpins /// </summary> /// <param name="moBanId"></param> /// <returns></returns> IList <EyouSoft.Model.MCaiGouMoBanChanPinInfo> GetMoBanChanPins(string moBanId) { IList <EyouSoft.Model.MCaiGouMoBanChanPinInfo> items = new List <EyouSoft.Model.MCaiGouMoBanChanPinInfo>(); var cmd = _db.GetSqlStringCommand("SELECT A.*,B.Name AS ChanPinName,C.Name AS GysName,B.JiLiangDanWei,B.GuiGe,B.JiaGe2,B.PinPai FROM tbl_CaiGouMoBanChanPin AS A INNER JOIN tbl_ChanPin AS B ON A.ChanPinId=B.ChanPinId INNER JOIN tbl_GongSi AS C ON C.GongSiId=A.GysId WHERE A.MoBanId=@MoBanId ORDER BY A.IdentityId ASC"); _db.AddInParameter(cmd, "MoBanId", DbType.AnsiStringFixedLength, moBanId); using (var rdr = DbHelper.ExecuteReader(cmd, _db)) { while (rdr.Read()) { var item = new EyouSoft.Model.MCaiGouMoBanChanPinInfo(); item.ChanPinId = rdr["ChanPinId"].ToString(); item.ChanPinName = rdr["ChanPinName"].ToString(); item.GysId = rdr["GysId"].ToString(); item.GysName = rdr["GysName"].ToString(); item.Id = rdr["Id"].ToString(); item.ShuLiang = rdr.GetDecimal(rdr.GetOrdinal("ShuLiang")); item.JiLiangDanWei = rdr["JiLiangDanWei"].ToString(); item.GuiGe = rdr["GuiGe"].ToString(); //item.ChanPinJiaGe = rdr.GetDecimal(rdr.GetOrdinal("JiaGe2")); item.ChanPinPinPai = rdr["PinPai"].ToString(); items.Add(item); } } return(items); }
/// <summary> /// get form info /// </summary> /// <returns></returns> EyouSoft.Model.MCaiGouMoBanInfo GetFormInfo() { var info = new EyouSoft.Model.MCaiGouMoBanInfo(); info.CaoZuoRenId = YongHuInfo.YongHuId; info.CgsId = YongHuInfo.GongSiId; info.ChanPins = new List <EyouSoft.Model.MCaiGouMoBanChanPinInfo>(); info.IsMoRen = false; info.IssueTime = DateTime.Now; info.MoBanId = EditId; info.Name = Utils.GetFormValue(txtMoBanName.UniqueID); var txt_moban_gysid = Utils.GetFormValues("txt_moban_gysid"); var txt_moban_chanpinid = Utils.GetFormValues("txt_moban_chanpinid"); var txt_moban_shuliang = Utils.GetFormValues("txt_moban_shuliang"); if (txt_moban_gysid.Length != txt_moban_chanpinid.Length || txt_moban_gysid.Length != txt_moban_shuliang.Length) { Utils.RCWE_AJAX("0", "表单异常"); } for (int i = 0; i < txt_moban_gysid.Length; i++) { var item = new EyouSoft.Model.MCaiGouMoBanChanPinInfo(); item.GysId = txt_moban_gysid[i]; item.ChanPinId = txt_moban_chanpinid[i]; item.ShuLiang = Utils.GetDecimal(txt_moban_shuliang[i]); if (string.IsNullOrEmpty(item.GysId) || string.IsNullOrEmpty(item.ChanPinId)) { continue; } bool isExists = false; foreach (var item1 in info.ChanPins) { if (item1.ChanPinId == item.ChanPinId) { isExists = true; } } if (isExists) { continue; } info.ChanPins.Add(item); } if (info.ChanPins == null || info.ChanPins.Count == 0) { Utils.RCWE_AJAX("0", "至少要选择一个有效产品"); } return(info); }