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