/// <summary> /// 修改 /// </summary> /// <param name="MR"></param> /// <returns></returns> public static bool Update(T_Bllb_MaterialReplace_tbmr MR) { string strSql = string.Format("update T_Bllb_MaterialReplace_tbmr set MaterialReplace='{1}',MaterialReplace1='{2}',MaterialReplace2='{3}', Updator='{4}',UpdateTime=getdate() where MaterialCode='{0}'", MR.MaterialCode, MR.MaterialReplace, MR.MaterialReplace1, MR.MaterialReplace2, PubUtils.uContext.UserID); return(NMS.ExecTransql(PubUtils.uContext, strSql)); }
/// <summary> /// 新增 /// </summary> /// <param name="MR"></param> /// <returns></returns> public static bool Insert(T_Bllb_MaterialReplace_tbmr MR) { string strSql = string.Format("insert into T_Bllb_MaterialReplace_tbmr(MaterialCode,MaterialReplace,MaterialReplace1,MaterialReplace2,Creator,CreateTime) values('{0}','{1}','{2}','{3}','{4}',getdate())", MR.MaterialCode, MR.MaterialReplace, MR.MaterialReplace1, MR.MaterialReplace2, PubUtils.uContext.UserID); return(NMS.ExecTransql(PubUtils.uContext, strSql)); }