/// <summary> /// 保存销售出库GSP检验单 /// </summary> /// <param name="dl"></param> /// <param name="flag">true:中药材/饮片;false:普通</param> /// <param name="errMsg"></param> /// <returns></returns> public static int SaveSaleOutGSP(SaleOutGSPVouch dl, bool flag, out string errMsg) { Common co = Common.GetInstance(); errMsg = ""; try { U8Business.Service.SaleOutGSPVouch saleoutGSP = new U8Business.Service.SaleOutGSPVouch(); saleoutGSP.CMAKER = dl.CMAKER; saleoutGSP.CDEFINE2 = dl.CDEFINE2; saleoutGSP.CDEFINE3 = dl.CDEFINE3; saleoutGSP.CDEFINE7 = dl.CDEFINE7; saleoutGSP.CDEFINE11 = dl.CDEFINE11; saleoutGSP.OperateDetails = new U8Business.Service.GSPVouchDetail[dl.OperateDetails.Count]; int i = 0; foreach (GSPVouchDetail dd in dl.OperateDetails) { U8Business.Service.GSPVouchDetail detail = new U8Business.Service.GSPVouchDetail(); detail.ddate = dd.ddate; detail.dvdate = dd.dvdate; detail.cinvcode = dd.cinvcode; detail.cbatch = dd.cbatch; detail.FQUANTITY = dd.FQUANTITY; detail.dmadedate = dd.dmadedate; detail.cbuscode = dd.cbuscode; detail.CVALDATE = dd.CVALDATE; detail.autoid = dd.autoid; detail.ccuscode = dd.ccuscode; detail.cdefine22 = dd.cdefine22; detail.cwhcode = dd.cwhcode; detail.imassdate = dd.imassdate; detail.CMASSUNIT = dd.CMASSUNIT; detail.ID = dd.ID; detail.cCode = dd.cCode; detail.cmaker = dd.cmaker; detail.CVALDATES = dd.CVALDATES; detail.CRESULT = dd.CRESULT;//质量情况 saleoutGSP.OperateDetails[i] = detail; i++; } int rt = co.Service.SaveSaleOutGSP(saleoutGSP, Common.CurrentUser.ConnectionString, flag, Common.CurrentUser.Accid, Common.CurrentUser.Year, out errMsg); if (rt != -1 && errMsg.Equals("")) { return(0); } else { return(-1); } } catch (Exception ex) { errMsg = ex.Message; return(-1); } }
public int SaveSaleOutGSP(SaleOutGSPVouch dl, string connectionString, bool flag, string accid, string year, out string errMsg) { if (flag) { return(GSPVouchProcess.SaveSaleOutGSP_CHM(dl, connectionString, accid, year, out errMsg)); } else { return(GSPVouchProcess.SaveSaleOutGSP(dl, connectionString, accid, year, out errMsg)); } }
public static bool GetSaleOut(string ccode, out SaleOutGSPVouch saleoutGSP, out string errMsg) { Common co = Common.GetInstance(); errMsg = ""; DataSet Details = null; co.Service.GetSaleOut(ccode, Common.CurrentUser.ConnectionString, out Details, out errMsg); if (errMsg != "") { throw new Exception(errMsg); } else { if (Details.Tables[0] != null && Details.Tables[0].Rows.Count > 0) { saleoutGSP = new SaleOutGSPVouch(); saleoutGSP.U8Details = new List <GSPVouchDetail>(); saleoutGSP.OperateDetails = new List <GSPVouchDetail>(); foreach (DataRow dr in Details.Tables[0].Rows) { saleoutGSP.U8Details.Add(new GSPVouchDetail(dr)); } saleoutGSP.CDEFINE2 = saleoutGSP.U8Details[0].cdefine2; saleoutGSP.CDEFINE3 = saleoutGSP.U8Details[0].cdefine3; saleoutGSP.CDEFINE7 = saleoutGSP.U8Details[0].cdefine7; saleoutGSP.CDEFINE11 = saleoutGSP.U8Details[0].cdefine11; return(true); } else { throw new Exception("获取销售出库单失败"); return(false); } } }
public frmGSPList(SaleOutGSPVouch sv) { InitializeComponent(); if (sv.OperateDetails == null || sv.OperateDetails.Count < 1) { return; } this.sv = sv; DataGridTableStyle dts = new DataGridTableStyle(); DataGridTextBoxColumn dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "仓库名称"; dtbc.MappingName = "cwhname"; dtbc.Width = 120; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "存货编码"; dtbc.MappingName = "cinvcode"; dtbc.Width = 80; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "存货名称"; dtbc.MappingName = "cinvname"; dtbc.Width = 90; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "批号"; dtbc.MappingName = "cbatch"; dtbc.Width = 100; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "货位"; dtbc.MappingName = "cposition"; dtbc.Width = 70; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "数量"; dtbc.MappingName = "iquantity"; dtbc.Width = 70; dtbc.Format = "F2"; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "扫描数量"; dtbc.MappingName = "FQUANTITY"; dtbc.Width = 70; dtbc.Format = "F2"; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "规格"; dtbc.MappingName = "cinvstd"; dtbc.Width = 90; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "产地"; dtbc.MappingName = "cinvdefine6"; dtbc.Width = 100; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "计量单位"; dtbc.MappingName = "cinvm_unit"; dtbc.Width = 70; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "保质期"; dtbc.MappingName = "imassdate"; dtbc.Width = 70; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "生产日期"; dtbc.MappingName = "dmadedate"; dtbc.Width = 100; dtbc.Format = "yyyy-MM-dd"; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "有效期至"; dtbc.MappingName = "CVALDATES"; dtbc.Width = 100; dtbc.Format = "yyyy-MM-dd"; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "失效日期"; dtbc.MappingName = "dvdate"; dtbc.Width = 100; dtbc.Format = "yyyy-MM-dd"; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "客户全称"; dtbc.MappingName = "cdefine11"; dtbc.Width = 120; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "客户简称"; dtbc.MappingName = "ccusabbname"; dtbc.Width = 120; dts.GridColumnStyles.Add(dtbc); dataGrid1.TableStyles.Add(dts); dataGrid1.RowHeadersVisible = true; dts.MappingName = sv.OperateDetails.GetType().Name; this.dataGrid1.DataSource = sv.OperateDetails; }