/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(T_SYS_NOTICE_Model m) { StringBuilder sb = new StringBuilder(); //HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO sb.AppendFormat("UPDATE T_SYS_NOTICE"); sb.AppendFormat(" set "); sb.AppendFormat("INFOTITLE='{0}'", ClsSql.EncodeSql(m.INFOTITLE)); sb.AppendFormat(",INFOCONTENT='{0}'", ClsSql.EncodeSql(m.INFOCONTENT)); if (string.IsNullOrEmpty(ClsSql.EncodeSql(m.INFOURL)) == false) { sb.AppendFormat(",INFOURL='{0}'", ClsSql.EncodeSql(m.INFOURL)); } if (string.IsNullOrEmpty(ClsSql.EncodeSql(m.FBTIME)) == false) { sb.AppendFormat(",FBTIME='{0}'", ClsSql.EncodeSql(m.FBTIME)); } sb.AppendFormat(",LABLE='{0}'", ClsSql.EncodeSql(m.LABLE)); //sb.AppendFormat(",NUM='{0}'", ClsSql.EncodeSql(m.NUM)); //sb.AppendFormat(",INFOTYPE='{0}'", ClsSql.EncodeSql(m.INFOTYPE)); //sb.AppendFormat(",INFOUSERID='{0}'", ClsSql.EncodeSql(m.INFOUSERID)); //sb.AppendFormat(",SYSFLAG='{0}'", ClsSql.EncodeSql(m.SYSFLAG)); sb.AppendFormat(" where INFOID= '{0}'", ClsSql.EncodeSql(m.INFOID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", "")); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(T_SYS_NOTICE_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO T_SYS_NOTICE( INFOTITLE, INFOCONTENT, INFOURL, FBTIME, LABLE, NUM, INFOTYPE, INFOUSERID,SYSFLAG)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.INFOTITLE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.INFOCONTENT)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.INFOURL)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.FBTIME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.LABLE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.NUM)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.INFOTYPE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.INFOUSERID)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SYSFLAG)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", "")); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(T_SYS_NOTICE_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete T_SYS_NOTICE"); sb.AppendFormat(" where INFOID= '{0}'", ClsSql.EncodeSql(m.INFOID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 获取分页信息 /// </summary> /// <param name="sw">参见模型</param> /// <param name="total">记录总数</param> /// <returns>参见模型</returns> public static IEnumerable <T_SYS_NOTICE_Model> getListPagerModel(T_SYS_NOTICE_SW sw, out int total) { var result = new List <T_SYS_NOTICE_Model>(); DataTable dt = BaseDT.T_SYS_NOTICE.getDT(sw, out total);//列表 for (int i = 0; i < dt.Rows.Count; i++) { T_SYS_NOTICE_Model m = new T_SYS_NOTICE_Model(); m.INFOTITLE = dt.Rows[i]["INFOTITLE"].ToString(); m.FBTIME = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["FBTIME"].ToString()); m.LOGINUSERNAME = dt.Rows[i]["LOGINUSERNAME"].ToString(); m.INFOID = dt.Rows[i]["INFOID"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 根据查询条件获取某一条用户信息记录,用于修改、删除、用户登录验证 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static T_SYS_NOTICE_Model getModel(T_SYS_NOTICE_SW sw) { DataTable dt = BaseDT.T_SYS_NOTICE.getDT(sw); T_SYS_NOTICE_Model m = new T_SYS_NOTICE_Model(); if (dt.Rows.Count > 0) { int i = 0; m.INFOID = dt.Rows[i]["INFOID"].ToString(); m.INFOTITLE = dt.Rows[i]["INFOTITLE"].ToString(); m.INFOCONTENT = dt.Rows[i]["INFOCONTENT"].ToString(); m.INFOURL = dt.Rows[i]["INFOURL"].ToString(); m.FBTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["FBTIME"].ToString()); m.LABLE = dt.Rows[i]["LABLE"].ToString(); m.NUM = dt.Rows[i]["NUM"].ToString(); m.INFOTYPE = dt.Rows[i]["INFOTYPE"].ToString(); m.INFOUSERID = dt.Rows[i]["INFOUSERID"].ToString(); m.SYSFLAG = dt.Rows[i]["SYSFLAG"].ToString(); } return(m); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(T_SYS_NOTICE_Model m) { if (m.opMethod == "Add") { SystemCls.LogSave("3", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_SYS_NOTICE.Add(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { SystemCls.LogSave("4", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_SYS_NOTICE.Mdy(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { SystemCls.LogSave("5", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.T_SYS_NOTICE.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }