/// <summary> /// 取消检测判定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnUnSubmit_Click(object sender, EventArgs e) { SCommBB commBB = new SCommBB(); BCheckBillBB checkBillBB = new BCheckBillBB(); try { bool isChecked = false; foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { string strArriveBillNo = "", strFinanceBillNo = "", strMaterialNo = ""; strArriveBillNo = this.grid.DataKeys[gvrow.RowIndex]["arriveBillNo"].ToString(); strFinanceBillNo = this.grid.DataKeys[gvrow.RowIndex]["financeBillNo"].ToString(); strMaterialNo = this.grid.DataKeys[gvrow.RowIndex]["materialNo"].ToString(); //更改检测单 BCheckBillData checkBillModel = checkBillBB.GetModel(Convert.ToInt32(chkId.ValidationGroup)); if (checkBillModel.instantState != "05" && checkBillModel.instantState != "06") { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"当前检测单未检测判定!\");", true); return; } isChecked = true; commBB.ExecuteSql("update dbo.BCheckBill set checkResult=null,checkEmpId=0,checkDt=null,instantState='04' where id=" + chkId.ValidationGroup); //更改箱检测结果 commBB.ExecuteSql("update dbo.BArrangeBillBox set checkResult=0,checkResultDt=null,checkResultEmpId=0 where arriveBillNo='" + strArriveBillNo + "' and financeBillNo='" + strFinanceBillNo + "' and materialNo='" + strMaterialNo + "'"); } } if (isChecked) { this.BindGrid(); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"请选择一条记录!\");", true); } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { commBB.Dispose(); checkBillBB.Dispose(); } }
/// <summary> /// 保存判断结果 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSaveRet_click(object sender, EventArgs e) { BCheckBillBB checkBillBB = new BCheckBillBB(); SCommBB commBB = new SCommBB(); try { HS.Model.BCheckBillData data = checkBillBB.GetModel(Convert.ToInt32(this.IdValue)); if (data.instantState == "04") { data.instantState = this.rdopass.Checked ? "05" : "06";//05 合格 06不合格 data.checkMark = this.txtMark.Text; data.checkDt = DateTime.Now.ToString(); data.checkEmpId = this.currentUser.empId; data.checkResult = this.rdopass.Checked ? "合格" : "不合格"; if (checkBillBB.ModifyRecord(data)) { bool checkResult = rdopass.Checked ? true : false; //更改所有箱的判定结果 commBB.ExecuteSql("update dbo.BArrangeBillBox set checkResult='" + checkResult + "',checkResultDt='" + System.DateTime.Now.ToString() + "',checkResultEmpId='" + this.currentUser.empId + "' where arriveBillNo='" + Request.QueryString["ano"] + "' and financeBillNo='" + Request.QueryString["fno"] + "' and materialNo='" + Request.QueryString["mno"] + "'"); this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"检测单判定录入成功!\");location.replace('BCheckBillListResult.aspx?itemNo=0402&pTypeNo=main');", true); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"检测单判定录入失败!\");", true); } } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"当前检测单已经判定完成!\");", true); } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { checkBillBB.Dispose(); commBB.Dispose(); } }
/// <summary> /// 数据保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { if (this.ValidataBillState()) { string strInfo = ""; bool isValidate = this.ValidatePageControlValue(out strInfo); if (isValidate) { BCheckBillBB checkBillBB = new BCheckBillBB(); BCheckBillBC checkBillBC = new BCheckBillBC(); try { BCheckBillData model = new BCheckBillData(); List<BCheckDetailData> listDetail = this.SetDetailApplyBillModel(); if (this.State == "1") { this.SetModel(ref model); model.checkBillNo = ""; model.isrtDt = DateTime.Now.ToString(); model.isrtEmpId = this.currentUser.empId; } else if (this.State == "2") { model = checkBillBB.GetModel(this.IdValue); this.SetModel(ref model); model.updtDt = DateTime.Now.ToString(); model.updtEmpId = this.currentUser.empId; } //保存检测单数据 checkBillBC.SavelData(model, listDetail, isReNew); Response.Write("<script laguage=\"javascript\">alert('保存成功,请及时提交检测单!');</script>");// "alert", "alert('订单保存成功,请及时提交订单!!');", true); Response.Redirect("BCheckBillList.aspx?&itemno=" + this.itemNo + "&pTypeNo=main", false); Response.Flush(); //this.IdValue = model.id; //this.State = "2"; //this.ShowInfo(this.IdValue); //this.DtResult = null; //this.BindDetailTable("old"); return; } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { checkBillBB.Dispose(); checkBillBC.Dispose(); //Response.Redirect("BCheckBillList.aspx?&itemno=" + this.itemNo + "&pTypeNo=main", false); } } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('" + strInfo + "');", true); } } }
/// <summary> /// 提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { bool retChecked = false; BCheckBillBB checkBillBB = new BCheckBillBB(); BCheckBillBC checkBillBC = new BCheckBillBC(); try { //获取选中的数据Id foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { retChecked = true; int id = int.Parse(chkId.ValidationGroup); BCheckBillData model = checkBillBB.GetModel(id); if (model.instantState == "01")//判断检测单是否已经提交,已经提交不允许提交 { //状态置为提交 model.commitDt = DateTime.Now.ToString(); model.commitEmpId = this.currentUser.empId; model.instantState = "02"; checkBillBC.CommitData(model); this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"提交成功!\");", true); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"检测单已经提交!\");", true); return; } } } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { checkBillBB.Dispose(); checkBillBC.Dispose(); } if (retChecked) { this.BindGrid(); } }
/// <summary> /// 修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnEdit_Click(object sender, EventArgs e) { BCheckBillBB checkBillBB = new BCheckBillBB(); try { foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { int id = int.Parse(chkId.ValidationGroup); BCheckBillData model = checkBillBB.GetModel(id); if (model.instantState == "01")//判断检测单是否已经提交,已经提交不允许再次修改 { Response.Redirect("BCheckBill.aspx?state=2&id=" + chkId.ValidationGroup + "&itemNo=" + this.itemNo + "&pTypeNo=edit", false); return; } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"当前检测单已经提交,不允许修改!\");", true); return; } } } this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"请选择一条记录!\");", true); return; } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { checkBillBB.Dispose(); } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDel_Click(object sender, EventArgs e) { bool retChecked = false; BCheckBillBB checkBillBB = new BCheckBillBB(); SCommBB comBB = new SCommBB(); try { //获取选中的数据Id foreach (GridViewRow gvrow in this.grid.Rows) { CheckBox chkId = (CheckBox)gvrow.FindControl("chkId"); if (chkId.Checked == true) { retChecked = true; int id = int.Parse(chkId.ValidationGroup); BCheckBillData model = checkBillBB.GetModel(id); if (model.instantState == "01")//判断检测单是否已经提交,已经提交不允许删除 { //删除主数据 checkBillBB.DeleteRecord(id); //删除明细 string strsql = "delete from BCheckDetail where checkBillId='" + id.ToString() + "'"; comBB.Query(strsql); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert(\"当前检测单已经提交,不允许删除!\");", true); return; } } } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true); return; } finally { checkBillBB.Dispose(); comBB.Dispose(); } if (retChecked) { this.BindGrid(); } }
public bool UpdateCheckBil(int checkBillId, int empId, string instantState, string checkResult, string checkmark, string checkDt, string arriveBillNo, string materialNo, string finaceBillNO) { //第一步 更新BcheckBill BCheckBillBB checkBillBB = new BCheckBillBB(); SCommBB commBB = new SCommBB(); HS.Model.BCheckBillData data = checkBillBB.GetModel(Convert.ToInt32(checkBillId)); try { if (data.instantState == "04") { data.instantState = instantState;//05是合格 06是不合格 data.checkMark = checkmark; data.checkDt = DateTime.Now.ToString(); data.checkEmpId = empId; data.checkResult = checkResult;//直接是合格或是不合格 if (checkBillBB.ModifyRecord(data)) { bool checkResultNew; if (checkResult == "合格") checkResultNew = true; else checkResultNew = false; //第二步 更新BarrangeBillBox //更改所有箱的判定结果 commBB.ExecuteSql("update dbo.BArrangeBillBox set checkResult='" + checkResultNew + "',checkResultDt='" + System.DateTime.Now.ToString() + "',checkResultEmpId='" + empId + "' where arriveBillNo='" + arriveBillNo + "' and financeBillNo='" + finaceBillNO + "' and materialNo='" + materialNo + "'"); } } return true; } catch { return false; } finally { checkBillBB.Dispose(); commBB.Dispose(); } }
public bool FinishCheckBill(int checkBillId) { BCheckBillBB checkBillBB = new BCheckBillBB(); try { BCheckBillData checkBillModel = new BCheckBillData(); checkBillModel = checkBillBB.GetModel(checkBillId); checkBillModel.instantState = "04"; return checkBillBB.ModifyRecord(checkBillModel); } finally { checkBillBB.Dispose(); } }