/// <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);
}
}
