/// <summary>
/// 质管处理，修改表信息
/// </summary>
/// <param name="djh">单据号</param>
/// <param name="disposeName">处理人</param>
/// <param name="dispose">处理方案</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>成功返回True</returns>
public bool HandleBill(string djh, string disposeName, string dispose, out string error)
{
error = "";
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var vardata = from a in dataContxt.S_QuarantineBill
where a.Bill_ID == djh
select a;
if (vardata.Count() != 1)
{
error = "数据不正确！";
return(false);
}
else
{
S_QuarantineBill list = vardata.Single();
list.DisposeName = disposeName;
list.DisposeTime = ServerTime.Time;
list.DisposeSol = dispose;
dataContxt.SubmitChanges();
return(true);
}
}
/// <summary>
/// 根据单据号删除(改变删除状态)
/// </summary>
/// <param name="djh">单据号</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>返回是否成功</returns>
public bool DeleteBill(string djh, out string error)
{
error = "";
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var delete = from a in dataContxt.S_QuarantineBill
where a.Bill_ID == djh
select a;
if (delete.Count() < 1)
{
error = "没有此单据！";
return(false);
}
else
{
S_QuarantineBill quarantinebill = delete.Single();
quarantinebill.DeleteFlag = true;
dataContxt.SubmitChanges();
return(true);
}
}
/// <summary>
/// 仓管审核，修改主表状态
/// </summary>
/// <param name="billID">单据号</param>
/// <param name="handle">是否处理标志 字符串</param>
/// <param name="status">单据状态</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>成功返回True，失败返回False</returns>
public bool AuditingBill(string billID, string handle, string status, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var verify = from a in dataContxt.S_QuarantineBill
where a.Bill_ID == billID
select a;
if (verify.Count() != 1)
{
error = "数据信息有误";
return(false);
}
else
{
S_QuarantineBill dataMain = verify.Single();
dataMain.Status = status;
dataMain.IsHandle = handle;
dataMain.CheckMan = BasicInfo.LoginName;
dataMain.CheckTime = ServerTime.Time;
dataContxt.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 添加主表信息
/// </summary>
/// <param name="quarantine">S_QuarantineBill对象</param>
/// <param name="error">出错时返回错误信息，无错时返回null</param>
/// <returns>成功返回True，失败返回False</returns>
public bool AddBill(S_QuarantineBill quarantine, out string error)
{
error = "";
try
{
DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext;
var dataMain = from a in dataContxt.S_QuarantineBill
where a.Bill_ID == quarantine.Bill_ID
select a;
if (dataMain.Count() > 0)
{
S_QuarantineBill q_bill = dataMain.Single();
if (q_bill.Status == "已保存" && q_bill.Status != "已解封")
{
q_bill.Storage = quarantine.Storage;
q_bill.Remark = quarantine.Remark;
q_bill.CheckMan = quarantine.CheckMan;
q_bill.CheckTime = quarantine.CheckTime;
q_bill.Description = quarantine.Description;
q_bill.Department = quarantine.Department;
q_bill.DeleteFlag = false;
dataContxt.SubmitChanges();
return(true);
}
else
{
error = "单据已经解封，不能进行此操作！";
return(false);
}
}
else
{
S_QuarantineBill lnqQuarantineAdd = new S_QuarantineBill();
lnqQuarantineAdd.Bill_ID = quarantine.Bill_ID;
lnqQuarantineAdd.Storage = quarantine.Storage;
lnqQuarantineAdd.Remark = quarantine.Remark;
lnqQuarantineAdd.LRRY = quarantine.LRRY;
lnqQuarantineAdd.LRRQ = quarantine.LRRQ;
lnqQuarantineAdd.Description = quarantine.Description;
lnqQuarantineAdd.Department = quarantine.Department;
lnqQuarantineAdd.DeleteFlag = false;
lnqQuarantineAdd.Status = "已保存";
lnqQuarantineAdd.IsHandle = quarantine.IsHandle;
dataContxt.S_QuarantineBill.InsertOnSubmit(lnqQuarantineAdd);
dataContxt.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
/// <summary>
/// 保存信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (m_strBillStatus == "已解封" || m_strHandleAll == "全部处理" || m_strBillStatus == "已处理")
{
MessageDialog.ShowPromptMessage("单据不能进行此操作！");
return;
}
if (txtQuarantine.Text == "")
{
MessageDialog.ShowPromptMessage("请填写隔离原因！");
return;
}
string strDJH = txtBill_ID.Text;
DataTable dt = (DataTable)dgv_Main.DataSource;
if (dt.Rows.Count > 0)
{
S_QuarantineBill dataMain = new S_QuarantineBill();
dataMain.Bill_ID = strDJH;
dataMain.LRRY = txtLRRY.Text;
dataMain.LRRQ = ServerTime.Time;
dataMain.Remark = txtRemarkAll.Text;
dataMain.Storage = cmbStorage.Text;
dataMain.Department = txtLRBM.Text;
dataMain.Description = txtQuarantine.Text;
dataMain.IsHandle = "未完成";
bool DataMainOk = m_serverQuarantine.AddBill(dataMain, out m_strErr);
if (!DataMainOk)
{
MessageDialog.ShowErrorMessage(m_strErr);
return;
}
else
{
if (!m_serverQuarantine.AddList(dt, txtBill_ID.Text, out m_strErr))
{
MessageDialog.ShowErrorMessage(m_strErr);
return;
}
}
MessageDialog.ShowPromptMessage("单据号【 " + strDJH + " 】保存成功！");
this.Close();
}
else
{
MessageDialog.ShowPromptMessage("请选择产品信息");
return;
}
}
catch (Exception ex)
{
MessageDialog.ShowErrorMessage(ex.Message);
return;
}
}
