/// <summary> /// 根据主键删除机具设备 /// </summary> /// <param name="specialEquipmentId"></param> public static void DeleteSpecialEquipmentById(string specialEquipmentId) { Model.SUBHSSEDB db = Funs.DB; Model.Base_SpecialEquipment specialEquipment = db.Base_SpecialEquipment.FirstOrDefault(e => e.SpecialEquipmentId == specialEquipmentId); if (specialEquipment != null) { db.Base_SpecialEquipment.DeleteOnSubmit(specialEquipment); db.SubmitChanges(); } }
/// <summary> /// 修改机具设备 /// </summary> /// <param name="specialEquipment"></param> public static void UpdateSpecialEquipment(Model.Base_SpecialEquipment specialEquipment) { Model.SUBHSSEDB db = Funs.DB; Model.Base_SpecialEquipment newSpecialEquipment = db.Base_SpecialEquipment.FirstOrDefault(e => e.SpecialEquipmentId == specialEquipment.SpecialEquipmentId); if (newSpecialEquipment != null) { newSpecialEquipment.SpecialEquipmentCode = specialEquipment.SpecialEquipmentCode; newSpecialEquipment.SpecialEquipmentName = specialEquipment.SpecialEquipmentName; newSpecialEquipment.Remark = specialEquipment.Remark; newSpecialEquipment.IsSpecial = specialEquipment.IsSpecial; newSpecialEquipment.SpecialEquipmentType = specialEquipment.SpecialEquipmentType; db.SubmitChanges(); } }
/// <summary> /// 添加机具设备 /// </summary> /// <param name="specialEquipment"></param> public static void AddSpecialEquipment(Model.Base_SpecialEquipment specialEquipment) { Model.SUBHSSEDB db = Funs.DB; Model.Base_SpecialEquipment newSpecialEquipment = new Model.Base_SpecialEquipment { SpecialEquipmentId = specialEquipment.SpecialEquipmentId, SpecialEquipmentCode = specialEquipment.SpecialEquipmentCode, SpecialEquipmentName = specialEquipment.SpecialEquipmentName, Remark = specialEquipment.Remark, IsSpecial = specialEquipment.IsSpecial, SpecialEquipmentType = specialEquipment.SpecialEquipmentType, }; db.Base_SpecialEquipment.InsertOnSubmit(newSpecialEquipment); db.SubmitChanges(); }
/// <summary> /// 保存按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { string strRowID = hfFormID.Text; Model.Base_SpecialEquipment specialEquipment = new Model.Base_SpecialEquipment { SpecialEquipmentCode = this.txtSpecialEquipmentCode.Text.Trim(), SpecialEquipmentName = this.txtSpecialEquipmentName.Text.Trim() }; if (this.ckbIsSpecial.Checked == true) { specialEquipment.IsSpecial = true; } else { specialEquipment.IsSpecial = false; } if (this.drpType.SelectedValue != Const._Null) { specialEquipment.SpecialEquipmentType = this.drpType.SelectedValue; } else { specialEquipment.SpecialEquipmentType = null; } specialEquipment.Remark = txtRemark.Text.Trim(); if (string.IsNullOrEmpty(strRowID)) { specialEquipment.SpecialEquipmentId = SQLHelper.GetNewID(typeof(Model.Base_SpecialEquipment)); BLL.SpecialEquipmentService.AddSpecialEquipment(specialEquipment); BLL.LogService.AddSys_Log(this.CurrUser, specialEquipment.SpecialEquipmentCode, specialEquipment.SpecialEquipmentId, BLL.Const.SpecialEquipmentMenuId, BLL.Const.BtnAdd); } else { specialEquipment.SpecialEquipmentId = strRowID; BLL.SpecialEquipmentService.UpdateSpecialEquipment(specialEquipment); BLL.LogService.AddSys_Log(this.CurrUser, specialEquipment.SpecialEquipmentCode, specialEquipment.SpecialEquipmentId, BLL.Const.SpecialEquipmentMenuId, BLL.Const.BtnModify); } this.SimpleForm1.Reset(); // 重新绑定表格,并点击当前编辑或者新增的行 BindGrid(); PageContext.RegisterStartupScript(String.Format("F('{0}').selectRow('{1}');", Grid1.ClientID, specialEquipment.SpecialEquipmentId)); }
private void getQRUrl() { if (!string.IsNullOrEmpty(Request.Params["PersonId"])) { ////人员 var person = BLL.PersonService.GetPersonById(Request.Params["PersonId"]); if (person != null && !string.IsNullOrEmpty(person.QRCodeAttachUrl)) { this.imgPhoto.Src = "../" + person.QRCodeAttachUrl; this.lbWedCode.Text = "人员卡号:" + person.CardNo; this.lbWedName.Text = "人员姓名:" + person.PersonName; Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(person.UnitId); string unitName = string.Empty; if (unit != null) { unitName = unit.UnitName; } this.lbUnitName.Text = "人员单位:" + unitName; } } else if (!string.IsNullOrEmpty(Request.Params["EquipmentQualityId"])) { ////设备 var equipmentQuality = BLL.EquipmentQualityService.GetEquipmentQualityById(Request.Params["EquipmentQualityId"]); if (equipmentQuality != null && !string.IsNullOrEmpty(equipmentQuality.QRCodeAttachUrl)) { this.imgPhoto.Src = "../" + equipmentQuality.QRCodeAttachUrl; this.lbWedCode.Text = "出厂编号:" + equipmentQuality.FactoryCode; this.lbWedName.Text = "设备名称:" + equipmentQuality.EquipmentQualityName; Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(equipmentQuality.UnitId); string unitName = string.Empty; if (unit != null) { unitName = unit.UnitName; } this.lbUnitName.Text = "所属单位:" + unitName; } } else if (!string.IsNullOrEmpty(Request.Params["GeneralEquipmentQualityId"])) { ///一般设备 var generalEquipmentQuality = BLL.GeneralEquipmentQualityService.GetGeneralEquipmentQualityById(Request.Params["GeneralEquipmentQualityId"]); if (generalEquipmentQuality != null && !string.IsNullOrEmpty(generalEquipmentQuality.QRCodeAttachUrl)) { this.imgPhoto.Src = "../" + generalEquipmentQuality.QRCodeAttachUrl; this.lbWedCode.Text = "编号:" + BLL.CodeRecordsService.ReturnCodeByDataId(generalEquipmentQuality.GeneralEquipmentQualityId); string equipmentTypeName = string.Empty; Model.Base_SpecialEquipment equipmentType = BLL.SpecialEquipmentService.GetSpecialEquipmentById(generalEquipmentQuality.SpecialEquipmentId); if (equipmentType != null) { equipmentTypeName = equipmentType.SpecialEquipmentName; } this.lbWedName.Text = "设备名称:" + equipmentTypeName; Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(generalEquipmentQuality.UnitId); string unitName = string.Empty; if (unit != null) { unitName = unit.UnitName; } this.lbUnitName.Text = "所属单位:" + unitName; } } else if (!string.IsNullOrEmpty(Request.Params["ConstructSolutionId"])) { ///施工方案 var constructSolution = BLL.ConstructSolutionService.GetConstructSolutionById(Request.Params["ConstructSolutionId"]); if (constructSolution != null && !string.IsNullOrEmpty(constructSolution.QRCodeAttachUrl)) { this.imgPhoto.Src = "../" + constructSolution.QRCodeAttachUrl; string code = string.Empty; if (!string.IsNullOrEmpty(constructSolution.ConstructSolutionCode)) { code = constructSolution.ConstructSolutionCode; } else { code = BLL.CodeRecordsService.ReturnCodeByDataId(constructSolution.ConstructSolutionId); } this.lbWedCode.Text = "编号:" + code; this.lbWedName.Text = "方案名称:" + constructSolution.ConstructSolutionName; Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(constructSolution.UnitId); string unitName = string.Empty; if (unit != null) { unitName = unit.UnitName; } this.lbUnitName.Text = "所属单位:" + unitName; } } else if (!string.IsNullOrEmpty(Request.Params["TrainingPlanId"])) { ///培训计划 var trainingPlan = BLL.TrainingPlanService.GetPlanById(Request.Params["TrainingPlanId"]); if (trainingPlan != null && !string.IsNullOrEmpty(trainingPlan.QRCodeUrl)) { this.imgPhoto.Src = "../" + trainingPlan.QRCodeUrl; string code = string.Empty; if (!string.IsNullOrEmpty(trainingPlan.PlanCode)) { code = trainingPlan.PlanCode; } else { code = BLL.CodeRecordsService.ReturnCodeByDataId(trainingPlan.PlanId); } this.lbWedCode.Text = "编号:" + code; this.lbWedName.Text = "名称:" + trainingPlan.PlanName; this.lbUnitName.Text = "培训时间:" + string.Format("{0:yyyy-MM-dd}", trainingPlan.TrainStartDate) + ";培训地点:" + trainingPlan.TeachAddress; } } else if (!string.IsNullOrEmpty(Request.Params["TestPlanId"])) { ///培训计划 var testPlan = BLL.TestPlanService.GetTestPlanById(Request.Params["TestPlanId"]); if (testPlan != null && !string.IsNullOrEmpty(testPlan.QRCodeUrl)) { this.imgPhoto.Src = "../" + testPlan.QRCodeUrl; string code = string.Empty; if (!string.IsNullOrEmpty(testPlan.PlanCode)) { code = testPlan.PlanCode; } else { code = BLL.CodeRecordsService.ReturnCodeByDataId(testPlan.PlanId); } this.lbWedCode.Text = "编号:" + code; this.lbWedName.Text = "名称:" + testPlan.PlanName; this.lbUnitName.Text = "考试扫码时间:" + string.Format("{0:yyyy-MM-dd}", testPlan.TestStartTime) + ";考试地点:" + testPlan.TestPalce; } } else if (!string.IsNullOrEmpty(Request.Params["ServerTestPlanId"])) { ///知识竞赛 var testPlan = BLL.ServerTestPlanService.GetTestPlanById(Request.Params["ServerTestPlanId"]); if (testPlan != null && !string.IsNullOrEmpty(testPlan.QRCodeUrl)) { this.imgPhoto.Src = "../" + testPlan.QRCodeUrl; this.lbWedCode.Text = "编号:" + testPlan.PlanCode; this.lbWedName.Text = "名称:" + testPlan.PlanName; this.lbUnitName.Text = "扫码考试时间:" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", testPlan.TestStartTime) + ";至:" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", testPlan.TestEndTime); } } }