/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(ART_DOCUMENT_Model m) { StringBuilder sb = new StringBuilder(); //HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO sb.AppendFormat("UPDATE ART_DOCUMENT"); sb.AppendFormat(" set "); sb.AppendFormat(" ARTTYPEID='{0}'", ClsSql.EncodeSql(m.ARTTYPEID)); sb.AppendFormat(",ARTTITLE='{0}'", ClsSql.EncodeSql(m.ARTTITLE)); sb.AppendFormat(",ARTTAG='{0}'", ClsSql.EncodeSql(m.ARTTAG)); //sb.AppendFormat(",ARTTIME='{0}'", ClsSql.EncodeSql(m.ARTTIME)); sb.AppendFormat(",ARTCONTENT='{0}'", ClsSql.EncodeSql(m.ARTCONTENT)); sb.AppendFormat(",ARTCHECKSTATUS='{0}'", ClsSql.EncodeSql(m.ARTCHECKSTATUS)); sb.AppendFormat(",ARTADDUSERID='{0}'", ClsSql.EncodeSql(m.ARTADDUSERID)); sb.AppendFormat(",ARTCHECKTIME='{0}'", ClsSql.EncodeSql(m.ARTCHECKTIME)); sb.AppendFormat(",ARTCHECKUSERID='{0}'", ClsSql.EncodeSql(m.ARTCHECKUSERID)); sb.AppendFormat(",PLANFILENAME='{0}'", ClsSql.EncodeSql(m.PLANFILENAME)); sb.AppendFormat(",BYORGNO='{0}'", ClsSql.EncodeSql(m.BYORGNO)); sb.AppendFormat(" where ARTID= '{0}'", ClsSql.EncodeSql(m.ARTID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", "")); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }
public ActionResult DocManager() { string Method = Request.Params["Method"]; //默认为添加 if (string.IsNullOrEmpty(Method)) { Method = "Add"; } if (Method != "Del") { if (string.IsNullOrEmpty(Request.Params["ARTTITLE"])) { return(Content(JsonConvert.SerializeObject(new Message(false, "请输入标题!", "")), "text/html;charset=UTF-8")); } } ART_DOCUMENT_Model m = new ART_DOCUMENT_Model(); m.ARTID = Request.Params["id"]; m.ARTTYPEID = Request.Params["ARTTYPEID"]; m.ARTTITLE = Request.Params["ARTTITLE"]; m.ARTCONTENT = Request.Params["ARTCONTENT"]; m.PLANFILENAME = Request.Params["PLANFILENAME"]; m.opMethod = Method; m.returnUrl = Request.Params["returnUrl"]; m.BYORGNO = SystemCls.getCurUserOrgNo(); m.ARTADDUSERID = SystemCls.getUserID(); return(Content(JsonConvert.SerializeObject(ART_DOCUMENTCls.Manager(m)), "text/html;charset=UTF-8")); }
/// <summary> /// 文档查看 /// </summary> /// <returns></returns> public ActionResult DocShow() { string ID = Request.Params["ID"]; if (string.IsNullOrEmpty(ID)) { ID = "0"; } ART_DOCUMENT_Model m = ART_DOCUMENTCls.getModel(new ART_DOCUMENT_SW { ARTID = ID }); pubViewBag(m.ARTTYPEID, m.ARTTYPEID, ""); ViewBag.isPageRight = true; StringBuilder sb = new StringBuilder(); var v = ART_DOCUMENTCls.getModel(new ART_DOCUMENT_SW { ARTID = ID }); sb.AppendFormat("<div class='showArtTitle'>{0}</div>", v.ARTTITLE); sb.AppendFormat("<div class='showArtSmallTitle'>{0}</div>", v.ARTTIME); sb.AppendFormat("<div class='showArtContent'>{0}</div>", v.ARTCONTENT); if (string.IsNullOrEmpty(v.PLANFILENAME) == false) { sb.AppendFormat("<div class=' showArtFile'>文件下载:<br><a href='/UploadFile/Doc/{0}'>{1}</a></div>", v.PLANFILENAME, v.ARTTITLE); } ViewBag.Content = sb.ToString(); return(View()); }
/// <summary> /// 获取分页 /// </summary> /// <param name="sw">参见模型</param> /// <param name="total">记录总数</param> /// <returns>参见模型</returns> public static IEnumerable <ART_DOCUMENT_Model> getModelList(ART_DOCUMENT_SW sw, out int total) { var result = new List <ART_DOCUMENT_Model>(); DataTable dt = BaseDT.ART_DOCUMENT.getDT(sw, out total);//列表 DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { }); DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); //获取单位 string typeid = ""; if (sw.ARTBigTYPEID == "013") { typeid = "47"; } if (sw.ARTBigTYPEID == "014") { typeid = "48"; } if (sw.ARTBigTYPEID == "015") { typeid = "49"; } DataTable dtType = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTTYPEID = typeid }); for (int i = 0; i < dt.Rows.Count; i++) { ART_DOCUMENT_Model m = new ART_DOCUMENT_Model(); m.ARTID = dt.Rows[i]["ARTID"].ToString(); m.ARTTYPEID = dt.Rows[i]["ARTTYPEID"].ToString(); m.ARTTITLE = dt.Rows[i]["ARTTITLE"].ToString(); m.ARTTAG = dt.Rows[i]["ARTTAG"].ToString(); m.ARTTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["ARTTIME"].ToString()); m.ARTCHECKSTATUS = dt.Rows[i]["ARTCHECKSTATUS"].ToString(); m.ARTADDUSERID = dt.Rows[i]["ARTADDUSERID"].ToString(); m.ARTCHECKTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["ARTCHECKTIME"].ToString()); m.ARTCHECKUSERID = dt.Rows[i]["ARTCHECKUSERID"].ToString(); m.PLANFILENAME = dt.Rows[i]["PLANFILENAME"].ToString(); m.ARTTYPENAME = BaseDT.T_SYS_DICT.getName(dtType, m.ARTTYPEID);// BaseDT.ART_TYPE.getName(dtType, dt.Rows[i]["ARTTYPEID"].ToString()); m.ARTADDUSERName = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.ARTADDUSERID); m.ARTCHECKUSERIDName = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.ARTCHECKUSERID); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.orgName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); result.Add(m); //ARTID, ARTTYPEID, ARTTITLE, ARTTAG, ARTTIME, ARTCHECKSTATUS, ARTADDUSERID,ARTCHECKTIME, ARTCHECKUSERID } dtORG.Clear(); dtORG.Dispose(); dtType.Clear(); dtType.Dispose(); dt.Clear(); dt.Dispose(); dtUser.Clear(); dtUser.Dispose(); return(result); }
/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(ART_DOCUMENT_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO ART_DOCUMENT( ARTTYPEID, ARTTITLE, ARTTAG, ARTTIME, ARTCONTENT, ARTCHECKSTATUS, ARTADDUSERID, ARTCHECKTIME, ARTCHECKUSERID,PLANFILENAME,BYORGNO)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.ARTTYPEID)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ARTTITLE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ARTTAG)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now))); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ARTCONTENT)); if (string.IsNullOrEmpty(m.ARTCHECKSTATUS)) { sb.AppendFormat(",null"); } else { sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ARTCHECKSTATUS)); } sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ARTADDUSERID)); if (string.IsNullOrEmpty(m.ARTCHECKTIME)) { sb.AppendFormat(",null"); } else { sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ARTCHECKTIME)); } if (string.IsNullOrEmpty(m.ARTCHECKUSERID)) { sb.AppendFormat(",null"); } else { sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ARTCHECKUSERID)); } sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.PLANFILENAME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.BYORGNO)); 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(ART_DOCUMENT_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete ART_DOCUMENT"); sb.AppendFormat(" where ARTID= '{0}'", ClsSql.EncodeSql(m.ARTID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 根据查询条件获取某一条用户信息记录,用于修改、删除、用户登录验证 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static ART_DOCUMENT_Model getModel(ART_DOCUMENT_SW sw) { var result = new List <ART_DOCUMENT_Model>(); DataTable dt = BaseDT.ART_DOCUMENT.getDT(sw);//列表 ART_DOCUMENT_Model m = new ART_DOCUMENT_Model(); DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { }); if (dt.Rows.Count > 0) { int i = 0; m.ARTID = dt.Rows[i]["ARTID"].ToString(); m.ARTTYPEID = dt.Rows[i]["ARTTYPEID"].ToString(); m.ARTTITLE = dt.Rows[i]["ARTTITLE"].ToString(); m.ARTTAG = dt.Rows[i]["ARTTAG"].ToString(); m.ARTTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["ARTTIME"].ToString()); m.ARTCHECKSTATUS = dt.Rows[i]["ARTCHECKSTATUS"].ToString(); m.ARTADDUSERID = dt.Rows[i]["ARTADDUSERID"].ToString(); m.ARTCHECKTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["ARTCHECKTIME"].ToString()); m.ARTCHECKUSERID = dt.Rows[i]["ARTCHECKUSERID"].ToString(); m.ARTCONTENT = dt.Rows[i]["ARTCONTENT"].ToString(); DataTable dtType = BaseDT.ART_TYPE.getDT(new ART_TYPE_SW { ARTTYPEID = m.ARTTYPEID }); m.ARTTYPENAME = BaseDT.ART_TYPE.getName(dtType, m.ARTTYPEID); m.ARTADDUSERName = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.ARTADDUSERID); m.ARTCHECKUSERIDName = BaseDT.T_SYSSEC_USER.getNameByUserList(dtUser, m.ARTCHECKUSERID); m.PLANFILENAME = dt.Rows[i]["PLANFILENAME"].ToString(); dtType.Clear(); dtType.Dispose(); } dt.Clear(); dt.Dispose(); dtUser.Clear(); dtUser.Dispose(); return(m); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(ART_DOCUMENT_Model m) { if (m.opMethod == "Add") { //SystemCls.LogSave("3", "通知公告:" + m.INFOTITLE, ClsStr.getModelContent(m)); Message msgUser = BaseDT.ART_DOCUMENT.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.ART_DOCUMENT.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.ART_DOCUMENT.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }