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