private bool doupgradesql(HttpContext context, string ZipPath, string rootPath) { var config = new Utility.SiteConfig(); string SiteName = config.SiteName; string NewFileName = DateTime.Now.ToString("yyyyMMddHHmmss"); Utility.Tools.UnZipFile(ZipPath, rootPath, NewFileName); string DatabaseName = ConfigurationManager.AppSettings["DatabaseName"]; string FullFilePath = rootPath + NewFileName; DirectoryInfo root = new DirectoryInfo(FullFilePath); foreach (FileInfo f in root.GetFiles().OrderBy(p => p.Name)) { if (!f.Extension.ToLower().Contains("sql")) { continue; } string SQLFullPath = FullFilePath + "\\" + f.Name; try { Utility.SQLHelper.ExecuteSQLFile(SQLFullPath, DatabaseName); } catch (Exception ex) { LogHelper.WriteError("更新数据库失败", "", ex); } } return(true); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int BaoXiuServiceID = new Utility.SiteConfig().BaoXiuServiceID; var typeList = Foresight.DataAccess.ServiceType.GetServiceTypes().ToArray(); var typeList2 = typeList.Where(p => p.ParentID == BaoXiuServiceID).ToArray(); var typeItems2 = typeList2.Select(p => { var item = new { ID = p.ID, Name = p.ServiceTypeName }; return(item); }).ToList(); typeItems2.Insert(0, new { ID = 0, Name = "全部" }); typeItems2.Insert(0, new { ID = -1, Name = "不限" }); this.hdServiceTypeName2.Value = Utility.JsonConvert.SerializeObject(typeItems2); var typeList2IDList = typeList2.Select(p => p.ID).ToArray(); var typeList3 = typeList.Where(p => typeList2IDList.Contains(p.ParentID)).ToArray(); var typeItems3 = typeList3.Select(p => { var item = new { ID = p.ID, Name = p.ServiceTypeName, ParentID = p.ParentID }; return(item); }).ToList(); this.hdServiceTypeName3.Value = Utility.JsonConvert.SerializeObject(typeItems3); } }
/// /// 处理文本消息 /// ///消息对象 ///参数(用于具体业务传递参数用) ///是否处理成功 public bool ProcessTextMessage(TextReceiveMessage msg, params object[] args) { string response_msg = new Utility.SiteConfig().WechatAutoResponseMsg; MessageHandler.SendTextReplyMessage(msg.ToUserName, msg.FromUserName, response_msg); return(true); }
public static bool IsInternalSys(out string errormsg, out Company company, bool includedemo = true) { var siteConfig = new Utility.SiteConfig(); errormsg = string.Empty; company = null; string requestURL = WebUtil.GetContextPath(); if (siteConfig.IsDemoSite && includedemo) { errormsg = "内部系统,无须审核"; company = Foresight.DataAccess.Company.GetCompanies().Where(p => p.BaseURL.Contains(WebUtil.GetContextPath())).FirstOrDefault(); return(true); } if (siteConfig.IsAdminSite) { errormsg = "内部系统,无须审核"; company = Foresight.DataAccess.Company.GetCompanies().Where(p => p.BaseURL.Contains(WebUtil.GetContextPath())).FirstOrDefault(); return(true); } if (requestURL.Contains("http://localhost")) { company = Foresight.DataAccess.Company.GetCompanies().FirstOrDefault(); errormsg = "本地系统,测试使用"; return(true); } return(false); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var site_config = new Utility.SiteConfig(); IsMallOn = site_config.IsMallOn; IsMallBusinessOn = site_config.IsMallBusinessOn; IsMallInHouseUserOn = site_config.IsMallInHouseUserOn; if (!string.IsNullOrEmpty(Request.QueryString["type"])) { int.TryParse(Request.QueryString["type"], out type); } if (!string.IsNullOrEmpty(Request.QueryString["msgtypeid"])) { int.TryParse(Request.QueryString["msgtypeid"], out msgtypeid); } if (!string.IsNullOrEmpty(Request.QueryString["MsgType"])) { MsgType = Request.QueryString["MsgType"]; } var list = Foresight.DataAccess.Wechat_MsgCategory.GetWechat_MsgCategories().OrderBy(p => p.SortOrder).ToArray(); var list_items = list.Select(p => { var item = new { ID = p.ID, CategoryName = p.CategoryName }; return(item); }); this.hdCategory.Value = JsonConvert.SerializeObject(list_items); int.TryParse(Request.QueryString["ID"], out ID); if (ID > 0) { var data = Foresight.DataAccess.Wechat_Msg.GetWechat_Msg(ID); if (data != null) { SetInfo(data); return; } } if (type == 1) { this.tdIsWechatSend.Checked = true; } if (type == 2) { this.tdIsCustomerAPPSend.Checked = true; } if (type == 3) { this.tdIsUserAPPSend.Checked = true; } this.tdPublishTime.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } }
public static int GetFromCompanyID(HttpContext context) { var config = new Utility.SiteConfig(); int CompanyID = 0; if (!string.IsNullOrEmpty(config.ServerSiteID)) { CompanyID = int.Parse(config.ServerSiteID); return(CompanyID); } var defaultcompany = Company.GetCompanies().FirstOrDefault(); if (defaultcompany != null) { return(defaultcompany.FromCompanyID); } return(0); }
public static bool doPostSmsMethod(string[] PhoneNumbers, List <string> paramList, string templateID, ref string sendResult, string sign = "") { try { var config = new Utility.SiteConfig(); Credential cred = new Credential { SecretId = config.tencentSecretId, SecretKey = config.tencentSecretKey }; ClientProfile clientProfile = new ClientProfile(); HttpProfile httpProfile = new HttpProfile(); httpProfile.Endpoint = ("sms.tencentcloudapi.com"); clientProfile.HttpProfile = httpProfile; SmsClient client = new SmsClient(cred, "", clientProfile); SendSmsRequest req = new SendSmsRequest(); PhoneNumbers = PhoneNumbers.Select(p => { return("+86" + p); }).ToArray(); string strParams = "{\"PhoneNumberSet\":" + Utility.JsonConvert.SerializeObject(PhoneNumbers) + ",\"TemplateID\":\"" + templateID + "\",\"Sign\":\"" + sign + "\",\"TemplateParamSet\":" + Utility.JsonConvert.SerializeObject(paramList) + ",\"SmsSdkAppid\":\"" + config.tencentAppID + "\"}"; req = SendSmsRequest.FromJsonString <SendSmsRequest>(strParams); SendSmsResponse resp = client.SendSmsSync(req); sendResult = Utility.JsonConvert.SerializeObject(resp); if (resp.SendStatusSet != null && resp.SendStatusSet.Length > 0 && resp.SendStatusSet[0].Code.ToLower().Equals("ok")) { return(true); } sendResult = Utility.JsonConvert.SerializeObject(resp); Utility.LogHelper.WriteInfo("Utility.TencentSms.doPostSmsMethod", sendResult); return(false); } catch (Exception ex) { sendResult = ex.Message; LogHelper.WriteError("Utility.TencentSms", "doPostSmsMethod", ex); return(false); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["typeid"])) { int.TryParse(Request.QueryString["typeid"], out ServiceTypeID); } int BaoXiuServiceID = new Utility.SiteConfig().BaoXiuServiceID; var typeList = Foresight.DataAccess.ServiceType.GetServiceTypes().ToArray(); var typeList2 = typeList.Where(p => p.ParentID == BaoXiuServiceID).ToArray(); var BaoShiServiceIDList = new SiteConfig().BaoShiServiceIDList; if (BaoShiServiceIDList != null && BaoShiServiceIDList.Length > 0) { if (ServiceTypeID == 3)//报修 { typeList2 = typeList2.Where(p => !BaoShiServiceIDList.Contains(p.ID)).ToArray(); } if (ServiceTypeID == 4)//报事 { typeList2 = typeList2.Where(p => BaoShiServiceIDList.Contains(p.ID)).ToArray(); } } var typeItems2 = typeList2.Select(p => { var item = new { ID = p.ID, Name = p.ServiceTypeName }; return(item); }).ToList(); typeItems2.Insert(0, new { ID = 0, Name = "全部" }); typeItems2.Insert(0, new { ID = -1, Name = "不限" }); this.hdServiceTypeName2.Value = Utility.JsonConvert.SerializeObject(typeItems2); var typeList2IDList = typeList2.Select(p => p.ID).ToArray(); var typeList3 = typeList.Where(p => typeList2IDList.Contains(p.ParentID)).ToArray(); var typeItems3 = typeList3.Select(p => { var item = new { ID = p.ID, Name = p.ServiceTypeName, ParentID = p.ParentID }; return(item); }).ToList(); this.hdServiceTypeName3.Value = Utility.JsonConvert.SerializeObject(typeItems3); } }
/// <summary> /// 统计发送 /// </summary> public static bool doPullSendStatus(DateTime StartTime, DateTime EndTime, ref int FeeCount, ref int RequestCount, ref int RequestSuccessCount) { try { var config = new Utility.SiteConfig(); Credential cred = new Credential { SecretId = config.tencentSecretId, SecretKey = config.tencentSecretKey }; ClientProfile clientProfile = new ClientProfile(); HttpProfile httpProfile = new HttpProfile(); httpProfile.Endpoint = ("sms.tencentcloudapi.com"); clientProfile.HttpProfile = httpProfile; SmsClient client = new SmsClient(cred, "", clientProfile); SendStatusStatisticsRequest req = new SendStatusStatisticsRequest(); string strParams = "{}"; req = SendStatusStatisticsRequest.FromJsonString <SendStatusStatisticsRequest>(strParams); SendStatusStatisticsResponse resp = client.SendStatusStatisticsSync(req); if (resp.SendStatusStatistics != null) { FeeCount = (int)resp.SendStatusStatistics.FeeCount; RequestCount = (int)resp.SendStatusStatistics.RequestCount; RequestSuccessCount = (int)resp.SendStatusStatistics.RequestSuccessCount; return(true); } Utility.LogHelper.WriteInfo("Utility.TencentSms.doPullSendStatus", Utility.JsonConvert.SerializeObject(resp)); return(false); } catch (Exception ex) { LogHelper.WriteError("Utility.TencentSms", "doPullSendStatus", ex); return(false); } }
private static string EncriptName(string Name) { var config = new Utility.SiteConfig(); string EncriptURL = config.EncriptURL; if (!string.IsNullOrEmpty(EncriptURL) && EncriptURL.Equals("0")) { return(Name); } if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["DES"])) { string sKey = "saasyy20"; using (DESCryptoServiceProvider des = new DESCryptoServiceProvider()) { byte[] inputByteArray = Encoding.UTF8.GetBytes(Name); des.Key = ASCIIEncoding.ASCII.GetBytes(sKey); des.IV = ASCIIEncoding.ASCII.GetBytes(sKey); System.IO.MemoryStream ms = new System.IO.MemoryStream(); using (CryptoStream cs = new CryptoStream(ms, des.CreateEncryptor(), CryptoStreamMode.Write)) { cs.Write(inputByteArray, 0, inputByteArray.Length); cs.FlushFinalBlock(); cs.Close(); } string str = Convert.ToBase64String(ms.ToArray()); ms.Close(); return(str); } } else { System.Web.Security.FormsAuthenticationTicket ticket = new System.Web.Security.FormsAuthenticationTicket(1, Name, DateTime.Now, DateTime.Now.AddMinutes(10), true, string.Empty); string key = System.Web.Security.FormsAuthentication.Encrypt(ticket); return(key); } }
private static bool IsLocalSystem() { var config = new Utility.SiteConfig(); return(Convert.ToBoolean(config.IsLocalSite)); }
private void upgradeweixinsite(HttpContext context) { string IDs = context.Request["IDList"]; List <int> IDList = new List <int>(); if (!string.IsNullOrEmpty(IDs)) { IDList = JsonConvert.DeserializeObject <List <int> >(IDs); } if (IDList.Count == 0) { WebUtil.WriteJson(context, new { status = false, error = "公司为空" }); return; } HttpPostedFile postedFile = context.Request.Files[0]; string fileName = postedFile.FileName; if (fileName == "" || fileName == null) { WebUtil.WriteJson(context, new { status = false, error = "请上传文件" }); return; } string extension = System.IO.Path.GetExtension(fileName).ToLower(); fileName = DateTime.Now.ToFileTime().ToString() + extension; string filepath = "/upload/"; string rootPath = HttpContext.Current.Server.MapPath("~" + filepath); if (!System.IO.Directory.Exists(rootPath)) { System.IO.Directory.CreateDirectory(rootPath); } string ZipPath = rootPath + fileName; postedFile.SaveAs(ZipPath); var companys = Foresight.DataAccess.Company.GetAllActiveCompanyList().Where(p => IDList.Contains(p.CompanyID)).ToArray(); var config = new Utility.SiteConfig(); string SitePath = config.Wechat_SitePath; string SiteName = config.SiteName; foreach (var company in companys) { if (!company.BaseURL.Contains(config.SITE_URL)) { WebUtil.WriteJson(context, new { status = false, error = "功能不支持,请手动配置微信" }); return; } string NewFileName = company.BaseURL.Replace(config.SITE_URL, ""); string VirName = NewFileName; string Sub_VirName = "html"; if (NewFileName.StartsWith("http://")) { NewFileName = "saas"; VirName = "html"; Sub_VirName = ""; } int SiteNumber = int.Parse(config.SiteNumber); Utility.Tools.UnZipFile(ZipPath, SitePath, NewFileName); string my_sitepath = SitePath + NewFileName + @"\html"; bool sitestatus = IISManager.CreateWebSite(SiteName, VirName, my_sitepath, false, 1, SiteNumber, "localhost", Sub_VirName); } WebUtil.WriteJson(context, new { status = true }); }
private void upgrade_out_company_file(List <Foresight.DataAccess.Company> company_list, Foresight.DataAccess.SiteVersion site_version, out string error_sites, out List <Foresight.DataAccess.Company> company_list_out) { error_sites = string.Empty; company_list_out = new List <Foresight.DataAccess.Company>(); var config = new Utility.SiteConfig(); string base_url = config.SITE_URL; string SitePath = config.SitePath; var version_list = Foresight.DataAccess.SiteVersion.GetSiteVersions(); int VersionCode = site_version.VersionCode; foreach (var company in company_list) { company.VersionCode = company.VersionCode > 0 ? company.VersionCode : 1; List <Utility.SiteVersionModel> site_version_model_list = new List <Utility.SiteVersionModel>(); for (int i = company.VersionCode + 1; i <= VersionCode; i++) { var current_version = version_list.FirstOrDefault(p => p.VersionCode == i); if (current_version == null) { continue; } Utility.SiteVersionModel site_version_model = null; string SqlPath = current_version.SqlPath; if (!string.IsNullOrEmpty(SqlPath)) { string extension = System.IO.Path.GetExtension(current_version.SqlPath).ToLower(); if (extension.ToLower().Contains("sql")) { if (site_version_model == null) { site_version_model = new Utility.SiteVersionModel(); site_version_model.VersionCode = current_version.VersionCode; } site_version_model.SqlPath = WebUtil.GetContextPath() + SqlPath; } } string FilePath = current_version.FilePath; if (!string.IsNullOrEmpty(FilePath)) { string extension = System.IO.Path.GetExtension(FilePath).ToLower(); if (extension.ToLower().Contains("zip")) { if (site_version_model == null) { site_version_model = new Utility.SiteVersionModel(); site_version_model.VersionCode = current_version.VersionCode; } site_version_model.FilePath = WebUtil.GetContextPath() + FilePath; } } if (site_version_model != null) { site_version_model_list.Add(site_version_model); } } if (EncryptHelper.DoUpgradeSite(company, site_version_model_list, VersionCode, out error_sites)) { company_list_out.Add(company); } } }
/// <summary> /// /// </summary> /// <param name="ServiceID"></param> /// <param name="ErrorMsg"></param> /// <param name="title"></param> /// <param name="SendUserID"></param> /// <param name="SendUserName"></param> /// <param name="service"></param> /// <param name="AccpetUserType">1-通知接单人 2-通知处理人</param> /// <returns></returns> public static bool SendJpushMsgByServiceID(int ServiceID, out string ErrorMsg, string title = "", int SendUserID = 0, string SendUserName = "", Foresight.DataAccess.CustomerService service = null, List <int> ServiceAccpetManIDList = null, List <int> ServiceProcessManIDList = null, bool isReturnNotify = false) { ErrorMsg = ""; var config = new Utility.SiteConfig(); if (string.IsNullOrEmpty(config.JPushKey_User)) { ErrorMsg = "推送未配置"; return(false); } if (service == null) { service = Foresight.DataAccess.CustomerService.GetCustomerService(ServiceID); } if (service == null) { ErrorMsg = "ID不合法"; return(false); } string result = string.Empty; string result_push = string.Empty; string result_ios = string.Empty; #region 派单人推送 if (service.ServiceStatus == 10 || service.ServiceStatus == 3) { if (ServiceAccpetManIDList == null) { ServiceAccpetManIDList = Foresight.DataAccess.CustomerService_Accpet.GetCustomerService_AccpetListByServiceID(ServiceID, new int[] { 0, 1 }, AccpetUserType: 1).Select(p => p.AccpetManID).ToList(); } if (ServiceAccpetManIDList.Count > 0)//待派单 { var users = Foresight.DataAccess.User.GetPushUserListByIDListByIDList(ServiceAccpetManIDList); if (users.Length > 0) { Dictionary <string, object> extras = new Dictionary <string, object>(); string pushMsg = string.Empty; if (isReturnNotify) { pushMsg = "您有新工单需要重新派单,请尽快处理"; } var extra_model = new Utility.JpushContent(service.ServiceStatus, Msg: pushMsg, Type: "customerservice"); extras["code"] = extra_model.code; extras["msg"] = extra_model.msg; extras["type"] = extra_model.type; extras["id"] = service.ID; extras["status"] = service.ServiceStatus; extras["isreturn"] = isReturnNotify; var users_android = users.Where(p => p.APPUserDeviceType.Equals("android")).ToArray(); var users_ios = users.Where(p => p.APPUserDeviceType.Equals("ios")).ToArray(); string[] android_cids = new string[] { }; string[] ios_cids = new string[] { }; if (users_android.Length > 0) { android_cids = users_android.Select(p => p.APPUserDeviceID).ToArray(); } if (users_ios.Length > 0) { ios_cids = users_ios.Select(p => p.APPUserDeviceID).ToArray(); } result_push = JPush.JpushAPI.PushMessage(title, extras, android_cids, ios_cids, extra_model.msg); Foresight.DataAccess.JPushLog.Insert_JPushLog(android_cids, ios_cids, extras, result_push, 1, service.ID, true, title); } } } #endregion #region 处理人推送 if (service.ServiceStatus == 0) { if (ServiceProcessManIDList == null) { ServiceProcessManIDList = Foresight.DataAccess.CustomerService_Accpet.GetCustomerService_AccpetListByServiceID(ServiceID, new int[] { 0, 1 }, AccpetUserType: 2).Select(p => p.AccpetManID).ToList(); } if (ServiceProcessManIDList.Count > 0)//通知处理人 { var users = Foresight.DataAccess.User.GetPushUserListByIDListByIDList(ServiceProcessManIDList); if (users.Length > 0) { Dictionary <string, object> extras = new Dictionary <string, object>(); var extra_model = new Utility.JpushContent(service.ServiceStatus, Type: "customerservice"); extras["code"] = extra_model.code; extras["msg"] = extra_model.msg; extras["type"] = extra_model.type; extras["id"] = service.ID; extras["status"] = service.ServiceStatus; var users_android = users.Where(p => p.APPUserDeviceType.Equals("android")).ToArray(); var users_ios = users.Where(p => p.APPUserDeviceType.Equals("ios")).ToArray(); string[] android_cids = new string[] { }; string[] ios_cids = new string[] { }; if (users_android.Length > 0) { android_cids = users_android.Select(p => p.APPUserDeviceID).ToArray(); } if (users_ios.Length > 0) { ios_cids = users_ios.Select(p => p.APPUserDeviceID).ToArray(); } result_push = JPush.JpushAPI.PushMessage(title, extras, android_cids, ios_cids, extra_model.msg); Foresight.DataAccess.JPushLog.Insert_JPushLog(android_cids, ios_cids, extras, result_push, 1, service.ID, true, title); } } } #endregion service.IsAPPSend = true; service.SendUserID = SendUserID; service.SendUserName = SendUserName; service.APPSendTime = DateTime.Now; service.APPSendResult = result_push; service.Save(); return(true); }
private void savesite(HttpContext context) { try { var config = new Utility.SiteConfig(); string VirName = context.Request.Params["sitename"]; int CompanyID = int.Parse(context.Request.Params["CompanyID"]); int SiteNumber = int.Parse(config.SiteNumber); string SiteName = config.SiteName; string ZipPath = config.ZipPath; string SitePath = config.SitePath; int ServerLocation = WebUtil.GetIntValue(context, "ServerLocation"); int VersionCode = 1; int.TryParse(config.SysVersionCode, out VersionCode); var company = Foresight.DataAccess.Company.GetCompany(CompanyID); if (company == null) { WebUtil.WriteJsonError(context, ErrorCode.InvalideRequest, "公司已删除"); return; } if (string.IsNullOrEmpty(VirName)) { WebUtil.WriteJsonError(context, ErrorCode.InvalideRequest, "网址不能为空"); return; } company.ServerLocation = ServerLocation; if (company.ServerLocation == 1) { if (!VirName.ToLower().StartsWith("http://") && !VirName.ToLower().StartsWith("https://")) { WebUtil.WriteJsonError(context, ErrorCode.InvalideRequest, "网址输入不正确"); return; } company.BaseURL = VirName; company.IsActive = true; company.IsAdmin = false; company.IsCustomer = true; company.VersionCode = company.VersionCode > 0 ? company.VersionCode : VersionCode; company.Save(); WebUtil.WriteJsonResult(context, "生成成功"); return; } if (!string.IsNullOrEmpty(company.BaseURL)) { WebUtil.WriteJsonError(context, ErrorCode.InvalideRequest, "网址已分配"); return; } var URLList = Foresight.DataAccess.Company.GetCompanies().Select(p => p.BaseURL); if (URLList.Any(p => p.Contains(VirName))) { WebUtil.WriteJsonError(context, ErrorCode.InvalideRequest, "网站已存在"); return; } string SiteURL = config.SITE_URL + VirName; string DBName = "yy_" + VirName; try { Utility.Tools.UnZipFile(ZipPath, SitePath, VirName); bool sitestatus = IISManager.CreateWebSite(SiteName, VirName, SitePath + VirName, false, 1, SiteNumber, "localhost"); //if (!sitestatus) //{ // WebUtil.WriteJsonError(context, ErrorCode.InvalideRequest, "网站已存在"); // return; //} string ConfigPath = SitePath + VirName + @"\Web.config"; if (!System.IO.File.Exists(ConfigPath)) { ConfigPath = SitePath + @"Web.config"; } if (System.IO.File.Exists(ConfigPath)) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic["SITE_URL"] = SiteURL; dic["CompanyName"] = company.CompanyName; dic["CopyRight"] = DateTime.Now.Year.ToString() + " " + company.CompanyName; dic["ConnString"] = config.ConnString + ";database=" + DBName; Utility.IISManager.UpdateConfigValue(ConfigPath, dic); } } catch (Exception) { } #region 生成数据库 try { Utility.SQLHelper.CreateDataBase(DBName, CompanyID); company.BaseURL = SiteURL; company.IsActive = true; company.IsAdmin = false; company.IsCustomer = true; company.VersionCode = VersionCode; company.Save(); string sqltext = @"insert into [" + DBName + "].[dbo].[Company]([CompanyName],[CompanyDesc],[PhoneNumber],[Address],[ChargePerson],[AddTime],[IsActive],[BaseURL],[VersionCode]) select [CompanyName],[CompanyDesc],[PhoneNumber],[Address],[ChargePerson],[AddTime],[IsActive],[BaseURL],[VersionCode] from [prosystem].[dbo].[Company] where CompanyID=" + company.CompanyID + ";"; Utility.SQLHelper.ExecuteSql("master", sqltext); sqltext = @"insert into [" + DBName + "].[dbo].[User]([LoginName],[Password],[PhoneNumber],[Email],[HeadImg],[NickName],[RealName],[Gender],[Type],[CreateTime],[IsLocked],[LockTime]) select [LoginName],[Password],[PhoneNumber],[Email],[HeadImg],[NickName],[RealName],[Gender],[Type],[CreateTime],[IsLocked],[LockTime] from [prosystem].[dbo].[User] where UserID in (select UserID from [prosystem].[dbo].[UserCompany] where [CompanyID]=" + CompanyID + ");"; Utility.SQLHelper.ExecuteSql("master", sqltext); } catch (Exception) { } #endregion WebUtil.WriteJsonResult(context, "生成成功"); } catch (Exception ex) { WebUtil.WriteJsonError(context, ErrorCode.InvalideRequest, ex); } }
private void socketinit(HttpContext context) { var config = new Utility.SiteConfig(); WebUtil.WriteJson(context, new { loginname = Web.WebUtil.GetUserLoginFullName(context) + Web.WebUtil.GetUser(context).LoginName, guid = HttpContext.Current.User.Identity.Name, url = config.SITE_URL, socketserver = config.SocketURL }); }
private void GetProjectTree(HttpContext context) { int CompanyID = WebUtil.GetIntValue(context, "CompanyID"); int ID = WebUtil.GetIntValue(context, "ID"); string Keywords = context.Request.Params["Keywords"]; int RoleID = WebUtil.GetIntValue(context, "RoleID"); int UserID = WebUtil.GetIntValue(context, "UserID"); ProjectTree[] list = ProjectTree.GetProjectTreeListByRoleIDAndUserID(ID, Keywords, RoleID, UserID, CompanyID: CompanyID).ToArray(); List <Dictionary <string, object> > items = null; var dic = new Dictionary <string, object>(); if (string.IsNullOrEmpty(Keywords)) { items = list.Select(p => { dic = p.ToJsonObject(); dic["type"] = Utility.EnumModel.ProjectTreeTypeDefine.project.ToString(); dic["name"] = p.Name; dic["id"] = p.ID; dic["pId"] = p.ParentID == 1 ? Utility.EnumModel.ProjectTreeTypeDefine.company.ToString() + "_" + p.CompanyID : p.ParentID.ToString(); dic["iconSkin"] = "Icon_" + p.IconID; dic["open"] = true; dic["checked"] = false; if (RoleID > 0) { dic["checked"] = RoleID == p.RoleID; } if (UserID > 0) { dic["checked"] = UserID == p.UserID; } return(dic); }).ToList(); if (CompanyID <= 0 && ID <= 0) { var companyList = Foresight.DataAccess.Company.GetCompanies().ToArray(); var companyRoleList = Foresight.DataAccess.UserCompany.GetUserCompanies().ToArray(); if (RoleID > 0) { companyRoleList = companyRoleList.Where(p => p.RoleID == RoleID).ToArray(); } else { companyRoleList = companyRoleList.Where(p => p.UserID == UserID).ToArray(); } var companyItems = companyList.Select(p => { var myCompanyRole = companyRoleList.FirstOrDefault(q => q.CompanyID == p.CompanyID); var type = Utility.EnumModel.ProjectTreeTypeDefine.company.ToString(); dic = new Dictionary <string, object>(); dic["ID"] = p.CompanyID; dic["ParentID"] = 1; dic["Name"] = p.CompanyName; dic["FullName"] = p.CompanyName; dic["isParent"] = true; dic["CompanyID"] = p.CompanyID; dic["id"] = type + "_" + p.CompanyID; dic["pId"] = 1; dic["name"] = p.CompanyName; dic["type"] = Utility.EnumModel.ProjectTreeTypeDefine.company.ToString(); dic["iconSkin"] = "Icon_0"; dic["open"] = "true"; dic["isRoom"] = false; dic["IsLocked"] = false; dic["chkDisabled"] = false; dic["checked"] = myCompanyRole != null; return(dic); }).ToList(); items.AddRange(companyItems); dic = new Dictionary <string, object>(); dic["ID"] = 1; dic["ParentID"] = 0; dic["Name"] = new Utility.SiteConfig().CompanyName; dic["FullName"] = string.Empty; dic["isParent"] = true; dic["CompanyID"] = 0; dic["id"] = 1; dic["pId"] = 0; dic["name"] = new Utility.SiteConfig().CompanyName; dic["type"] = Utility.EnumModel.ProjectTreeTypeDefine.company.ToString(); dic["iconSkin"] = "Icon_0"; dic["open"] = "true"; dic["isRoom"] = false; dic["IsLocked"] = false; dic["chkDisabled"] = false; items.Add(dic); } } else { items = list.Select(p => { dic = p.ToJsonObject(); if (p.ID == 1) { var company = Company.GetCompany(CompanyID); dic["name"] = company.CompanyName; } else { dic["name"] = p.FullName + p.Name; } dic["id"] = p.ID; dic["pId"] = p.ParentID; dic["iconSkin"] = "Icon_" + p.IconID; dic["open"] = true; dic["checked"] = false; if (RoleID > 0) { dic["checked"] = RoleID == p.RoleID; } if (UserID > 0) { dic["checked"] = UserID == p.UserID; } return(dic); }).ToList(); } WebUtil.WriteJson(context, items); }
private void savewxservice(HttpContext context) { int ProjectID = WebUtil.GetIntValue(context, "ProjectID"); if (ProjectID <= 0) { WebUtil.WriteJsonError(context, ErrorCode.InvalideRequest, "请选择项目"); return; } var service = new Foresight.DataAccess.CustomerService(); service.AddTime = DateTime.Now; service.AddMan = context.Request.Params["AddMan"]; service.AddUserID = 0; service.IsSuggestion = WebUtil.GetBoolValue(context, "IsSuggestion"); service.ServiceStatus = 3; service.ServiceFullName = context.Request["FullName"]; service.ProjectID = ProjectID; service.ServiceType1ID = WebUtil.GetIntValue(context, "TypeID1"); int TypeID2 = WebUtil.GetIntValue(context, "TypeID2"); int TypeID3 = WebUtil.GetIntValue(context, "TypeID3"); if (TypeID2 > 0) { service.ServiceType2ID = "[" + TypeID2 + "]"; } if (TypeID3 > 0) { service.ServiceType3ID = "[" + TypeID3 + "]"; } service.ProjectName = context.Request["ProjectName"]; service.ServiceFullName = service.ProjectName; service.AddUserName = "******"; service.StartTime = DateTime.Now;//反应时间 int OrderNumberID = 0; string ServiceNumber = Foresight.DataAccess.CustomerService.GetLastestCustomerServiceNumber(Foresight.DataAccess.OrderTypeNameDefine.customerservice.ToString(), 0, out OrderNumberID); service.ServiceNumber = ServiceNumber; service.OrderNumberID = OrderNumberID; service.AddCustomerName = context.Request["AddCustomerName"]; //反映人 service.AddCallPhone = context.Request["PhoneNo"]; //反映人联系电话 service.ServiceContent = context.Request["Content"]; service.ServiceAppointTime = WebUtil.GetDateValue(context, "AppointTime"); service.ServiceFrom = Utility.EnumModel.WechatServiceFromDefine.weixin.ToString(); List <Foresight.DataAccess.CustomerServiceAttach> attachlist = new List <Foresight.DataAccess.CustomerServiceAttach>(); string FilePaths = context.Request["FilePaths"]; List <Dictionary <string, object> > FilePathList = new List <Dictionary <string, object> >(); if (!string.IsNullOrEmpty(FilePaths)) { FilePathList = Utility.JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(FilePaths); } HttpFileCollection uploadFiles = context.Request.Files; foreach (var item in FilePathList) { Foresight.DataAccess.CustomerServiceAttach attach = new Foresight.DataAccess.CustomerServiceAttach(); attach.FileOriName = item["FileOriName"].ToString(); attach.AttachedFilePath = item["FilePath"].ToString(); attach.AddTime = DateTime.Now; attachlist.Add(attach); } using (SqlHelper helper = new SqlHelper()) { try { helper.BeginTransaction(); service.Save(helper); foreach (var item in attachlist) { item.ServiceID = service.ID; item.Save(helper); } helper.Commit(); } catch (Exception ex) { Utility.LogHelper.WriteError("ServiceHandler", "命令: savewxservice", ex); helper.Rollback(); WebUtil.WriteJsonError(context, ErrorCode.InvalideRequest, ex.Message); return; } } if (!service.IsSuggestion) { string title = new Utility.SiteConfig().CompanyName; APPCode.SocketNotify.PushSocketNotifyAlert(EnumModel.SocketNotifyDefine.notifyservice, ID: service.ID); } else { string notify_msg = APPCode.SocketNotify.PushSocketNotifyAlert(EnumModel.SocketNotifyDefine.notifysuggestion, ID: service.ID); } WebUtil.WriteJsonResult(context, "Success"); }
private void upgradecompany_file(List <Foresight.DataAccess.Company> company_list, Foresight.DataAccess.SiteVersion site_version, out string error_sql_sites, out string error_file_sites, out List <Foresight.DataAccess.Company> company_list_out) { error_sql_sites = string.Empty; error_file_sites = string.Empty; company_list_out = new List <Foresight.DataAccess.Company>(); var config = new Utility.SiteConfig(); string base_url = config.SITE_URL; string SitePath = config.SitePath; var version_list = Foresight.DataAccess.SiteVersion.GetSiteVersions().Where(p => p.VersionType.Equals("platform") || string.IsNullOrEmpty(p.VersionType)).OrderByDescending(p => p.VersionCode); foreach (var company in company_list) { if (!company.BaseURL.ToLower().StartsWith(base_url)) { continue; } string SiteName = company.BaseURL.Replace(base_url, ""); company.VersionCode = company.VersionCode > 0 ? company.VersionCode : 1; string FilePath = string.Empty; for (int i = company.VersionCode + 1; i <= site_version.VersionCode; i++) { var current_version = version_list.FirstOrDefault(p => p.VersionCode == i); if (current_version == null) { continue; } string SqlPath = current_version.SqlPath; if (!string.IsNullOrEmpty(SqlPath)) { string extension = System.IO.Path.GetExtension(current_version.SqlPath).ToLower(); if (extension.ToLower().Contains("sql")) { try { string SQLFullPath = HttpContext.Current.Server.MapPath("~" + SqlPath); string DatabaseName = "yy_" + SiteName; Utility.SQLHelper.ExecuteSQLFile(SQLFullPath, DatabaseName); if (!company_list_out.Select(p => p.CompanyID).ToList().Contains(company.CompanyID)) { company_list_out.Add(company); } } catch (Exception ex) { error_sql_sites += company.CompanyName + ","; LogHelper.WriteError("更新数据库失败", company.CompanyName, ex); } } } if (!string.IsNullOrEmpty(current_version.FilePath)) { FilePath = current_version.FilePath; } } if (!string.IsNullOrEmpty(FilePath)) { string extension = System.IO.Path.GetExtension(FilePath).ToLower(); if (extension.ToLower().Contains("zip")) { try { string FileFullPath = HttpContext.Current.Server.MapPath("~" + FilePath); string SiteFullPath = SitePath + SiteName; Utility.Tools.UnZipFile(FileFullPath, SiteFullPath, ""); if (!company_list_out.Select(p => p.CompanyID).ToList().Contains(company.CompanyID)) { company_list_out.Add(company); } } catch (Exception ex) { error_file_sites += company.CompanyName + ","; LogHelper.WriteError("更新系统文件失败", company.CompanyName, ex); } } } } }