//public ActionResult DepositRent(DepositRentViewModel model)
//{
// StringBuilder sbTable = new StringBuilder();
// sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
// sbTable.Append("<thead>");
// sbTable.Append("<tr>");
// sbTable.Append("<th>商户代码</th>");
// sbTable.Append("<th>商户名称</th>");
// sbTable.Append("<th>POS机ID</th>");
// sbTable.Append("<th>地址</th>");
// sbTable.Append("<th>联系人</th>");
// sbTable.Append("<th>联系电话</th>");
// sbTable.Append("<th>订单号</th>");
// sbTable.Append("<th>押金</th>");
// sbTable.Append("<th>租期(月)</th>");
// sbTable.Append("<th>租金/月</th>");
// sbTable.Append("<th>到期日期</th>");
// sbTable.Append("<th>合计租金</th>");
// sbTable.Append("<th>状态</th>");
// sbTable.Append("<th>缴费时间</th>");
// sbTable.Append("<th>合计</th>");
// sbTable.Append("</tr>");
// sbTable.Append("</thead>");
// sbTable.Append("<tbody>");
// sbTable.Append("{content}");
// sbTable.Append("</tbody>");
// sbTable.Append("</table>");
// if (Request.HttpMethod == "GET")
// {
// #region GET
// sbTable.Replace("{content}", "<tr><td colspan=\"15\"></td></tr>");
// model.TableHtml = sbTable.ToString();
// return View(model);
// #endregion
// }
// else
// {
// #region POST
// StringBuilder sql = new StringBuilder("select b.ClientCode,b.YYZZ_Name,c.DeviceId, b.YYZZ_Address, b.ContactName,b.ContactPhoneNumber,d.Sn, c.Deposit,e.RentMonths,e.MonthlyRent,e.RentDueDate, e.RentTotal,d.[Status], d.PayTime,d.Price from MerchantPosMachine a ");
// sql.Append(" inner join Merchant b on a.MerchantId=b.Id inner join PosMachine c on a.PosMachineId=c.Id ");
// sql.Append(" inner join [Order] d on b.Id=d.MerchantId inner join OrderToDepositRent e on d.Id=e.Id ");
// sql.Append(" where d.ProductType=" + (int)Enumeration.ProductType.PosMachineDepositRent + " ");
// if (!string.IsNullOrEmpty(model.ClientCode))
// {
// sql.Append(" and b.ClientCode='" + model.ClientCode + "'");
// }
// if (model.StartTime != null)
// {
// sql.Append(" and d.PayTime >='" + CommonUtils.ConverToShortDateStart(model.StartTime.Value) + "'"); ;
// }
// if (model.EndTime != null)
// {
// sql.Append(" and d.PayTime <='" + CommonUtils.ConverToShortDateEnd(model.EndTime.Value) + "'");
// }
// sql.Append(" order by d.SubmitTime desc ");
// DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
// StringBuilder sbTableContent = new StringBuilder();
// for (int r = 0; r < dtData.Rows.Count; r++)
// {
// sbTableContent.Append("<tr>");
// for (int c = 0; c < dtData.Columns.Count; c++)
// {
// string td_value = "";
// switch (c)
// {
// case 12:
// td_value = GetOrderStatusName(dtData.Rows[r][c].ToString().Trim());
// break;
// default:
// td_value = dtData.Rows[r][c].ToString().Trim();
// break;
// }
// sbTableContent.Append("<td>" + td_value + "</td>");
// }
// sbTableContent.Append("</tr>");
// }
// sbTable.Replace("{content}", sbTableContent.ToString());
// ReportTable reportTable = new ReportTable(sbTable.ToString());
// if (model.Operate == Enumeration.OperateType.Serach)
// {
// return Json(ResultType.Success, reportTable, "");
// }
// else
// {
// NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "商户押金租金报表");
// return Json(ResultType.Success, "");
// }
// #endregion
// }
//}
//public ActionResult Rent(DepositRentViewModel model)
//{
// StringBuilder sbTable = new StringBuilder();
// sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
// sbTable.Append("<thead>");
// sbTable.Append("<tr>");
// sbTable.Append("<th>商户代码</th>");
// sbTable.Append("<th>商户名称</th>");
// sbTable.Append("<th>POS机ID</th>");
// sbTable.Append("<th>地址</th>");
// sbTable.Append("<th>联系人</th>");
// sbTable.Append("<th>联系电话</th>");
// sbTable.Append("<th>续期(月)</th>");
// sbTable.Append("<th>租金/月</th>");
// sbTable.Append("<th>到期日期</th>");
// sbTable.Append("<th>状态</th>");
// sbTable.Append("<th>缴费时间</th>");
// sbTable.Append("<th>合计</th>");
// sbTable.Append("</tr>");
// sbTable.Append("</thead>");
// sbTable.Append("<tbody>");
// sbTable.Append("{content}");
// sbTable.Append("</tbody>");
// sbTable.Append("</table>");
// if (Request.HttpMethod == "GET")
// {
// #region GET
// sbTable.Replace("{content}", "<tr><td colspan=\"12\"></td></tr>");
// model.TableHtml = sbTable.ToString();
// return View(model);
// #endregion
// }
// else
// {
// #region POST
// StringBuilder sql = new StringBuilder("select b.ClientCode,b.YYZZ_Name,c.DeviceId, b.YYZZ_Address, b.ContactName,b.ContactPhoneNumber,e.RentMonths,e.MonthlyRent,e.RentDueDate,d.[Status], d.PayTime,d.Price from MerchantPosMachine a ");
// sql.Append(" inner join Merchant b on a.MerchantId=b.Id inner join PosMachine c on a.PosMachineId=c.Id ");
// sql.Append(" inner join [Order] d on b.Id=d.MerchantId inner join OrderToDepositRent e on d.Id=e.Id ");
// sql.Append(" where d.ProductType=" + (int)Enumeration.ProductType.PosMachineRent + " ");
// if (!string.IsNullOrEmpty(model.ClientCode))
// {
// sql.Append(" and b.ClientCode='" + model.ClientCode + "'");
// }
// if (model.StartTime != null)
// {
// sql.Append(" and d.PayTime >='" + CommonUtils.ConverToShortDateStart(model.StartTime.Value) + "'"); ;
// }
// if (model.EndTime != null)
// {
// sql.Append(" and d.PayTime <='" + CommonUtils.ConverToShortDateEnd(model.EndTime.Value) + "'");
// }
// sql.Append(" order by d.SubmitTime desc ");
// DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
// StringBuilder sbTableContent = new StringBuilder();
// for (int r = 0; r < dtData.Rows.Count; r++)
// {
// sbTableContent.Append("<tr>");
// for (int c = 0; c < dtData.Columns.Count; c++)
// {
// string td_value = "";
// switch (c)
// {
// case 9:
// td_value = GetOrderStatusName(dtData.Rows[r][c].ToString().Trim());
// break;
// default:
// td_value = dtData.Rows[r][c].ToString().Trim();
// break;
// }
// sbTableContent.Append("<td>" + td_value + "</td>");
// }
// sbTableContent.Append("</tr>");
// }
// sbTable.Replace("{content}", sbTableContent.ToString());
// ReportTable reportTable = new ReportTable(sbTable.ToString());
// if (model.Operate == Enumeration.OperateType.Serach)
// {
// return Json(ResultType.Success, reportTable, "");
// }
// else
// {
// NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "商户租金报表");
// return Json(ResultType.Success, "");
// }
// #endregion
// }
//}
public ActionResult SalesmanPos(SalesmanPosViewModel model)
{
StringBuilder sbTable = new StringBuilder();
sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
sbTable.Append("<thead>");
sbTable.Append("<tr>");
sbTable.Append("<th>业务员账号</th>");
sbTable.Append("<th>业务员姓名</th>");
sbTable.Append("<th>商户名称</th>");
sbTable.Append("<th>商户账号</th>");
sbTable.Append("<th>POS机Id</th>");
sbTable.Append("<th>状态</th>");
sbTable.Append("<th>激活时间</th>");
sbTable.Append("</tr>");
sbTable.Append("</thead>");
sbTable.Append("<tbody>");
sbTable.Append("{content}");
sbTable.Append("</tbody>");
sbTable.Append("</table>");
if (Request.HttpMethod == "GET")
{
#region GET
sbTable.Replace("{content}", "<tr><td colspan=\"7\"></td></tr>");
model.TableHtml = sbTable.ToString();
return(View(model));
#endregion
}
else
{
#region POST
StringBuilder sql = new StringBuilder(" select d.UserName,d.FullName,b.YYZZ_Name,b.ClientCode,c.DeviceId,a.[Status],a.DepositPayTime from ");
sql.Append(" [dbo].[MerchantPosMachine] a inner join [dbo].[Merchant] b on a.MerchantId=b.Id ");
sql.Append(" inner join [dbo].[PosMachine] c on a.PosMachineId=c.Id ");
sql.Append(" inner join [dbo].[SysUser] d on b.SalesmanId=d.Id ");
sql.Append(" where 1=1 ");
if (!string.IsNullOrEmpty(model.UserName))
{
sql.Append(" and d.UserName='******'");
}
if (model.StartTime != null)
{
sql.Append(" and a.DepositPayTime >='" + CommonUtils.ConverToShortDateStart(model.StartTime.Value) + "'");;
}
if (model.EndTime != null)
{
sql.Append(" and a.DepositPayTime <='" + CommonUtils.ConverToShortDateEnd(model.EndTime.Value) + "'");
}
sql.Append(" order by d.UserName desc ");
DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
StringBuilder sbTableContent = new StringBuilder();
for (int r = 0; r < dtData.Rows.Count; r++)
{
sbTableContent.Append("<tr>");
for (int c = 0; c < dtData.Columns.Count; c++)
{
string td_value = "";
switch (c)
{
case 5:
td_value = GetPosMachineStatusName(dtData.Rows[r][c].ToString().Trim());
break;
default:
td_value = dtData.Rows[r][c].ToString().Trim();
break;
}
sbTableContent.Append("<td>" + td_value + "</td>");
}
sbTableContent.Append("</tr>");
}
sbTable.Replace("{content}", sbTableContent.ToString());
ReportTable reportTable = new ReportTable(sbTable.ToString());
if (model.Operate == Enumeration.OperateType.Serach)
{
return(Json(ResultType.Success, reportTable, ""));
}
else
{
NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "业务员对应POS机报表");
return(Json(ResultType.Success, ""));
}
#endregion
}
}
public ActionResult PosList(PosListViewModel model)
{
StringBuilder sbTable = new StringBuilder();
sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
sbTable.Append("<thead>");
sbTable.Append("<tr>");
sbTable.Append("<th>设备ID</th>");
sbTable.Append("<th>机身号</th>");
sbTable.Append("<th>终端号</th>");
sbTable.Append("<th>版本号 </th>");
sbTable.Append("<th>已使用</th>");
sbTable.Append("<th>登记时间</th>");
sbTable.Append("</tr>");
sbTable.Append("</thead>");
sbTable.Append("<tbody>");
sbTable.Append("{content}");
sbTable.Append("</tbody>");
sbTable.Append("</table>");
if (Request.HttpMethod == "GET")
{
#region GET
sbTable.Replace("{content}", "<tr><td colspan=\"6\"></td></tr>");
model.TableHtml = sbTable.ToString();
return(View(model));
#endregion
}
else
{
#region POST
StringBuilder sql = new StringBuilder(" select a.DeviceId,a.FuselageNumber,a.TerminalNumber,a.Version,a.IsUse,a.CreateTime from ");
sql.Append(" PosMachine a ");
sql.Append(" where 1=1 ");
if (model.StartTime != null)
{
sql.Append(" and a.CreateTime >='" + CommonUtils.ConverToShortDateStart(model.StartTime.Value) + "'");;
}
if (model.EndTime != null)
{
sql.Append(" and a.CreateTime <='" + CommonUtils.ConverToShortDateEnd(model.EndTime.Value) + "'");
}
sql.Append(" order by a.TerminalNumber desc ");
DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
StringBuilder sbTableContent = new StringBuilder();
for (int r = 0; r < dtData.Rows.Count; r++)
{
sbTableContent.Append("<tr>");
for (int c = 0; c < dtData.Columns.Count; c++)
{
string td_value = "";
switch (c)
{
case 4:
td_value = GetBoolName(dtData.Rows[r][c].ToString().Trim());
break;
default:
td_value = dtData.Rows[r][c].ToString().Trim();
break;
}
sbTableContent.Append("<td>" + td_value + "</td>");
}
sbTableContent.Append("</tr>");
}
sbTable.Replace("{content}", sbTableContent.ToString());
ReportTable reportTable = new ReportTable(sbTable.ToString());
if (model.Operate == Enumeration.OperateType.Serach)
{
return(Json(ResultType.Success, reportTable, ""));
}
else
{
NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "POS机报表");
return(Json(ResultType.Success, ""));
}
#endregion
}
}
public ActionResult CarInsure(CarInsureViewModel model)
{
StringBuilder sbTable = new StringBuilder();
sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
sbTable.Append("<thead>");
sbTable.Append("<tr>");
sbTable.Append("<th>商户代码</th>");
sbTable.Append("<th>商户名称</th>");
sbTable.Append("<th>订单号</th>");
sbTable.Append("<th>保险公司</th>");
sbTable.Append("<th>保单号</th>");
sbTable.Append("<th>投保人</th>");
sbTable.Append("<th>商业险保费金额</th>");
sbTable.Append("<th>交强险保费金额</th>");
sbTable.Append("<th>车船税金额</th>");
sbTable.Append("<th>总保费金额</th>");
sbTable.Append("<th>商业险佣金金额</th>");
sbTable.Append("<th>提交时间</th>");
sbTable.Append("<th>支付时间</th>");
sbTable.Append("<th>取消时间</th>");
sbTable.Append("<th>状态</th>");
sbTable.Append("</tr>");
sbTable.Append("</thead>");
sbTable.Append("<tbody>");
sbTable.Append("{content}");
sbTable.Append("</tbody>");
sbTable.Append("</table>");
if (Request.HttpMethod == "GET")
{
#region GET
sbTable.Replace("{content}", "<tr><td colspan=\"15\"></td></tr>");
model.TableHtml = sbTable.ToString();
return(View(model));
#endregion
}
else
{
#region POST
StringBuilder sql = new StringBuilder("select c.ClientCode,c.YYZZ_Name,a.Sn,b.InsuranceCompanyName,b.InsuranceOrderId,b.CarOwner,b.CommercialPrice,b.CompulsoryPrice,b.TravelTaxPrice,a.Price,b.MerchantCommission,a.SubmitTime,a.PayTime,a.CancleTime,a.Status from [dbo].[Order] a ");
sql.Append(" inner join [dbo].[OrderToCarInsure] b on a.Id=b.Id ");
sql.Append(" left join [dbo].[Merchant] c on a.MerchantId=c.Id ");
sql.Append(" where 1=1 ");
if (model.Status != Enumeration.OrderStatus.Unknow)
{
sql.Append(" and a.Status='" + (int)model.Status + "'");
}
if (!string.IsNullOrEmpty(model.ClientCode))
{
sql.Append(" and c.ClientCode='" + model.ClientCode + "'");
}
if (model.StartTime != null)
{
sql.Append(" and a.SubmitTime >='" + CommonUtils.ConverToShortDateStart(model.StartTime.Value) + "'");;
}
if (model.EndTime != null)
{
sql.Append(" and a.SubmitTime <='" + CommonUtils.ConverToShortDateEnd(model.EndTime.Value) + "'");
}
if (model.StartPayTime != null)
{
sql.Append(" and a.PayTime >='" + CommonUtils.ConverToShortDateStart(model.StartPayTime.Value) + "'");;
}
if (model.EndPayTime != null)
{
sql.Append(" and a.PayTime <='" + CommonUtils.ConverToShortDateEnd(model.EndPayTime.Value) + "'");
}
sql.Append(" order by a.SubmitTime desc ");
DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
StringBuilder sbTableContent = new StringBuilder();
for (int r = 0; r < dtData.Rows.Count; r++)
{
sbTableContent.Append("<tr>");
for (int c = 0; c < dtData.Columns.Count; c++)
{
string td_value = "";
switch (c)
{
case 14:
td_value = GetOrderStatusName(dtData.Rows[r][c].ToString().Trim());
break;
default:
td_value = dtData.Rows[r][c].ToString().Trim();
break;
}
sbTableContent.Append("<td>" + td_value + "</td>");
}
sbTableContent.Append("</tr>");
}
sbTable.Replace("{content}", sbTableContent.ToString());
ReportTable reportTable = new ReportTable(sbTable.ToString());
if (model.Operate == Enumeration.OperateType.Serach)
{
return(Json(ResultType.Success, reportTable, ""));
}
else
{
NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "商户车险订单报表");
return(Json(ResultType.Success, ""));
}
#endregion
}
}
public ActionResult Merchant(MerchantViewModel model)
{
StringBuilder sbTable = new StringBuilder();
sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
sbTable.Append("<thead>");
sbTable.Append("<tr>");
sbTable.Append("<th>商户代码</th>");
sbTable.Append("<th>商户名称</th>");
sbTable.Append("<th>POS机ID</th>");
sbTable.Append("<th>营业执照编号</th>");
sbTable.Append("<th>商户地址</th>");
sbTable.Append("<th>法人</th>");
sbTable.Append("<th>法人身份证</th>");
sbTable.Append("<th>联系人</th>");
sbTable.Append("<th>联系方式</th>");
sbTable.Append("<th>联系地址</th>");
sbTable.Append("<th>绑定银行卡账号</th>");
sbTable.Append("<th>持卡人</th>");
sbTable.Append("<th>开户行</th>");
sbTable.Append("<th>激活时间</th>");
sbTable.Append("<th>注销时间</th>");
sbTable.Append("<th>业务员</th>");
sbTable.Append("</tr>");
sbTable.Append("</thead>");
sbTable.Append("<tbody>");
sbTable.Append("{content}");
sbTable.Append("</tbody>");
sbTable.Append("</table>");
if (Request.HttpMethod == "GET")
{
#region GET
sbTable.Replace("{content}", "<tr><td colspan=\"16\"></td></tr>");
model.TableHtml = sbTable.ToString();
return(View(model));
#endregion
}
else
{
#region POST
StringBuilder sql = new StringBuilder(" select b.ClientCode,b.YYZZ_Name,d.DeviceId,b.YYZZ_RegisterNo,b.YYZZ_Address,b.FR_Name,b.FR_IdCardNo,b.ContactName,b.ContactPhoneNumber,b.ContactAddress,c.BankAccountNo,c.BankAccountName,c.BankName,a.DepositPayTime,a.ReturnTime,e.FullName from [dbo].[MerchantPosMachine] a ");
sql.Append(" left join[dbo].[Merchant] b on a.MerchantId = b.Id");
sql.Append(" left join[dbo].[BankCard] c on a.BankCardId = c.Id");
sql.Append(" left join[dbo].[PosMachine] d on a.PosMachineId = d.Id ");
sql.Append(" left join[dbo].[SysUser] e on b.SalesmanId = e.Id ");
sql.Append(" where 1=1 ");
if (!string.IsNullOrEmpty(model.ClientCode))
{
sql.Append(" and b.ClientCode='" + model.ClientCode + "'");
}
if (model.StartTime != null)
{
sql.Append(" and a.DepositPayTime >='" + CommonUtils.ConverToShortDateStart(model.StartTime.Value) + "'");;
}
if (model.EndTime != null)
{
sql.Append(" and a.DepositPayTime <='" + CommonUtils.ConverToShortDateEnd(model.EndTime.Value) + "'");
}
sql.Append(" order by a.DepositPayTime desc ");
DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
StringBuilder sbTableContent = new StringBuilder();
for (int r = 0; r < dtData.Rows.Count; r++)
{
sbTableContent.Append("<tr>");
for (int c = 0; c < dtData.Columns.Count; c++)
{
string td_value = "";
switch (c)
{
default:
td_value = dtData.Rows[r][c].ToString().Trim();
break;
}
sbTableContent.Append("<td>" + td_value + "</td>");
}
sbTableContent.Append("</tr>");
}
sbTable.Replace("{content}", sbTableContent.ToString());
ReportTable reportTable = new ReportTable(sbTable.ToString());
if (model.Operate == Enumeration.OperateType.Serach)
{
return(Json(ResultType.Success, reportTable, ""));
}
else
{
NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "商户信息登记报表");
return(Json(ResultType.Success, ""));
}
#endregion
}
}
public ActionResult WithdrawRecord(WithdrawRecordViewModel model)
{
StringBuilder sbTable = new StringBuilder();
sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
sbTable.Append("<thead>");
sbTable.Append("<tr>");
sbTable.Append("<th>序号</th>");
sbTable.Append("<th>流水号</th>");
sbTable.Append("<th>昵称</th>");
sbTable.Append("<th>姓名</th>");
sbTable.Append("<th>身份证号码</th>");
sbTable.Append("<th>开户行</th>");
sbTable.Append("<th>银行卡号码</th>");
sbTable.Append("<th>申请时间</th>");
sbTable.Append("<th>提现金额</th>");
sbTable.Append("<th>状态</th>");
sbTable.Append("</tr>");
sbTable.Append("</thead>");
sbTable.Append("<tbody>");
sbTable.Append("{content}");
sbTable.Append("</tbody>");
sbTable.Append("</table>");
if (Request.HttpMethod == "GET")
{
#region GET
sbTable.Replace("{content}", "<tr><td colspan=\"10\"></td></tr>");
model.TableHtml = sbTable.ToString();
return(View(model));
#endregion
}
else
{
#region POST
StringBuilder sql = new StringBuilder(" select a.Sn,b.Nickname,a.AcName,a.AcIdNumber, AcBank,AcBankCardNumber,a.ApplyTime,a.Amount,a.[Status] from dbo.Withdraw a left join dbo.WxUserInfo b on a.clientId=b.clientId ");
sql.Append(" where 1=1 ");
if (model.Status != 0)
{
sql.Append(" and a.[status] ='" + model.Status + "'");;
}
if (model.StartTime != null)
{
sql.Append(" and a.ApplyTime >='" + CommonUtil.ConverToShortDateStart(model.StartTime.Value) + "'");;
}
if (model.EndTime != null)
{
sql.Append(" and a.ApplyTime <='" + CommonUtil.ConverToShortDateEnd(model.EndTime.Value) + "'");
}
sql.Append(" order by a.ApplyTime desc ");
DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
StringBuilder sbTableContent = new StringBuilder();
for (int r = 0; r < dtData.Rows.Count; r++)
{
sbTableContent.Append("<tr>");
sbTableContent.Append("<td>" + (r + 1) + "</td>");
for (int c = 0; c < dtData.Columns.Count; c++)
{
string td_value = "";
switch (c)
{
case 8:
td_value = dtData.Rows[r][c].ToString().Trim();
switch (td_value)
{
case "1":
td_value = "申请中";
break;
case "2":
td_value = "待转账";
break;
case "3":
td_value = "转账成功";
break;
case "4":
td_value = "转账失败";
break;
}
break;
default:
td_value = dtData.Rows[r][c].ToString().Trim();
break;
}
sbTableContent.Append("<td>" + td_value + "</td>");
}
sbTableContent.Append("</tr>");
}
sbTable.Replace("{content}", sbTableContent.ToString());
ReportTable reportTable = new ReportTable(sbTable.ToString());
if (model.Operate == Enumeration.OperateType.Serach)
{
return(Json(ResultType.Success, reportTable, ""));
}
else
{
NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "提现记录报表");
return(Json(ResultType.Success, ""));
}
#endregion
}
}
public ActionResult NoActiveAccount(MerchantViewModel model)
{
StringBuilder sbTable = new StringBuilder();
sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
sbTable.Append("<thead>");
sbTable.Append("<tr>");
sbTable.Append("<th style=\"width:50%\">商户代码</th>");
sbTable.Append("<th style=\"width:50%\">POS机ID</th>");
sbTable.Append("</tr>");
sbTable.Append("</thead>");
sbTable.Append("<tbody>");
sbTable.Append("{content}");
sbTable.Append("</tbody>");
sbTable.Append("</table>");
if (Request.HttpMethod == "GET")
{
#region GET
sbTable.Replace("{content}", "<tr><td colspan=\"2\"></td></tr>");
model.TableHtml = sbTable.ToString();
return(View(model));
#endregion
}
else
{
#region POST
StringBuilder sql = new StringBuilder(" select b.ClientCode,d.DeviceId from [dbo].[MerchantPosMachine] a ");
sql.Append(" left join[dbo].[Merchant] b on a.MerchantId = b.Id ");
sql.Append(" ");
sql.Append(" left join[dbo].[PosMachine] d on a.PosMachineId = d.Id ");
sql.Append(" where 1=1 and a.[Status]=2 ");
if (!string.IsNullOrEmpty(model.ClientCode))
{
sql.Append(" and b.ClientCode='" + model.ClientCode + "'");
}
if (model.StartTime != null)
{
sql.Append(" and a.DepositPayTime >='" + CommonUtils.ConverToShortDateStart(model.StartTime.Value) + "'");;
}
if (model.EndTime != null)
{
sql.Append(" and a.DepositPayTime <='" + CommonUtils.ConverToShortDateEnd(model.EndTime.Value) + "'");
}
sql.Append(" order by a.DepositPayTime desc ");
DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
StringBuilder sbTableContent = new StringBuilder();
for (int r = 0; r < dtData.Rows.Count; r++)
{
sbTableContent.Append("<tr>");
for (int c = 0; c < dtData.Columns.Count; c++)
{
string td_value = "";
switch (c)
{
default:
td_value = dtData.Rows[r][c].ToString().Trim();
break;
}
sbTableContent.Append("<td>" + td_value + "</td>");
}
sbTableContent.Append("</tr>");
}
sbTable.Replace("{content}", sbTableContent.ToString());
ReportTable reportTable = new ReportTable(sbTable.ToString());
if (model.Operate == Enumeration.OperateType.Serach)
{
return(Json(ResultType.Success, reportTable, ""));
}
else
{
NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "商户账号（未激活）");
return(Json(ResultType.Success, ""));
}
#endregion
}
}
public ActionResult PromoteSkuBuyRecord(PromoteShareRecordViewModel model)
{
StringBuilder sbTable = new StringBuilder();
sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
sbTable.Append("<thead>");
sbTable.Append("<tr>");
sbTable.Append("<th>序号</th>");
sbTable.Append("<th>订单号</th>");
sbTable.Append("<th>昵称</th>");
sbTable.Append("<th>姓名</th>");
sbTable.Append("<th>手机</th>");
sbTable.Append("<th>是否学员</th>");
sbTable.Append("<th>校区</th>");
sbTable.Append("<th>商品名称</th>");
sbTable.Append("<th>价格</th>");
sbTable.Append("<th>下单时间</th>");
sbTable.Append("<th>支付时间</th>");
sbTable.Append("</tr>");
sbTable.Append("</thead>");
sbTable.Append("<tbody>");
sbTable.Append("{content}");
sbTable.Append("</tbody>");
sbTable.Append("</table>");
if (Request.HttpMethod == "GET")
{
#region GET
sbTable.Replace("{content}", "<tr><td colspan=\"11\"></td></tr>");
model.TableHtml = sbTable.ToString();
return(View(model));
#endregion
}
else
{
#region POST
StringBuilder sql = new StringBuilder(" select Sn,c.Nickname, a.CtName,a.CtPhone,a.CtIsStudent,a.CtSchool,b.SkuName,b.SalePrice,a.SubmitTime,a.PayTime from [Order] a left join OrderDetails b on a.Id=b.OrderId left join WxUserInfo c on a.ClientId=c.ClientId ");
sql.Append(" where a.[Status]=3 ");
if (model.PromoteId != null)
{
sql.Append(" and a.PromoteId ='" + model.PromoteId + "'");;
}
if (model.StartTime != null)
{
sql.Append(" and a.PayTime >='" + CommonUtil.ConverToShortDateStart(model.StartTime.Value) + "'");;
}
if (model.EndTime != null)
{
sql.Append(" and a.PayTime <='" + CommonUtil.ConverToShortDateEnd(model.EndTime.Value) + "'");
}
sql.Append(" order by a.PayTime desc ");
DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
StringBuilder sbTableContent = new StringBuilder();
for (int r = 0; r < dtData.Rows.Count; r++)
{
sbTableContent.Append("<tr>");
sbTableContent.Append("<td>" + (r + 1) + "</td>");
for (int c = 0; c < dtData.Columns.Count; c++)
{
string td_value = "";
switch (c)
{
case 4:
td_value = dtData.Rows[r][c].ToString().Trim();
if (td_value == "" || td_value == "0")
{
td_value = "否";
}
else
{
td_value = "是";
}
break;
default:
td_value = dtData.Rows[r][c].ToString().Trim();
break;
}
sbTableContent.Append("<td>" + td_value + "</td>");
}
sbTableContent.Append("</tr>");
}
sbTable.Replace("{content}", sbTableContent.ToString());
ReportTable reportTable = new ReportTable(sbTable.ToString());
if (model.Operate == Enumeration.OperateType.Serach)
{
return(Json(ResultType.Success, reportTable, ""));
}
else
{
NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "商品购买记录报表");
return(Json(ResultType.Success, ""));
}
#endregion
}
}
public ActionResult PromoteCouponBuyRecord(PromoteCouponBuyRecordViewModel model)
{
StringBuilder sbTable = new StringBuilder();
sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
sbTable.Append("<thead>");
sbTable.Append("<tr>");
sbTable.Append("<th>序号</th>");
sbTable.Append("<th>昵称</th>");
sbTable.Append("<th>姓名</th>");
sbTable.Append("<th>手机</th>");
sbTable.Append("<th>是否学员</th>");
sbTable.Append("<th>校区</th>");
sbTable.Append("<th>支付状态</th>");
sbTable.Append("<th>支付时间</th>");
sbTable.Append("<th>领取状态</th>");
sbTable.Append("<th>领取时间</th>");
sbTable.Append("<th>核销状态</th>");
sbTable.Append("<th>核销时间</th>");
sbTable.Append("</tr>");
sbTable.Append("</thead>");
sbTable.Append("<tbody>");
sbTable.Append("{content}");
sbTable.Append("</tbody>");
sbTable.Append("</table>");
if (Request.HttpMethod == "GET")
{
#region GET
sbTable.Replace("{content}", "<tr><td colspan=\"12\"></td></tr>");
model.TableHtml = sbTable.ToString();
return(View(model));
#endregion
}
else
{
#region POST
StringBuilder sql = new StringBuilder(" select b.Nickname,c.CtName,c.CtPhone,c.CtIsStudent, CtSchool, a.IsBuy,a.BuyTime,a.IsGet,a.GetTime,a.IsConsume,a.ConsumeTime from ClientCoupon a left join WxUserInfo b on a.ClientId=b.ClientId left join PromoteUser c on a.ClientId=c.ClientId and a.PromoteId=c.PromoteId ");
sql.Append(" where a.BuyTime is not null ");
if (model.PromoteId != null)
{
sql.Append(" and a.PromoteId ='" + model.PromoteId + "'");;
}
if (model.StartTime != null)
{
sql.Append(" and a.BuyTime >='" + CommonUtil.ConverToShortDateStart(model.StartTime.Value) + "'");;
}
if (model.EndTime != null)
{
sql.Append(" and a.BuyTime <='" + CommonUtil.ConverToShortDateEnd(model.EndTime.Value) + "'");
}
sql.Append(" order by a.BuyTime desc ");
DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
StringBuilder sbTableContent = new StringBuilder();
for (int r = 0; r < dtData.Rows.Count; r++)
{
sbTableContent.Append("<tr>");
sbTableContent.Append("<td>" + (r + 1) + "</td>");
for (int c = 0; c < dtData.Columns.Count; c++)
{
string td_value = "";
switch (c)
{
case 3:
td_value = dtData.Rows[r][c].ToString().Trim();
if (td_value == "" || td_value == "0")
{
td_value = "否";
}
else
{
td_value = "是";
}
break;
case 5:
td_value = dtData.Rows[r][c].ToString().Trim();
if (td_value == "True")
{
td_value = "已支付";
}
else
{
td_value = "未支付";
}
break;
case 7:
td_value = dtData.Rows[r][c].ToString().Trim();
if (td_value == "True")
{
td_value = "已领取";
}
else
{
td_value = "未领取";
}
break;
case 9:
td_value = dtData.Rows[r][c].ToString().Trim();
if (td_value == "True")
{
td_value = "已核销";
}
else
{
td_value = "未核销";
}
break;
default:
td_value = dtData.Rows[r][c].ToString().Trim();
break;
}
sbTableContent.Append("<td>" + td_value + "</td>");
}
sbTableContent.Append("</tr>");
}
sbTable.Replace("{content}", sbTableContent.ToString());
ReportTable reportTable = new ReportTable(sbTable.ToString());
if (model.Operate == Enumeration.OperateType.Serach)
{
return(Json(ResultType.Success, reportTable, ""));
}
else
{
NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "卡卷购买记录报表");
return(Json(ResultType.Success, ""));
}
#endregion
}
}
public ActionResult PromoteShareBuyRecord(PromoteShareBuyRecordViewModel model)
{
StringBuilder sbTable = new StringBuilder();
sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
sbTable.Append("<thead>");
sbTable.Append("<tr>");
sbTable.Append("<th>序号</th>");
sbTable.Append("<th>分享者昵称</th>");
sbTable.Append("<th>被分享者昵称</th>");
sbTable.Append("<th>卡券领取情况</th>");
sbTable.Append("<th>卡券核销情况</th>");
sbTable.Append("</tr>");
sbTable.Append("</thead>");
sbTable.Append("<tbody>");
sbTable.Append("{content}");
sbTable.Append("</tbody>");
sbTable.Append("</table>");
if (Request.HttpMethod == "GET")
{
#region GET
sbTable.Replace("{content}", "<tr><td colspan=\"5\"></td></tr>");
model.TableHtml = sbTable.ToString();
return(View(model));
#endregion
}
else
{
#region POST
StringBuilder sql = new StringBuilder(" select ClientId, Nickname,b.Num from WxUserInfo a inner join (select RefereerId, count(*) as Num from[dbo].[ClientCoupon] ");
if (model.PromoteId != null)
{
sql.Append(" where PromoteId ='" + model.PromoteId + "'");;
}
sql.Append(" group by RefereerId) b on a.ClientId = b.RefereerId ");
sql.Append(" where 1=1 ");
sql.Append(" order by Num desc ");
DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
StringBuilder sbTableContent = new StringBuilder();
for (int r = 0; r < dtData.Rows.Count; r++)
{
var clientId = dtData.Rows[r]["ClientId"].ToString().Trim();
var nickname = dtData.Rows[r]["Nickname"].ToString().Trim();
var num = dtData.Rows[r]["Num"].ToString().Trim();
string sql2 = " select b.Nickname, a.IsBuy,a.BuyTime,a.IsGet,a.GetTime,a.IsConsume,a.ConsumeTime from ClientCoupon a inner join WxUserInfo b on a.ClientId=b.ClientId where a.RefereerId='" + clientId + "' ";
DataTable dtData2 = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql2).Tables[0].ToStringDataTable();
if (num == "1")
{
sbTableContent.Append("<tr >");
sbTableContent.Append("<td>" + (r + 1) + "</td>");
sbTableContent.Append("<td>" + nickname + "</td>");
sbTableContent.Append("<td>" + dtData2.Rows[0]["Nickname"].ToString().Trim() + "</td>");
var isGet2 = dtData2.Rows[0]["IsGet"].ToString().Trim();
var isConsume3 = dtData2.Rows[0]["IsConsume"].ToString().Trim();
if (isGet2 == "True")
{
isGet2 = "已领取";
}
else
{
isGet2 = "未领取";
}
if (isConsume3 == "True")
{
isConsume3 = "已核销";
}
else
{
isConsume3 = "未核销";
}
sbTableContent.Append("<td>" + isGet2 + "</td>");
sbTableContent.Append("<td>" + isConsume3 + "</td>");
sbTableContent.Append("</tr>");
}
else
{
sbTableContent.Append("<tr>");
sbTableContent.Append("<td rowspan=\"" + num + "\">" + (r + 1) + "</td>");
sbTableContent.Append("<td rowspan=\"" + num + "\">" + nickname + "</td>");
for (int a = 0; a < dtData2.Rows.Count; a++)
{
var nickname2 = dtData2.Rows[a]["Nickname"].ToString().Trim();
var isGet2 = dtData2.Rows[a]["IsGet"].ToString().Trim();
var isConsume3 = dtData2.Rows[a]["IsConsume"].ToString().Trim();
if (isGet2 == "True")
{
isGet2 = "已领取";
}
else
{
isGet2 = "未领取";
}
if (isConsume3 == "True")
{
isConsume3 = "已核销";
}
else
{
isConsume3 = "未核销";
}
if (a == 0)
{
sbTableContent.Append("<td>" + nickname2 + "</td>");
sbTableContent.Append("<td>" + isGet2 + "</td>");
sbTableContent.Append("<td>" + isConsume3 + "</td>");
sbTableContent.Append("</tr>");
}
else
{
sbTableContent.Append("<tr>");
sbTableContent.Append("<td>" + nickname2 + "</td>");
sbTableContent.Append("<td>" + isGet2 + "</td>");
sbTableContent.Append("<td>" + isConsume3 + "</td>");
sbTableContent.Append("</tr>");
}
}
}
}
sbTable.Replace("{content}", sbTableContent.ToString());
ReportTable reportTable = new ReportTable(sbTable.ToString());
if (model.Operate == Enumeration.OperateType.Serach)
{
return(Json(ResultType.Success, reportTable, ""));
}
else
{
NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "活动分享记录报表");
return(Json(ResultType.Success, ""));
}
#endregion
}
}
public ActionResult PromoteShareRecord(PromoteShareRecordViewModel model)
{
StringBuilder sbTable = new StringBuilder();
sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
sbTable.Append("<thead>");
sbTable.Append("<tr>");
sbTable.Append("<th>序号</th>");
sbTable.Append("<th>昵称</th>");
sbTable.Append("<th>分享时间</th>");
sbTable.Append("<th>分享到</th>");
sbTable.Append("<th>分享链接</th>");
sbTable.Append("</tr>");
sbTable.Append("</thead>");
sbTable.Append("<tbody>");
sbTable.Append("{content}");
sbTable.Append("</tbody>");
sbTable.Append("</table>");
if (Request.HttpMethod == "GET")
{
#region GET
sbTable.Replace("{content}", "<tr><td colspan=\"5\"></td></tr>");
model.TableHtml = sbTable.ToString();
return(View(model));
#endregion
}
else
{
#region POST
StringBuilder sql = new StringBuilder(" select b.Nickname,a.CreateTime,a.[Type],a.ShareLink from ClientShareLog a left join WxUserInfo b on a.ClientId=b.ClientId ");
sql.Append(" where 1=1 ");
if (model.PromoteId != null)
{
sql.Append(" and a.PromoteId ='" + model.PromoteId + "'");;
}
if (model.StartTime != null)
{
sql.Append(" and a.CreateTime >='" + CommonUtil.ConverToShortDateStart(model.StartTime.Value) + "'");;
}
if (model.EndTime != null)
{
sql.Append(" and a.CreateTime <='" + CommonUtil.ConverToShortDateEnd(model.EndTime.Value) + "'");
}
sql.Append(" order by a.CreateTime desc ");
DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
StringBuilder sbTableContent = new StringBuilder();
for (int r = 0; r < dtData.Rows.Count; r++)
{
sbTableContent.Append("<tr>");
sbTableContent.Append("<td>" + (r + 1) + "</td>");
for (int c = 0; c < dtData.Columns.Count; c++)
{
string td_value = "";
switch (c)
{
case 2:
td_value = dtData.Rows[r][c].ToString().Trim();
if (td_value == "1")
{
td_value = "微信好友";
}
else
{
td_value = "微信朋友圈";
}
break;
default:
td_value = dtData.Rows[r][c].ToString().Trim();
break;
}
sbTableContent.Append("<td>" + td_value + "</td>");
}
sbTableContent.Append("</tr>");
}
sbTable.Replace("{content}", sbTableContent.ToString());
ReportTable reportTable = new ReportTable(sbTable.ToString());
if (model.Operate == Enumeration.OperateType.Serach)
{
return(Json(ResultType.Success, reportTable, ""));
}
else
{
NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "活动分享记录报表");
return(Json(ResultType.Success, ""));
}
#endregion
}
}
public ActionResult Withdraw(WithdrawViewModel model)
{
StringBuilder sbTable = new StringBuilder();
sbTable.Append("<table class='list-tb' cellspacing='0' cellpadding='0'>");
sbTable.Append("<thead>");
sbTable.Append("<tr>");
sbTable.Append("<th>商户代码</th>");
sbTable.Append("<th>商户名称</th>");
sbTable.Append("<th>提现金额</th>");
sbTable.Append("<th>申请时间</th>");
sbTable.Append("<th>处理时间</th>");
sbTable.Append("<th>结果</th>");
sbTable.Append("</tr>");
sbTable.Append("</thead>");
sbTable.Append("<tbody>");
sbTable.Append("{content}");
sbTable.Append("</tbody>");
sbTable.Append("</table>");
if (Request.HttpMethod == "GET")
{
#region GET
sbTable.Replace("{content}", "<tr><td colspan=\"6\"></td></tr>");
model.TableHtml = sbTable.ToString();
return(View(model));
#endregion
}
else
{
#region POST
StringBuilder sql = new StringBuilder(" select b.ClientCode,b.YYZZ_Name,a.Amount,a.SettlementStartTime,a.SettlementEndTime,a.Status from Withdraw a left join Merchant b on a.MerchantId=b.Id ");
sql.Append(" where 1=1 ");
if (model.Status != Enumeration.WithdrawStatus.Unknow)
{
sql.Append(" and a.Status='" + (int)model.Status + "'");
}
if (!string.IsNullOrEmpty(model.ClientCode))
{
sql.Append(" and b.ClientCode='" + model.ClientCode + "'");
}
if (model.StartTime != null)
{
sql.Append(" and a.SettlementStartTime >='" + CommonUtils.ConverToShortDateStart(model.StartTime.Value) + "'");;
}
if (model.EndTime != null)
{
sql.Append(" and a.SettlementStartTime <='" + CommonUtils.ConverToShortDateEnd(model.EndTime.Value) + "'");
}
sql.Append(" order by a.SettlementStartTime desc ");
DataTable dtData = DatabaseFactory.GetIDBOptionBySql().GetDataSet(sql.ToString()).Tables[0].ToStringDataTable();
StringBuilder sbTableContent = new StringBuilder();
for (int r = 0; r < dtData.Rows.Count; r++)
{
sbTableContent.Append("<tr>");
for (int c = 0; c < dtData.Columns.Count; c++)
{
string td_value = "";
switch (c)
{
case 5:
td_value = GetWithdrawStatusName(dtData.Rows[r][c].ToString().Trim());
break;
default:
td_value = dtData.Rows[r][c].ToString().Trim();
break;
}
sbTableContent.Append("<td>" + td_value + "</td>");
}
sbTableContent.Append("</tr>");
}
sbTable.Replace("{content}", sbTableContent.ToString());
ReportTable reportTable = new ReportTable(sbTable.ToString());
if (model.Operate == Enumeration.OperateType.Serach)
{
return(Json(ResultType.Success, reportTable, ""));
}
else
{
NPOIExcelHelper.HtmlTable2Excel(reportTable.Html, "商户提现报表");
return(Json(ResultType.Success, ""));
}
#endregion
}
}
