/// <summary> /// 更新数据 /// </summary> /// <param name="tbmb"></param> /// <returns></returns> public bool UpdateEntity(T_Bllb_materialRule_tbmb tbmb) { string strSql = string.Format("UPDATE T_Bllb_materialRule_tbmb SET TBBR_ID = '{0}',MaterialCode='{1}',TBKT_ID='{2}',DEFAULT_FLAG='{3}' WHERE TBMR_ID='{4}'", tbmb.TBBR_ID, tbmb.MaterialCode, tbmb.TBKT_ID, tbmb.DEFAULT_FLAG, tbmb.TBMR_ID); return(NMS.ExecTransql(PubUtils.uContext, strSql)); }
/// <summary> /// 新增数据 /// </summary> /// <param name="tbmb"></param> /// <returns></returns> public bool InsertEntity(T_Bllb_materialRule_tbmb tbmb) { string strSql = string.Format("INSERT INTO T_Bllb_materialRule_tbmb (TBBR_ID,MaterialCode,TBKT_ID,DEFAULT_FLAG)VALUES('{0}','{1}','{2}','{3}')", tbmb.TBBR_ID, tbmb.MaterialCode, tbmb.TBKT_ID, tbmb.DEFAULT_FLAG); return(NMS.ExecTransql(PubUtils.uContext, strSql)); }
/// <summary> /// 查询数据 /// </summary> /// <returns></returns> public DataTable GetTbmrID(T_Bllb_materialRule_tbmb tbmb) { string strSql = string.Format("SELECT TBMR_ID FROM T_Bllb_materialRule_tbmb WHERE MaterialCode='{0}' AND TBBR_ID='{1}' ", tbmb.MaterialCode, tbmb.TBBR_ID); return(NMS.QueryDataTable(PubUtils.uContext, strSql.ToString())); }
/// <summary> /// 查询数据 /// </summary> /// <returns></returns> public DataTable SelectTbmrID(T_Bllb_materialRule_tbmb tbmb) { return(t_Bllb_materialRule_tbmb_DAL.GetTbmrID(tbmb)); }
/// <summary> /// 修改数据 /// </summary> /// <param name="tbmb"></param> /// <returns></returns> public bool Update(T_Bllb_materialRule_tbmb tbmb) { return(t_Bllb_materialRule_tbmb_DAL.UpdateEntity(tbmb)); }
/// <summary> /// 插入数据 /// </summary> /// <param name="tbmb"></param> /// <returns></returns> public bool Insert(T_Bllb_materialRule_tbmb tbmb) { return(t_Bllb_materialRule_tbmb_DAL.InsertEntity(tbmb)); }