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();
}
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));
}
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();
}
}
/// <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();
}
}
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 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 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();
}
}
}
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();
}
}
[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 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");
}
