public List <search_history_data> search_history(string select, int page, int pageLength)
{
int page_size = 10000; //一次ajax讀取多少筆資料
string getDataSizeSqlCmd = "";
string getDataSqlCmd = "";
if (select == "1")
{
getDataSizeSqlCmd = "SELECT COUNT(ROWNUM) FROM ROBOT_INFOS";
getDataSqlCmd = "SELECT* FROM (SELECT A.*, ROWNUM RN FROM(SELECT * FROM ROBOT_INFOS ORDER BY ROWNUM) A ) WHERE RN BETWEEN ";
}
else if (select == "2")
{
getDataSizeSqlCmd = "SELECT COUNT(ROWNUM)FROM ROBOT_RPM_INFOS_HISTORY";
getDataSqlCmd = "SELECT* FROM (SELECT A.*, ROWNUM RN FROM(SELECT * FROM ROBOT_RPM_INFOS_HISTORY ORDER BY ROWNUM) A ) WHERE RN BETWEEN ";
}
else if (select == "3")
{
getDataSizeSqlCmd = "SELECT * FROM ROBOT_TORQUE_INFOS_HISTORY";
}
else if (select == "4")
{
getDataSizeSqlCmd = "SELECT * FROM ROBOT_TEMPATURE_INFOS_HISTORY";
}
List <search_history_data> sch_data_list = new List <search_history_data>();
// string s = "User Id=foxlinkrobot;Password=foxlink;Data Source=192.168.60.37:1521/robot"; //Data Source格式:IP/SID
connect_sql connect1 = new connect_sql();
sch_data_list.Clear();
connect1.get_HistoryData("foxlinkrobot", "foxlink", "192.168.60.37:1521/robot", getDataSizeSqlCmd, getDataSqlCmd, select, page, page_size, pageLength, sch_data_list);
/////////////////////////LinQ//////////////////////////
//var r = from lt in sch_list where Convert.ToInt64(lt.j1_rpm) > 0 && Convert.ToInt64(lt.j2_rpm) > 0 orderby lt.j1_rpm select lt;
// var r = from lt in sch_list orderby lt.j1_rpm select lt;
// return r.ToList<search_history_data_buf>();
return(sch_data_list);
}
public List <online_datas> online_data(string select, int page, int pageLength)
{
int page_size = 10000; //一次ajax讀取多少筆資料
string getDataSizeSqlCmd = "";
string getDataSqlCmd = "";
getDataSizeSqlCmd = "SELECT COUNT(ROWNUM) FROM ROBOT_INFOS";
getDataSqlCmd = "SELECT* FROM (SELECT A.*, ROWNUM RN FROM(SELECT * FROM ROBOT_INFOS ORDER BY ROWNUM) A ) WHERE RN BETWEEN ";
List <search_history_data> list1 = new List <search_history_data>();
// string s = "User Id=foxlinkrobot;Password=foxlink;Data Source=192.168.60.37:1521/robot"; //Data Source格式:IP/SID
connect_sql connect1 = new connect_sql();
list1.Clear();
list1 = connect1.get_HistoryData("foxlinkrobot", "foxlink", "192.168.60.37:1521/robot", getDataSizeSqlCmd, getDataSqlCmd, "1", page, page_size, pageLength, list1);
/////////////////////////LinQ//////////////////////////
// var r = from lt in sch_list orderby lt.j1_rpm select lt;
List <online_datas> list_online = new List <online_datas>();
if (select == "1") //依BG顯示手臂數量
{
var r1 = from lt in list1
// where Convert.ToInt64(lt.j1_rpm) > 0 && Convert.ToInt64(lt.j2_rpm) > 0
group lt by lt.bg_code into _lt
select new
{
bg = _lt.Key,
qty = _lt.Count()
};
foreach (var l in r1)
{
list_online.Add(new online_datas
{
_bg = l.bg,
_bg_qty = l.qty.ToString(),
});
}
}
else if (select == "2") //依廠區顯示手臂數量
{
var r1 = from lt in list1
// where Convert.ToInt64(lt.j1_rpm) > 0 && Convert.ToInt64(lt.j2_rpm) > 0
group lt by lt.factory_locate into _lt
select new
{
factory_locate = _lt.Key,
qty = _lt.Count()
};
foreach (var l in r1)
{
list_online.Add(new online_datas
{
_factory_locate = l.factory_locate,
_factory_locate_qty = l.qty.ToString(),
});
}
}
else if (select == "3") //依產品顯示手臂數量
{
var r1 = from lt in list1
// where Convert.ToInt64(lt.j1_rpm) > 0 && Convert.ToInt64(lt.j2_rpm) > 0
group lt by lt.product into _lt
select new
{
product = _lt.Key,
qty = _lt.Count()
};
foreach (var l in r1)
{
list_online.Add(new online_datas
{
_product = l.product,
_product_qty = l.qty.ToString(),
});
}
}
else if (select == "4") //依廠區樓層顯示手臂數量
{
var r1 = from lt in list1
// where Convert.ToInt64(lt.j1_rpm) > 0 && Convert.ToInt64(lt.j2_rpm) > 0
group lt by new { lt.factory_locate, lt.floor } into _lt
select new
{
factory_locate_floor = _lt.Key.factory_locate + "/" + _lt.Key.floor + "樓",
qty = _lt.Count()
};
foreach (var l in r1)
{
list_online.Add(new online_datas
{
_factory_locate_floor = l.factory_locate_floor,
_factory_locate_floor_qty = l.qty.ToString()
});
}
}
///// return r.ToList<search_history_data_buf>();
return(list_online);
}