public void deleteNaire(List <int> naireIds)
{
for (int i = 0; i < naireIds.Count; i++)
{
NaireWebDataContext db = new NaireWebDataContext();
var result = from r in db.naire_info
where r.id == naireIds[i]
select r;
db.naire_info.DeleteAllOnSubmit(result);
List <question_info> question_results = (from r in db.question_info
where r.naire_id == naireIds[i]
select r).ToList();
db.question_info.DeleteAllOnSubmit(question_results);
for (int j = 0; j < question_results.Count; j++)
{
var data_results = from r in db.data_info
where r.question_id == question_results[j].id
select r;
db.data_info.DeleteAllOnSubmit(data_results);
}
db.SubmitChanges();
}
}
public JsonResult register_info(string account, string password, string name)
{
NaireWebDataContext db = new NaireWebDataContext();
var rs = from r in db.user_info
where account == r.account
select new
{
r.id,
r.account
};
if (rs.FirstOrDefault() != null)
{
return(Json(0));
}
user_info user = new user_info();
user.account = account;
user.password = password;
user.name = name;
db.user_info.InsertOnSubmit(user);
db.SubmitChanges();
var rs2 = from r in db.user_info
where account == r.account
select new
{
r.id,
};
var ID = rs2.FirstOrDefault().id.ToString();
return(Json(ID));
}
/// <summary>
/// 获取管理员信息
/// </summary>
public void getManageInfo()
{
NaireWebDataContext db = new NaireWebDataContext();
var rs = from r in db.admin_info
where id == r.id.ToString()
select new
{
r.account,
r.password,
r.name
};
var account = rs.FirstOrDefault().account;
var name = rs.FirstOrDefault().name;
var password = rs.FirstOrDefault().password;
admin.Manage_account = account;
admin.Manage_name = name;
admin.Manage_password = password;
HttpCookie cookie = new HttpCookie("manage_account");
cookie.Value = admin.Manage_account;
Response.Cookies.Add(cookie);
HttpCookie cookie2 = new HttpCookie("manage_name");
cookie2.Value = admin.Manage_name;
Response.Cookies.Add(cookie2);
HttpCookie cookie3 = new HttpCookie("manage_password");
cookie3.Value = admin.Manage_password;
Response.Cookies.Add(cookie3);
}
public void getQuestionData(QuestionDataList questionDataList)
{
NaireWebDataContext db = new NaireWebDataContext();
List <QuestionDataItem> question_data_items = questionDataList.list;
for (int i = 0; i < question_data_items.Count; i++)
{
data_info data = new data_info();
data.question_id = question_data_items[i].id;
if (question_data_items[i].items.Count > 1)
{
data.data = JsonConvert.SerializeObject(question_data_items[i].items);
}
else if (question_data_items[i].items.Count == 1)
{
data.data = question_data_items[i].items[0];
}
// 提交存入数据库
db.data_info.InsertOnSubmit(data);
db.SubmitChanges();
}
// 获得问题id->获得问卷id->问卷收到数据数+1
int question_id = question_data_items[0].id;
question_info question_result = (from r in db.question_info
where r.id == question_id
select r).FirstOrDefault();
naire_info naire = (from r in db.naire_info
where r.id == question_result.naire_id
select r).FirstOrDefault();
naire.data += 1;
db.SubmitChanges();
}
// GET: Manager
public ActionResult Index()
{
id = Request.QueryString["id"];
if (id != null)
{
HttpCookie cookie = new HttpCookie("manage_id");
cookie.Value = id;
Response.Cookies.Add(cookie);
}
else
{
Response.Redirect("~/Manager/ManagerLogin");
return(View());
}
NaireWebDataContext db = new NaireWebDataContext();
// 首页显示基本信息
double user_num = (from r in db.user_info
select r.id).Count();
double naire_num = (from r in db.naire_info
select r.id).Count();
double data_num = (from r in db.data_info
select r.id).Count();
ViewBag.UserNum = user_num;
ViewBag.NaireNum = naire_num;
ViewBag.DataNum = data_num;
getManageInfo();
return(View());
}
public JsonResult login_info(string account, string password)
{
NaireWebDataContext db = new NaireWebDataContext();
var rs = from r in db.user_info
where account == r.account
where password == r.password
select new
{
r.id,
r.account
};
if (rs.FirstOrDefault() == null)
{
return(Json(0));
}
var rs2 = from r in db.user_info
where account == r.account
select new
{
r.id,
};
var ID = rs2.FirstOrDefault().id.ToString();
return(Json(ID));
}
public void instertNaireInfo(user_info naire_add)
{
user_info ca = new user_info();
ca.name = naire_add.name;
ca.password = naire_add.password;
ca.avatar = ca.avatar;
NaireWebDataContext db = new NaireWebDataContext();
db.user_info.InsertOnSubmit(ca);
db.SubmitChanges();
}
public string upImg(string avatar, string id)
{
NaireWebDataContext db = new NaireWebDataContext();
var user = db.user_info.Where(r => r.id.ToString() == id).FirstOrDefault();
user.avatar = "http://test.xkspbz.com/avatar/img" + GetImage(avatar, id);
db.SubmitChanges();
HttpCookie cookie3 = new HttpCookie("user_avatar");
cookie3.Value = "http://test.xkspbz.com/avatar/img" + GetImage(avatar, id);
Response.Cookies.Add(cookie3);
return("1");
}
public JsonResult getAllUserJson()
{
NaireWebDataContext db = new NaireWebDataContext();
var user_result = from r in db.user_info
select new
{
r.id,
r.name,
r.password,
r.avatar
};
return(Json(user_result));
}
public void DelateNaireInfo_User(int naire_id_user)
{
NaireWebDataContext db = new NaireWebDataContext();
try
{
var result = from r in db.user_info
where r.id == naire_id_user
select r;
db.user_info.DeleteAllOnSubmit(result);
db.SubmitChanges();
}
catch
{
}
}
public void naireToRecycleBin(int naire_id)
{
NaireWebDataContext db = new NaireWebDataContext();
var result = from r in db.naire_info
where r.id == naire_id
select r;
if (result != null)
{
foreach (naire_info r in result)
{
r.recycle = 1;
r.recycle_time = DateTime.Now.ToString("yyyy/MM/dd");
}
db.SubmitChanges();
}
}
public JsonResult getAllNaireJson()
{
NaireWebDataContext db = new NaireWebDataContext();
var naire_result = from r in db.naire_info
select new
{
r.id,
r.title,
r.state,
r.start_time,
r.update_time,
r.recycle,
r.recycle_time,
r.data
};
return(Json(naire_result));
}
// GET: PublishProject
public ActionResult Index()
{
string naire_id = Request.QueryString["naire_id"];
NaireWebDataContext db = new NaireWebDataContext();
var result = from r in db.naire_info
where r.id == int.Parse(naire_id)
select new
{
r.id,
r.title,
r.state
};
ViewBag.NaireInfo = JsonConvert.SerializeObject(result);
return(View());
}
public void editNaireInfo_user(user_info naire)
{
NaireWebDataContext db = new NaireWebDataContext();
var res = from p in db.user_info
where p.id == naire.id
select p;
if (res.FirstOrDefault() != null)
{
foreach (user_info ca in res)
{
ca.name = naire.name;
ca.password = naire.password;
ca.avatar = naire.avatar;
}
db.SubmitChanges();
}
}
public JsonResult getNewNaireJson()
{
string today = DateTime.Now.ToString("yyyy/MM/dd");//获取当前日期
NaireWebDataContext db = new NaireWebDataContext();
var naire_result = from r in db.naire_info where r.start_time == today
select new
{
r.id,
r.title,
r.state,
r.start_time,
r.update_time,
r.recycle,
r.recycle_time,
r.data
};
return(Json(naire_result));
}
public void restoreNaire(List <int> naireIds)
{
for (int i = 0; i < naireIds.Count; i++)
{
NaireWebDataContext db = new NaireWebDataContext();
var result = from r in db.naire_info
where r.id == naireIds[i]
select r;
if (result != null)
{
foreach (naire_info r in result)
{
r.recycle = 0;
r.recycle_time = null;
}
db.SubmitChanges();
}
}
}
/// <summary>
/// 创建项目
/// </summary>
private void createProject(NaireJsonObject naireJson)
{
user_id = Request.Cookies["user_id"].Value;
// 开始时间与最后修改时间
string start_time = Request.Cookies["start_time"].Value;
string edit_time = DateTime.Now.ToShortDateString().ToString();
NaireWebDataContext db = new NaireWebDataContext();
naire_info naire = new naire_info();
naire.user_id = int.Parse(user_id);
naire.title = naireJson.title;
naire.hint = naireJson.hint;
naire.state = "未发布";
naire.start_time = start_time;
naire.update_time = edit_time;
naire.questions = JsonConvert.SerializeObject(naireJson);
naire.recycle = 0;
// 提交问卷
db.naire_info.InsertOnSubmit(naire);
db.SubmitChanges();
// 获得naire_id的最大值
var naire_num = db.naire_info.Max(p => p.id);
naire_id = naire_num.ToString();
// 提交每一个问题
for (int i = 0; i < naireJson.list.Count; i++)
{
question_info question = new question_info();
question.naire_id = naire_num;
question.title = naireJson.list[i].title;
question.flag = naireJson.list[i].flag;
question.items = JsonConvert.SerializeObject(naireJson.list[i].items);
db.question_info.InsertOnSubmit(question);
db.SubmitChanges();
}
}
/// <summary>
/// 获得用户问卷
/// </summary>
public void getUserNaire()
{
string user_id = Request.Cookies["user_id"].Value;
NaireWebDataContext db = new NaireWebDataContext();
var result = from r in db.naire_info
where r.user_id.ToString() == user_id
select new
{
r.id,
r.title,
r.state,
r.start_time,
r.update_time,
r.data,
r.recycle,
r.recycle_time
};
ViewBag.NaireInfo = JsonConvert.SerializeObject(result);
}
public JsonResult JudgmentExists(string type, string input)
{
NaireWebDataContext db = new NaireWebDataContext();
if (type == "name")
{
var rs = from r in db.user_info
where input == r.name
select new
{
r.name
};
if (rs.FirstOrDefault() != null)
{
return(Json(1));
}
}
if (type == "phone" || type == "email")
{
var rs = from r in db.user_info
where input == r.account
select new
{
r.account
};
if (rs.FirstOrDefault() != null)
{
if (type == "phone")
{
return(Json(2));
}
if (type == "email")
{
return(Json(3));
}
}
}
return(Json(0));
}
[HttpPost] //表的编辑
public void editNaireInfo(naire_info naire)
{
NaireWebDataContext db = new NaireWebDataContext();
var res = from p in db.naire_info
where p.id == naire.id
select p;
if (res.FirstOrDefault() != null)
{
foreach (naire_info ca in res)
{
ca.title = naire.title;
ca.state = naire.state;
ca.update_time = naire.update_time;
ca.start_time = naire.start_time;
ca.data = naire.data;
ca.recycle = naire.recycle;
}
db.SubmitChanges();
}
}
public void getUserInfo()
{
NaireWebDataContext db = new NaireWebDataContext();
var rs = from r in db.user_info
where id == r.id.ToString()
select new
{
r.account,
r.name,
r.password,
r.avatar
};
var name = rs.FirstOrDefault().name;
var account = rs.FirstOrDefault().account;
var avatar = rs.FirstOrDefault().avatar;
var password = rs.FirstOrDefault().password;
user.Name = name;
user.Id = int.Parse(id);
user.Account = account;
user.Avatar = avatar;
user.Password = password;
HttpCookie cookie = new HttpCookie("user_account");
cookie.Value = user.Account;
Response.Cookies.Add(cookie);
HttpCookie cookie2 = new HttpCookie("user_name");
cookie2.Value = user.Name;
Response.Cookies.Add(cookie2);
HttpCookie cookie3 = new HttpCookie("user_avatar");
cookie3.Value = user.Avatar;
Response.Cookies.Add(cookie3);
HttpCookie cookie4 = new HttpCookie("user_password");
cookie4.Value = user.Password;
Response.Cookies.Add(cookie4);
}
public void changeState(string id, string state)
{
NaireWebDataContext db = new NaireWebDataContext();
var result = from r in db.naire_info
where r.id == int.Parse(id)
select r;
if (result != null)
{
foreach (naire_info r in result)
{
if (state == "0")
{
r.state = "收集中";
}
else
{
r.state = "未发布";
}
}
}
db.SubmitChanges();
}
public JsonResult Change_Admin_Info(string account, string name, string password)
{
NaireWebDataContext db = new NaireWebDataContext();
var rs = from r in db.admin_info
where r.account == account
select r;
if (rs != null)
{
foreach (admin_info r in rs)
{
r.name = name;
r.password = password;
}
}
else
{
return(Json(0));
}
db.SubmitChanges();
return(Json(1));
}
public string upInfo(string id, string name, string password)
{
NaireWebDataContext db = new NaireWebDataContext();
var rs = from r in db.user_info
where r.id.ToString() == id
select r;
if (rs.FirstOrDefault() != null)
{
rs.FirstOrDefault().name = name;
rs.FirstOrDefault().password = password;
}
db.SubmitChanges();
HttpCookie cookie2 = new HttpCookie("user_name");
cookie2.Value = name;
Response.Cookies.Add(cookie2);
HttpCookie cookie4 = new HttpCookie("user_password");
cookie4.Value = password;
Response.Cookies.Add(cookie4);
return("1");
}
// GET: StatisticProject
public ActionResult Index()
{
string naire_id = Request.QueryString["naire_id"];
ViewBag.naireId = int.Parse(naire_id);
NaireWebDataContext db = new NaireWebDataContext();
Statistic statistic = new Statistic();
// 先找问卷表拿 问卷标题，描述
var naires = from r in db.naire_info
where r.id == int.Parse(naire_id)
select new
{
r.title,
r.hint,
r.update_time,
r.data
};
statistic.title = naires.FirstOrDefault().title;
statistic.update_time = naires.FirstOrDefault().update_time;
statistic.data = naires.FirstOrDefault().data;
ViewBag.naireTitle = statistic.title;
ViewBag.naireData = statistic.data;
ViewBag.updateTime = statistic.update_time;
// 然后找问题表拿 问题id，flag，题目，选项
var questions = from r in db.question_info
where r.naire_id == int.Parse(naire_id)
select r;
foreach (question_info question in questions)
{
questions q = new questions();
q.title = question.title;
q.flag = question.flag;
var n = JsonConvert.DeserializeObject <List <string> >(question.items);
if (n != null)
{
for (var i = 0; i < n.Count; i++)
{
q.options.Add(n[i]);
}
}
else
{
q.options = null;
}
var reply = from r in db.data_info
where r.question_id == question.id
select r;
if (q.flag == 2 || q.flag == 3)
{
var count = JsonConvert.DeserializeObject <List <string> >(reply.FirstOrDefault().data).Count;
int[] a = new int[count];
foreach (var r in reply)
{
var index = JsonConvert.DeserializeObject <List <string> >(r.data);
for (var i = 0; i < index.Count; i++)
{
a[i] += int.Parse(index[i]);
}
}
foreach (var i in a)
{
q.replys.Add(i.ToString());
}
}
else if (q.flag == 1)
{
foreach (var r in reply)
{
q.replys.Add(r.data);
}
}
else if (q.flag == 4)
{
foreach (var r in reply)
{
q.replys.Add(r.data);
}
}
statistic.questions.Add(q);
}
string statistic_info = JsonConvert.SerializeObject(statistic);
ViewBag.statisticJson = statistic_info;
return(View());
}
// GET: Project
public ActionResult Index()
{
// 获得问卷Id
string naire_id = Request.QueryString["naire_id"];
// 判断问卷是否在预览状态
string isPreview = Request.QueryString["isPreview"];
if (isPreview == "1")
{
ViewBag.isPreview = "1";
}
// 根据问卷Id获得相应问题的Id
NaireWebDataContext db = new NaireWebDataContext();
// 判断是否发布了，如果没发布就不能打开
naire_info stateResult = (from r in db.naire_info
where r.id == int.Parse(naire_id)
select r).FirstOrDefault();
if (stateResult.state == "未发布")
{
// 重定向去首页
if (isPreview != "1")
{
return(Redirect("~/Home/Index"));
}
}
// 获得问卷的问题
var question_header = from r in db.question_info
where r.naire_id == int.Parse(naire_id)
select new
{
r.id,
r.naire_id,
r.title,
r.flag
};
var questions = (from r in db.naire_info
where r.id == int.Parse(naire_id)
select new
{
r.questions
}).FirstOrDefault().questions.ToString();
NaireJsonObject naire = JsonConvert.DeserializeObject <NaireJsonObject>(questions);
string question_header_json = JsonConvert.SerializeObject(question_header);
List <QuestionListItemHeader> naireList = JArray.Parse(question_header_json)
.ToObject <List <QuestionListItemHeader> >();
List <QuestionListItem> questionListItem_list = new List <QuestionListItem>();
for (int i = 0; i < naireList.Count; i++)
{
QuestionListItem item = new QuestionListItem();
item.id = naireList[i].id;
item.naire_id = naireList[i].naire_id;
item.title = naireList[i].title;
item.flag = naireList[i].flag;
item.list = naire.list[i].items;
questionListItem_list.Add(item);
}
// 根据相应问题的Id获得选项
NaireHaveIdJsonObject naireHaveId = new NaireHaveIdJsonObject();
naireHaveId.title = naire.title;
naireHaveId.hint = naire.hint;
naireHaveId.list = questionListItem_list;
// 拼接成JSON给前台生成问卷（挂个data-quesion-id）的属性
ViewBag.NaireHaveId = JsonConvert.SerializeObject(naireHaveId);
return(View());
}
