public string Update(string Name, string Company, string Flag, string ID)
{
TouPiaoContext tc = new TouPiaoContext();
Guid UID = Guid.Parse(ID);
string feebackMessage = string.Empty;
switch (Flag)
{
case "DU":
User du = tc.Users.Find(UID);
tc.Users.Remove(du);
tc.SaveChanges();
feebackMessage = "DELTE USER ID:" + ID;
break;
case "AU":
User au = tc.Users.Find(UID);
au.Company = Company;
au.Name = Name;
tc.SaveChanges();
feebackMessage = "UPDATE USER ID:" + ID + " COMPANY TO :" + Company + " NAME TO:" + Name;
break;
case "DT":
TouPiao dt = tc.TouPiaos.Find(UID);
tc.TouPiaos.Remove(dt);
tc.SaveChanges();
feebackMessage = "DELTE TOUPIAO ID:" + ID;
break;
default:
break;
}
return(feebackMessage);
}
public ActionResult ImportSystemName()
{
string exportDataList = Request["exportDataList"];
if (!string.IsNullOrEmpty(exportDataList))
{
string[] rowList = exportDataList.Split('%');
TouPiaoContext tc = new TouPiaoContext();
var tps = tc.TouPiaos.ToList();
foreach (var tp in tps)
{
tc.TouPiaos.Remove(tp);
}
tc.SaveChanges();
var sns = tc.SystemNames.ToList();
foreach (var sn in sns)
{
tc.SystemNames.Remove(sn);
}
tc.SaveChanges();
foreach (string rowstr in rowList)
{
string[] colList = rowstr.Split('&');
if (colList.Length == 4)
{
SystemName ed = new SystemName();
ed.NameCN = colList[0] == "." ? string.Empty : colList[0];
ed.NameEN = colList[1] == "." ? string.Empty : colList[1];
ed.Remark = colList[2] == "." ? string.Empty : colList[2];
ed.SubmitTime = Convert.ToDateTime(colList[3]);
tc.SystemNames.Add(ed);
tc.SaveChanges();
}
}
}
return(View());
}
public ActionResult Index()
{
ViewBag.FeebackMessage = string.Empty;
Dictionary <string, object> dataList = new Dictionary <string, object>();
TouPiaoContext tc = new TouPiaoContext();
string userName = Request["UserName"];
string companyName = Request["CompanyName"];
string checkID = Request["checkID"];
string remoteAddr = Request["REMOTE_ADDR"];
string remoteHost = Request["REMOTE_HOST"];
if (!string.IsNullOrEmpty(userName) && !string.IsNullOrEmpty(companyName) && !string.IsNullOrEmpty(checkID))
{
User submitUser = tc.Users.Where(u => u.Name == userName && u.Company == companyName).FirstOrDefault();
if (submitUser != null)
{
int submitCount = tc.TouPiaos.Where(t => t.User.ID == submitUser.ID).Count();
if (submitCount != 0)
{
SystemName targetName = tc.TouPiaos.Where(t => t.User.ID == submitUser.ID).Select(t => t.SystemName).FirstOrDefault();
ViewBag.FeebackMessage = "本次投票失败，您之前已投票给【" + targetName.NameCN + "/" + targetName.NameEN + "】如有疑问，请联系管理员。";
}
else
{
Guid guid = Guid.Parse(checkID);
TouPiao tempTouPiao = new TouPiao();
tempTouPiao.User = submitUser;
tempTouPiao.SystemName = tc.SystemNames.Where(s => s.ID == guid).First();
tempTouPiao.SubmitIP = remoteAddr;
tempTouPiao.SubmitMAC = remoteHost;
tempTouPiao.SubmitTime = DateTime.Now;
tc.TouPiaos.Add(tempTouPiao);
tc.SaveChanges();
ViewBag.FeebackMessage = "投票成功";
}
}
else
{
ViewBag.FeebackMessage = "投票名单不存在：" + userName + " 联系管理员处理。";
}
}
dataList["NameList"] = tc.Users.OrderByDescending(k => k.Name).Select(u => u.Name).Distinct().ToList();
((List <string>)dataList["NameList"]).Sort();
dataList["CompanyList"] = tc.Users.OrderByDescending(u => u.Company).Select(u => u.Company).Distinct().ToList();
((List <string>)dataList["CompanyList"]).Sort();
dataList["SystemName"] = tc.SystemNames.OrderBy(u => u.SubmitTime).ToList();
return(View(dataList));
}
public ActionResult ImportUser()
{
string exportDataList = Request["exportDataList"];
if (!string.IsNullOrEmpty(exportDataList))
{
string[] rowList = exportDataList.Split('%');
TouPiaoContext tc = new TouPiaoContext();
var tps = tc.TouPiaos.ToList();
foreach (var tp in tps)
{
tc.TouPiaos.Remove(tp);
}
tc.SaveChanges();
var sns = tc.Users.ToList();
foreach (var sn in sns)
{
tc.Users.Remove(sn);
}
tc.SaveChanges();
foreach (string rowstr in rowList)
{
string[] colList = rowstr.Split('&');
if (colList.Length == 3)
{
User ed = new User();
ed.Company = colList[0];
ed.Name = colList[1];
ed.Contact = colList[2];
tc.Users.Add(ed);
tc.SaveChanges();
}
}
}
return(View());
}
