public ActionResult Index(BasicProvince BasicProvince, EFPagingInfo <BasicProvince> p, int IsFirst = 0)
{
IPageOfItems <BasicProvince> BasicProvinceList = null;
if (!BasicProvince.Name.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Name.Contains(BasicProvince.Name));
}
if (!BasicProvince.State.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.State == (BasicProvince.State == 99 ? 0 : BasicProvince.State));
}
p.OrderByList.Add("Id", "ASC");
if (IsFirst == 0)
{
BasicProvinceList = new PageOfItems <BasicProvince>(new List <BasicProvince>(), 0, 10, 0, new Hashtable());
}
else
{
BasicProvinceList = Entity.Selects <BasicProvince>(p);
}
ViewBag.BasicProvinceList = BasicProvinceList;
ViewBag.BasicProvince = BasicProvince;
ViewBag.Add = this.checkPower("Add");
ViewBag.Edit = this.checkPower("Edit");
ViewBag.Delete = this.checkPower("Delete");
ViewBag.Save = this.checkPower("Save");
return(View());
}
public void Save(BasicProvince BasicProvince)
{
BasicProvince baseBasicProvince = Entity.BasicProvince.FirstOrDefault(n => n.Id == BasicProvince.Id);
baseBasicProvince = Request.ConvertRequestToModel <BasicProvince>(baseBasicProvince, BasicProvince);
Entity.SaveChanges();
BaseRedirect();
}
public void Delete(BasicProvince BasicProvince, string InfoList, int?IsDel)
{
if (string.IsNullOrEmpty(InfoList))
{
InfoList = BasicProvince.Id.ToString();
}
int Ret = Entity.MoveToDeleteEntity <BasicProvince>(InfoList, IsDel, AdminUser.UserName);
Entity.SaveChanges();
Response.Write(Ret);
}
public void ChangeStatus(BasicProvince BasicProvince, string InfoList, string Clomn, string Value)
{
if (string.IsNullOrEmpty(InfoList))
{
InfoList = BasicProvince.Id.ToString();
}
int Ret = Entity.ChangeEntity <BasicProvince>(InfoList, Clomn, Value);
Entity.SaveChanges();
Response.Write(Ret);
}
public ActionResult Edit(BasicProvince BasicProvince)
{
if (BasicProvince.Id != 0)
{
BasicProvince = Entity.BasicProvince.FirstOrDefault(n => n.Id == BasicProvince.Id);
}
if (BasicProvince == null)
{
ViewBag.ErrorMsg = "数据不存在";
return(View("Error"));
}
ViewBag.BasicProvince = BasicProvince;
if (Request.UrlReferrer != null)
{
Session["Url"] = Request.UrlReferrer.ToString();
}
return(View());
}
public void Add(DaiLiApply DaiLiApply)
{
//TODO:因为代理级别业务修改，这里这要改变
//if (BasicAgent.Levels == 3) {
// DaiLiApply Temp = Entity.DaiLiApply.FirstOrDefault(n => n.Agent == BasicAgent.Id && (n.OrderState == 1 || n.OrderState == 2));
// if (Temp != null) {
// Response.Write("有未处理完成订单在处理中~");
// return;
// }
//}
DaiLiApply = Request.ConvertRequestToModel <DaiLiApply>(DaiLiApply, DaiLiApply);
DaiLiApply.AddTime = DateTime.Now;
DaiLiApply.Agent = BasicAgent.Id;
DaiLiApply.AId = AdminUser.Id;
DaiLiApply.Amoney = 0;
DaiLiApply.OrderState = 1;//1待处理 2已开通 3取消
if (DaiLiApply.Area.IsNullOrEmpty())
{
int Area = 0;
try
{
Area = Int32.Parse(DaiLiApply.Area);
}
catch (Exception) { }
if (!Area.IsNullOrEmpty())
{
BasicCity BasicCity = Entity.BasicCity.FirstOrNew(n => n.Id == Area);
BasicProvince BasicProvince = Entity.BasicProvince.FirstOrNew(n => n.Id == BasicCity.PId);
DaiLiApply.Area = BasicProvince.Name + "|" + BasicCity.Name;
}
}
//if (BasicAgent.Levels == 3) {
// DaiLiApply.Remark = "金牌代理申请升级钻石代理";
//}
//Entity.DaiLiApply.AddObject(DaiLiApply);
//Entity.SaveChanges();
//if (BasicAgent.Levels == 3) {
// Response.Redirect("/Agent/DaiLiApply/Edit.html");
//}
//if (BasicAgent.Levels == 4)
//{
// Response.Redirect("/Agent/DaiLiApply/Index.html");
//}
}
public void Post()
{
string Data = DataObj.GetData();
if (Data.IsNullOrEmpty())
{
DataObj.OutError("1000");
return;
}
JObject json = new JObject();
try
{
json = (JObject)JsonConvert.DeserializeObject(Data);
}
catch (Exception Ex)
{
Log.Write("[UserCardInfo]:", "【Data】" + Data, Ex);
}
if (json == null)
{
DataObj.OutError("1000");
return;
}
UserCard UserCard = new UserCard();
UserCard = JsonToObject.ConvertJsonToModel(UserCard, json);
//获取用户信息
Users baseUsers = Entity.Users.FirstOrDefault(n => n.Token == UserCard.Token);
if (baseUsers == null)//用户令牌不存在
{
DataObj.OutError("2004");
return;
}
if (baseUsers.State != 1)//用户被锁定
{
DataObj.OutError("2003");
return;
}
if (baseUsers.CardStae != 2)//未实名认证
{
DataObj.OutError("2006");
return;
}
if (baseUsers.MiBao != 1)//未设置支付密码
{
DataObj.OutError("2008");
return;
}
UserCard = Entity.UserCard.FirstOrDefault(n => n.Id == UserCard.Id && n.UId == baseUsers.Id && n.State == 1);
if (UserCard == null)//不存在
{
DataObj.OutError("1001");
return;
}
if (!UserCard.Province.IsNullOrEmpty())
{
BasicProvince BasicProvince = Entity.BasicProvince.FirstOrDefault(n => n.Id == UserCard.Province);
if (BasicProvince != null)
{
UserCard.ProvinceName = BasicProvince.Name;
}
}
if (!UserCard.City.IsNullOrEmpty())
{
BasicCity BasicCity = Entity.BasicCity.FirstOrDefault(n => n.Id == UserCard.City);
if (BasicCity != null)
{
UserCard.CityName = BasicCity.Name;
}
}
UserCard.Cols = "Id,Bank,Card,Name,Type,Deposit,Province,City,District,Bin,BId,ProvinceName,CityName,Mobile";
DataObj.Data = UserCard.OutJson();
DataObj.Code = "0000";
DataObj.OutString();
}
/// <summary>
/// 导出
/// </summary>
/// <param name="ApplyJoin"></param>
/// <param name="p"></param>
/// <param name="STime"></param>
/// <param name="ETime"></param>
/// <param name="IsShowSupAgent"></param>
/// <returns></returns>
public FileResult ExcelExport(ApplyJoin ApplyJoin, EFPagingInfo <ApplyJoin> p, DateTime?STime, DateTime?ETime, bool?IsShowSupAgent)
{
p.PageSize = 9999999;
if (IsShowSupAgent == null)
{
IsShowSupAgent = false;
}
p.SqlWhere.Add(f => f.AddTime > STime && f.AddTime < ETime);
if (!ApplyJoin.ServiceType.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.ServiceType == ApplyJoin.ServiceType);
}
if (!ApplyJoin.ApplyType.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.ApplyType == ApplyJoin.ApplyType);
}
if (!ApplyJoin.Linker.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Linker.Contains(ApplyJoin.Linker));
}
if (!ApplyJoin.Mobile.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Mobile.Contains(ApplyJoin.Mobile));
}
if (!ApplyJoin.ComName.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.ComName.Contains(ApplyJoin.ComName));
}
if (!ApplyJoin.Province.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.Province == ApplyJoin.Province);
}
if (!ApplyJoin.City.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.City == ApplyJoin.City);
}
if (!ApplyJoin.TiePaiAgentId.IsNullOrEmpty())
{
if (ApplyJoin.TiePaiAgentId == 1)
{
p.SqlWhere.Add(f => f.TiePaiAgentId != null);
}
else
{
p.SqlWhere.Add(f => f.TiePaiAgentId == null);
}
}
if (!ApplyJoin.State.IsNullOrEmpty())
{
p.SqlWhere.Add(f => f.State == ApplyJoin.State);
}
p.OrderByList.Add("Id", "DESC");
IPageOfItems <ApplyJoin> ApplyJoinList = Entity.Selects <ApplyJoin>(p);
DataTable table = new DataTable();
DataRow row = null;
// 创建 datatable
table.Columns.Add(new DataColumn("联系人", typeof(string)));
table.Columns.Add(new DataColumn("手机号", typeof(string)));
table.Columns.Add(new DataColumn("公司名称", typeof(string)));
table.Columns.Add(new DataColumn("所在省", typeof(string)));
table.Columns.Add(new DataColumn("所在市", typeof(string)));
table.Columns.Add(new DataColumn("申请时间", typeof(string)));
table.Columns.Add(new DataColumn("状态", typeof(string)));
table.Columns.Add(new DataColumn("上级代理名", typeof(string)));
table.Columns.Add(new DataColumn("是否贴牌", typeof(string)));
// 填充数据
foreach (var item in ApplyJoinList)
{
BasicProvince BasicProvince = Entity.BasicProvince.FirstOrNew(n => n.Id == item.Province);
BasicCity BasicCity = Entity.BasicCity.FirstOrNew(n => n.Id == item.City);
string stateName = "";
row = table.NewRow();
row[0] = item.Linker;
row[1] = item.Mobile;
row[2] = item.ComName;
row[3] = BasicProvince.Name;
row[4] = BasicCity.Name;
row[5] = item.AddTime.ToString("yyyy-MM-dd");
switch (item.State)
{
case 1:
stateName = "未跟进";
break;
case 2:
stateName = "跟进中";
break;
case 3:
stateName = "无意向";
break;
case 4:
stateName = "已完成";
break;
default:
break;
}
row[6] = stateName;
row[7] = item.AgentName;
row[8] = item.TiePaiAgentId != null ? "是" : "否";
table.Rows.Add(row);
}
string Time = STime.IsNullOrEmpty() ? "" : STime.Value.ToString("yyyy-MM-dd") + "至" + (ETime.IsNullOrEmpty() ? "" : ETime.Value.ToString("yyyy-MM-dd"));
return(this.ExportExcelBase(table, "合作申请 " + Time));
}
public void Add(BasicProvince BasicProvince)
{
Entity.BasicProvince.AddObject(BasicProvince);
Entity.SaveChanges();
BaseRedirect();
}
