public JsonResult GetTree() { DataTable dt = proxy.GetLoginPictureTree(); string strPath = Request.PhysicalApplicationPath; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["type"].ToString() == "1") { if (!System.IO.File.Exists(strPath + dt.Rows[i]["src"].ToString()) && dt.Rows[i]["attachid"] != DBNull.Value) { try { byte[] buffer = NG3UploadFileService.NG3GetEx("", (long)dt.Rows[i]["attachid"]); System.IO.File.WriteAllBytes(strPath + dt.Rows[i]["src"].ToString(), buffer); } catch { } } } } string filter = "(pid is null or pid='')"; IList <TreeJSONBase> list = new LoginPicManagerSelectedTreeBuilder().GetExtTreeList(dt, "pid", "id", filter, TreeDataLevelType.TopLevel); return(this.Json(list, JsonRequestBehavior.AllowGet)); }
public string ReplaceIconUpload(string id, string name, string tag, string attachid) { try { name = Guid.NewGuid().ToString() + name.Substring(name.LastIndexOf(".")); string strPath = "NG3Resource\\CustomIcons\\"; string dirPath = Request.PhysicalApplicationPath + strPath; HttpPostedFileBase imgFile = Request.Files["replaceCustomIcon"]; string filePath = dirPath + name; imgFile.SaveAs(filePath); if (!string.IsNullOrEmpty(attachid)) { byte[] buffer = GetFileData(filePath); NG3UploadFileService.NG3ModifyEx("", long.Parse(attachid), buffer); } return(JsonConvert.SerializeObject(proxy.ReplaceFuncIcon(id, name, tag))); } catch (Exception ex) { throw new Exception(ex.Message); } }
public string AttachUpload(string src) { string path = Request.PhysicalApplicationPath + src; FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read); byte[] buffer; try { buffer = new byte[fs.Length]; fs.Read(buffer, 0, (int)fs.Length); } catch { return(""); } finally { if (fs != null) { fs.Close(); } } string result = NG3UploadFileService.NG3UploadEx("", buffer); JObject jo = (JObject)JsonConvert.DeserializeObject(result); if (jo["success"] != null && jo["success"].ToString() == "true") { return(jo["phid"].ToString()); } else { return(""); } }
public string SaveOneAttach() { string tablename = System.Web.HttpContext.Current.Request.Params["tablename"]; string busguid = System.Web.HttpContext.Current.Request.Params["busguid"]; string phid = System.Web.HttpContext.Current.Request.Params["phid"]; string asrflg = System.Web.HttpContext.Current.Request.Params["asrflg"]; //1有附件;0无附件;3附件标志无变化 //附件保存 string saveparms = string.Empty; if (!string.IsNullOrEmpty(busguid) && busguid.Length > 30) //guid长度为36 { saveparms += busguid + "||" + phid + "@@##"; } if (!string.IsNullOrEmpty(saveparms)) { saveparms = saveparms.TrimEnd('#', '@'); NG3UploadFileService.BatchSave(saveparms, NG3.AppInfoBase.UserConnectString); } //更新表上的附件标志asr_flg int iret = 0; if (asrflg != "3") { DataTable dt = DbHelper.GetDataTable(string.Format("select * from {0} where 1=2", tablename)); if (dt.Columns.Contains("asr_flg")) { iret = DbHelper.ExecuteNonQuery(string.Format("update {0} set asr_flg = {1} where phid = {2}", tablename, asrflg, phid)); } } JObject jResult = new JObject(); if (iret != -1) { jResult.Add("status", "OK"); return(JsonConvert.SerializeObject(jResult)); } else { jResult.Add("status", "Fail"); return(JsonConvert.SerializeObject(jResult)); } }
string AttachUpload(byte[] buffer) { if (buffer == null) { return(""); } string result = NG3UploadFileService.NG3UploadEx("", buffer); JObject jo = (JObject)JsonConvert.DeserializeObject(result); if (jo["success"] != null && jo["success"].ToString() == "true") { return(jo["phid"].ToString()); } else { return(""); } }
public bool DelFuncIcon(string id) { try { bool deletable = dac.CheckDelFuncIcon(id); if (deletable) { DataTable dt = dac.GetFuncIconDtByPhid(id); string tag = dt.Rows[0]["tag"].ToString(); string name = dt.Rows[0]["name"].ToString(); //删除图标文件 string path = AppDomain.CurrentDomain.BaseDirectory + @"NG3Resource\CustomIcons"; if (File.Exists(path + "\\" + name)) { File.Delete(path + "\\" + name); } //删除附件表存储数据 if (dt.Rows[0]["attachid"] != DBNull.Value) { try { NG3UploadFileService.NG3Del("", (long)dt.Rows[0]["attachid"]); } catch { } } return(dac.DelFuncIcon(id, tag)); } else { return(deletable); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public void DelNode(string phid) { try { string rootpath = AppDomain.CurrentDomain.BaseDirectory; DataTable dt = dac.GetLoginPicture(phid); //图片节点需要删除图片文件以及附件表存储数据 if (dt.Rows[0]["type"].ToString() == "1") { if (!string.IsNullOrEmpty(dt.Rows[0]["src"].ToString())) { string src = dt.Rows[0]["src"].ToString(); string path = Path.Combine(rootpath, src); if (File.Exists(path)) { File.Delete(path); } } if (dt.Rows[0]["attachid"] != DBNull.Value) { try { NG3UploadFileService.NG3Del("", (long)dt.Rows[0]["attachid"]); } catch { } } } dac.DelNode(phid); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 注意,默认tab和设置是分别加载,一起保存 /// </summary> /// <returns></returns> public string SaveDefaultOpenTab() { string defaultOpenTab = System.Web.HttpContext.Current.Request.Form["defaultOpenTab"]; //string userid = System.Web.HttpContext.Current.Request.Form["userid"]; long userid = AppInfoBase.UserID; //保存默认tab页设置 DataTable defaultOpenTabTable = DataConverterHelper.ToDataTable(defaultOpenTab, "select * from fg3_defaultopen_tab"); int iret1 = proxy.SaveDefaultOpenTab(userid, defaultOpenTabTable); //保存系统设置 string individualSetting = System.Web.HttpContext.Current.Request.Form["individualSetting"]; bool iret2 = proxy.SaveSysSetting(userid, individualSetting); if (String.Compare(AppInfoBase.UserType, UserType.System, true) == 0) { //保存管理员权限下的路由设置和显示设置,注意这两个会改了数据库连接串,不再连0002 string ServerIpAndNetWorkIpConfig = System.Web.HttpContext.Current.Request.Form["ServerIpAndNetWorkIpConfig"]; string DisplaySetting = System.Web.HttpContext.Current.Request.Form["DisplaySetting"]; this.SaveServerIpAndNetWorkIpConfig(ServerIpAndNetWorkIpConfig); this.SaveDisplaySetting(DisplaySetting); } //保存小铃铛设置 string alertconfig = System.Web.HttpContext.Current.Request.Form["alertconfig"]; bool iret3 = proxy.SaveAlertItem(alertconfig); //bool iret3 = this.SaveAlertItem(alertconfig); //保存换肤设置 string uitheme = System.Web.HttpContext.Current.Request.Form["uitheme"]; int tempuitheme = 0; Int32.TryParse(uitheme.ToString(), out tempuitheme); bool iret4 = MenuConfigProxy.SaveUITheme(tempuitheme, userid); ////保存登陆单位信息 //string SSOOrgValue = System.Web.HttpContext.Current.Request.Form["SSOOrgValue"]; //proxy.SetSSOOrg(SSOOrgValue); //保存APP启动页Logo string APPlogo = System.Web.HttpContext.Current.Request.Form["APPlogo"]; string filePath = Request.PhysicalApplicationPath + "NG3Resource\\APPLogo\\" + APPlogo; bool iret5 = true; if (!string.IsNullOrEmpty(APPlogo) && System.IO.File.Exists(filePath)) { byte[] buffer; using (FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read)) { buffer = new byte[fs.Length]; fs.Read(buffer, 0, (int)fs.Length); } string attachid = proxy.GetAPPLogoAttachId(); try { if (string.IsNullOrEmpty(attachid)) { string result = NG3UploadFileService.NG3UploadEx("", buffer); JObject jo = (JObject)JsonConvert.DeserializeObject(result); if (jo["success"] != null && jo["success"].ToString() == "true") { attachid = jo["phid"].ToString(); } else { return("{status : \"error\", msg: \"APPLogo上传到附件出错\"}"); } } else { NG3UploadFileService.NG3ModifyEx("", long.Parse(attachid), buffer); } } catch { return("{status : \"error\", msg: \"APPLogo上传到附件出错\"}"); } iret5 = proxy.SaveAPPLogo(APPlogo, attachid); if (iret5) { string dirPath = Request.PhysicalApplicationPath + "NG3Resource\\APPLogo"; if (Directory.Exists(dirPath)) { Directory.Delete(dirPath, true); } } } if (iret1 >= 0 && iret2 && iret3 && iret4 && iret5) { return("{status : \"ok\"}"); } else { return("{status : \"error\"}"); } }
public DataTable GetFuncIcons(bool buildinIconShow, bool customIconShow, string tag, ref int totalRecord) { try { DataTable dt = new DataTable(); dt.TableName = "FuncIcons"; dt.Columns.Add(new DataColumn("id", Type.GetType("System.String"))); dt.Columns.Add(new DataColumn("name", Type.GetType("System.String"))); dt.Columns.Add(new DataColumn("src", Type.GetType("System.String"))); dt.Columns.Add(new DataColumn("tag", Type.GetType("System.String"))); dt.Columns.Add(new DataColumn("icontype", Type.GetType("System.String"))); dt.Columns.Add(new DataColumn("attachid", Type.GetType("System.String"))); DataRow row; string path; string srcPre = HttpContext.Current.Request.Url.Scheme + "://" + HttpContext.Current.Request.Url.Host + ":" + HttpContext.Current.Request.Url.Port + "/" + HttpContext.Current.Request.Url.Segments[1]; DataTable iconDt; if (buildinIconShow) { path = AppDomain.CurrentDomain.BaseDirectory + @"NG3Resource\FuncIcons"; if (Directory.Exists(path)) { iconDt = dac.GetIconDt("0"); totalRecord += iconDt.Rows.Count; for (int i = 0; i < iconDt.Rows.Count; i++) { row = dt.NewRow(); row["id"] = iconDt.Rows[i]["phid"];; row["name"] = iconDt.Rows[i]["name"]; row["src"] = srcPre + "/NG3Resource/FuncIcons/" + row["name"]; row["tag"] = iconDt.Rows[i]["tag"]; row["icontype"] = "0"; dt.Rows.Add(row); } } } if (customIconShow) { path = AppDomain.CurrentDomain.BaseDirectory + @"NG3Resource\CustomIcons"; if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } if (Directory.Exists(path)) { iconDt = dac.GetIconDt("1"); totalRecord += iconDt.Rows.Count; for (int i = 0; i < iconDt.Rows.Count; i++) { row = dt.NewRow(); row["id"] = iconDt.Rows[i]["phid"]; row["name"] = iconDt.Rows[i]["name"]; row["src"] = srcPre + "/NG3Resource/CustomIcons/" + row["name"]; if (File.Exists(path + "\\" + row["name"])) { row["tag"] = iconDt.Rows[i]["tag"]; row["icontype"] = "1"; row["attachid"] = iconDt.Rows[i]["attachid"]; dt.Rows.Add(row); } else { if (iconDt.Rows[i]["attachid"] != DBNull.Value) { try { byte[] buffer = NG3UploadFileService.NG3GetEx("", (long)iconDt.Rows[i]["attachid"]); File.WriteAllBytes(path + "\\" + row["name"], buffer); row["tag"] = iconDt.Rows[i]["tag"]; row["icontype"] = "1"; row["attachid"] = iconDt.Rows[i]["attachid"]; dt.Rows.Add(row); } catch { continue; } } else { continue; } } } } } if (tag != "") { DataView dv = dt.DefaultView; dv.RowFilter = "tag like '%" + tag + ";%'"; dt = dv.ToTable(); totalRecord = dt.Rows.Count; } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }