public ApiMessage ExportOrders()
{
this.IniRequest();
ApiMessage message = new ApiMessage();
int orderId = 0;
int agencyId = 0;
int resourceId = 0;
int resourceTaocanId = 0;
int status = 0;
string mobileNumber = null;
DateTime sDate = DateTime.MinValue;
DateTime eDate = DateTime.MinValue;
if (request["OrderId"]!=null)
{
int.TryParse(request["OrderId"].ToString(),out orderId);
}
if (request["AgencyId"] != null)
{
int.TryParse(request["AgencyId"].ToString(), out agencyId);
}
if(request["Status"]!=null)
{
int.TryParse(request["Status"],out status);
}
if (request["ResourceId"] != null)
{
int.TryParse(request["ResourceId"].ToString(), out resourceId);
}
if (request["ResourceTaocanId"] != null)
{
int.TryParse(request["ResourceTaocanId"].ToString(), out resourceTaocanId);
}
mobileNumber = request["MobileNumber"];
if (!string.IsNullOrEmpty(request["StartTime"]))
{
DateTime.TryParse(request["StartTime"], out sDate);
}
if (!string.IsNullOrEmpty(request["EndTime"]))
{
DateTime.TryParse(request["EndTime"], out eDate);
}
int total = 0;
long sintDate = sDate != DateTime.MinValue ? DateTimeUtil.ConvertDateTimeToInt(sDate) : 0;
long eintDate = eDate != DateTime.MinValue ? DateTimeUtil.ConvertDateTimeToInt(eDate) : 0;
OrderManagement orderMgr = new OrderManagement(User.Identity.Name);
List<BOrder> orders = orderMgr.FindOrders(orderId,
agencyId,
resourceId,
resourceTaocanId,
0,
null, mobileNumber,
new int[] { status},
sintDate,
eintDate,
out total,
0,
0, false);
message.Status = "OK";
string path = request.PhysicalApplicationPath;
string fileName = orderMgr.CurrentLoginUser.User.Id +"_"+ DateTime.Now.ToString("yyyyMMddHHmm")+".csv";
string fullPath = System.IO.Path.Combine(path+"\\Temp",fileName);
FileStream fs = null;
StreamWriter sw = null;
try
{
fs = new FileStream(fullPath, FileMode.Create);
sw = new StreamWriter(fs,Encoding.UTF8);
sw.WriteLine("编号,资源,代理商,手机号,省份,城市,平台成本价,平台售价,代理商代理价,代理商售价,时间,状态");
foreach (BOrder order in orders)
{
StringBuilder builder = new StringBuilder();
builder.Append(order.Id.ToString() + ",");
builder.Append(order.ReseouceName + ",");
builder.Append((order.AgentName != null ? order.AgentName.ToString() : "") + ",");
builder.Append(order.MobilePhone + ",");
builder.Append((order.MobileProvince != null ? order.MobileProvince : "") + ",");
builder.Append((order.MobileCity != null ? order.MobileCity : "") + ",");
builder.Append(order.PlatformCostPrice.ToString("0.00") + ",");
builder.Append(order.PlatformSalePrice.ToString("0.00") + ",");
builder.Append(order.PurchasePrice.ToString("0.00") + ",");
builder.Append(order.SalePrice.ToString("0.00") + ",");
builder.Append(DateTimeUtil.ConvertToDateTime(order.CreatedTime).ToString("yyyy-MM-dd HH:mm") + ",");
builder.Append(order.StatusText != null ? order.StatusText : "");
sw.WriteLine(builder.ToString());
}
}
catch(Exception ex)
{
logger.Fatal(ex);
}
finally
{
if(sw!=null)
{
sw.Close();
}
if (fs != null)
{
fs.Close();
}
}
message.Item = "http://"+request.Url.Authority+"/Temp/"+ fileName;
return message;
}
public ActionResult ChargeOrders(OrderSearchModel searchModel)
{
OrderManagement orderMgt = new OrderManagement(User.Identity.GetUserId<int>());
int pageSize = 30;
DateTime sDate = DateTime.MinValue;
DateTime eDate = DateTime.MinValue;
if (!string.IsNullOrEmpty(searchModel.StartTime))
{
DateTime.TryParse(searchModel.StartTime, out sDate);
}
if (!string.IsNullOrEmpty(searchModel.EndTime))
{
DateTime.TryParse(searchModel.EndTime, out eDate);
}
long sintDate = sDate != DateTime.MinValue ? DateTimeUtil.ConvertDateTimeToInt(sDate) : 0;
long eintDate = eDate != DateTime.MinValue ? DateTimeUtil.ConvertDateTimeToInt(eDate) : 0;
int page = 1;
if (Request["page"] != null)
{
int.TryParse(Request["page"], out page);
}
searchModel.Page = page;
searchModel.AgencyId = User.Identity.GetUserId<int>();
List<BOrder> orders = orderMgt.FindOrders(searchModel.OrderId != null ? (int)searchModel.OrderId : 0,
searchModel.AgencyId != null ? (int)searchModel.AgencyId : 0,
searchModel.ResourceId != null ? (int)searchModel.ResourceId : 0,
searchModel.ResourceTaocanId != null ? (int)searchModel.ResourceTaocanId : 0,
searchModel.RuoteId != null ? (int)searchModel.RuoteId : 0,
searchModel.SPName, searchModel.MobileNumber,
searchModel.Status,
sintDate,
eintDate,
out total,
pageSize,
searchModel.Page, true);
PageItemsResult<BOrder> result = new PageItemsResult<BOrder>() { CurrentPage = searchModel.Page, Items = orders, PageSize = pageSize, TotalRecords = total, EnablePaging = true };
KMBit.Grids.KMGrid<BOrder> grid = new Grids.KMGrid<BOrder>(result);
BigOrderSearchModel model = new BigOrderSearchModel() { SearchModel = searchModel, OrderGrid = grid };
List<BResourceTaocan> taocans = new List<BResourceTaocan>();
agentMgt = new AgentManagement(orderMgt.CurrentLoginUser);
List<BAgentRoute> routes = agentMgt.FindTaocans(0);
taocans = (from r in routes select r.Taocan).ToList<BResourceTaocan>();
ViewBag.Taocans = new SelectList((from t in taocans select new { Id = t.Taocan.Id, Name = t.Taocan2.Name }), "Id", "Name");
ViewBag.StatusList = new SelectList((from s in StaticDictionary.GetChargeStatusList() select new { Id = s.Id, Name = s.Value }), "Id", "Name");
return View(model);
}
public ActionResult OrderDetail(int orderId)
{
OrderManagement orderMgt = new OrderManagement(User.Identity.GetUserId<int>());
if (!orderMgt.CurrentLoginUser.Permission.CHARGE_HISTORY)
{
ViewBag.Message = "没有权限查看流量充值记录";
return View("Error");
}
List<BOrder> orders = orderMgt.FindOrders(orderId, 0, 0, 0, 0, null, null, null, 0, 0, out total);
if(orders==null || orders.Count==0)
{
ViewBag.Message = string.Format("编号为:{0}的充值记录不存在",orderId);
return View("Error");
}
return View(orders[0]);
}
public ActionResult OrderDetail(int orderId)
{
OrderManagement orderMgt = new OrderManagement(User.Identity.GetUserId<int>());
List<BOrder> orders = orderMgt.FindOrders(orderId, 0, 0, 0, 0, null, null, null, 0, 0, out total);
if (orders == null || orders.Count == 0)
{
ViewBag.Message = string.Format("编号为:{0}的充值记录不存在", orderId);
return View("Error");
}
if(orders[0].AgentId!=orderMgt.CurrentLoginUser.User.Id)
{
ViewBag.Message = string.Format("编号为:{0}的充值记录为其他代理商的充值信息，不能查看", orderId);
return View("Error");
}
return View(orders[0]);
}
public ActionResult ChargeOrders(OrderSearchModel searchModel)
{
OrderManagement orderMgt = new OrderManagement(User.Identity.GetUserId<int>());
agentAdminMgt = new AgentAdminMenagement(orderMgt.CurrentLoginUser);
resourceMgt = new ResourceManagement(orderMgt.CurrentLoginUser);
if (!orderMgt.CurrentLoginUser.Permission.CHARGE_HISTORY)
{
ViewBag.Message = "没有权限查看流量充值记录";
return View("Error");
}
int pageSize = 40;
DateTime sDate = DateTime.MinValue;
DateTime eDate = DateTime.MinValue;
if(!string.IsNullOrEmpty(searchModel.StartTime))
{
DateTime.TryParse(searchModel.StartTime, out sDate);
}
if (!string.IsNullOrEmpty(searchModel.EndTime))
{
DateTime.TryParse(searchModel.EndTime, out eDate);
}
long sintDate = sDate!=DateTime.MinValue?DateTimeUtil.ConvertDateTimeToInt(sDate):0;
long eintDate= eDate != DateTime.MinValue ? DateTimeUtil.ConvertDateTimeToInt(eDate) : 0;
int page = 1;
if(Request["page"]!=null)
{
int.TryParse(Request["page"],out page);
}
searchModel.Page = page;
List<BOrder> orders = orderMgt.FindOrders(searchModel.OrderId!=null?(int)searchModel.OrderId:0,
searchModel.AgencyId!=null?(int)searchModel.AgencyId:0,
searchModel.ResourceId!=null?(int)searchModel.ResourceId:0,
searchModel.ResourceTaocanId!=null?(int)searchModel.ResourceTaocanId:0,
searchModel.RuoteId!=null?(int)searchModel.RuoteId:0,
searchModel.SPName, searchModel.MobileNumber,
searchModel.Status,
sintDate,
eintDate,
out total,
pageSize,
searchModel.Page, true);
PageItemsResult<BOrder> result = new PageItemsResult<BOrder>() { CurrentPage = searchModel.Page, Items = orders, PageSize = pageSize, TotalRecords = total,EnablePaging=true };
KMBit.Grids.KMGrid<BOrder> grid = new Grids.KMGrid<BOrder>(result);
BigOrderSearchModel model = new BigOrderSearchModel() { SearchModel = searchModel, OrderGrid = grid };
List<KMBit.Beans.BUser> agencies = agentAdminMgt.FindAgencies(0, null, null, 0, 0, out total, 0, 0, false,null);
List<BResource> resources = new List<BResource>();
if(searchModel.AgencyId!=null)
{
resources = agentAdminMgt.FindAgentResources((int)searchModel.AgencyId);
}else
{
resources = resourceMgt.FindResources(0,null,0,out total);
}
ViewBag.Agencies = new SelectList((from a in agencies select a.User).ToList<Users>(),"Id","Name");
ViewBag.Resources = new SelectList((from r in resources select r.Resource).ToList<Resource>(), "Id", "Name");
List<BResourceTaocan> taocans = new List<BResourceTaocan>();
if(searchModel.ResourceId!=null)
{
if(searchModel.AgencyId==null)
{
taocans = resourceMgt.FindResourceTaocans((int)searchModel.ResourceId, 0, false);
}
else
{
taocans = agentAdminMgt.FindAgencyResourceTaocans((int)searchModel.AgencyId, (int)searchModel.ResourceId);
}
}
ViewBag.Taocans = new SelectList((from t in taocans select new { Id=t.Taocan.Id,Name=t.Taocan2.Name}), "Id", "Name");
ViewBag.StatusList = new SelectList((from s in StaticDictionary.GetChargeStatusList() select new { Id=s.Id,Name=s.Value}),"Id","Name");
return View(model);
}