/// <summary>
/// 改变BILL的单据状态为 等待审核
/// </summary>
/// <param name="yearAndMonth">年月字符串</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>改变成功返回True，改变失败返回False</returns>
public bool UpdateBillStatus(string yearAndMonth, out string error)
{
error = null;
try
{
DepotManagementDataContext dataContext = CommentParameter.DepotDataContext;
var varData = from a in dataContext.B_WebForOrderFormBill
where a.Ny == yearAndMonth
select a;
if (varData.Count() != 1)
{
error = "数据为空或者不唯一";
return(false);
}
else
{
B_WebForOrderFormBill lnqBill = varData.Single();
lnqBill.DJZT = "等待审核";
}
dataContext.SubmitChanges();
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 修改单据状态
/// </summary>
/// <param name="yearAndMonth">操作年月字符串</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>修改成功返回True，修改失败返回False</returns>
public bool UpdateBill(string yearAndMonth, out string error)
{
try
{
error = null;
DepotManagementDataContext dataContext = CommentParameter.DepotDataContext;
var varData = from a in dataContext.B_WebForOrderFormBill
where a.Ny == yearAndMonth
select a;
if (varData.Count() != 1)
{
error = "数据不唯一或者为空";
return(false);
}
else
{
B_WebForOrderFormBill lnqBill = varData.Single();
switch (lnqBill.DJZT)
{
case "等待审核":
lnqBill.DJZT = "等待发布";
lnqBill.AuthorizePersonnel = BasicInfo.LoginName;
lnqBill.AuthorizeTime = ServerTime.Time;
var varOrderFormList = from a in dataContext.B_WebForOrderFormList
where a.Ny == yearAndMonth
select a;
foreach (var item in varOrderFormList)
{
item.ChangeFlag = false;
}
break;
case "等待发布":
lnqBill.DJZT = "单据已完成";
lnqBill.IssuePersonnel = BasicInfo.LoginName;
lnqBill.IssueTime = ServerTime.Time;
//插入WINFROM 订单表
if (!InsertWinFormOrderForm(dataContext, yearAndMonth, out error))
{
return(false);
}
dataContext.SubmitChanges();
//插入WEB 订单表
if (!InsertWebOrderForm(yearAndMonth, out error))
{
return(false);
}
break;
default:
break;
}
dataContext.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
