public ActionResult SelectData()
{
int pageindex = int.Parse(Request.Params["pageindex"]);
string taskcode = "";
string worktypename = "";
string createby = "";
string time1 = "";
string time2 = "";
int skip = (pageindex - 1) * 6;
string sql = "select *from ps_solvetask_main where 1=1 and taskstatus!=1 ";
if (Request.Params["taskcode"] != "")
{
taskcode = Request.Params["taskcode"];
sql += " and solveTaskCode like '%" + taskcode + "%' ";
}
if (Request.Params["worktypename"] != "")
{
worktypename = Request.Params["worktypename"];
sql += " and workDocTypeName='" + worktypename + "' ";
}
if (Request.Params["createby"] != "")
{
createby = Request.Params["createby"];
sql += "and issuedByName like '%" + createby + "%'";
}
if (Request.Params["time1"] != null)
{
time1 = Request.Params["time1"];
time2 = Request.Params["time2"];
sql += " and issuedTime>= '" + time1 + "' and issuedTime<='" + time2 + "'";
}
SqlConnection con = new SqlConnection("server=.;database=MyElectrCheck_DB;Integrated Security=true;");
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
List <ps_solvetask_main> list = new List <ps_solvetask_main>();
while (dr.Read())
{
ps_solvetask_main main = new ps_solvetask_main();
main.id = int.Parse(dr["id"].ToString());
main.solveTaskCode = dr["solveTaskCode"].ToString();
main.solveTaskName = dr["solveTaskName"].ToString();
main.workDocTypeName = dr["workDocTypeName"].ToString();
main.issuedByName = dr["issuedByName"].ToString();
main.issuedTime = DateTime.Parse(dr["issuedTime"].ToString());
main.taskStatus = int.Parse(dr["taskStatus"].ToString());
main.taskStatusName = dr["taskStatusName"].ToString();
if (dr["finishTime"].ToString() != "")
{
main.finishTime = Convert.ToDateTime(dr["finishTime"].ToString());
}
main.isCancel = int.Parse(dr["isCancel"].ToString());
list.Add(main);
}
dr.Close();
con.Close();
DataSource ds = new DataSource();
ds.taskmainlist = list.Skip(skip).Take(6).ToList();
ds.datacount = list.Count();
string jsonstr = JsonConvert.SerializeObject(ds);
return(Content(jsonstr));
}
public ActionResult SelectData()
{
int pageindex = int.Parse(Request.Params["pageindex"]);
string taskcode = "";
string worktypename = "";
string createby = "";
string time1 = "";
string time2 = "";
int skip = (pageindex - 1) * 5;
var user = (from u in medc.ps_user
where u.id == int.Parse(Session["userid"].ToString())
select u).FirstOrDefault();
var role = (from r in medc.ps_role
where r.id == user.roleId
select r).FirstOrDefault();
string sql = "";
if (role.roleName == "系统管理员")
{
sql = "select* from [ps_solvetask_main] where 1=1 and taskStatus!=1 and taskStatus!=4 and taskStatus!=5 ";
}
else
{
sql = "select a.id,a.solveTaskCode,a.solveTaskName,a.workDocTypeName,a.issuedByName,a.issuedTime,a.taskStatus,a.taskStatusName,a.finishTime,a.iscancel from [ps_solvetask_main] a inner join ps_solver_detail b on a.id=b.taskid where a.isCancel=0 and 1=1 and a.taskStatus!=1 and a.taskStatus!=4 and b.solverCode='" + user.userCode + "' ";
}
if (Request.Params["taskcode"] != "")
{
taskcode = Request.Params["taskcode"];
sql += " and a.solveTaskCode like '%" + taskcode + "%' ";
}
if (Request.Params["worktypename"] != "")
{
worktypename = Request.Params["worktypename"];
sql += " and a.workDocTypeName='" + worktypename + "' ";
}
if (Request.Params["createby"] != "")
{
createby = Request.Params["createby"];
sql += " and a.issuedByName like '%" + createby + "%'";
}
if (Request.Params["time1"] != null)
{
time1 = Request.Params["time1"];
time2 = Request.Params["time2"];
sql += " and a.issuedTime>= '" + time1 + "' and a.issuedTime<='" + time2 + "'";
}
SqlConnection con = new SqlConnection("server=.;database=MyElectrCheck_DB;Integrated Security=true;");
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
List <ps_solvetask_main> list = new List <ps_solvetask_main>();
while (dr.Read())
{
ps_solvetask_main main = new ps_solvetask_main();
main.id = int.Parse(dr["id"].ToString());
main.solveTaskCode = dr["solveTaskCode"].ToString();
main.solveTaskName = dr["solveTaskName"].ToString();
main.workDocTypeName = dr["workDocTypeName"].ToString();
main.issuedByName = dr["issuedByName"].ToString();
main.issuedTime = DateTime.Parse(dr["issuedTime"].ToString());
main.taskStatus = int.Parse(dr["taskStatus"].ToString());
main.taskStatusName = dr["taskStatusName"].ToString();
if (dr["finishTime"].ToString() != "")
{
main.finishTime = Convert.ToDateTime(dr["finishTime"].ToString());
}
main.isCancel = int.Parse(dr["isCancel"].ToString());
list.Add(main);
}
dr.Close();
con.Close();
DataSource ds = new DataSource();
ds.taskmainlist = list.Skip(skip).Take(5).ToList();
ds.datacount = list.Count();
string jsonstr = JsonConvert.SerializeObject(ds);
return(Content(jsonstr));
}
//添加消缺任务
public ActionResult AddSolveData()
{
string taskcode = Request.Params["taskcode"];
string taskname = Request.Params["taskname"];
int worktype = int.Parse(Request.Params["worktype"]);
int taskmanagercode = int.Parse(Request.Params["taskmanagercode"]);
DateTime issuedtime = Convert.ToDateTime(Request.Params["issuedtime"]);
string taskdesc = Request.Params["taskdesc"];
string remark = Request.Params["remark"];
string inspectlist = Request.Params["inspectlist"];
string solvetorsid = "";
//查询工作单据信息
var workdoc = (from a in medb.ps_systemconfig
where a.configCode == "DOC_TYPE" && a.configValueId == worktype
select a).FirstOrDefault();
//查询任务负责人信息
var taskmanager = (from a in medb.ps_user
where a.id == taskmanagercode && a.userStatus == 1
select a).FirstOrDefault();
var issued = (from a in medb.ps_user
where a.id == int.Parse(Session["userid"].ToString())
select a).FirstOrDefault();
bool b = true;
if (Request.Params["solvetorsid"] != "")
{
solvetorsid = Request.Params["solvetorsid"];
//首先向消缺主表中插入数据
ps_solvetask_main main = new ps_solvetask_main()
{
solveTaskCode = taskcode,
solveTaskName = taskname,
workDocType = workdoc.configValueId,
workDocTypeName = workdoc.configValueName,
taskDesc = taskdesc,
taskManagerCode = taskmanager.userCode,
taskManagerName = taskmanager.userName,
taskStatus = 2,
taskStatusName = "已分配",
finishTime = null,
common = remark,
managerSuggestion = null,
taskFinishDesc = null,
taskFinishReport = null,
taskNotes = null,
issuedByCode = issued.userCode,
issuedByName = issued.userName,
issuedTime = issuedtime,
issuedSuggestion = null,
createdBy = issued.userName,
creationTime = DateTime.Now,
lastUpdateTime = DateTime.Now,
isCancel = 0,
isrejectexamine = 0
};
//添加数据
medb.ps_solvetask_main.InsertOnSubmit(main);
try
{
medb.SubmitChanges();
}
catch (Exception)
{
b = false;
}
if (b)
{
//首先查询出消缺主表中最大的一条编号 即刚刚插入的数据编号
var tasks = (from a in medb.ps_solvetask_main
orderby a.id descending
select a).FirstOrDefault();
List <ps_solvetask_detail> tasklist = new List <ps_solvetask_detail>();
if (inspectlist.IndexOf(',') >= 0)
{
//再向消缺子表中插入数据
string[] solvetoridlist = inspectlist.Split(',');
for (var i = 0; i < solvetoridlist.Length; i++)
{
ps_solvetask_detail taskdetail = new ps_solvetask_detail()
{
taskId = tasks.id,
inspectionTaskDelId = int.Parse(solvetoridlist[i]),
createdBy = issued.userName,
creationTime = DateTime.Now,
lastUpdateTime = DateTime.Now
};
tasklist.Add(taskdetail);
}
}
else
{
ps_solvetask_detail taskdetail = new ps_solvetask_detail()
{
taskId = tasks.id,
inspectionTaskDelId = int.Parse(inspectlist),
createdBy = issued.userName,
creationTime = DateTime.Now,
lastUpdateTime = DateTime.Now
};
tasklist.Add(taskdetail);
}
//添加数据
medb.ps_solvetask_detail.InsertAllOnSubmit(tasklist);
try
{
medb.SubmitChanges();
}
catch (Exception)
{
b = false;
}
if (b)
{
List <ps_solver_detail> solvers = new List <ps_solver_detail>();
//最后向消缺员信息表中插入消缺员信息
if (solvetorsid.IndexOf(',') >= 0)
{
//则进行分割
string[] solvelist = solvetorsid.Split(',');
for (var i = 0; i < solvelist.Length; i++)
{
//根据消缺员id查询出对应的消缺员
var users = (from u in medb.ps_user
where u.id == int.Parse(solvelist[i])
select u).FirstOrDefault();
ps_solver_detail solver = new ps_solver_detail()
{
taskId = tasks.id,
solverCode = users.userCode,
solverName = users.userName,
createdBy = issued.userCode,
lastUpdateTime = DateTime.Now
};
solvers.Add(solver);
}
}
else
{
//根据消缺员id查询出对应的消缺员
var users = (from u in medb.ps_user
where u.id == int.Parse(solvetorsid)
select u).FirstOrDefault();
ps_solver_detail solver = new ps_solver_detail()
{
taskId = tasks.id,
solverCode = users.userCode,
solverName = users.userName,
createdBy = issued.userCode,
lastUpdateTime = DateTime.Now
};
solvers.Add(solver);
}
medb.ps_solver_detail.InsertAllOnSubmit(solvers);
try
{
medb.SubmitChanges();
}
catch (Exception)
{
b = false;
}
}
}
}
else
{
//首先向消缺主表中插入数据
ps_solvetask_main main = new ps_solvetask_main()
{
solveTaskCode = taskcode,
solveTaskName = taskname,
workDocType = workdoc.configValueId,
workDocTypeName = workdoc.configValueName,
taskDesc = taskdesc,
taskManagerCode = taskmanager.userCode,
taskManagerName = taskmanager.userName,
taskStatus = 1,
taskStatusName = "未分配",
finishTime = null,
common = remark,
managerSuggestion = null,
taskFinishDesc = null,
taskFinishReport = null,
taskNotes = null,
issuedByCode = issued.userCode,
issuedByName = issued.userName,
issuedTime = issuedtime,
issuedSuggestion = null,
createdBy = issued.userName,
creationTime = DateTime.Now,
lastUpdateTime = DateTime.Now,
isCancel = 0,
isrejectexamine = 0
};
//添加数据
medb.ps_solvetask_main.InsertOnSubmit(main);
try
{
medb.SubmitChanges();
}
catch (Exception)
{
b = false;
}
if (b)
{
//首先查询出消缺主表中最大的一条编号 即刚刚插入的数据编号
var tasks = (from a in medb.ps_solvetask_main
orderby a.id descending
select a).FirstOrDefault();
List <ps_solvetask_detail> tasklist = new List <ps_solvetask_detail>();
if (inspectlist.IndexOf(',') >= 0)
{
//再向消缺子表中插入数据
string[] solvetoridlist = inspectlist.Split(',');
for (var i = 0; i < solvetoridlist.Length; i++)
{
ps_solvetask_detail taskdetail = new ps_solvetask_detail()
{
taskId = tasks.id,
inspectionTaskDelId = int.Parse(solvetoridlist[i]),
createdBy = issued.userName,
creationTime = DateTime.Now,
lastUpdateTime = DateTime.Now
};
tasklist.Add(taskdetail);
}
}
else
{
ps_solvetask_detail taskdetail = new ps_solvetask_detail()
{
taskId = tasks.id,
inspectionTaskDelId = int.Parse(inspectlist),
createdBy = issued.userName,
creationTime = DateTime.Now,
lastUpdateTime = DateTime.Now
};
tasklist.Add(taskdetail);
}
//添加数据
medb.ps_solvetask_detail.InsertAllOnSubmit(tasklist);
try
{
medb.SubmitChanges();
}
catch (Exception)
{
b = false;
}
}
}
return(Json(b));
}
