public static string GetCountersT(string s)
{
int o = (int)Mydb.ExecuteScalar("select top 1 OBJECT_ID from VW_ROOMS where NUMBER=@s", new SqlParameter[] { new SqlParameter("@s", s) }, CommandType.Text);
DataTable dt = Mydb.ExecuteReadertoDataTable("select * from VW_METERS where OBJECT_ID=@o and ROOM_NUMBER=(select ROOM_ID from PER_SCORE where SCORE_ID=@s)", new SqlParameter[] { new SqlParameter("@o", o), new SqlParameter("@s", s) }, CommandType.Text);
List <METERS> ms = new List <METERS>();
foreach (DataRow item in dt.Rows)
{
METERS m = new METERS();
m.AMUNT_TARIF = item["AMUNT_TARIF"].ToString();
m.LOG_IN_ID = item["LOG_IN_ID"].ToString();
m.METERS_ID = item["METERS_ID"].ToString();
m.METERS_NUMBER = item["METERS_NUMBER"].ToString();
m.NEXT_DATE = item["NEXT_DATE"].ToString();
m.OBJECT_ID = item["OBJECT_ID"].ToString();
m.PREVIOUS_DATE = item["PREVIOUS_DATE"].ToString();
m.ROOM_NUMBER = item["ROOM_NUMBER"].ToString();
m.ROOM_TYPE = item["ROOM_TYPE"].ToString();
m.ROOM_TYPE_ID = item["ROOM_TYPE_ID"].ToString();
m.SCORE_ID = item["SCORE_ID"].ToString();
m.TYPE = item["TYPE"].ToString();
m.TYPE_ID = item["TYPE"].ToString();
ms.Add(m);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(ms));
}
public static string GetMeterDetail(int mid)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("GetMeterDetail ", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.StoredProcedure);
List <METERS> ms = new List <METERS>();
foreach (DataRow item in dt.Rows)
{
METERS m = new METERS();
m.AMUNT_TARIF = item["AMUNT_TARIF"].ToString();
m.LOG_IN_ID = item["ARXIV"].ToString() + "|" + item["SUSBEND"].ToString();
m.METERS_ID = item["METERS_ID"].ToString();
m.METERS_NUMBER = item["METERS_NUMBER"].ToString();
m.NEXT_DATE = item["NEXT_DATE"].ToString();
m.OBJECT_ID = item["OBJECT_ID"].ToString();
m.PREVIOUS_DATE = item["PREVIOUS_DATE"].ToString();
m.ROOM_NUMBER = item["ROOM_NUMBER2"].ToString();
m.ROOM_TYPE = item["ROOM_TYPE"].ToString();
m.ROOM_TYPE_ID = item["ROOM_TYPE_ID2"].ToString();
m.SCORE_ID = item["SCORE_ID"].ToString();
m.TYPE = item["TYPE"].ToString();
m.TYPE_ID = item["TYPE_ID"].ToString();
m.IS_AUTO = item["IS_AUTO"].ToString();
ms.Add(m);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(ms));
}
public static string GetMeterHist(int mid)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select * from METERS_HISTORY where METERS_ID=@mid order by HYSTORY_ID desc", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
List <METERS> ms = new List <METERS>();
foreach (DataRow item in dt.Rows)
{
METERS m = new METERS();
m.PREVIOUS_DATE = item["DATETIME"].ToString();
m.SCORE_ID = item["EVENT"].ToString();
m.ROOM_NUMBER = item["AUTHOR"].ToString();
m.TYPE = item["FILE_"].ToString();
ms.Add(m);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(ms));
}
public static string getMetersValuesT(int mid)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("select * from METER_VALUE where METERS_ID=@mid order by DATE_ desc", new SqlParameter[] { new SqlParameter("@mid", mid) }, CommandType.Text);
List <METERS> ms = new List <METERS>();
foreach (DataRow item in dt.Rows)
{
// AMUNT_TARIF/VALUE_
// LOG_IN_ID/VALUE_2
// METERS_ID/VALUE_3
// NEXT_DATE/DATE_
METERS m = new METERS();
m.AMUNT_TARIF = item["VALUE_"].ToString();
m.LOG_IN_ID = item["VALUE_2"].ToString();
m.METERS_ID = item["VALUE_3"].ToString();
m.NEXT_DATE = item["DATE_"].ToString();
ms.Add(m);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(ms));
}
