private string cancelrefundaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Op.BusinessContract bc = new Business.Op.BusinessContract();
bc.load(jp.getValue("id"));
if (bc.Entity.OffLeaseStatus != "2" || bc.Entity.ContractStatus != "2")
{
flag = "3";
}
else
{
bc.Entity.OffLeaseStatus = "1";
bc.Entity.OffLeaseApplyDate = DateTime.MinValue.AddYears(1900);
bc.Entity.OffLeaseScheduleDate = DateTime.MinValue.AddYears(1900);
bc.Entity.OffLeaseReason = "";
bc.refund();
}
}
catch { }
collection.Add(new JsonStringValue("type", "cancelrefund"));
collection.Add(new JsonStringValue("flag", flag));
collection.Add(new JsonStringValue("liststr", createList(jp.getValue("ContractNoS"), jp.getValue("ContractNoManualS"), jp.getValue("ContractTypeS"),
jp.getValue("ContractSPNoS"), jp.getValue("ContractCustNoS"), jp.getValue("MinContractSignedDate"), jp.getValue("MaxContractSignedDate"),
jp.getValue("MinContractEndDate"), jp.getValue("MaxContractEndDate"), jp.getValue("OffLeaseStatusS"), jp.getValue("MinOffLeaseActulDate"),
jp.getValue("MaxOffLeaseActulDate"), ParseIntForString(jp.getValue("page")))));
return(collection.ToString());
}
private string refundsubmitaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Op.BusinessContract bc = new Business.Op.BusinessContract();
bc.load(jp.getValue("id"));
if (bc.Entity.ContractStartDate >= Convert.ToDateTime(jp.getValue("RefundDate")))
{
flag = "2";
}
else if (bc.Entity.ContractStatus != "2")
{
flag = "3";
}
else
{
string InfoBar = refund(jp.getValue("id"), jp.getValue("RefundDate"), user.Entity.UserName);
if (InfoBar != "")
{
flag = "4";
collection.Add(new JsonStringValue("InfoBar", InfoBar));
}
else
{
collection.Add(new JsonStringValue("liststr", createList(jp.getValue("ContractNoS"), jp.getValue("ContractNoManualS"), jp.getValue("ContractTypeS"),
jp.getValue("ContractSPNoS"), jp.getValue("ContractCustNoS"), jp.getValue("MinContractSignedDate"), jp.getValue("MaxContractSignedDate"),
jp.getValue("MinContractEndDate"), jp.getValue("MaxContractEndDate"), jp.getValue("OffLeaseStatusS"), jp.getValue("MinOffLeaseActulDate"),
jp.getValue("MaxOffLeaseActulDate"), ParseIntForString(jp.getValue("page")))));
#region 步到管家
try
{
string status = string.Empty;
string date = string.Empty;
bc.CheckCustStatus(out status, out date);
ButlerSrv.AppService appService = new ButlerSrv.AppService {
Timeout = 5000
};
appService.UpdateCustomer(bc.Entity.ContractCustNo, status, date);
}
catch (Exception ex)
{
collection.Add(new JsonStringValue("syncButlerException", ex.ToString()));
}
#endregion
}
}
}
catch { flag = "99"; }
collection.Add(new JsonStringValue("type", "refundsubmit"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
private string refundsubmitaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
DateTime leaveDate = Convert.ToDateTime(jp.getValue("RefundDate"));
Business.Op.BusinessContract bc = new Business.Op.BusinessContract();
bc.load(jp.getValue("id"));
if (bc.Entity.ContractStartDate >= leaveDate)
{
flag = "2";
}
else if (bc.Entity.ContractStatus != "2")
{
flag = "3";
}
else
{
string msg = bc.ContractExit(bc.Entity.RowPointer, user.Entity.UserName, jp.getValue("RefundDate"));
if (string.IsNullOrEmpty(msg))
{
//成功
collection.Add(new JsonStringValue("liststr", createList(jp.getValue("ContractNoS"), jp.getValue("ContractNoManualS"), jp.getValue("ContractTypeS"),
jp.getValue("ContractSPNoS"), jp.getValue("ContractCustNoS"), jp.getValue("MinContractSignedDate"), jp.getValue("MaxContractSignedDate"),
jp.getValue("MinContractEn dDate"), jp.getValue("MaxContractEndDate"), jp.getValue("OffLeaseStatusS"), jp.getValue("MinOffLeaseActulDate"),
jp.getValue("MaxOffLeaseActulDate"), ParseIntForString(jp.getValue("page")))));
collection.Add(new JsonStringValue("GJSync", bc.SyncButlerForCustStatus())); //同步到管家
collection.Add(new JsonStringValue("ZYSync", bc.SyncResource("rm", 1, "out", user.Entity.UserName, leaveDate))); //同步到资源
}
else
{
//失败
flag = "4";
collection.Add(new JsonStringValue("InfoBar", msg));
}
}
}
catch { flag = "99"; }
collection.Add(new JsonStringValue("type", "refundsubmit"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
private string applyrefundsubmitaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Op.BusinessContract bc = new Business.Op.BusinessContract();
bc.load(jp.getValue("id"));
if (bc.Entity.OffLeaseStatus != "1")
{
flag = "3";
}
else
{
bc.Entity.OffLeaseStatus = "2";
bc.Entity.OffLeaseApplyDate = GetDate();
bc.Entity.OffLeaseScheduleDate = ParseDateForString(jp.getValue("OffLeaseScheduleDate"));
bc.Entity.OffLeaseReason = jp.getValue("OffLeaseReason");
int r = bc.refund();
if (r <= 0)
{
flag = "2";
}
else
{
collection.Add(new JsonStringValue("liststr", createList(jp.getValue("ContractNoS"), jp.getValue("ContractNoManualS"), jp.getValue("ContractTypeS"),
jp.getValue("ContractSPNoS"), jp.getValue("ContractCustNoS"), jp.getValue("MinContractSignedDate"), jp.getValue("MaxContractSignedDate"),
jp.getValue("MinContractEndDate"), jp.getValue("MaxContractEndDate"), jp.getValue("OffLeaseStatusS"), jp.getValue("MinOffLeaseActulDate"),
jp.getValue("MaxOffLeaseActulDate"), ParseIntForString(jp.getValue("page")))));
}
}
}
catch { }
collection.Add(new JsonStringValue("type", "applyrefundsubmit"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
private string refundaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
Business.Op.BusinessContract bc = new Business.Op.BusinessContract();
bc.load(jp.getValue("id"));
if (bc.Entity.OffLeaseStatus != "2")
{
flag = "3";
}
else
{
collection.Add(new JsonStringValue("ContractNo", bc.Entity.ContractNo));
collection.Add(new JsonStringValue("ContractCustNo", bc.Entity.ContractCustNo));
collection.Add(new JsonStringValue("ContractCustName", bc.Entity.ContractCustName));
collection.Add(new JsonStringValue("ContractNoManual", bc.Entity.ContractNoManual));
collection.Add(new JsonStringValue("ContractSignedDate", ParseStringForDate(bc.Entity.ContractSignedDate)));
collection.Add(new JsonStringValue("ContractStartDate", ParseStringForDate(bc.Entity.ContractStartDate)));
collection.Add(new JsonStringValue("ContractEndDate", ParseStringForDate(bc.Entity.ContractEndDate)));
collection.Add(new JsonStringValue("EntryDate", ParseStringForDate(bc.Entity.EntryDate)));
collection.Add(new JsonStringValue("FeeStartDate", ParseStringForDate(bc.Entity.FeeStartDate)));
collection.Add(new JsonStringValue("RefundDate", jp.getValue("RefundDate")));
System.Text.StringBuilder sb = new System.Text.StringBuilder("");
sb.Append("<table class=\"table table-border table-bordered table-hover table-bg table-sort mt-5\">");
sb.Append("<thead>");
sb.Append("<tr class=\"text-c\">");
sb.Append("<th style=\"width:5%\">序号</th>");
sb.Append("<th style=\"width:18%\">房间编号</th>");
sb.Append("<th style=\"width:17%\">费用项目</th>");
sb.Append("<th style=\"width:12%\">开始日期</th>");
sb.Append("<th style=\"width:12%\">截止日期</th>");
sb.Append("<th style=\"width:12%\">数量</th>");
sb.Append("<th style=\"width:12%\">单价</th>");
sb.Append("<th style=\"width:12%\">金额</th>");
sb.Append("</tr>");
sb.Append("</thead>");
int r = 1;
sb.Append("<tbody>");
foreach (DataRow dr in GetRefundFeeList(jp.getValue("id"), jp.getValue("RefundDate")).Rows)
{
sb.Append("<tr class=\"text-c\" id=\"" + dr["RowPointer"].ToString() + "\">");
sb.Append("<td align='center'>" + r.ToString() + "</td>");
sb.Append("<td>" + dr["RMID"].ToString() + "</td>");
sb.Append("<td>" + dr["SRVName"].ToString() + "</td>");
sb.Append("<td>" + ParseStringForDate(ParseDateForString(dr["FeeStartDate"].ToString())) + "</td>");
sb.Append("<td>" + ParseStringForDate(ParseDateForString(dr["FeeEndDate"].ToString())) + "</td>");
sb.Append("<td>" + ParseDecimalForString(dr["FeeQty"].ToString()).ToString("0.####") + "</td>");
sb.Append("<td>" + ParseDecimalForString(dr["FeeUnitPrice"].ToString()).ToString("0.####") + "</td>");
sb.Append("<td>" + ParseDecimalForString(dr["FeeAmount"].ToString()).ToString("0.####") + "</td>");
sb.Append("</tr>");
r++;
}
sb.Append("</tbody>");
sb.Append("</table>");
collection.Add(new JsonStringValue("liststr", sb.ToString()));
}
}
catch { }
collection.Add(new JsonStringValue("type", "refund"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
private string refundsubmitaction(JsonArrayParse jp)
{
JsonObjectCollection collection = new JsonObjectCollection();
string flag = "1";
try
{
DateTime leaveDate = Convert.ToDateTime(jp.getValue("RefundDate"));
Business.Op.BusinessContract bc = new Business.Op.BusinessContract();
bc.load(jp.getValue("id"));
if (bc.Entity.ContractStartDate >= leaveDate)
{
flag = "2";
}
else if (bc.Entity.ContractStatus != "2")
{
flag = "3";
}
else
{
string infoMsg = bc.ConfirmLeaveWithNoFee(leaveDate);
if (infoMsg != "")
{
collection.Add(new JsonStringValue("InfoBar", infoMsg));
flag = "4";
}
else
{
collection.Add(new JsonStringValue("liststr", createList(jp.getValue("ContractNoS"), jp.getValue("ContractNoManualS"), jp.getValue("ContractTypeS"),
jp.getValue("ContractSPNoS"), jp.getValue("ContractCustNoS"), jp.getValue("MinContractSignedDate"), jp.getValue("MaxContractSignedDate"),
jp.getValue("MinContractEndDate"), jp.getValue("MaxContractEndDate"), jp.getValue("OffLeaseStatusS"), jp.getValue("MinOffLeaseActulDate"),
jp.getValue("MaxOffLeaseActulDate"), ParseIntForString(jp.getValue("page")))));
#region 步到管家
try
{
string status = string.Empty;
string date = string.Empty;
bc.CheckCustStatus(out status, out date);
ButlerSrv.AppService appService = new ButlerSrv.AppService {
Timeout = 5000
};
appService.UpdateCustomer(bc.Entity.ContractCustNo, status, date);
}
catch (Exception ex)
{
collection.Add(new JsonStringValue("syncButlerException", ex.ToString()));
}
#endregion
#region 步到资源系统
string syncResult = string.Empty;
try
{
ResourceService.ResourceService srv = new ResourceService.ResourceService
{
Timeout = 5000,
Url = ConfigurationManager.AppSettings["ResourceServiceUrl"].ToString()
};
string Items = "";
Business.Base.BusinessCustomer cust = new Business.Base.BusinessCustomer();
cust.load(bc.Entity.ContractCustNo);
var dt = obj.PopulateDataSet("SELECT WPNo FROM Op_ContractWPRentalDetail WHERE RefRP='" + bc.Entity.RowPointer + "' GROUP BY WPNo").Tables[0];
foreach (DataRow dr in dt.Rows)
{
SycnResourceStatus rs = new SycnResourceStatus();
rs.SysID = 1; //1.订单
rs.ResourceID = dr["WPNo"].ToString();
rs.BusinessID = bc.Entity.RowPointer;
rs.BusinessNo = bc.Entity.ContractNo;
rs.BusinessType = 1;//1租赁，2物业
rs.RentBeginTime = bc.Entity.FeeStartDate;
rs.RentEndTime = leaveDate;
rs.Status = 2;
rs.RentType = 1;
rs.UpdateTime = GetDate();
rs.UpdateUser = user.Entity.UserName;
Items += (Items == "" ? "" : ",") + JsonConvert.SerializeObject(rs);
}
syncResult = srv.LeaseOut("[" + Items + "]");
}
catch (Exception ex)
{
syncResult = ex.ToString();
}
collection.Add(new JsonStringValue("sync", syncResult));
#endregion
}
}
}
catch { }
collection.Add(new JsonStringValue("type", "refundsubmit"));
collection.Add(new JsonStringValue("flag", flag));
return(collection.ToString());
}
