private void RestoreCheckInfo(int ID) { EquipmentCheckInfo equipmentCheckInfo = new EquipmentCheckInfo(); equipmentCheckInfo = EquipmentCheckAction.GetSingleEquipmentCheckInfo(ID); this.txtCode.Text = equipmentCheckInfo.CheckBillCode; this.txtTime.Text = equipmentCheckInfo.CheckDate.ToString("yyyy-MM-dd"); this.txtDept.Text = equipmentCheckInfo.CheckDept; this.txtPerson.Text = equipmentCheckInfo.CheckPerson; this.txtRemark.Text = equipmentCheckInfo.Remark; this.txtDescript.Text = equipmentCheckInfo.ResultDescript; if (equipmentCheckInfo.InOrOut == 0) { this.RbtTypeIn.Checked = true; } else { this.RbtTypeOut.Checked = true; } if (equipmentCheckInfo.Result == 1) { this.RbtResultOk.Checked = true; } else { this.RbtResultNo.Checked = true; } this.ViewState["EQUIPMENTUNIQUECODE"] = equipmentCheckInfo.EquipmentUniqueCode; }
protected void btnAdd_Click(object sender, EventArgs e) { if ((int)this.ViewState["CHECKID"] == 0) { if (EquipmentCheckAction.AddEquipmentCheck(this.GatherEquipmentCheckInfo()) != 1) { this.js.Text = "alert('增加失败!');"; return; } EquipmentCheckInfo equipmentCheckInfo = this.GatherEquipmentCheckInfo(); EquipmentInfo singleEquipmentInfo = EquipmentAction.GetSingleEquipmentInfo(equipmentCheckInfo.EquipmentUniqueCode); string mes = string.Concat(new string[] { "设备检定通知:编号为", singleEquipmentInfo.EquipmentManCode, "的", singleEquipmentInfo.EquipmentName, ",本次检定日期于一个月后到期。" }); DateTime time = equipmentCheckInfo.CheckDate.AddMonths(singleEquipmentInfo.CheckCycle).AddMonths(-1); this.getOrganiger(equipmentCheckInfo.EquipmentUniqueCode.ToString(), mes, base.UserCode.ToString(), time); this.js.Text = "alert('增加成功!');window.returnValue=true;window.close();"; return; } else { if (EquipmentCheckAction.EditEquipmentCheck(this.GatherEquipmentCheckInfo()) != 1) { this.js.Text = "alert('更新失败!');"; return; } this.js.Text = "alert('更新成功!');window.returnValue=true;window.close();"; return; } }
public static int EditEquipmentCheck(EquipmentCheckInfo ec) { object obj2 = (" BEGIN " + " UPDATE Ent_Ept_Checkinfo ") + " SET CheckDept = '" + ec.CheckDept + "',"; object obj3 = string.Concat(new object[] { obj2, " InOrOut = '", ec.InOrOut, "',CheckBillCode = '", ec.CheckBillCode, "'," }); string str2 = string.Concat(new object[] { obj3, " Result = '", ec.Result, "',CheckDate = '", ec.CheckDate, "'," }); object obj4 = (str2 + " CheckPerson = '" + ec.CheckPerson + "',ResultDescript = '" + ec.ResultDescript + "',") + " Remark = '" + ec.Remark + "' "; return(publicDbOpClass.ExecSqlString(((((string.Concat(new object[] { obj4, " WHERE NoteSequenceID = '", ec.NoteSequenceID, "' " }) + " update Ent_Ept_CheckInfo set IsLast = 0 where (EquipmentUniqueCode = '" + ec.EquipmentUniqueCode.ToString() + "') ") + " UPDATE Ent_Ept_Checkinfo set IsLast = 1 ") + " where (NoteSequenceId = (select max(NoteSequenceId) from Ent_Ept_CheckInfo where (EquipmentUniqueCode = '" + ec.EquipmentUniqueCode.ToString() + "')and(CheckDate = ") + " (select max(CheckDate) from Ent_Ept_CheckInfo where EquipmentUniqueCode = '" + ec.EquipmentUniqueCode.ToString() + "')))) ") + " END")); }
public static int AddEquipmentCheck(EquipmentCheckInfo ec) { string str = ""; str = " BEGIN "; object obj2 = str + " INSERT INTO Ent_Ept_Checkinfo (EquipmentUniqueCode,InOrOut,CheckBillCode,Result,CheckDate, " + " CheckDept,CheckPerson,ResultDescript,Remark,IsLast) "; object obj3 = string.Concat(new object[] { obj2, " VALUES ('", ec.EquipmentUniqueCode.ToString(), "','", ec.InOrOut, "','", ec.CheckBillCode, "','", ec.Result, "', " }); return(publicDbOpClass.ExecSqlString(((((string.Concat(new object[] { obj3, " '", ec.CheckDate, "','", ec.CheckDept, "','", ec.CheckPerson, "','", ec.ResultDescript, "','", ec.Remark, "','", ec.IsLast, "') " }) + " update Ent_Ept_CheckInfo set IsLast = 0 where (EquipmentUniqueCode = '" + ec.EquipmentUniqueCode.ToString() + "') ") + " UPDATE Ent_Ept_Checkinfo set IsLast = 1 ") + " where (NoteSequenceId = (select max(NoteSequenceId) from Ent_Ept_CheckInfo where (EquipmentUniqueCode = '" + ec.EquipmentUniqueCode.ToString() + "')and(CheckDate = ") + " (select max(CheckDate) from Ent_Ept_CheckInfo where EquipmentUniqueCode = '" + ec.EquipmentUniqueCode.ToString() + "')))) ") + " END ")); }
protected void btnDel_Click(object sender, EventArgs e) { EquipmentCheckInfo equipmentCheckInfo = new EquipmentCheckInfo(); equipmentCheckInfo.NoteSequenceID = Convert.ToInt32(this.hdnChickId.Value); if (EquipmentCheckAction.DelEqiupmentCheckInfo(Convert.ToInt32(this.hdnChickId.Value)) != 1) { this.js.Text = "alert('删除数据出错!');"; } this.BindDataGrid(); }
public static int DelEqiupmentCheckInfo(int noteSequenceID) { EquipmentCheckInfo singleEquipmentCheckInfo = new EquipmentCheckInfo(); singleEquipmentCheckInfo = GetSingleEquipmentCheckInfo(noteSequenceID); string str = ""; str = " begin "; str = str + " delete from Ent_Ept_Checkinfo where NoteSequenceID = " + noteSequenceID; if (singleEquipmentCheckInfo.IsLast == 1) { str = ((str + " UPDATE Ent_Ept_Checkinfo set IsLast = 1 ") + " where (NoteSequenceId = (select max(NoteSequenceId) from Ent_Ept_CheckInfo where (EquipmentUniqueCode = '" + singleEquipmentCheckInfo.EquipmentUniqueCode.ToString() + "')and(CheckDate = ") + " (select max(CheckDate) from Ent_Ept_CheckInfo where EquipmentUniqueCode = '" + singleEquipmentCheckInfo.EquipmentUniqueCode.ToString() + "')))) "; } return(publicDbOpClass.ExecSqlString(str + " end ")); }