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