public void ShowData()
{
this.ReportViewer1.Reset();
this.ReportViewer1.LocalReport.Dispose();
this.ReportViewer1.LocalReport.DataSources.Clear();
Microsoft.Reporting.WebForms.ReportDataSource reportdatsource = new Microsoft.Reporting.WebForms.ReportDataSource();
reportdatsource.Name = "SolveRpt";
List <DataEliminate> list = new List <DataEliminate>();
List <DataEliminate> dmlist = new List <DataEliminate>();
if (Session["solvelist"] != null)
{
//将session转为集合
list = (List <DataEliminate>)Session["solvelist"];
foreach (var v in list)
{
DataEliminate dmm = new DataEliminate();
dmm.solveTaskCode = v.solveTaskCode;
dmm.solveTaskName = v.solveTaskName;
dmm.lineCode = v.lineCode;
dmm.poleCode = v.poleCode;
dmm.startPoleCode = v.startPoleCode;
dmm.endPoleCode = v.endPoleCode;
dmm.bugLevelName = v.bugLevelName;
dmm.bugTypeName = v.bugTypeName;
if (v.isBug == 1)
{
dmm.BugName = "有";
}
else
{
dmm.BugName = "无";
}
dmm.finishTime2 = v.finishTime.ToString();
dmm.discoverTime2 = v.discoverTime.ToString();
dmm.bugDesc = v.bugDesc;
dmlist.Add(dmm);
}
}
reportdatsource.Value = dmlist;
this.ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Models/SolveReport.rdlc");
this.ReportViewer1.LocalReport.DataSources.Add(reportdatsource);
this.ReportViewer1.LocalReport.Refresh();
}
public ActionResult EliminateCountData()
{
var results = (from r in md.ps_solvetask_main
join i in md.ps_solvetask_detail
on r.id equals i.taskId
join p in md.ps_inspectiontask_detail
on i.inspectionTaskDelId equals p.id
join d in md.ps_inspectiontask_main
on p.taskid equals d.id
where r.taskStatus == 5 && r.isCancel == 0
select new { id = r.id, solveTaskCode = r.solveTaskCode, solveTaskName = r.solveTaskName, lineCode = p.lineCode, startPoleCode = d.startPoleCode, endPoleCode = d.endPoleCode, poleCode = p.poleCode, isBug = p.isBug, bugLevel = p.bugLevelName, bugType = p.bugTypeName, issuedTime = r.issuedTime, discoverTime = p.discoverTime, bugDesc = p.bugDesc });
List <DataEliminate> delist = new List <DataEliminate>();
if (results.Count() > 0)
{
foreach (var f in results)
{
DataEliminate de = new DataEliminate()
{
id = f.id,
solveTaskCode = f.solveTaskCode,
solveTaskName = f.solveTaskName,
lineCode = f.lineCode,
startPoleCode = f.startPoleCode,
endPoleCode = f.endPoleCode,
poleCode = f.poleCode,
isBug = f.isBug,
bugLevelName = f.bugLevel,
bugTypeName = f.bugType,
issuedTime = f.issuedTime,
discoverTime = f.discoverTime,
bugDesc = f.bugDesc
};
delist.Add(de);
}
}
int pageindex = int.Parse(Request.Params["pageindex"].ToString());
int skip = (pageindex - 1) * 6;
DataCount dc = new DataCount();
if (delist.Count() > 0)
{
dc.plist = delist.Skip(skip).Take(6).ToList();
dc.PageCount = delist.Count();
Session["solvelist"] = dc.plist;
}
string strs = JsonConvert.SerializeObject(dc);
return(Content(strs));
}
public ActionResult SelectBtn()
{
string sovercode = "";
string sovername = "";
string isbug = "";
string time1 = "";
string time2 = "";
int pageindex = int.Parse(Request.Params["pageindex"]);
SqlConnection con = new SqlConnection("server=.;database=MyElectrCheck_DB;Integrated Security=true;");
if (con.State != ConnectionState.Open)
{
con.Open();
}
string sql = "select a.id,a.solveTaskCode,a.solveTaskName,b.lineCode,b.startPoleCode,b.endPoleCode,c.poleCode,c.isBug,c.bugLevelName,c.bugTypeName,a.issuedTime,c.discoverTime,c.bugDesc from ps_solvetask_main a inner join ps_inspectiontask_main b on a.id=b.id inner join ps_inspectiontask_detail c on b.id=c.taskid where 1=1 and a.taskstatus=5 and a.iscancel=0 ";
if (Request.Params["sovercode"] != "")
{
sovercode = Request.Params["sovercode"];
sql += " and a.solveTaskCode like '%" + sovercode + "%'";
}
if (Request.Params["sovername"] != "")
{
sovername = Request.Params["sovername"];
sql += "and b.lineCode like '%" + sovername + "%'";
}
if (Request.Params["isbug"] != "")
{
isbug = Request.Params["isbug"];
sql += "and c.isBug =" + isbug + "";
}
if (Request.Params["time1"] != "")
{
time1 = Request.Params["time1"];
sql += "and c.discoverTime >= '" + time1 + "' ";
}
if (Request.Params["time2"] != "")
{
time2 = Request.Params["time2"];
sql += "and c.discoverTime <= '" + time2 + "' ";
}
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
List <DataEliminate> list = new List <DataEliminate>();
while (dr.Read())
{
DataEliminate del = new DataEliminate()
{
id = int.Parse(dr["id"].ToString()),
solveTaskCode = dr["solveTaskCode"].ToString(),
solveTaskName = dr["solveTaskName"].ToString(),
lineCode = dr["lineCode"].ToString(),
startPoleCode = dr["startPoleCode"].ToString(),
endPoleCode = dr["endPoleCode"].ToString(),
poleCode = dr["poleCode"].ToString(),
isBug = int.Parse(dr["isBug"].ToString()),
bugLevelName = dr["bugLevelName"].ToString(),
bugTypeName = dr["bugTypeName"].ToString(),
issuedTime = DateTime.Parse(dr["issuedTime"].ToString()),
discoverTime = DateTime.Parse(dr["discoverTime"].ToString()),
bugDesc = dr["bugDesc"].ToString()
};
list.Add(del);
}
dr.Close();
con.Close();
int skip = (pageindex - 1) * 6;
DataCount ds = new DataCount();
ds.plist = list.Skip(skip).Take(6).ToList();
ds.PageCount = list.Count();
Session["solvelist"] = ds.plist;
string strs = JsonConvert.SerializeObject(ds);;
return(Content(strs));
}