public AppConfigs.OperResult AddSchool(SchoolEntity mdl)
{
if (User.IsInRole(AppConfigs.AppRole.sys.ToString()) || User.IsInRole(AppConfigs.AppRole.schoolmaster.ToString()))
{
var ss = new SchoolSv();
var se = ss.GetSchool(MyUserId);
if (se != null) //already has a school
{
se.MakeDay = DateTime.Now;
se.SchoolMasterId = MyUserId;
se.SchoolUrl = mdl.SchoolUrl;
se.Memo = mdl.Memo;
return(ss.UpdateSchool(se));
}
else
{
mdl.SchoolId = Guid.NewGuid().ToString("n");
mdl.Maker = MyUserId;
mdl.MakeDay = DateTime.Now;
mdl.SchoolMasterId = MyUserId;
return(ss.AddSchool(mdl));
}
}
return(AppConfigs.OperResult.failDueToAuthen);
}
public IHttpActionResult UpdateSchool([FromUri] int schoolId, [FromUri] string schoolName)
{
var files = HttpContext.Current.Request.Files;
if (files.Count > 0)
{
var file = HttpContext.Current.Request.Files[0];
using (MemoryStream ms = new MemoryStream())
{
file.InputStream.CopyTo(ms);
var school = new SchoolEntity
{
SchoolId = schoolId,
SchoolName = schoolName,
Logo = ms.ToArray()
};
schoolService.Update(school);
return(Ok());
}
}
else
{
var school = new SchoolEntity
{
SchoolId = schoolId,
SchoolName = schoolName
};
schoolService.Update(school);
return(Ok());
}
}
async void ViewModel_OnSchoolAddedAsync(Object sender, SchoolEntity SchoolEntity)
{
if (PopupNavigation.PopupStack.Count > 0)
{
await PopupNavigation.PopAllAsync(animate : true);
}
}
/// <summary>
/// 查询所有驾校信息 按当前位置坐标距离最近排序
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public List <SchoolEntity> GetAllShoolList(SchoolEntity para)
{
var list = SchoolBLL.Instance.GetList(para);
list.ForEach((o) =>
{
if (o.Lat != null && o.Lng != null && para.Lat != null && para.Lng != null)
{
o.HowLong = HarvenSin.GetDistance(
new Point2D()
{
Lng = (double)para.Lng,
Lat = (double)para.Lat
},
new Point2D()
{
Lng = (double)o.Lng,
Lat = (double)o.Lat
}).ToString("f2");
}
else
{
o.HowLong = "未知";
}
});
//list = list.OrderByDescending(d => d.HowLong).ToList();
list = list.OrderBy(i => i.HowLong).ThenBy(i => i.SortNum).ToList();
return(list);
}
public async Task UpdateSchoolAsync(SchoolEntity school)
{
var schoolPut = await PIDBContext.Schools.SingleAsync(c => c.Id == school.Id);
schoolPut.Name = school.Name;
schoolPut.City = school.City;
}
public void Delete(SchoolEntity entity)
{
using (var uow = unitOfWorkFactory.CreateUnitOfWork())
{
uow.SchoolRepository.Delete(entity);
uow.Save();
}
}
public AppConfigs.OperResult UpdateSchool(SchoolEntity mdl)
{
using (_db = new ApplicationDbContext())
{
_db.Entry(mdl).State = EntityState.Modified;
return(_db.SaveChanges() > 0?AppConfigs.OperResult.success:AppConfigs.OperResult.failUnknown);
}
}
public AppConfigs.OperResult AddSchool(SchoolEntity mdl)
{
using (_db = new ApplicationDbContext())
{
_db.Entry(mdl).State = System.Data.Entity.EntityState.Added;
return(_db.SaveChanges() > 0?AppConfigs.OperResult.success:AppConfigs.OperResult.failUnknown);
}
}
public SchoolMapPopup(SchoolEntity School, bool Selectable = false)
{
_school = School;
_selectable = Selectable;
InitializeComponent();
initMap();
}
protected void Page_Init(object sender, EventArgs e)
{
var userId = Request.Cookies["SmacCookie"]["UserId"];
if (SchoolEntity.GetUsersSchools(userId).Count == 1)
{
Response.Redirect("/Home.aspx");
}
}
public JsonResult Edit(int id, IFormCollection collection)
{
SchoolEntity entity = new SchoolEntity();
TryUpdateModelAsync(entity);
var result = service.Update(entity, AppUser);
// 如果有缓存，注意在这里要清空缓存
return(Json(result));
}
public void Update(SchoolEntity entity)
{
using (var uow = unitOfWorkFactory.CreateUnitOfWork())
{
if (entity.Logo == null)
{
entity.Logo = this.GetLogoById(entity.SchoolId);
}
uow.SchoolRepository.Update(entity);
uow.Save();
}
}
public JsonResult Create(IFormCollection collection)
{
SchoolEntity entity = new SchoolEntity();
TryUpdateModelAsync(entity);
entity.Enabled = true;
entity.Pw = AESEncryptUtil.Encrypt("123456");
var result = service.Create(entity, AppUser);
// 如果有缓存，注意在这里要清空缓存
return(Json(result));
}
public IActionResult Add([FromBody] SchoolEntity school)
{
try
{
schoolBusiness.Add(school);
return(Ok());
}
catch (Exception)
{
return(BadRequest("Não foi possível completar a requisição"));
throw;
}
}
/// <summary>
/// 考场
/// </summary>
/// <param name="id"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public List <OrgEntity> GetExamPalce(string id, string startTime, string endTime)
{
List <OrgEntity> list = new List <OrgEntity>();
SchoolEntity para = new SchoolEntity();
if (id != "")
{
para.SchoolId = id;
}
para.Status = (int)QX360.Model.Enums.UseStatus.启用;
para.IsTraining = 1;
var schoolList = SchoolBLL.Instance.GetList(para);
if (schoolList.Count > 0)
{
schoolList.ForEach((o) =>
{
var item = new OrgEntity();
item.Type = 2;
item.Id = o.SchoolId;
item.Name = o.Name;
item.KpiList = new List <KpiEntity>();
//车辆
item.KpiList.Add(new KpiEntity()
{
Name = "实训车辆数",
Count = TrainingCarBLL.Instance.GetList(new TrainingCarEntity()
{
SchoolId = o.SchoolId,
Status = (int)QX360.Model.Enums.UseStatus.启用
}).Count().ToString(),
});
//实训订单
item.KpiList.Add(new KpiEntity()
{
Name = "实训订单",
Count = TrainingOrderBLL.Instance.GetList(new TrainingOrderEntity()
{
StartTime = startTime,
EndTime = endTime,
SchoolId = o.SchoolId
}).Where(p => p.Status != (int)QX360.Model.Enums.TrainingStatus.已取消).Count().ToString()
});
list.Add(item);
});
}
return(list);
}
protected void Submit_Click(object sender, EventArgs e)
{
try
{
var usr = UserCredentialEntity.Authenticate(Request.Form["username"].Trim(), Request.Form["password"]);
FormsAuthenticationTicket tkt;
string cookiestr;
HttpCookie ck;
tkt = new FormsAuthenticationTicket(1, Request.Form["username"].Trim(), DateTime.Now, DateTime.Now.AddMinutes(60), false, "");
cookiestr = FormsAuthentication.Encrypt(tkt);
ck = new HttpCookie("SmacCookie", cookiestr);
StringBuilder sb = new StringBuilder();
var genders = GenderEntity.GetGenders();
genders.ForEach(t => sb.Append(t.GenderType.ToString() + ":"));
sb.Remove(sb.Length - 1, 1);
ck.Values.Add("UserId", usr.UserId);
ck.Values.Add("FirstName", usr.FirstName);
ck.Values.Add("LastName", usr.LastName);
ck.Values.Add("PhoneNumber", usr.PhoneNumber);
ck.Values.Add("Email", usr.EmailAddress);
ck.Values.Add("MiddleName", usr.MiddleName);
ck.Values.Add("UserName", usr.UserCredential.UserName);
ck.Values.Add("Gender", usr.GenderType);
ck.Values.Add("Genders", sb.ToString());
var school = SchoolEntity.GetUsersSchools(usr.UserId);
if (school.Count == 1)
{
ck.Values.Add("SchoolName", school[0].SchoolName);
ck.Values.Add("SchoolId", school[0].SchoolId.ToString());
}
Response.Cookies.Add(ck);
FormsAuthentication.RedirectFromLoginPage(Request.Form["username"].Trim(), false);
}
catch (Exception ex)
{
loginStatus.Text = ex.Message;
loginStatus.ForeColor = System.Drawing.Color.Red;
}
}
public ActionResult GetDataListJson(string queryJson)
{
SchoolEntity para = new SchoolEntity();
if (!string.IsNullOrWhiteSpace(queryJson))
{
var queryParam = queryJson.ToJObject();
if (!queryParam["istraining"].IsEmpty())
{
para.IsTraining = int.Parse(queryParam["istraining"].ToString());
}
}
para.IsTraining = 1;
var list = SchoolBLL.Instance.GetList(para);
return(Content(list.ToJson()));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var userId = Request.Cookies["SmacCookie"]["UserId"];
var schoolList = SchoolEntity.GetUsersSchools(userId);
ddList_SchoolSelect.Items.Clear();
ddList_SchoolSelect.Items.Add(new ListItem("------------------"));
foreach (var school in schoolList)
{
ddList_SchoolSelect.Items.Add(new ListItem(school.SchoolName, school.SchoolId.ToString()));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
var schoolId = int.Parse(Request.Cookies["SmacCookie"]["SchoolId"]);
if (!IsPostBack)
{
var school = SchoolEntity.GetSchool(schoolId);
var latestNews = LatestNewsEntity.GetLatestNews(schoolId, null);
this.SchoolNameDiv.InnerText = school.SchoolName;
this.SchoolAddrDiv.InnerText = school.StreetAddress;
this.SchoolCityDiv.InnerText = school.City;
this.SchoolStateDiv.InnerText = school.State;
this.SchoolZipDiv.InnerText = school.ZipCode;
this.SchoolPhoneDiv.InnerText = school.PhoneNumber;
var list = new List <string> {
"News", "Author"
};
var table = new DataTable();
foreach (var item in list)
{
table.Columns.Add(item, typeof(string));
}
//Now add some rows(which will be repeated in the ItemTemplate)
foreach (var news in latestNews)
{
table.Rows.Add(news.Content, string.Concat("Posted by ", news.User.FirstName, " ", news.User.LastName, " at ", news.PostedAt.ToString()));
}
latestNewsListView.DataSource = table;
latestNewsListView.DataBind();
}
}
/// <summary>
/// 导出EXCEL
/// </summary>
/// <param name="productOutId"></param>
/// <param name="conditions"></param>
public void ExportExcel(string queryJson)
{
string cacheKey = Request["cacheid"] as string;
HttpRuntime.Cache[cacheKey + "-state"] = "processing";
HttpRuntime.Cache[cacheKey + "-row"] = "0";
try
{
//这里要url解码
var queryParam = Server.UrlDecode(queryJson).ToJObject();
SchoolEntity para = new SchoolEntity();
//类型
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
var condition = queryParam["condition"].ToString().ToLower();
switch (condition)
{
case "name":
para.Name = queryParam["keyword"].ToString();
break;
case "conectname":
para.ConectName = queryParam["keyword"].ToString();
break;
case "conecttel":
para.ConectTel = queryParam["keyword"].ToString();
break;
case "countyname":
para.CountyName = queryParam["keyword"].ToString();
break;
}
}
para.IsTraining = 1;//实训
var list = SchoolBLL.Instance.GetList(para);
if (list != null)
{
list.ForEach((o) =>
{
if (o.ProvinceId != null)
{
o.ProvinceName = AreaBLL.Instance.GetEntity(o.ProvinceId).AreaName;
}
if (o.CityId != null)
{
o.CityName = AreaBLL.Instance.GetEntity(o.CityId).AreaName;
}
if (o.CountyId != null)
{
o.CountyName = AreaBLL.Instance.GetEntity(o.CountyId).AreaName;
}
o.AddressInfo = o.ProvinceName + o.CityName + o.CountyName + o.AddressInfo;
var subjectlist = SubjectBLL.Instance.GetList(new SubjectEntity()
{
SchoolId = o.SchoolId
});
var subjectname = "";
foreach (var item in subjectlist)
{
subjectname += string.Format("{0}：【{1}元】,", item.SubjectName, item.Price);
}
if (subjectname != "")
{
o.SubjectName = subjectname.Substring(0, subjectname.Length - 1);
}
o.TrainingCarCount = TrainingCarBLL.Instance.GetList(new TrainingCarEntity()
{
SchoolId = o.SchoolId
}).Count();
o.TrainingOrderCount = TrainingOrderBLL.Instance.GetList(new TrainingOrderEntity()
{
SchoolId = o.SchoolId
}).Count();
if (o.Status != null)
{
o.StatusName = ((RCHL.Model.Enums.UseStatus)o.Status).ToString();
}
});
//设置导出格式
ExcelConfig excelconfig = new ExcelConfig();
excelconfig.Title = "考场信息";
excelconfig.TitleFont = "微软雅黑";
excelconfig.TitlePoint = 10;
excelconfig.FileName = "考场信息.xls";
excelconfig.IsAllSizeColumn = true;
//每一列的设置,没有设置的列信息，系统将按datatable中的列名导出
List <ColumnEntity> listColumnEntity = new List <ColumnEntity>();
excelconfig.ColumnEntity = listColumnEntity;
ColumnEntity columnentity = new ColumnEntity();
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "Name", ExcelColumn = "考场名称", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "AddressInfo", ExcelColumn = "地址", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "ConectName", ExcelColumn = "联系人", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "ConectTel", ExcelColumn = "联系电话", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "TrainingPrice", ExcelColumn = "实训费用", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "SubjectName", ExcelColumn = "实训科目", Width = 15
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "TrainingCarCount", ExcelColumn = "实训车辆数", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "TrainingOrderCount", ExcelColumn = "实训订单", Width = 20
});
excelconfig.ColumnEntity.Add(new ColumnEntity()
{
Column = "StatusName", ExcelColumn = "状态", Width = 20
});
//需合并索引
//excelconfig.MergeRangeIndexArr = new int[] { 0, 1, 2, 3, 4, 5, 6, 7 };
//调用导出方法
ExcelHelper <SchoolEntity> .ExcelDownload(list, excelconfig);
HttpRuntime.Cache[cacheKey + "-state"] = "done";
}
}
catch (Exception)
{
HttpRuntime.Cache[cacheKey + "-state"] = "error";
}
}
/// <summary>
/// 驾校
/// </summary>
/// <param name="id"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public List <OrgEntity> GetSchool(string id, string startTime, string endTime)
{
List <OrgEntity> list = new List <OrgEntity>();
SchoolEntity para = new SchoolEntity();
if (id != "")
{
para.SchoolId = id;
}
para.Status = (int)QX360.Model.Enums.UseStatus.启用;
para.IsTraining = 0;
var schoolList = SchoolBLL.Instance.GetList(para);
if (schoolList.Count > 0)
{
schoolList.ForEach((o) =>
{
var item = new OrgEntity();
item.Type = 1;
item.Id = o.SchoolId;
item.Name = o.Name;
item.KpiList = new List <KpiEntity>();
//学员数
item.KpiList.Add(new KpiEntity()
{
Name = "学员总数",
Count = MemberBLL.Instance.GetList(new MemberEntity()
{
SchoolId = o.SchoolId,
Status = (int)QX360.Model.Enums.UseStatus.启用
}).Count().ToString(),
});
//教练数
item.KpiList.Add(new KpiEntity()
{
Name = "教练总数",
Count = TeacherBLL.Instance.GetList(new TeacherEntity()
{
SchoolId = o.SchoolId,
Status = (int)QX360.Model.Enums.UseStatus.启用
}).Count().ToString(),
});
//报名订单数
item.KpiList.Add(new KpiEntity()
{
Name = "报名订单",
Count = ApplyOrderBLL.Instance.GetList(new ApplyOrderEntity()
{
StartTime = startTime,
EndTime = endTime,
SchoolId = o.SchoolId
}).Where(p => p.Status != (int)QX360.Model.Enums.ApplyStatus.已取消).Count().ToString()
});
//学车订单
item.KpiList.Add(new KpiEntity()
{
Name = "学车订单",
Count = StudyOrderBLL.Instance.GetList(new StudyOrderEntity()
{
StartTime = startTime,
EndTime = endTime,
SchoolId = o.SchoolId
}).Where(p => p.Status != (int)QX360.Model.Enums.StudySubscribeStatus.取消).Count().ToString()
});
list.Add(item);
});
}
return(list);
}
public void Update(SchoolEntity school)
{
schoolData.Update(school);
}
public void Add(SchoolEntity school)
{
schoolData.Add(school);
}
public void Update(SchoolEntity school)
{
context.Update <SchoolEntity>(school);
context.SaveChanges();
}
public EditSonViewModel(IUserDialogs userDialogs, IMvxMessenger mvxMessenger, IParentService parentService,
ISocialMediaService socialMediaService, AppHelper appHelper, IOAuthService oauthService, ISchoolService schoolService) : base(userDialogs, mvxMessenger, appHelper)
{
_parentService = parentService;
_socialMediaService = socialMediaService;
_schoolService = schoolService;
_oauthService = oauthService;
RefreshCommand = ReactiveCommand.CreateFromObservable <Unit, PageModel>((param) => !PageLoaded ? LoadPageModel(): Observable.Empty <PageModel>());
RefreshCommand.Subscribe(OnPageModelLoaded);
RefreshCommand.IsExecuting.Subscribe((isExecuting) => HandleIsExecuting(isExecuting, AppResources.Common_Loading));
RefreshCommand.ThrownExceptions.Subscribe(HandleExceptions);
ForceRefreshCommand = ReactiveCommand.CreateFromObservable <Unit, PageModel>((param) => LoadPageModel());
ForceRefreshCommand.Subscribe(OnPageModelLoaded);
ForceRefreshCommand.IsExecuting.Subscribe((isExecuting) => HandleIsExecuting(isExecuting, AppResources.Common_Loading));
ForceRefreshCommand.ThrownExceptions.Subscribe(HandleExceptions);
TakePhotoCommand = ReactiveCommand.CreateFromObservable <Unit, MediaFile>((param) => _appHelper.PickPhotoStream());
TakePhotoCommand.Subscribe((ImageFile) =>
{
_userDialogs.HideLoading();
NewProfileImage = ImageFile;
OnNewSelectedImage(ImageFile);
});
TakePhotoCommand.ThrownExceptions.Subscribe(HandleExceptions);
SaveChangesCommand = ReactiveCommand
.CreateFromObservable <Unit, bool>((param) =>
{
return((CurrentSon.Identity == null ?
_parentService.AddSonToSelfParent(CurrentSon.FirstName, CurrentSon.LastName, CurrentSon.Birthdate, CurrentSon.School.Identity) :
_parentService.UpdateSonInformation(CurrentSon.Identity, CurrentSon.FirstName, CurrentSon.LastName, CurrentSon.Birthdate, CurrentSon.School.Identity))
.Do((SonEntity) => CurrentSon.HydrateWith(SonEntity))
.SelectMany((SonEntity) => _socialMediaService
.SaveAllSocialMedia(
CurrentSon.Identity,
CurrentSocialMedia.Select(s => { s.Son = CurrentSon.Identity; return s; }).ToList()
).Catch <IList <SocialMediaEntity>, NoSocialMediaFoundException>(ex => Observable.Return(new List <SocialMediaEntity>()))
)
.Do((SocialMediaEntities) => CurrentSocialMedia.ReplaceRange(SocialMediaEntities))
.SelectMany((_) =>
{
return NewProfileImage != null ?
_parentService.UploadSonProfileImage(CurrentSon.Identity, NewProfileImage.GetStream()) :
Observable.Empty <ImageEntity>();
})
.Select((_) => true)
.DefaultIfEmpty(true));
});
SaveChangesCommand.Subscribe((_) =>
{
NewProfileImage = null;
OnSonUpdated(CurrentSon);
_userDialogs.ShowSuccess(AppResources.EditSon_Saved_Changes_Successfully);
IsDirtyMonitoring = true;
});
SaveChangesCommand.IsExecuting.Subscribe((isLoading) => HandleIsExecuting(isLoading, AppResources.EditSon_Saving_Changes));
SaveChangesCommand.ThrownExceptions.Subscribe(HandleExceptions);
SaveSchoolCommand = ReactiveCommand.CreateFromObservable <Unit, SchoolEntity>((param) => _schoolService.CreateSchool(NewSchool.Name, NewSchool.Residence, NewSchool.Latitude, NewSchool.Longitude, NewSchool.Province, NewSchool.Tfno, NewSchool.Email));
SaveSchoolCommand.Subscribe((SchoolAdded) =>
{
NewSchool = new SchoolEntity();
CurrentSon.School.HydrateWith(SchoolAdded);
_appHelper.ShowAlert(AppResources.EditSon_School_Saved);
OnSchoolAdded(SchoolAdded);
});
SaveSchoolCommand.IsExecuting.Subscribe((isLoading) => HandleIsExecuting(isLoading, AppResources.EditSon_Saving_School));
SaveSchoolCommand.ThrownExceptions.Subscribe(HandleExceptions);
FindSchoolsCommand = ReactiveCommand.CreateFromObservable <string, IList <SchoolEntity> >(
(name) => _schoolService.FindSchools(name));
FindSchoolsCommand.IsExecuting.Subscribe((isLoading) => HandleIsExecuting(isLoading, AppResources.EditSon_Find_School));
FindSchoolsCommand.ThrownExceptions.Subscribe(HandleExceptions);
FindSchoolsCommand.Subscribe((SchoolsFounded) => {
SearchPerformed = true;
Schools.ReplaceRange(SchoolsFounded);
});
}
public ActionResult GetPageListJson(Pagination pagination, string queryJson)
{
var watch = CommonHelper.TimerStart();
SchoolEntity para = new SchoolEntity();
if (!string.IsNullOrWhiteSpace(queryJson))
{
var queryParam = queryJson.ToJObject();
//类型
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
var condition = queryParam["condition"].ToString().ToLower();
switch (condition)
{
case "name":
para.Name = queryParam["keyword"].ToString();
break;
case "conectname":
para.ConectName = queryParam["keyword"].ToString();
break;
case "conecttel":
para.ConectTel = queryParam["keyword"].ToString();
break;
case "countyname":
para.CountyName = queryParam["keyword"].ToString();
break;
}
}
}
para.IsTraining = 1;
var currentlogin = OperatorProvider.Provider.Current();
if (currentlogin.Account != Util.Config.GetValue("SysAccount"))
{
para.CreateId = currentlogin.UserId;
}
var pageList = SchoolBLL.Instance.GetPageList(para, ref pagination);
if (pageList != null)
{
pageList.ForEach((o) =>
{
if (o.ProvinceId != null)
{
o.ProvinceName = AreaBLL.Instance.GetEntity(o.ProvinceId).AreaName;
}
if (o.CityId != null)
{
o.CityName = AreaBLL.Instance.GetEntity(o.CityId).AreaName;
}
if (o.CountyId != null)
{
o.CountyName = AreaBLL.Instance.GetEntity(o.CountyId).AreaName;
}
o.AddressInfo = o.ProvinceName + o.CityName + o.CountyName + o.AddressInfo;
var subjectlist = SubjectBLL.Instance.GetList(new SubjectEntity()
{
SchoolId = o.SchoolId
});
var subjectname = "";
foreach (var item in subjectlist)
{
subjectname += string.Format("{0}：【{1}元】,", item.SubjectName, item.Price);
}
if (subjectname != "")
{
o.SubjectName = subjectname.Substring(0, subjectname.Length - 1);
}
var tagList = TagBLL.Instance.GetList(new TagEntity()
{
ObjectId = o.SchoolId
});
var tagname = "";
foreach (var item in tagList)
{
tagname += string.Format("{0},", item.Value);
}
if (tagname != "")
{
o.TagName = tagname.Substring(0, tagname.Length - 1);
}
o.TrainingCarCount = TrainingCarBLL.Instance.GetList(new TrainingCarEntity()
{
SchoolId = o.SchoolId
}).Count();
o.TrainingOrderCount = TrainingOrderBLL.Instance.GetList(new TrainingOrderEntity()
{
SchoolId = o.SchoolId
}).Count();
});
}
var JsonData = new
{
rows = pageList,
total = pagination.total,
page = pagination.page,
records = pagination.records,
costtime = CommonHelper.TimerEnd(watch)
};
return(Content(JsonData.ToJson()));
}
public void AddSchoolAsync(SchoolEntity school)
{
var saveSchool = PIDBContext.Schools.Add(school);
}
public JsonResult List(string queryJson)
{
var result = new ReturnMessage(false)
{
Message = "加载列表失败!"
};
try
{
int trainingtype = 1;
SchoolEntity para = new SchoolEntity();
if (!string.IsNullOrWhiteSpace(queryJson))
{
var queryParam = queryJson.ToJObject();
if (!queryParam["keyword"].IsEmpty())
{
para.Name = queryParam["keyword"].ToString();
}
if (!queryParam["provinceid"].IsEmpty())
{
para.ProvinceId = queryParam["provinceid"].ToString();
}
if (!queryParam["cityid"].IsEmpty())
{
para.CityId = queryParam["cityid"].ToString();
}
if (!queryParam["countyid"].IsEmpty())
{
para.CountyId = queryParam["countyid"].ToString();
}
if (!queryParam["priceid"].IsEmpty())
{
para.TrainingPriceRange = (RCHL.Model.Enums.PriceRange) int.Parse(queryParam["priceid"].ToString());
}
if (!queryParam["distanceid"].IsEmpty())
{
para.DistanceRange = (RCHL.Model.Enums.DistanceRange) int.Parse(queryParam["distanceid"].ToString());
}
if (!queryParam["lat"].IsEmpty())
{
para.Lat = decimal.Parse(queryParam["lat"].ToString());
}
if (!queryParam["lng"].IsEmpty())
{
para.Lng = decimal.Parse(queryParam["lng"].ToString());
}
if (!queryParam["schoolid"].IsEmpty())
{
para.SchoolId = queryParam["schoolid"].ToString();
}
if (!queryParam["istraining"].IsEmpty())
{
para.IsTraining = int.Parse(queryParam["istraining"].ToString());
}
if (!queryParam["trainingtype"].IsEmpty())
{
trainingtype = int.Parse(queryParam["trainingtype"].ToString());
}
}
para.IsTraining = 1;
para.Status = (int)Model.Enums.UseStatus.启用;
var newlist = new List <SchoolEntity>();
var flag = false;
para.sidx = "sortnum";
para.sord = "asc";
var list = SchoolBLL.Instance.GetList(para);
if (list != null)
{
foreach (var page in list)
{
if (page.SchoolId != null)
{
page.TagList = TagBLL.Instance.GetList(new TagEntity()
{
ObjectId = page.SchoolId
});
int count = SubjectBLL.Instance.GetList(new SubjectEntity()
{
SchoolId = page.SchoolId, ItemId = trainingtype.ToString()
}).Count();
if (count > 0)
{
flag = true;
}
else
{
continue;
}
}
if (page.FaceImage != null)
{
var imageHost = System.Configuration.ConfigurationManager.AppSettings["ImageHost"] == "" ? string.Format("http://{0}{1}", Request.Url.Host, Request.Url.Port == 80 ? "" : ":" + Request.Url.Port) : System.Configuration.ConfigurationManager.AppSettings["ImageHost"];
page.FaceImage = imageHost + page.FaceImage;
}
if (page.Lat != null && page.Lng != null && para.Lat != null && para.Lng != null)
{
page.HowLong = HarvenSin.GetDistance(
new Point2D()
{
Lng = (double)para.Lng,
Lat = (double)para.Lat
},
new Point2D()
{
Lng = (double)page.Lng,
Lat = (double)page.Lat
}).ToString("f2");
}
else
{
page.HowLong = "未知";
}
//添加数据
if (flag)
{
newlist.Add(page);
}
}
}
result.IsSuccess = true;
result.Message = "加载列表成功!";
result.ResultData["List"] = newlist;
}
catch (Exception ex)
{
ex.Data["Method"] = "ExamPlaceController>>List";
new ExceptionHelper().LogException(ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult ImportExcel(HttpPostedFileBase file)
{
int count = 0;
var result = new ReturnMessage(false)
{
Message = "上传失败!"
};
try
{
var data = ExcelHelper.ExcelImport(file.InputStream);
if (data != null)
{
if (data.Columns.Count != 8)
{
result.Message = "请按照模板格式正确填写内容!";
return(Json(result));
}
int successcount = 0, errorcount = 0;
foreach (System.Data.DataRow row in data.Rows)
{
try
{
if (row[0].ToString() != "")
{
SchoolEntity entity = new SchoolEntity();
entity.SchoolId = Util.Util.NewUpperGuid();
entity.Name = row[0].ToString();
var provincelist = AreaBLL.Instance.GetList().Where((o) => { return(o.AreaName == row[1].ToString()); });
if (provincelist != null && provincelist.Count() > 0)
{
var province = provincelist.FirstOrDefault();
entity.ProvinceId = province.AreaId;
entity.ProvinceName = province.AreaName;
}
var citylist = AreaBLL.Instance.GetList().Where((o) => { return(o.AreaName == row[2].ToString()); });
if (citylist != null && citylist.Count() > 0)
{
var city = citylist.FirstOrDefault();
entity.CityId = city.AreaId;
entity.CityName = city.AreaName;
}
var countyList = AreaBLL.Instance.GetList().Where((o) => { return(o.AreaName == row[3].ToString()); });
if (countyList != null && countyList.Count() > 0)
{
var county = countyList.FirstOrDefault();
entity.CountyId = county.AreaId;
entity.CountyName = county.AreaName;
}
entity.AddressInfo = row[4].ToString();
entity.ConectName = row[5].ToString();
entity.ConectTel = row[6].ToString();
if (row[7].ToString() != "")
{
entity.TrainingPrice = decimal.Parse(row[7].ToString());
}
entity.CreateTime = DateTime.Now;
entity.CreateId = LoginUser.UserId;
entity.IsTraining = 1;//考场
SchoolBLL.Instance.Add(entity);
successcount++;
}
}
catch (Exception)
{
errorcount++;
}
}
result.IsSuccess = true;
result.Message = string.Format("导入成功({0}条),失败({1}条))!", successcount, errorcount);
}
}
catch (Exception ex)
{
ex.Data["Method"] = "OrderLogisticController>>Import";
new ExceptionHelper().LogException(ex);
}
return(Json(result));
}
public JsonResult List(int?pageIndex, string queryJson)
{
var result = new ReturnMessage(false)
{
Message = "加载列表失败!"
};
try
{
SchoolEntity para = new SchoolEntity();
if (!string.IsNullOrWhiteSpace(queryJson))
{
var queryParam = queryJson.ToJObject();
if (!queryParam["keyword"].IsEmpty())
{
para.Name = queryParam["keyword"].ToString();
}
if (!queryParam["provinceid"].IsEmpty())
{
para.ProvinceId = queryParam["provinceid"].ToString();
}
if (!queryParam["cityid"].IsEmpty())
{
para.CityId = queryParam["cityid"].ToString();
}
if (!queryParam["countyid"].IsEmpty())
{
para.CountyId = queryParam["countyid"].ToString();
}
if (!queryParam["priceid"].IsEmpty())
{
para.TrainingPriceRange = (QX360.Model.Enums.PriceRange) int.Parse(queryParam["priceid"].ToString());
}
if (!queryParam["distanceid"].IsEmpty())
{
para.DistanceRange = (QX360.Model.Enums.DistanceRange) int.Parse(queryParam["distanceid"].ToString());
}
if (!queryParam["lat"].IsEmpty())
{
para.Lat = decimal.Parse(queryParam["lat"].ToString());
}
if (!queryParam["lng"].IsEmpty())
{
para.Lng = decimal.Parse(queryParam["lng"].ToString());
}
if (!queryParam["schoolid"].IsEmpty())
{
para.SchoolId = queryParam["schoolid"].ToString();
}
if (!queryParam["istraining"].IsEmpty())
{
para.IsTraining = int.Parse(queryParam["istraining"].ToString());
}
}
para.Status = (int)Model.Enums.UseStatus.启用;
Pagination pagination = new Pagination();
pagination.page = pageIndex ?? 1;
pagination.rows = 10;
//pagination.sidx = "SortNum";
//pagination.sord = "asc";
//var pageList = SchoolBLL.Instance.GetPageList(para, ref pagination);
var currentpage = new List <SchoolEntity>();
var pageList = GetAllShoolList(para);
var qpage = pageList.AsQueryable();
qpage = qpage.Skip((pagination.page - 1) * pagination.rows).Take(pagination.rows);
currentpage = qpage.ToList();
pagination.records = pageList.Count();
if (currentpage != null)
{
currentpage.ForEach((page) =>
{
if (page.FaceImage != null)
{
var imageHost = System.Configuration.ConfigurationManager.AppSettings["ImageHost"] == "" ? string.Format("http://{0}{1}", Request.Url.Host, Request.Url.Port == 80 ? "" : ":" + Request.Url.Port) : System.Configuration.ConfigurationManager.AppSettings["ImageHost"];
page.FaceImage = imageHost + page.FaceImage;
}
if (page.SchoolId != null)
{
page.TagList = TagBLL.Instance.GetList(new TagEntity()
{
ObjectId = page.SchoolId
});
page.TeacherList = TeacherBLL.Instance.GetList(new TeacherEntity()
{
SchoolId = page.SchoolId, Status = (int)Model.Enums.UseStatus.启用
}).OrderBy(o => o.SortNum).ToList();
if (page.TeacherList != null)
{
page.TeacherList.Foreach((o) =>
{
if (o.FaceImage != null)
{
var imageHost = System.Configuration.ConfigurationManager.AppSettings["ImageHost"] == "" ? string.Format("http://{0}{1}", Request.Url.Host, Request.Url.Port == 80 ? "" : ":" + Request.Url.Port) : System.Configuration.ConfigurationManager.AppSettings["ImageHost"];
o.FaceImage = imageHost + o.FaceImage;
}
});
}
}
//if (page.Lat != null && page.Lng != null && para.Lat != null && para.Lng != null)
//{
// page.HowLong = HarvenSin.GetDistance(
// new Point2D()
// {
// Lng = (double)para.Lng,
// Lat = (double)para.Lat
// },
// new Point2D()
// {
// Lng = (double)page.Lng,
// Lat = (double)page.Lat
// }).ToString("f2");
//}
//else
//{
// page.HowLong = "未知";
//}
});
}
result.IsSuccess = true;
result.Message = "加载列表成功!";
result.ResultData["IsEndPage"] = (pagination.total == (pageIndex ?? 1));
result.ResultData["List"] = currentpage;
}
catch (Exception ex)
{
ex.Data["Method"] = "ApplyController>>List";
new ExceptionHelper().LogException(ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
