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