private String machinesummarypop(string proc, string testcode)
{
BLL_Machine BLL = new BLL_Machine();
testcode = GetSelectTree(testcode, SelectedTestRoomCodes);
DataTable dt = BLL.GetProcDataTableChartsPara5(proc, StartDate, DateTime.Parse(EndDate).AddDays(1).ToString("yyyy-MM-dd"), testcode, 1);
if (dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["testname"].ToString();
trcs.IntNumber = Int32.Parse(dr["ncount"].ToString());
trcs.Para1 = dr["companycode"].ToString();
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
/// <summary>
/// 设备情况
/// </summary>
/// <returns></returns>
public DataTable SBQK()
{
string sqlwhere = string.Empty;
if (!String.IsNullOrEmpty(SelectedTestRoomCodes))
{
sqlwhere += " and 试验室编码 in (" + SelectedTestRoomCodes + ") ";
}
else
{
sqlwhere += "and 1=0";
}
BLL_Machine BLL = new BLL_Machine();
DataTable dt = BLL.GetDataTablePager("v_bs_machineSummary", "*", sqlwhere, "id", "OrderID", "asc", 1, 100000, out pageCount, out records);
dt.Columns.Remove("rowNum");
dt.Columns.Remove("ID");
dt.Columns.Remove("试验室编码");
dt.Columns.Remove("单位编码");
dt.Columns.Remove("标段编码");
dt.Columns.Remove("备注");
dt.Columns.Remove("OrderID");
dt.Columns.Remove("购置日期");
dt.Columns["标段名称"].SetOrdinal(0);
dt.Columns["单位名称"].SetOrdinal(1);
return(dt);
}
private String machinesummary(String name, String fileds, String sqlwhere, String key, int ftype, out int pageCount, out int records)
{
if (!"NUM".RequestStr().IsNullOrEmpty())
{
sqlwhere += " and 试验室编码 in ('" + "NUM".RequestStr() + "') ";
}
else if (!String.IsNullOrEmpty(SelectedTestRoomCodes))
{
sqlwhere += " and 试验室编码 in (" + SelectedTestRoomCodes + ") ";
}
else
{
sqlwhere += "and 1=0";
}
switch ("meet".RequestStr())
{
case "1":
sqlwhere += " AND 预计下次校验日期 < '" + DateTime.Now.AddDays(1).AddSeconds(-1).ToString() + "' ";
break;
case "2":
sqlwhere += " AND 预计下次校验日期 > '" + DateTime.Now.AddDays(1).AddSeconds(-1).ToString() + "' ";
break;
}
#region For首页
if (!string.IsNullOrEmpty("RPNAME".RequestStr()))
{
switch ("RPNAME".RequestStr())
{
case "1": //待标定数
sqlwhere += " AND 预计下次校验日期 between '" + StartDate + "' and '" + EndDate + "' ";
break;
}
}
#endregion
BLL_Machine BLL = new BLL_Machine();
DataTable dt = BLL.GetDataTablePager(name, fileds, sqlwhere, key, "OrderID", "asc", PageIndex, PageSize, out pageCount, out records);
if (dt != null)
{
return(JsonConvert.SerializeObject(dt));
}
else
{
return("");
}
}
/// <summary>
/// 设备情况
/// </summary>
/// <returns></returns>
public DataTable SBQKWITHIMG()
{
string sqlwhere = string.Empty;
if (!String.IsNullOrEmpty(SelectedTestRoomCodes))
{
sqlwhere += " and testroomcode in (" + SelectedTestRoomCodes + ") ";
}
string Sql = @"
select
id,
t1.description as '标段名称',
t2.description as '单位名称',
t3.description as '试验室名称',
Ext2 as '管理编号',
Ext1 as '设备名称',
Ext3 as '生产厂家',
Ext4 as '规格型号',
Ext9 as '数量',
Ext11 as '检定情况',
Ext12 as '检定证书编号',
Ext13 as '上次校验日期',
Ext14 as '预计下次校验日期',
Ext15 as '检定周期'
from sys_document
join Sys_Tree t1 on t1.NodeCode = sys_document.SegmentCode
join Sys_Tree t2 on t2.NodeCode = sys_document.CompanyCode
join Sys_Tree t3 on t3.NodeCode = sys_document.TestRoomCode
WHERE ModuleID in('A0C51954-302D-43C6-931E-0BAE2B8B10DB')
{0}
Order By t1.OrderID asc
";
Sql = string.Format(Sql, sqlwhere);
BLL_Machine BLL = new BLL_Machine();
DataTable dt = BLL.GetDataTable(Sql);
dt.Columns["标段名称"].SetOrdinal(0);
dt.Columns["单位名称"].SetOrdinal(1);
return(dt);
}
public void Chart()
{
string Sql = @"
select
t1.Description as sg ,
t2.Description,
t2.nodecode as Para1,
COUNT(b1.ID) as IntNumber,
Sum(case when b1.Ext22<'{0}' then 1 else 0 end) as OIntNumber
from sys_tree t1
left outer join sys_tree t2 on left(t2.nodecode,8)=t1.nodecode AND len(t2.nodecode)=12
left outer join sys_document b1 on t2.nodecode= b1.CompanyCode AND b1.TestRoomCode IN ({1})
AND b1.ModuleID in('A0C51954-302D-43C6-931E-0BAE2B8B10DB')
where len(t1.nodecode)=8 AND b1.Status>0
group by t1.OrderID,t2.Description,t1.Description, t2.nodecode
order by t1.OrderID asc
";
BLL_Machine BLL = new BLL_Machine();
DataTable Dt = BLL.GetDataTable(string.Format(Sql, DateTime.Now.AddDays(1).AddSeconds(-1).ToString(), SelectedTestRoomCodes));
if (Dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in Dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["sg"].ToString() + "\n" + dr["Description"].ToString();
trcs.IntNumber = Int32.Parse(dr["IntNumber"].ToString());
trcs.Para1 = dr["Para1"].ToString();
trcs.IntNumberMarks = Int32.Parse(dr["OIntNumber"].ToString());
list.Add(trcs);
}
Response.Write(JsonConvert.SerializeObject(list));
}
else
{
Response.Write("");
}
Response.End();
}
private String machinesummary(string proc, int ntype)
{
string Sql = @"
select
t1.Description as sg , t2.Description, t2.nodecode as Para1,
COUNT(b1.ID) as IntNumber,
Sum(case when b1.预计下次校验日期<'{0}' then 1 else 0 end)
as OIntNumber
from sys_tree t1
left outer join sys_tree t2 on left(t2.nodecode,8)=t1.nodecode AND len(t2.nodecode)=12
left outer join v_bs_machineSummary b1 on t2.nodecode= b1.单位编码 AND b1.试验室编码 IN (" + SelectedTestRoomCodes + ") where len(t1.nodecode)=8 group by b1.标段编码,t2.Description,t1.Description, t2.nodecode order by b1.标段编码 asc ";
BLL_Machine BLL = new BLL_Machine();
DataTable Dt = BLL.GetDataTable(string.Format(Sql, DateTime.Now.AddDays(1).AddSeconds(-1).ToString()));
if (Dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in Dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["sg"].ToString() + "\n" + dr["Description"].ToString();
trcs.IntNumber = Int32.Parse(dr["IntNumber"].ToString());
trcs.Para1 = dr["Para1"].ToString();
trcs.IntNumberMarks = Int32.Parse(dr["OIntNumber"].ToString());
list.Add(trcs);
}
return(JsonConvert.SerializeObject(list));
}
else
{
return("");
}
}
public void Chart()
{
string Sql = @"
select count(b1.id) as IntNumber ,b1.testroomcode ,t1.description as Description
from sys_document b1
left outer join sys_tree t1 on t1.nodecode = b1.testroomcode
where b1.Status>0 and b1.CompanyCode IN ('{0}')
AND b1.ModuleID in('A0C51954-302D-43C6-931E-0BAE2B8B10DB')
group by b1.testroomcode,t1.description
";
BLL_Machine BLL = new BLL_Machine();
DataTable Dt = BLL.GetDataTable(string.Format(Sql, "sTestcode".RequestStr()));
if (Dt != null)
{
List <ChartModel> list = new List <ChartModel>();
foreach (DataRow dr in Dt.Rows)
{
ChartModel trcs = new ChartModel();
trcs.Description = dr["Description"].ToString();
trcs.IntNumber = Int32.Parse(dr["IntNumber"].ToString());
trcs.Para1 = dr["testroomcode"].ToString();
list.Add(trcs);
}
Response.Write(JsonConvert.SerializeObject(list));
}
else
{
Response.Write("");
}
Response.End();
}
