public ActionResult SelectData()
{
string taskcode = "";
string linecode = "";
string taskstatus = "";
string createuser = "";
string time1 = "";
string time2 = "";
int pageindex = int.Parse(Request.Params["pageindex"]);
int skip = (pageindex - 1) * 6;
string sql = "select *from [ps_inspectiontask_main] where isCancel=0 and 1=1 ";
if (Request.Params["taskcode"] != "")
{
taskcode = Request.Params["taskcode"];
sql += " and inspectionTaskCode like '%" + taskcode + "%' ";
}
if (Request.Params["linecode"] != "")
{
linecode = Request.Params["linecode"];
sql += " and lineCode like '%" + linecode + "%' ";
}
if (Request.Params["taskstatus"] != "")
{
taskstatus = Request.Params["taskstatus"];
sql += " and taskStatusName='" + taskstatus + "' ";
}
if (Request.Params["createby"] != "")
{
createuser = Request.Params["createby"];
sql += "and issuedByName like '%" + createuser + "%'";
}
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_inspectiontask_main> list = new List <ps_inspectiontask_main>();
while (dr.Read())
{
ps_inspectiontask_main main = new ps_inspectiontask_main();
main.id = int.Parse(dr["id"].ToString());
main.inspectionTaskCode = dr["inspectionTaskCode"].ToString();
main.inspectionTaskName = dr["inspectionTaskName"].ToString();
main.lineCode = dr["lineCode"].ToString();
main.startPoleCode = dr["startPoleCode"].ToString();
main.endPoleCode = dr["endPoleCode"].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.imlist = list.Skip(skip).Take(6).ToList();
ds.pagecount = list.Count();
string jsonstr = JsonConvert.SerializeObject(ds);
return(Content(jsonstr));
}
public ActionResult AddTaskinfo()
{
string taskcode = Request.Params["taskcode"];
string taskname = Request.Params["taskname"];
int lineid = int.Parse(Request.Params["lineid"]);
string linecode = Request.Params["linecode"];
string linename = Request.Params["linename"];
int startpole = int.Parse(Request.Params["startpole"]);
int endpole = int.Parse(Request.Params["endpole"]);
string startpolecode = Request.Params["startpolecode"];
string endpolecode = Request.Params["endpolecode"];
string desc = Request.Params["desc"];
DateTime issuedtime = Convert.ToDateTime(Request.Params["issuedtime"]);
string inspecname = "";
string inspectorcode = "";
var user = (from u in medc.ps_user
where u.id == int.Parse(Session["userid"].ToString()) && u.userStatus == 1
select u).FirstOrDefault();
bool b = true;
if (Request.Params["inspecname"] != "" && Request.Params["inspectorcode"] != "")
{
inspectorcode = Request.Params["inspectorcode"];
inspecname = Request.Params["inspecname"];
ps_inspectiontask_main taskmain = new ps_inspectiontask_main();
taskmain.inspectionTaskCode = taskcode;
taskmain.inspectionTaskName = taskname;
taskmain.lineId = lineid;
taskmain.lineCode = linecode;
taskmain.lineName = linename;
taskmain.startPole = startpole;
taskmain.startPoleCode = startpolecode;
taskmain.endPole = endpole;
taskmain.endPoleCode = endpolecode;
taskmain.issuedByCode = user.userCode;
taskmain.issuedByName = user.userName;
taskmain.issuedTime = issuedtime;
taskmain.taskStatus = 2;
taskmain.taskStatusName = "已分配";
taskmain.finishTime = null;
taskmain.common = desc;
taskmain.createdBy = user.userCode;
taskmain.creationTime = DateTime.Now;
taskmain.lastUpdateTime = DateTime.Now;
taskmain.isCancel = 0;
medc.ps_inspectiontask_main.InsertOnSubmit(taskmain);
//保存添加
try
{
medc.SubmitChanges();
}
catch (Exception)
{
b = false;
}
if (b)
{
var tm = (from m in medc.ps_inspectiontask_main
orderby m.id descending
select m).FirstOrDefault();
List <ps_inspector_detail> ilist = new List <ps_inspector_detail>();
if (inspectorcode.IndexOf(',') > 0)
{
string[] strslist = inspectorcode.Split(',');
for (var i = 0; i < strslist.Length; i++)
{
var u = (from p in medc.ps_user
where p.userCode == strslist[i]
select p).FirstOrDefault();
ps_inspector_detail det = new ps_inspector_detail()
{
taskId = tm.id,
inspectorCode = strslist[i],
inspectorName = u.userName,
creationTime = DateTime.Now,
createdBy = user.userCode,
lastUpdateTime = DateTime.Now
};
ilist.Add(det);
}
}
else
{
ps_inspector_detail det = new ps_inspector_detail()
{
taskId = tm.id,
inspectorCode = inspectorcode,
inspectorName = inspecname,
creationTime = DateTime.Now,
createdBy = user.userCode,
lastUpdateTime = DateTime.Now
};
ilist.Add(det);
}
medc.ps_inspector_detail.InsertAllOnSubmit(ilist);
try
{
medc.SubmitChanges();
}
catch (Exception)
{
b = false;
}
}
}
else
{
//实例化对象将数据添加到该实例中
ps_inspectiontask_main taskmain = new ps_inspectiontask_main()
{
inspectionTaskCode = taskcode,
inspectionTaskName = taskname,
lineId = lineid,
lineCode = linecode,
lineName = linename,
startPole = startpole,
startPoleCode = startpolecode,
endPole = endpole,
endPoleCode = endpolecode,
issuedByCode = user.userCode,
issuedByName = user.userName,
issuedTime = issuedtime,
taskStatus = 1,
taskStatusName = "未分配",
finishTime = null,
common = desc,
creationTime = DateTime.Now,
createdBy = user.userCode,
lastUpdateTime = DateTime.Now,
isCancel = 0
};
medc.ps_inspectiontask_main.InsertOnSubmit(taskmain);
try
{
medc.SubmitChanges();
}
catch (Exception)
{
b = false;
}
}
if (b)
{
//首先查询出刚刚添加的任务的id
var taskmains = (from i in medc.ps_inspectiontask_main
orderby i.id descending
select i).FirstOrDefault();
//根据线路编号查询出所有的杆塔信息
var poles = (from p in medc.ps_pole_info
where p.lineId == lineid
select p).ToList();
List <ps_inspectiontask_detail> taskdetails = new List <ps_inspectiontask_detail>();
for (var i = 0; i < poles.Count(); i++)
{
ps_inspectiontask_detail dets = new ps_inspectiontask_detail()
{
taskid = taskmains.id,
poleid = poles[i].id,
poleCode = poles[i].poleCode,
lineCode = poles[i].lineCode,
lineName = poles[i].lineName,
isBug = 0,
intactRate = 100,
bugLevel = null,
bugLevelName = null,
bugType = null,
bugTypeName = null,
bugDesc = null,
discovererCode = user.userCode,
discovererName = user.userName,
discoverTime = DateTime.Now,
isSolve = 0,
inspectTime = null,
createdBy = user.userCode,
creationTime = DateTime.Now,
lastUpdateTime = DateTime.Now,
taskStatus = 1,
isBugLevel = 0
};
taskdetails.Add(dets);
}
//插入数据
medc.ps_inspectiontask_detail.InsertAllOnSubmit(taskdetails);
try
{
medc.SubmitChanges();
}
catch (Exception)
{
b = false;
}
}
return(Json(b));
}
