public ActionResult upd1()
{
int lineid = int.Parse(Request.Params["lineid"]);
int isStart = int.Parse(Request.Params["isStart"]);
int uid = int.Parse(Session["userid"].ToString());
bool b = true;
MyElectrCheck_DBDataContext mdc = new MyElectrCheck_DBDataContext();
ps_line_info result = (from l in mdc.ps_line_info
where l.id == lineid
select l).FirstOrDefault();
var user = (from u in mdc.ps_user
where u.id == uid
select u).FirstOrDefault();
//修改数据
result.isStart = isStart;
result.lastUpdateTime = DateTime.Now;
result.createdBy = user.userCode;
try
{
//保存修改
mdc.SubmitChanges();
}
catch (Exception)
{
b = false;
}
return(Json(b));
}
public ActionResult Addline()
{
bool b = false;
string lineCode = Request.Params["lineCode"];
string lineName = Request.Params["lineName"];
int lineLength = int.Parse(Request.Params["lineLength"]);
int backLength = int.Parse(Request.Params["backLength"]);
DateTime productDate = Convert.ToDateTime(Request.Params["productDate"]);
string voltageLevel = Request.Params["voltageLevel"];
string common = Request.Params["common"];
int towerBaseNum = int.Parse(Request.Params["towerBaseNum"]);
string startPoleCode = Request.Params["startPoleCode"];
string endPoleCode = Request.Params["endPoleCode"];
int isStart = int.Parse(Request.Params["isStart"]);
int status = int.Parse(Request.Params["status"]);
var count1 = medc.ps_line_info.Count();
int uid = int.Parse(Session["userid"].ToString());
int pid = int.Parse(Session["pid"].ToString());
int pid2 = int.Parse(Session["pid2"].ToString());
var user = (from u in medc.ps_user
where u.id == uid
select u).FirstOrDefault();
var sys = (from s in medc.ps_systemconfig
where s.configName == "运行状态" && s.configValueId == status
select s).FirstOrDefault();
ps_line_info lines = new ps_line_info();
ps_line_info line = new ps_line_info()
{
lineCode = lineCode,
lineName = lineName,
lineLength = lineLength,
backLength = backLength,
productDate = productDate,
voltageLevel = voltageLevel,
startPoleCode = startPoleCode,
endPoleCode = endPoleCode,
towerBaseNum = towerBaseNum,
common = common,
startPole = pid,
createdBy = user.userCode,
isStart = isStart,
runningStatus = status,
endPole = pid2,
runningStatusName = sys.configValueName,
creationTime = DateTime.Now,
lastUpdateTime = DateTime.Now
};
medc.ps_line_info.InsertOnSubmit(line);
medc.SubmitChanges();
var count2 = medc.ps_line_info.Count();
if (count2 > count1)
{
b = true;
}
return(Json(b));
}
public ActionResult GetlineCodes()
{
//首先查询巡检员子表中状态不等于完成的所有巡检员的信息
var inspectors = (from a in medc.ps_inspector_detail
join b in medc.ps_inspectiontask_main
on a.taskId equals b.id
where b.taskStatus != 4
select a).ToList();
List <ps_user> list = new List <ps_user>();
string sql = " select *from ps_user where 1=1 and roleid=(select id from ps_role where rolename='巡检员' and isstart=1) and userstatus=1";
for (var i = 0; i < inspectors.Count(); i++)
{
sql += " and usercode!='" + inspectors[i].inspectorCode + "'";
}
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();
while (dr.Read())
{
ps_user u = new ps_user()
{
id = int.Parse(dr["id"].ToString()),
userCode = dr["userCode"].ToString(),
userName = dr["userName"].ToString()
};
list.Add(u);
}
dr.Close();
//首先查询出巡检任务为完成的巡检任务信息
var ins = (from i in medc.ps_inspectiontask_main
where i.taskStatus != 4
select i).ToList();
sql = "select *from ps_line_info where 1=1 and isStart=1 ";
if (ins.Count() > 0)
{
foreach (var v in ins)
{
sql += " and id!=" + v.lineId + " ";
}
}
List <ps_line_info> linelist = new List <ps_line_info>();
SqlCommand cmd2 = new SqlCommand(sql, con);
dr = cmd2.ExecuteReader();
while (dr.Read())
{
ps_line_info lines = new ps_line_info()
{
id = int.Parse(dr["id"].ToString()),
lineCode = dr["lineCode"].ToString(),
lineName = dr["lineName"].ToString(),
startPole = int.Parse(dr["startPole"].ToString()),
endPole = int.Parse(dr["endPole"].ToString()),
startPoleCode = dr["startPoleCode"].ToString(),
endPoleCode = dr["endPoleCode"].ToString()
};
linelist.Add(lines);
}
dr.Close();
con.Close();
DataSource ds = new DataSource();
ds.pslist = list;
if (linelist.Count() > 0)
{
ds.lilist = linelist;
}
return(Json(ds));
}
