/// <summary>
/// 获取采购单产品信息集合
/// </summary>
/// <param name="caiGouDanId">采购单编号</param>
/// <returns></returns>
IList <EyouSoft.Model.MCaiGouDanChanPinInfo> GetCaiGouDanChanPins(string caiGouDanId)
{
IList <EyouSoft.Model.MCaiGouDanChanPinInfo> items = new List <EyouSoft.Model.MCaiGouDanChanPinInfo>();
var cmd = _db.GetSqlStringCommand("SELECT A.*,B.GysId,B.GysName FROM tbl_DingDanChanPin AS A INNER JOIN tbl_DingDan AS B ON A.DingDanId=B.DingDanId WHERE A.CaiGouDanId=@CaiGouDanId ORDER BY A.IdentityId ASC");
_db.AddInParameter(cmd, "CaiGouDanId", DbType.AnsiStringFixedLength, caiGouDanId);
using (var rdr = DbHelper.ExecuteReader(cmd, _db))
{
while (rdr.Read())
{
var item = new EyouSoft.Model.MCaiGouDanChanPinInfo();
item.ChanPinGuiGe = rdr["ChanPinGuiGe"].ToString();
item.ChanPinId = rdr["ChanPinId"].ToString();
item.ChanPinName = rdr["ChanPinName"].ToString();
item.DingDanId = rdr["DingDanId"].ToString();
item.GysId = rdr["GysId"].ToString();
item.GysName = rdr["GysName"].ToString();
item.JiLiangDanWei = rdr["JiLiangDanWei"].ToString();
item.MingXiId = rdr["MingXiId"].ToString();
item.ShuLiang = rdr.GetDecimal(rdr.GetOrdinal("ShuLiang"));
item.ChanPinJiaGe = rdr.GetDecimal(rdr.GetOrdinal("ChanPinJiaGe"));
item.ChanPinPinPai = rdr["ChanPinPinPai"].ToString();
items.Add(item);
}
}
return(items);
}
/// <summary>
/// get form info
/// </summary>
/// <returns></returns>
EyouSoft.Model.MCaiGouDanInfo GetFormInfo()
{
var info = new EyouSoft.Model.MCaiGouDanInfo();
info.CaiGouBuMen = YongHuInfo.BuMenName;
info.CaiGouDanHao = string.Empty;
info.CaiGouDanId = EditId;
info.CaiGouDanName = Utils.GetFormValue(txtCaiGouDanName.UniqueID);
info.CaiGouDanShuoMing = string.Empty;
info.CaoZuoRenId = YongHuInfo.YongHuId;
info.CaoZuoRenName = string.Empty;
info.CgsId = YongHuInfo.GongSiId;
info.ChanPins = new List <EyouSoft.Model.MCaiGouDanChanPinInfo>();
info.FaBuRenId = string.Empty;
info.FaBuRenName = string.Empty;
info.FaBuTime = DateTime.Now;
info.IssueTime = DateTime.Now;
info.MoBanId = Utils.GetFormValue("txtMoBan");
info.ShouHuoDiZhi = Utils.GetFormValue(txtShouHuoDiZhi.UniqueID);
info.ShouHuoRenDianHua = Utils.GetFormValue(txtShouHuoRenDianHua.UniqueID);
info.ShouHuoRenName = Utils.GetFormValue(txtShouHuoRenName.UniqueID);
info.Status = EyouSoft.Model.CaiGouDanStatus.计划采购;
info.YaoQiuDaoHuoTime = Utils.GetDateTimeNullable(Utils.GetFormValue(txtYaoQiuDaoHuoTime.UniqueID));
var txt_chanpin_id = Utils.GetFormValues("txt_chanpin_id");
var txt_chanpin_gysid = Utils.GetFormValues("txt_chanpin_gysid");
var txt_chanpin_shuliang = Utils.GetFormValues("txt_chanpin_shuliang");
var txt_chanpin_mignxiid = Utils.GetFormValues("txt_chanpin_mignxiid");
var txt_chanpin_dingdanid = Utils.GetFormValues("txt_chanpin_dingdanid");
var txt_chanpin_xuanzhong = Utils.GetFormEditorValues("txt_chanpin_xuanzhong");
if (txt_chanpin_id == null || txt_chanpin_id.Length == 0)
{
Utils.RCWE_AJAX("0", "操作失败：至少需要采购一件产品");
}
if (txt_chanpin_id.Length != txt_chanpin_gysid.Length ||
txt_chanpin_id.Length != txt_chanpin_shuliang.Length ||
txt_chanpin_id.Length != txt_chanpin_mignxiid.Length ||
txt_chanpin_id.Length != txt_chanpin_dingdanid.Length ||
txt_chanpin_id.Length != txt_chanpin_xuanzhong.Length)
{
Utils.RCWE_AJAX("0", "操作失败：表单异常");
}
for (int i = 0; i < txt_chanpin_id.Length; i++)
{
var item = new EyouSoft.Model.MCaiGouDanChanPinInfo();
item.ChanPinId = txt_chanpin_id[i];
item.GysId = txt_chanpin_gysid[i];
item.MingXiId = txt_chanpin_mignxiid[i];
item.ShuLiang = Utils.GetDecimal(txt_chanpin_shuliang[i]);
item.DingDanId = txt_chanpin_dingdanid[i];
if (string.IsNullOrEmpty(item.ChanPinId) || string.IsNullOrEmpty(item.GysId) || item.ShuLiang <= 0 || txt_chanpin_xuanzhong[i] != "1")
{
continue;
}
info.ChanPins.Add(item);
}
if (info.ChanPins == null || info.ChanPins.Count == 0)
{
Utils.RCWE_AJAX("0", "操作失败：至少需要采购一件产品");
}
info.ShouHuoDiZhiId = Utils.GetFormValue("radioDiZhi");
return(info);
}
