/// <summary>
/// 获取信息
/// </summary>
void GetInfo()
{
m_lnqBill = new S_ProductReturnBill();
m_lnqBill.BillNo = txtBillNo.Text;
m_lnqBill.BillStatus = lbBillStatus.Text;
m_lnqBill.Remark = txtBillRemark.Text;
m_lnqBill.StorageID = cmbStorage.SelectedValue.ToString();
m_lnqBill.DeptCode = txtDepartment.Tag.ToString();
m_dtList = (DataTable)dataGridView1.DataSource;
}
/// <summary>
/// 确认单据
/// </summary>
/// <param name="billNo">单据号</param>
/// <param name="list">明细信息</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True,失败返回False</returns>
public bool AffirmBill(string billNo, DataTable list, out string error)
{
error = null;
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
ctx.Connection.Open();
ctx.Transaction = ctx.Connection.BeginTransaction();
try
{
var varData = from a in ctx.S_ProductReturnBill
where a.BillNo == billNo
select a;
S_ProductReturnBill tempBill = new S_ProductReturnBill();
if (varData.Count() == 1)
{
tempBill = varData.Single();
if (tempBill.BillStatus != ProductLendReturnBillStatus.等待确认.ToString())
{
throw new Exception("单据状态错误，请重新确认");
}
tempBill.BillStatus = ProductLendReturnBillStatus.单据已完成.ToString();
tempBill.Affirm = BasicInfo.LoginName;
tempBill.AffirmDate = ServerTime.Time;
}
else
{
throw new Exception("数据不唯一,请重新确认");
}
ListControl(ctx, tempBill.BillNo, list);
ctx.SubmitChanges();
OpertaionDetailAndStock(ctx, tempBill, list);
ctx.SubmitChanges();
ctx.Transaction.Commit();
return(true);
}
catch (Exception ex)
{
ctx.Transaction.Rollback();
error = ex.Message;
return(false);
}
}
/// <summary>
/// 单据赋值
/// </summary>
/// <param name="bill">单据数据集</param>
/// <param name="returnBill">返回单据</param>
void AssignmentValue(S_ProductReturnBill bill, ref S_ProductReturnBill returnBill)
{
returnBill.BillNo = bill.BillNo;
returnBill.BillStatus = ProductLendReturnBillStatus.等待审核.ToString();
returnBill.DeptCode = bill.DeptCode;
returnBill.StorageID = bill.StorageID;
returnBill.Remark = bill.Remark;
returnBill.Proposer = BasicInfo.LoginName;
returnBill.ProposerDate = ServerTime.Time;
returnBill.Affirm = null;
returnBill.AffirmDate = null;
returnBill.Audit = null;
returnBill.AuditDate = null;
}
/// <summary>
/// 根据单据信息操作账务信息与库存信息
/// </summary>
/// <param name="dataContext">数据上下文</param>
/// <param name="bill">单据信息</param>
/// <param name="dataTable">明细信息集合</param>
void OpertaionDetailAndStock(DepotManagementDataContext dataContext, S_ProductReturnBill bill, DataTable dataTable)
{
IFinancialDetailManagement serverDetail =
ServerModule.ServerModuleFactory.GetServerModule <IFinancialDetailManagement>();
foreach (DataRow dr in dataTable.Rows)
{
S_FetchGoodsDetailBill detailInfo = AssignDetailInfo(dataContext, bill, dr);
if (detailInfo == null)
{
throw new Exception("获取账务信息或者库存信息失败");
}
serverDetail.ProcessFetchGoodsDetail(dataContext, detailInfo, null);
}
}
public 还货单明细(string billNo)
{
InitializeComponent();
m_strBillNo = billNo;
if (m_strBillNo != null)
{
m_lnqBill = m_serverReturn.GetBillSingle(m_strBillNo);
}
m_billNoControl = new BillNumberControl(CE_BillTypeEnum.还货单.ToString(), m_serverReturn);
m_billMessageServer.BillType = CE_BillTypeEnum.还货单.ToString();
cmbStorage.DataSource = UniversalFunction.GetStorageTb();
cmbStorage.DisplayMember = "StorageName";
cmbStorage.ValueMember = "StorageID";
}
/// <summary>
/// 删除单据
/// </summary>
/// <param name="billNo">单据号</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True,失败返回False</returns>
public bool DeleteBill(string billNo, out string error)
{
error = null;
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
try
{
var varData = from a in ctx.S_ProductReturnBill
where a.BillNo == billNo
select a;
if (varData.Count() != 1)
{
throw new Exception("数据不唯一");
}
else
{
S_ProductReturnBill tempBill = varData.Single();
if (tempBill.BillStatus == ProductLendReturnBillStatus.单据已完成.ToString())
{
throw new Exception("单据已完成，无法删除");
}
if (tempBill.Proposer != BasicInfo.LoginName)
{
throw new Exception("只有申请人本人才能删除单据");
}
}
ctx.S_ProductReturnBill.DeleteAllOnSubmit(varData);
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 审核单据
/// </summary>
/// <param name="billNo">单据号</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True,失败返回False</returns>
public bool AuditBill(string billNo, out string error)
{
error = null;
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
try
{
var varData = from a in ctx.S_ProductReturnBill
where a.BillNo == billNo
select a;
if (varData.Count() != 1)
{
throw new Exception("数据错误，请重新确认");
}
else
{
S_ProductReturnBill tempBill = varData.Single();
if (tempBill.BillStatus != ProductLendReturnBillStatus.等待审核.ToString())
{
throw new Exception("单据状态错误，请重新确认");
}
tempBill.BillStatus = ProductLendReturnBillStatus.等待确认.ToString();
tempBill.Audit = BasicInfo.LoginName;
tempBill.AuditDate = ServerTime.Time;
ctx.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 申请单据
/// </summary>
/// <param name="bill">单据信息</param>
/// <param name="list">明细信息</param>
/// <param name="error">错误信息</param>
/// <returns>成功返回True,失败返回False</returns>
public bool ProposeBill(S_ProductReturnBill bill, DataTable list, out string error)
{
error = null;
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
S_ProductReturnBill tempBill = new S_ProductReturnBill();
var varData = from a in ctx.S_ProductReturnBill
where a.BillNo == bill.BillNo
select a;
switch (varData.Count())
{
case 0:
AssignmentValue(bill, ref tempBill);
ctx.S_ProductReturnBill.InsertOnSubmit(tempBill);
break;
case 1:
tempBill = varData.Single();
AssignmentValue(bill, ref tempBill);
break;
default:
throw new Exception("数据错误，请重新确认");
}
ListControl(ctx, tempBill.BillNo, list);
ctx.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 赋值账务信息
/// </summary>
/// <param name="dataContext">数据上下文</param>
/// <param name="tempBill">单据信息</param>
/// <param name="dr">明细信息</param>
/// <returns>返回账务信息对象</returns>
S_FetchGoodsDetailBill AssignDetailInfo(DepotManagementDataContext dataContext, S_ProductReturnBill tempBill, DataRow dr)
{
S_FetchGoodsDetailBill detailBill = new S_FetchGoodsDetailBill();
detailBill.ID = Guid.NewGuid();
detailBill.FetchBIllID = tempBill.BillNo;
detailBill.BillTime = ServerTime.Time;
detailBill.FetchCount = Convert.ToDecimal(dr["数量"]);
detailBill.GoodsID = Convert.ToInt32(dr["物品ID"]);
detailBill.BatchNo = dr["批次号"].ToString();
detailBill.UnitPrice = 0;
detailBill.Price = detailBill.UnitPrice * (decimal)detailBill.FetchCount;
detailBill.Provider = dr["供应商"].ToString();
detailBill.FillInPersonnel = tempBill.Proposer;
detailBill.FinanceSignatory = null;
detailBill.DepartDirector = tempBill.Audit;
detailBill.DepotManager = tempBill.Affirm;
detailBill.OperationType = (int)CE_SubsidiaryOperationType.还货;
detailBill.Remark = dr["备注"].ToString();
detailBill.FillInDate = tempBill.ProposerDate;
detailBill.StorageID = tempBill.StorageID;
return(detailBill);
}
