/// <summary> /// 修改标签数据源 /// </summary> /// <param name="lableS"></param> /// <returns></returns> public static bool Update(T_Bllb_LabelSource_tbls lableS, string current_LabelName) { string strSql = string.Format(@"update T_Bllb_LabelSource_tbls set LabelName='{0}',LabelSQL='{1}',Updator='{2}',UpdateTime=getdate() where LabelName='{3}'", lableS.LabelName, lableS.LabelSQL, PubUtils.uContext.UserID, current_LabelName); return(NMS.ExecTransql(PubUtils.uContext, strSql)); }
/// <summary> /// 新增标签数据源 /// </summary> /// <param name="lableS"></param> /// <returns></returns> public static bool Insert(T_Bllb_LabelSource_tbls lableS) { string strSql = string.Format(@" insert into T_Bllb_LabelSource_tbls(LabelName,LabelSQL,Creator,CreateTime) values('{0}','{1}','{2}',getdate())", lableS.LabelName, lableS.LabelSQL, PubUtils.uContext.UserID); return(NMS.ExecTransql(PubUtils.uContext, strSql)); }