/// <summary> /// admin使用 /// </summary> /// <param name="company"></param> /// <param name="errormsg"></param> /// <returns></returns> public static bool SaveCompany(Foresight.DataAccess.Company company, out string errormsg) { errormsg = string.Empty; try { //if (EncryptHelper.IsInternalSys(out errormsg, false)) //{ // errormsg = "内部系统,无须审核"; // return true; //} Encript.CompanyModel my_company = GetSqlLiteCompany(company); if (my_company == null) { errormsg = "公司不存在"; return(false); } my_company.CompanyName = company.CompanyName; SqlLite.SaveCompany(my_company); errormsg = "成功"; return(true); } catch (Exception ex) { LogHelper.WriteError("SqlLiteHelper", "SaveCompany", ex); errormsg = "内部异常"; return(false); } }
public static bool SaveCompanyModule(Foresight.DataAccess.Company company, out string errormsg) { errormsg = string.Empty; try { var sys_menus = Foresight.DataAccess.SysMenu.GetSysModulesByCompany(company.CompanyID); List <CompanyModuleModel> modellist = new List <CompanyModuleModel>(); foreach (var item in sys_menus) { Encript.CompanyModuleModel model = new CompanyModuleModel(); model.CompanyID = company.CompanyID; model.ModuleID = item.ID; modellist.Add(model); } Encript.SqlLite.InsertCompanyModule(modellist.ToArray(), company.CompanyID); errormsg = ""; return(true); } catch (Exception ex) { LogHelper.WriteError("SqlLiteHelper", "SaveCompanyModule", ex); errormsg = "内部异常"; return(false); } }
public static Foresight.DataAccess.Company GetSQLCompany(string BaseURL, int FromCompanyID) { var company = GetSqlLiteCompany(BaseURL: BaseURL, FromCompanyID: FromCompanyID); if (company == null) { return(null); } var my_company = new Foresight.DataAccess.Company(); my_company.CompanyID = company.CompanyID; my_company.BaseURL = company.BaseURL; my_company.CompanyName = company.CompanyName; my_company.IsActive = company.IsActive; my_company.BaseURL = company.BaseURL; my_company.UserCount = company.UserCount; my_company.ServerStartTime = company.ServerStartTime; my_company.ServerEndTime = company.ServerEndTime; my_company.IsPay = company.IsPay; my_company.IsAdmin = company.IsAdmin; my_company.IsCustomer = company.IsCustomer; my_company.Login_LogImg = company.Login_LogImg; my_company.Login_BodyImg = company.Login_BodyImg; my_company.Home_LogoImg = company.Home_LogoImg; my_company.VersionCode = company.VersionCode; return(my_company); }
private void upgradecompany_file(Foresight.DataAccess.Company company, List <SiteVersionModel> version_list, int VersionCode, out string error_sql_sites, out string error_file_sites) { error_sql_sites = string.Empty; error_file_sites = string.Empty; string DatabaseName = ConfigurationManager.AppSettings["DatabaseName"]; string SiteFullPath = ConfigurationManager.AppSettings["SiteLocation"]; company.VersionCode = company.VersionCode > 0 ? company.VersionCode : 1; string FilePath = string.Empty; for (int i = company.VersionCode + 1; i <= 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 SQLFullPath = DownloadFile(SqlPath, ".sql"); try { Utility.SQLHelper.ExecuteSQLFile(SQLFullPath, DatabaseName); } 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(error_sql_sites) && string.IsNullOrEmpty(error_file_sites)) { company.VersionCode = current_version.VersionCode; company.Save(); } } if (!string.IsNullOrEmpty(FilePath)) { string FileFullPath = DownloadFile(FilePath, ".zip"); try { Utility.Tools.UnZipFile(FileFullPath, SiteFullPath, ""); } catch (Exception ex) { error_file_sites += company.CompanyName + ","; LogHelper.WriteError("更新系统文件失败", company.CompanyName, ex); } } }
public static bool CheckCompany(string BaseURL, int FromCompanyID, out string errormsg) { errormsg = string.Empty; try { if (string.IsNullOrEmpty(BaseURL)) { errormsg = "公司域名不合法"; return(false); } Foresight.DataAccess.Company company = GetSQLCompany(BaseURL, FromCompanyID); if (company == null) { errormsg = "公司未登记"; return(false); } if (company.IsAdmin) { return(true); } if (!company.IsPay) { errormsg = "当前公司未付费,禁止登陆"; return(false); } if (DateTime.Now < company.ServerStartTime || DateTime.Now > company.ServerEndTime) { errormsg = "当前公司已超过使用期限,禁止登陆"; return(false); } return(true); } catch (Exception ex) { LogHelper.WriteError("SqlLiteHelper", "CheckCompany", ex); errormsg = "内部异常"; return(false); } }
public static Encript.CompanyModel GetSqlLiteCompany(Foresight.DataAccess.Company company = null, string BaseURL = "", int FromCompanyID = 0) { if (company == null && string.IsNullOrEmpty(BaseURL)) { return(null); } BaseURL = company != null ? company.BaseURL : BaseURL; FromCompanyID = company != null ? company.CompanyID : FromCompanyID; var my_company = SqlLite.GetMyCompany(BaseURL, FromCompanyID); if (company == null) { return(my_company); } if (my_company == null) { my_company = new Encript.CompanyModel(); my_company.CompanyID = company.CompanyID; my_company.BaseURL = company.BaseURL; SqlLite.InsertCompany(my_company); } my_company.CompanyName = company.CompanyName; my_company.IsActive = company.IsActive; my_company.BaseURL = company.BaseURL; my_company.UserCount = company.UserCount; my_company.ServerStartTime = company.ServerStartTime; my_company.ServerEndTime = company.ServerEndTime; my_company.IsPay = company.IsPay; my_company.IsAdmin = company.IsAdmin; my_company.IsCustomer = company.IsCustomer; my_company.Login_LogImg = company.Login_LogImg; my_company.Login_BodyImg = company.Login_BodyImg; my_company.Home_LogoImg = company.Home_LogoImg; my_company.VersionCode = company.VersionCode; return(my_company); }
public static bool GetCompanyInfo(string BaseURL, int FromCompanyID, out string errormsg, out Foresight.DataAccess.Company company, bool includedemo = true) { company = null; errormsg = string.Empty; try { if (EncryptHelper.IsInternalSys(out errormsg, out company, includedemo)) { return(true); } if (string.IsNullOrEmpty(BaseURL)) { return(false); } company = GetSQLCompany(BaseURL, FromCompanyID); if (company == null) { errormsg = "公司不存在"; return(false); } errormsg = "成功"; return(true); } catch (Exception ex) { LogHelper.WriteError("SqlLiteHelper", "GetCompanyInfo", ex); errormsg = "内部异常"; return(false); } }