private void insertimportfeebyhistory(HttpContext context) { int ID = WebUtil.GetIntValue(context, "ID"); if (ID <= 0) { WebUtil.WriteJson(context, "ID不合法"); return; } int ChargeID = WebUtil.GetIntValue(context, "ChargeID"); if (ChargeID <= 0) { WebUtil.WriteJson(context, "ChargeID不合法"); return; } List <int> ProjectIDList = new List <int>(); ProjectIDList.Add(ID); var list = Foresight.DataAccess.RoomFeeHistory.GetRoomFeeHistoryListByRoomIDList(new List <int>(), ChargeID: ChargeID, ProjectIDList: ProjectIDList, OnlyChargeFee: true); foreach (var item in list) { if (item.ImportFeeID > 0) { Foresight.DataAccess.ImportFee.GetOrCreateImportFeeByID(item.ImportFeeID); } } WebUtil.WriteJson(context, "success"); }
private void upgradecompany(HttpContext context) { string VersionType = context.Request["VersionType"]; if (VersionType.Equals("weixin")) { upgradeweixinsite(context); return; } int VersionID = WebUtil.GetIntValue(context, "VersionID"); var site_version = Foresight.DataAccess.SiteVersion.GetSiteVersion(VersionID); if (site_version == null) { WebUtil.WriteJson(context, new { status = false, error = "升级版本号不合法" }); return; } int VersionCode = site_version.VersionCode; string FilePath = site_version.FilePath; string SqlPath = site_version.SqlPath; 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; } var companys = Foresight.DataAccess.Company.GetAllActiveCompanyList().Where(p => IDList.Contains(p.CompanyID)).ToArray(); List <Foresight.DataAccess.Company> company_list = new List <Foresight.DataAccess.Company>(); List <Foresight.DataAccess.Company> out_company_list = new List <Foresight.DataAccess.Company>(); foreach (var company in companys) { company.VersionCode = company.VersionCode > 0 ? company.VersionCode : 1; if (company.VersionCode >= VersionCode) { continue; } if (company.ServerLocation == 1) { out_company_list.Add(company); } else { company_list.Add(company); } } if (company_list.Count == 0 && out_company_list.Count == 0) { WebUtil.WriteJson(context, new { status = false, error = "所选公司当前版本号全部大于升级版本号" }); return; } string error_sql_sites = string.Empty; string error_file_sites = string.Empty; string error_sites = string.Empty; if (company_list.Count > 0) { string in_error_sql_sites = string.Empty; string in_error_file_sites = string.Empty; List <Foresight.DataAccess.Company> company_list_out = new List <Foresight.DataAccess.Company>(); upgradecompany_file(company_list, site_version, out in_error_sql_sites, out in_error_file_sites, out company_list_out); if (string.IsNullOrEmpty(error_sql_sites) && string.IsNullOrEmpty(error_file_sites)) { foreach (var company in company_list_out) { company.VersionCode = VersionCode; company.Save(); } } error_sql_sites += in_error_sql_sites; error_file_sites += in_error_file_sites; } if (out_company_list.Count > 0) { string out_error_sql_sites = string.Empty; string out_error_file_sites = string.Empty; List <Foresight.DataAccess.Company> company_list_out = new List <Foresight.DataAccess.Company>(); upgrade_out_company_file(out_company_list, site_version, out error_sites, out company_list_out); if (string.IsNullOrEmpty(out_error_sql_sites) && string.IsNullOrEmpty(out_error_file_sites)) { foreach (var company in company_list_out) { company.VersionCode = VersionCode; company.Save(); } } foreach (var company in company_list_out) { company.VersionCode = VersionCode; company.Save(); } error_sql_sites += out_error_sql_sites; error_file_sites += out_error_file_sites; } string error = string.Empty; if (!string.IsNullOrEmpty(error_sql_sites)) { error += error_sql_sites + "更新数据库失败."; } if (!string.IsNullOrEmpty(error_file_sites)) { error += error_file_sites + "更新系统代码失败"; } if (!string.IsNullOrEmpty(error_sites)) { error += error_sites; } if (!string.IsNullOrEmpty(error)) { WebUtil.WriteJson(context, new { status = false, error = error }); return; } WebUtil.WriteJson(context, new { status = true }); }