private void updateprojectorder(HttpContext context)
{
var url_list = Foresight.DataAccess.Company.GetAllActiveCompanyList().Where(p => !p.BaseURL.Contains("saasyy.com")).Select(o => o.BaseURL).ToList();
string error_urls = string.Empty;
foreach (var url in url_list)
{
string apiurl = url + "/Handler/ProjectHandler.ashx";
try
{
Foresight.Web.HttpRequest.Post(null, new Dictionary <string, string>()
{
{ "visit", "saveprojectneworder" }, { "ProjectID", "1" }, { "SortOrder", "1" }
}, apiurl: apiurl);
}
catch (Exception ex)
{
error_urls += apiurl + ",";
Utility.LogHelper.WriteError("UpdateProjectOrder", url, ex);
}
}
if (string.IsNullOrEmpty(error_urls))
{
WebUtil.WriteJson(context, "成功");
}
else
{
WebUtil.WriteJson(context, error_urls + "失败");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string visit = context.Request.Params["visit"];
try
{
switch (visit.ToLower())
{
case "getsites":
getsites(context);
break;
case "savesites":
savesites(context);
break;
case "deletesites":
deletesites(context);
break;
case "upgradecompany":
upgradecompany(context);
break;
case "updateweishu":
updateweishu(context);
break;
case "updateorder":
updateprojectorder(context);
break;
case "rechargeroomfee":
rechargeroomfee(context);
break;
case "updateallsiteweishu":
updateallsiteweishu(context);
break;
case "insertimportfeebyhistory":
insertimportfeebyhistory(context);
break;
case "updatehistoryfeechageid":
updatehistoryfeechageid(context);
break;
default:
WebUtil.WriteJson(context, new { status = false });
break;
}
}
catch (Exception ex)
{
LogHelper.WriteError("Web.CommHandler", "visit: " + visit, ex);
WebUtil.WriteJson(context, new { status = false });
}
}
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 updatehistoryfeechageid(HttpContext context)
{
HttpFileCollection uploadFiles = context.Request.Files;
if (uploadFiles.Count == 0)
{
context.Response.Write("请选择一个文件");
return;
}
if (string.IsNullOrEmpty(uploadFiles[0].FileName))
{
context.Response.Write("请选择一个文件");
return;
}
HttpPostedFile postedFile = uploadFiles[0];
string filepath = HttpContext.Current.Server.MapPath("~/upload/Temp/" + DateTime.Now.ToString("yyyyMMdd"));
if (!System.IO.Directory.Exists(filepath))
{
System.IO.Directory.CreateDirectory(filepath);
}
string filename = DateTime.Now.ToLocalTime().ToString("yyyyMMddHHmmss") + "_" + postedFile.FileName;
string fullpath = Path.Combine(filepath, filename);
postedFile.SaveAs(fullpath);
DataTable table = ExcelExportHelper.NPOIReadExcel(fullpath);
var ChargeSummarys = Foresight.DataAccess.ChargeSummary.GetChargeSummaries().ToArray();
int total = 0;
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow dr = table.Rows[i];
string PrintNumber = dr["收款单号"].ToString();
string ChargeName = dr["收费项目"].ToString();
if (string.IsNullOrEmpty(PrintNumber) || string.IsNullOrEmpty(ChargeName))
{
continue;
}
var my_chargesummary = ChargeSummarys.FirstOrDefault(p => p.Name.Equals(ChargeName));
if (my_chargesummary == null)
{
continue;
}
var history_data = Foresight.DataAccess.RoomFeeHistory.GetRoomFeeHistoryByPrintNumber(PrintNumber);
if (history_data != null)
{
history_data.ChargeID = my_chargesummary.ID;
history_data.Save();
total++;
}
}
WebUtil.WriteJson(context, new { status = true, count = total });
}
private void updateallsiteweishu(HttpContext context)
{
var companys = Foresight.DataAccess.Company.GetAllActiveCompanyList();
foreach (var item in companys)
{
var dic = new Dictionary <string, object>();
dic["visit"] = "updateweishu";
Utility.HttpRequestHelper.DoPostData <Dictionary <string, object> >(dic, "/CommHandler.ashx", apiurl: item.BaseURL);
}
WebUtil.WriteJson(context, new { status = true });
}
private void updateweishu(HttpContext context)
{
var print_list = Foresight.DataAccess.PrintRoomFeeHistoryDetail.GetPrintRoomFeeHistoryDetailList().OrderBy(p => p.ID).ToArray();
foreach (var print in print_list)
{
var printRoomFeeHistory = Foresight.DataAccess.PrintRoomFeeHistory.GetPrintRoomFeeHistory(print.ID);
printRoomFeeHistory.Cost = print.HistoryCost;
decimal finalweishu = Foresight.DataAccess.PrintRoomFeeHistory.GetRoomWeiShuBalance(print.ID, 0, print.ChargeTime);
decimal ceil_historycost = Math.Ceiling(print.HistoryCost);
if (ceil_historycost != print.RealCost && ceil_historycost != (print.RealCost - 1))
{
printRoomFeeHistory.WeiShuMore = 0;
printRoomFeeHistory.WeiShuConsume = 0;
printRoomFeeHistory.WeiShuBalance = finalweishu;
}
else
{
decimal weishumore = Math.Ceiling(print.HistoryCost) - print.HistoryCost;
if (finalweishu >= (1 - weishumore))
{
printRoomFeeHistory.WeiShuMore = 0;
printRoomFeeHistory.WeiShuConsume = (1 - weishumore);
printRoomFeeHistory.WeiShuBalance = finalweishu - (1 - weishumore);
printRoomFeeHistory.RealCost = (ceil_historycost - 1);
}
else
{
printRoomFeeHistory.WeiShuMore = weishumore;
printRoomFeeHistory.WeiShuConsume = 0;
printRoomFeeHistory.WeiShuBalance = finalweishu + weishumore;
printRoomFeeHistory.RealCost = ceil_historycost;
}
}
if (printRoomFeeHistory.RealMoneyCost2 >= printRoomFeeHistory.RealCost)
{
printRoomFeeHistory.RealMoneyCost1 = 0;
printRoomFeeHistory.RealMoneyCost2 = printRoomFeeHistory.RealCost;
}
else if (printRoomFeeHistory.RealMoneyCost2 > 0)
{
printRoomFeeHistory.RealMoneyCost1 = printRoomFeeHistory.RealCost - printRoomFeeHistory.RealMoneyCost2;
}
else
{
printRoomFeeHistory.RealMoneyCost1 = printRoomFeeHistory.RealCost;
}
printRoomFeeHistory.Save();
}
WebUtil.WriteJson(context, new { status = true, IDList = print_list.Select(p => p.ID) });
}
private void rechargeroomfee(HttpContext context)
{
string tradeno = context.Request["tradeno"];
if (string.IsNullOrEmpty(tradeno))
{
WebUtil.WriteJson(context, "参数为空");
return;
}
var payment = Foresight.DataAccess.Payment.GetPaymentByTradeNo(tradeno);
if (payment == null)
{
WebUtil.WriteJson(context, "payment不存在");
return;
}
string remark = context.Request["remark"];
string paytype = context.Request["paytype"];
remark = string.IsNullOrEmpty(remark) ? "APP微信支付" : remark;
paytype = string.IsNullOrEmpty(paytype) ? "微信支付" : paytype;
Foresight.DataAccess.Payment.Insert_Payment(payment.Amount, payment.PaymentType, payment.TradeNo, payment.Status, payment.AddUser, payment.Remark, ResponseContent: payment.ResponseContent, payment: payment, CanSave: true, IsRoomFee: true);
var history_count = Foresight.DataAccess.RoomFeeHistory.GetRoomFeeHistoryCountByTradeNo(tradeno, OrderID: payment.OrderID);
if (history_count > 0)
{
WebUtil.WriteJson(context, "历史单据已存在");
return;
}
var list = Foresight.DataAccess.RoomFee.GetRoomFeeListByTradeNo(tradeno, OrderID: payment.OrderID);
if (list.Length == 0)
{
WebUtil.WriteJson(context, "待支付单据不存在");
return;
}
string result = Web.APPCode.PaymentHelper.SaveRoomFee(tradeno, remark, paytype);
WebUtil.WriteJson(context, result);
}
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 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 });
}