/// <summary>
/// 获得实体集数据
/// </summary>
void GetMessage()
{
m_lnqProductReleases = new ZL_ProductReleases();
m_lnqProductReleases.BillNo = txtBillNo.Text;
m_lnqProductReleases.BillStatus = lbDJZT.Text;
m_lnqProductReleases.FaultPhenomenon = txtFaultPhenomenon.Text;
m_lnqProductReleases.ProductCode = txtProductCode.Text;
m_lnqProductReleases.ProductModel = cmbEdition.Text;
m_lnqProductReleases.Remark = txtRemark.Text;
}
/// <summary>
/// 提交单据
/// </summary>
/// <param name="produtctReleases">LINQ实体集</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True,失败返回False</returns>
public bool SubmitBill(ZL_ProductReleases produtctReleases, out string error)
{
error = null;
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
try
{
var varData = from a in ctx.ZL_ProductReleases
where a.BillNo == produtctReleases.BillNo
select a;
ZL_ProductReleases lnqProductReleases = new ZL_ProductReleases();
if (varData.Count() == 0)
{
lnqProductReleases.BillNo = m_serverAssginBillNo.AssignNewNo(this, CE_BillTypeEnum.线不合格品放行单.ToString());
lnqProductReleases.BillStatus = "等待审核";
lnqProductReleases.FaultPhenomenon = produtctReleases.FaultPhenomenon;
lnqProductReleases.ProductCode = produtctReleases.ProductCode;
lnqProductReleases.ProductModel = produtctReleases.ProductModel;
lnqProductReleases.Proposer = BasicInfo.LoginName;
lnqProductReleases.ProposerDate = ServerTime.Time;
lnqProductReleases.Remark = produtctReleases.Remark;
ctx.ZL_ProductReleases.InsertOnSubmit(lnqProductReleases);
}
else if (varData.Count() == 1)
{
lnqProductReleases = varData.Single();
switch (lnqProductReleases.BillStatus)
{
case "新建单据":
lnqProductReleases.BillStatus = "等待审核";
lnqProductReleases.FaultPhenomenon = produtctReleases.FaultPhenomenon;
lnqProductReleases.ProductCode = produtctReleases.ProductCode;
lnqProductReleases.ProductModel = produtctReleases.ProductModel;
lnqProductReleases.Proposer = BasicInfo.LoginName;
lnqProductReleases.ProposerDate = ServerTime.Time;
lnqProductReleases.Remark = produtctReleases.Remark;
break;
case "等待审核":
lnqProductReleases.BillStatus = "等待批准";
lnqProductReleases.Auditing = BasicInfo.LoginName;
lnqProductReleases.AuditingDate = ServerTime.Time;
break;
case "等待批准":
lnqProductReleases.BillStatus = "已完成";
lnqProductReleases.Authorize = BasicInfo.LoginName;
lnqProductReleases.AuthorizeDate = ServerTime.Time;
break;
;
default:
break;
}
}
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
