private void btnOK_Click(object sender, EventArgs e) { string varMsg = string.Empty; if (!ValidateInput(out varMsg)) { new PubUtils().ShowNoteNGMsg(varMsg, 2, grade.OrdinaryError); return; } obj_tbmr = new T_Bllb_MaterialRelation_Tbmr(); obj_tbmr.LocalMaterialCode = txtLocalMaterial.Text.Trim(); obj_tbmr.SupplyMaterialCode = txtSupplyMaterial.Text.Trim(); obj_tbmr.Supply = txtSupply.Text.Trim(); obj_tbmr.Remark = txtRemark.Text.Trim(); if (_operationType == OperationType.Add) { obj_tbmr.TBMR_ID = Guid.NewGuid().ToString(); if (BLL_Bllb_MaterialRelation_Tbmr.Insert(obj_tbmr)) { ClearControl(); new PubUtils().ShowNoteOKMsg("新增成功"); } } else if (_operationType == OperationType.Edit) { obj_tbmr.TBMR_ID = TBMR_ID; if (BLL_Bllb_MaterialRelation_Tbmr.Update(obj_tbmr)) { new PubUtils().ShowNoteOKMsg("编辑成功"); this.DialogResult = DialogResult.OK; } } }
/// <summary> /// 修改 /// </summary> /// <param name="model">T_Bllb_MaterialRelation_Tbmr表实体</param> /// <returns></returns> public static bool Update(T_Bllb_MaterialRelation_Tbmr model) { string sqlcmd = string.Format(@" update T_Bllb_MaterialRelation_Tbmr set LocalMaterialCode='{0}', SupplyMaterialCode='{1}', Supply='{2}', Remark='{3}' where TBMR_ID='{4}'", model.LocalMaterialCode, model.SupplyMaterialCode, model.Supply, model.Remark, model.TBMR_ID); return(NMS.ExecTransql(PubUtils.uContext, sqlcmd)); }
/// <summary> /// 增加 /// </summary> /// <param name="model">T_Bllb_MaterialRelation_Tbmr表实体</param> /// <returns></returns> public static bool Insert(T_Bllb_MaterialRelation_Tbmr model) { string sqlcmd = string.Format(@" INSERT INTO T_Bllb_MaterialRelation_Tbmr ( LocalMaterialCode , SupplyMaterialCode , Supply , Remark , TBMR_ID ) VALUES ( '{0}' , '{1}' , '{2}' , '{3}' , '{4}' )", model.LocalMaterialCode, model.SupplyMaterialCode, model.Supply, model.Remark, model.TBMR_ID); return(NMS.ExecTransql(PubUtils.uContext, sqlcmd)); }