public List <InformationModel> GetInformation(string condition, Guid adminId)
{
// InformationModel List 最终提交到页面的数据集
// InformationModel 继承至 Information
// 目的是为了包含FollowModel List
List <InformationModel> InformationModelList = new List <InformationModel>();
List <Information> InformationList = new List <Information>();
if (string.IsNullOrEmpty(condition))
{
// 如果condition没有值
// 首先获取前50条数据记录到 InformationList
InformationList = _informationBLL.GetInformationByAnythingswithGroupLeader(50, adminId).ToList();
}
else
{
// 如果condition有值 就按条件查询
InformationList = _informationBLL.GetInformationByAnythingswithGroupLeader(condition, adminId).ToList();
}
List <Information> InfoList = new List <Information>();
InfoList = InformationList.ToList();
// 然后循环InformationList
// 构造 InformationModelList
foreach (Information item in InformationList)
{
InformationModel info = new InformationModel(item);
List <FollowModel> followModelList = new List <FollowModel>();
List <FollowRecord> followRecordList = new List <FollowRecord>();
followRecordList = _followRecordBLL.GetFollowRecordByInformationId(info.Id).ToList();
foreach (FollowRecord fr in followRecordList)
{
FollowModel fm = new FollowModel();
fm.FollowName = _followBLL.GetFollow(fr.FollowId).FollowItem;
fm.FollowValue = fr.FollowValue;
followModelList.Add(fm);
}
info.FollowList = followModelList.AsEnumerable();
// 获取收集员的账号
var m = _memberBLL.GetMemberById(info.MemberId);
if (m != null)
{
info.MemberAccount = m.Account;
InformationModelList.Add(info);
}
}
return(InformationModelList);
}
public List <InformationModel> GetInformation(string condition)
{
// InformationModel List 最终提交到页面的数据集
// InformationModel 继承至 Information
// 目的是为了包含FollowModel List
List <InformationModel> InformationModelList = new List <InformationModel>();
List <Information> InformationList = new List <Information>();
if (string.IsNullOrEmpty(condition))
{
// 如果condition没有值
// 首先获取前50条数据记录到 InformationList
InformationList = _informationBLL.GetinformationLimitedwithSpecificMember(50, System.Web.HttpContext.Current.Session["member"].ToString()).ToList();
}
else
{
// 如果condition有值 就按条件查询
InformationList = _informationBLL.GetInformationByAnythingswithSpecificMember(condition, System.Web.HttpContext.Current.Session["member"].ToString()).ToList();
}
List <Information> InfoList = new List <Information>();
InfoList = InformationList.ToList();
// 然后循环InformationList
// 构造 InformationModelList
foreach (Information item in InformationList)
{
InformationModel info = new InformationModel(item);
List <FollowModel> followModelList = new List <FollowModel>();
List <FollowRecord> followRecordList = new List <FollowRecord>();
followRecordList = _followRecordBLL.GetFollowRecordByInformationId(info.Id).ToList();
foreach (FollowRecord fr in followRecordList)
{
FollowModel fm = new FollowModel();
fm.FollowName = _followBLL.GetFollow(fr.FollowId).FollowItem;
fm.FollowValue = fr.FollowValue;
followModelList.Add(fm);
}
info.FollowList = followModelList.AsEnumerable();
// 获取收集员的账号
info.MemberAccount = _memberBLL.GetMemberById(info.MemberId).Account;
InformationModelList.Add(info);
}
return(InformationModelList);
}
public ActionResult Update(string followId, string followName)
{
Follow follow = new Follow();
follow = _followBLL.GetFollow(Guid.Parse(followId));
follow.FollowItem = followName;
bool res = false;
using (DFYW_DbContext db = new DFYW_DbContext())
{
using (var trans = db.Database.BeginTransaction())
{
try
{
db.Set <Follow>().Attach(follow);
db.Entry <Follow>(follow).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
trans.Commit();
res = true;
}
catch (Exception ex)
{
LogHelper.Log.Write(ex.Message);
LogHelper.Log.Write(ex.StackTrace);
trans.Rollback();
res = false;
}
}
}
var obj = new
{
res = res,
follow = new
{
Id = followId,
Name = followName
}
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
public ActionResult ImportData()
{
if (Request.IsAjaxRequest())
{
var stream = HttpContext.Request.InputStream;
string json = new StreamReader(stream).ReadToEnd();
try
{
//JArray jarray = (JArray)JsonConvert.DeserializeObject(json);
List <KeyValuePair <string, string> > kvList = JsonToList(json);
Information infor = new Information();
#region 给information赋值
infor.Address = kvList.Where(n => n.Key == "address").SingleOrDefault().Value;
infor.Age = kvList.SingleOrDefault(n => n.Key == "age").Value;
infor.Children = kvList.SingleOrDefault(n => n.Key == "children").Value;
infor.CustomerName = kvList.SingleOrDefault(n => n.Key == "customerName").Value;
infor.Email = kvList.SingleOrDefault(n => n.Key == "email").Value;
infor.HasCar = kvList.SingleOrDefault(n => n.Key == "hascar").Value;
infor.HasHouse = kvList.SingleOrDefault(n => n.Key == "hashouse").Value;
infor.Hobby = kvList.SingleOrDefault(n => n.Key == "hobby").Value;
infor.Id = Guid.NewGuid();
infor.Income = kvList.SingleOrDefault(n => n.Key == "income").Value;
infor.Industry = kvList.SingleOrDefault(n => n.Key == "industry").Value;
infor.InserTime = DateTime.Now.ToString("yyyy-MM-dd");
infor.IsMarry = kvList.SingleOrDefault(n => n.Key == "ismarry").Value;
infor.MemberId = _memberBLL.GetMemberByAccount(System.Web.HttpContext.Current.Session["Admin"].ToString(), 1).Id;
infor.Occupation = kvList.SingleOrDefault(n => n.Key == "occupation").Value;
infor.Phone = kvList.SingleOrDefault(n => n.Key == "phone").Value;
infor.QQ = kvList.SingleOrDefault(n => n.Key == "qq").Value;
infor.Sex = kvList.SingleOrDefault(n => n.Key == "sex").Value;
infor.WebCat = kvList.SingleOrDefault(n => n.Key == "webcat").Value;
infor.Note1 = kvList.SingleOrDefault(n => n.Key == "note1").Value;
infor.Note2 = kvList.SingleOrDefault(n => n.Key == "note2").Value;
infor.Note3 = kvList.SingleOrDefault(n => n.Key == "note3").Value;
#endregion
#region 添加FollowRecord
if (_informationBLL.Add(infor))
{
List <Follow> followList = _followBLL.GetAllFollow().ToList();
foreach (var item in followList)
{
FollowRecord fr = new FollowRecord();
fr.FollowId = _followBLL.GetFollow(item.FollowItem).Id;
fr.InforId = infor.Id;
fr.Id = Guid.NewGuid();
fr.FollowValue = kvList.SingleOrDefault(n => n.Key == item.FollowItem).Value;
_followRecordBLL.Add(fr);
}
return(Json("True", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("False", JsonRequestBehavior.AllowGet));
}
#endregion
}
catch (Exception ex)
{
LogHelper.Log.Write(ex.Message);
LogHelper.Log.Write(ex.StackTrace);
return(Json("False", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("False", JsonRequestBehavior.AllowGet));
}
}