public List <DeviceRealState> readTRobDeviceRunState(string gis_numv, string mis_numv)
{
dtime = DateTime.Now;
wtime = DateTime.Now.AddHours(ReadParameter.WShiftOffsetHour);
DeviceRealState drs = null;
List <DeviceRealState> listDeviceRealState = new List <DeviceRealState>(5);
String strSql = "select vt.machine_id,vt.run_state,tmp.pic_name,tmp.pic_state,tmp.pic_path,tmp.rank_num,tmp.pheight,tmp.pwidth,tmp.ptop,tmp.pbottom,tmp.pleft,tmp.pright "
+ " from (select tri.machine_id,tri.run_state,row_number() over(partition by tri.machine_id order by tri.read_time desc) as row_ord "
+ " from tb_run_info tri,vw_machine_info vmi where 1=1 and tri.machine_id = vmi.machine_id "
+ " and vmi.is_program = 'Rob' "
+ " and mis_visual in (" + mis_numv + ") and gis_visual = '" + gis_numv + "' and tri.calc_date=" + wtime.ToString("yyyyMMdd") + ") vt, "
+ " tb_machine_rphoto tmp where vt.machine_id = tmp.machine_id and vt.run_state = tmp.pic_state "
+ " and tmp.pic_kinds = 'RunState' and vt.row_ord = 1 ";
listDeviceRealState.Clear();
dtInfo = getStrSqlTData("readDeviceRunState", strSql);
DataRow[] drRow = dtInfo.Select("1=1", "rank_num asc");
for (int i = 0; i < drRow.Length; i++)
{
drs = new DeviceRealState();
drs.machine_id = Convert.ToInt32(drRow[i]["machine_id"]);
drs.run_state = Convert.ToInt32(drRow[i]["run_state"]);
drs.pic_name = drRow[i]["pic_name"].ToString();
drs.pic_path = drRow[i]["pic_path"].ToString();
if (!Convert.IsDBNull(drRow[i]["pheight"]))
{
drs.pic_height = Convert.ToInt32(drRow[i]["pheight"]);
}
else
{
drs.pic_height = 0;
}
if (!Convert.IsDBNull(drRow[i]["pwidth"]))
{
drs.pic_width = Convert.ToInt32(drRow[i]["pwidth"]);
}
else
{
drs.pic_width = 0;
}
if (!Convert.IsDBNull(drRow[i]["ptop"]))
{
drs.pic_top = Convert.ToInt32(drRow[i]["ptop"]);
}
else
{
drs.pic_top = 0;
}
if (!Convert.IsDBNull(drRow[i]["pbottom"]))
{
drs.pic_bottom = Convert.ToInt32(drRow[i]["pbottom"]);
}
else
{
drs.pic_bottom = 0;
}
if (!Convert.IsDBNull(drRow[i]["pleft"]))
{
drs.pic_left = Convert.ToInt32(drRow[i]["pleft"]);
}
else
{
drs.pic_left = 0;
}
if (!Convert.IsDBNull(drRow[i]["pright"]))
{
drs.pic_right = Convert.ToInt32(drRow[i]["pright"]);
}
else
{
drs.pic_right = 0;
}
drs.rank_num = Convert.ToInt32(drRow[i]["rank_num"]);
listDeviceRealState.Add(drs);
}
return(listDeviceRealState);
}
public List <DeviceRealState> readDeviceRunState(int run_state, string gis_numv, string mis_numv)
{
DeviceRealState drs = null;
List <DeviceRealState> listDeviceRealState = new List <DeviceRealState>(5);
String strSql = "select vmi.machine_id,tmp.pic_state as run_state,tmp.pic_name,tmp.pic_state,tmp.pic_path,tmp.rank_num, "
+ " tmp.pheight,tmp.pwidth,tmp.ptop,tmp.pbottom,tmp.pleft,tmp.pright "
+ " from vw_machine_info vmi left join tb_machine_photo tmp on vmi.machine_id = tmp.machine_id "
+ " and tmp.pic_kinds = 'RunState' and tmp.pic_state = " + RunStateParam.StopState
+ " where 1=1 and (vmi.show_numv = 'M' or (vmi.show_numv = 'G' and vmi.is_main = 'YES')) "
+ " and mis_visual in (" + mis_numv + ") and gis_visual = '" + gis_numv + "'";
listDeviceRealState.Clear();
dtInfo = getStrSqlTData("readDeviceRunState", strSql);
DataRow[] drRow = dtInfo.Select("1=1", "rank_num asc");
for (int i = 0; i < drRow.Length; i++)
{
drs = new DeviceRealState();
drs.machine_id = Convert.ToInt32(drRow[i]["machine_id"]);
drs.run_state = Convert.ToInt32(drRow[i]["run_state"]);
drs.pic_name = drRow[i]["pic_name"].ToString();
drs.pic_path = drRow[i]["pic_path"].ToString();
if (!Convert.IsDBNull(drRow[i]["pheight"]))
{
drs.pic_height = Convert.ToInt32(drRow[i]["pheight"]);
}
else
{
drs.pic_height = 0;
}
if (!Convert.IsDBNull(drRow[i]["pwidth"]))
{
drs.pic_width = Convert.ToInt32(drRow[i]["pwidth"]);
}
else
{
drs.pic_width = 0;
}
if (!Convert.IsDBNull(drRow[i]["ptop"]))
{
drs.pic_top = Convert.ToInt32(drRow[i]["ptop"]);
}
else
{
drs.pic_top = 0;
}
if (!Convert.IsDBNull(drRow[i]["pbottom"]))
{
drs.pic_bottom = Convert.ToInt32(drRow[i]["pbottom"]);
}
else
{
drs.pic_bottom = 0;
}
if (!Convert.IsDBNull(drRow[i]["pleft"]))
{
drs.pic_left = Convert.ToInt32(drRow[i]["pleft"]);
}
else
{
drs.pic_left = 0;
}
if (!Convert.IsDBNull(drRow[i]["pright"]))
{
drs.pic_right = Convert.ToInt32(drRow[i]["pright"]);
}
else
{
drs.pic_right = 0;
}
drs.rank_num = Convert.ToInt32(drRow[i]["rank_num"]);
listDeviceRealState.Add(drs);
}
return(listDeviceRealState);
}
public List <DeviceRealState> readTDeviceRunState(string gis_numv, string mis_numv)
{
dtime = DateTime.Now;
wtime = DateTime.Now.AddHours(ReadParameter.WShiftOffsetHour);
DeviceRealState drs = null;
List <DeviceRealState> listDeviceRealState = new List <DeviceRealState>(5);
//String strSql = "select vt.machine_id,vt.run_state,tmp.pic_name,tmp.pic_state,tmp.pic_path,tmp.rank_num,tmp.pheight,tmp.pwidth,tmp.ptop,tmp.pbottom,tmp.pleft,tmp.pright "
// + " from (select tri.machine_id,tri.run_state,row_number() over(partition by tri.machine_id order by tri.read_time desc) as row_ord "
// + " from tb_run_info tri,vw_machine_info vmi where 1=1 and tri.machine_id = vmi.machine_id "
// + " and (vmi.show_numv = 'M' or (vmi.show_numv = 'G' and vmi.is_main = 'YES')) "
// + " and mis_visual in (" + mis_numv + ") and gis_visual = '" + gis_numv + "' and tri.calc_date=" + wtime.ToString("yyyyMMdd") + ") vt, "
// + " tb_machine_lphoto tmp where vt.machine_id = tmp.machine_id and vt.run_state = tmp.pic_state "
// + " and tmp.pic_kinds = 'RunState' and vt.row_ord = 1 ";
String strSql = "select machine_id from tb_machine_info where mis_visual = '" + gis_numv + "'";
listDeviceRealState.Clear();
dtInfo = getStrSqlTData("readDeviceRunState", strSql).Copy();
DataRow[] drRow = dtInfo.Select("1=1", "machine_id asc");
for (int i = 0; i < drRow.Length; i++)
{
drs = new DeviceRealState();
drs.machine_id = Convert.ToInt32(drRow[i]["machine_id"]);
//drs.run_state = Convert.ToInt32(drRow[i]["run_state"]);
//drs.pic_name = drRow[i]["pic_name"].ToString();
//drs.pic_path = drRow[i]["pic_path"].ToString();
JObject queryParam = new JObject();
queryParam.Add("machine_id", drs.machine_id);
RepositoryFactory BR = new RepositoryFactory();
var run_state = BR.BaseRepository("MongoDB").FindMGStateList <BsonDocument>("clc_run_state", queryParam);
drs.run_state = run_state["run_state"].AsInt32;
drs.pic_path = getPic_path(drs.machine_id, drs.run_state);
/*
* if (!Convert.IsDBNull(drRow[i]["pheight"]))
* {
* drs.pic_height = Convert.ToInt32(drRow[i]["pheight"]);
* }
* else
* {
* drs.pic_height = 0;
* }
* if (!Convert.IsDBNull(drRow[i]["pwidth"]))
* {
* drs.pic_width = Convert.ToInt32(drRow[i]["pwidth"]);
* }
* else
* {
* drs.pic_width = 0;
* }
* if (!Convert.IsDBNull(drRow[i]["ptop"]))
* {
* drs.pic_top = Convert.ToInt32(drRow[i]["ptop"]);
* }
* else
* {
* drs.pic_top = 0;
* }
* if (!Convert.IsDBNull(drRow[i]["pbottom"]))
* {
* drs.pic_bottom = Convert.ToInt32(drRow[i]["pbottom"]);
* }
* else
* {
* drs.pic_bottom = 0;
* }
* if (!Convert.IsDBNull(drRow[i]["pleft"]))
* {
* drs.pic_left = Convert.ToInt32(drRow[i]["pleft"]);
* }
* else
* {
* drs.pic_left = 0;
* }
* if (!Convert.IsDBNull(drRow[i]["pright"]))
* {
* drs.pic_right = Convert.ToInt32(drRow[i]["pright"]);
* }
* else
* {
* drs.pic_right = 0;
* }
*
* drs.rank_num = Convert.ToInt32(drRow[i]["rank_num"]);
*/
listDeviceRealState.Add(drs);
}
return(listDeviceRealState);
}
