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