/// <summary>
/// 保养监视数量
/// </summary>
/// <returns></returns>
public static string getBYCount()
{
string result = "0";
string sql = @" select count(1) from MoJu_LY a
join MoJu_BY_APP app on a.ly_no=app.ly_no
join MoJu_Down_Apply ap on a.ly_no=ap.ly_no
left join MoJu_BY on MoJu_BY.by_no=app.by_no
where ([state]='保养完成' and act_date is not null and app.zg_confirm='Y' and app.zg_confirm_date is null)
or state in('待保养','保养中') " ;
Maticsoft.DBUtility.DbHelperSQLP helper = new Maticsoft.DBUtility.DbHelperSQLP(connReport);
result = helper.GetSingle(sql).ToString();
//string appp_ng = re_dt.Rows[0]["app_ng"].ToString();
//string result = "[{\"appp_ng\":\"" + appp_ng + "\"}]";
return(result);
}
/// <summary>
/// 上模监视数量
/// </summary>
/// <returns></returns>
public static string getSMCount()
{
string result = "0";
string sql = @"select sum(cnt) from (
select count(1)cnt from MoJu_ly where state in('待出库','待上模','待下模')
union all
select COUNT(1) from MoJu_LY a join MoJu b on a.moju_id=b.id
join MoJu_Down_apply ap on a.ly_no=ap.ly_no
join MoJu_Down down on a.ly_no=down.ly_no
where ap.mojian_check='末件要检测' and down.mojian_date is null )t " ;
Maticsoft.DBUtility.DbHelperSQLP helper = new Maticsoft.DBUtility.DbHelperSQLP(connReport);
result = helper.GetSingle(sql).ToString();
//string appp_ng = re_dt.Rows[0]["app_ng"].ToString();
//string result = "[{\"appp_ng\":\"" + appp_ng + "\"}]";
return(result);
}