public static bool GetSaleBack(string ccode, out SaleBackGSPVouch salebackGSP, out string errMsg) { Common co = Common.GetInstance(); errMsg = ""; DataSet Details = null; co.Service.GetSaleBack(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) { salebackGSP = new SaleBackGSPVouch(); salebackGSP.U8Details = new List <SaleBackGSPDetail>(); salebackGSP.OperateDetails = new List <SaleBackGSPDetail>(); foreach (DataRow dr in Details.Tables[0].Rows) { salebackGSP.U8Details.Add(new SaleBackGSPDetail(dr)); } salebackGSP.ICODE = salebackGSP.U8Details[0].dlid; salebackGSP.CCODE = salebackGSP.U8Details[0].cdlcode; salebackGSP.DARVDATE = salebackGSP.U8Details[0].ddate; return(true); } else { throw new Exception("获取销售退货单失败"); return(false); } } }
public static int SaveSaleBackGSP(SaleBackGSPVouch dl, out string errMsg) { Common co = Common.GetInstance(); errMsg = ""; try { U8Business.Service.SaleBackGSPVouch saleoutGSP = new U8Business.Service.SaleBackGSPVouch(); saleoutGSP.CMAKER = dl.CMAKER; saleoutGSP.ICODE = dl.ICODE; saleoutGSP.CCODE = dl.CCODE; saleoutGSP.DARVDATE = dl.DARVDATE; saleoutGSP.OperateDetails = new U8Business.Service.SaleBackGSPDetail[dl.OperateDetails.Count]; int i = 0; foreach (SaleBackGSPDetail dd in dl.OperateDetails) { U8Business.Service.SaleBackGSPDetail detail = new U8Business.Service.SaleBackGSPDetail(); detail.cinvcode = dd.cinvcode; detail.FQUANTITY = dd.FQUANTITY; detail.FARVQUANTITY = dd.FARVQUANTITY; detail.DPRODATE = dd.DPRODATE; detail.FQUANTITY = dd.FQUANTITY; detail.DVDATE = dd.DVDATE; detail.CVALDATE = dd.CVALDATE; //detail.DDATE_T = dd.DDATE_T; detail.FELGQUANTITY = dd.ScanCount; detail.CBATCH = dd.CBATCH; detail.CCUSCODE = dd.CCUSCODE; detail.CDEFINE22 = dd.CDEFINE22; detail.ICODE_T = dd.ICODE_T; detail.cwhcode = dd.cwhcode; detail.imassDate = dd.imassDate; detail.DVDATE = dd.DVDATE; detail.ddate = dd.ddate; detail.COUTINSTANCE = dd.COUTINSTANCE; detail.ccusname = dd.ccusname; saleoutGSP.OperateDetails[i] = detail; i++; } int rt = co.Service.SaveSaleBackGSP(saleoutGSP, Common.CurrentUser.ConnectionString, 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 frmSaleBackGSP() { InitializeComponent(); salebackgsp = new SaleBackGSPVouch(); lblInvName.Text = ""; lblInvStd.Text = ""; lblcBatch.Text = ""; lblProAddress.Text = ""; lblEnterprise.Text = ""; lblProDate.Text = ""; lblValidDate.Text = ""; lblScanedNum.Text = ""; this.cmbWarehouse.DataSource = Common.s_Warehouse; this.cmbWarehouse.ValueMember = "cwhcode"; this.cmbWarehouse.DisplayMember = "cwhname"; this.cmbCoutinstance.SelectedIndex = 0; }
public int SaveSaleBackGSP(SaleBackGSPVouch dl, string connectionString, string accid, string year, out string errMsg) { return(GSPVouchProcess.SaveSaleBackGSP(dl, connectionString, accid, year, out errMsg)); }
public frmSaleBackGSPList(SaleBackGSPVouch 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 = 80; 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 = 90; 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 = "CDEFINE22"; 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 = "FQUANTITY"; dtbc.Width = 70; dtbc.Format = "F2"; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "扫描数量"; dtbc.MappingName = "ScanCount"; dtbc.Width = 70; dtbc.Format = "F2"; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "生产日期"; dtbc.MappingName = "DPRODATE"; dtbc.Width = 100; dtbc.Format = "yyyy-MM-dd"; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "有效期至"; dtbc.MappingName = "CVALDATE"; 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 = "cvenabbname"; dtbc.Width = 120; dts.GridColumnStyles.Add(dtbc); dtbc = new DataGridTextBoxColumn(); dtbc.HeaderText = "客户全称"; dtbc.MappingName = "ccusname"; 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; }