/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HighBack model)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetStoredProcCommond("Proc_HighBack_Insert");//返回主键
db.AddInParameter(cmd, "@house_no", DbType.Int32, model.HouseNo);
db.AddInParameter(cmd, "@temperatureset", DbType.String, model.Temperatureset);
db.AddInParameter(cmd, "@RegionCode", DbType.String, model.RegionCode);
db.AddInParameter(cmd, "@regionName", DbType.String, model.RegionName);
db.AddInParameter(cmd, "@RegionId", DbType.Guid,Guid.Parse(model.RegionId));
db.AddInParameter(cmd, "@testdatetime", DbType.DateTime, model.Testdatetime);
db.AddInParameter(cmd, "@addTime", DbType.DateTime, model.AddTime);
db.AddInParameter(cmd, "@state", DbType.String, model.State);
object res = db.ExecuteScalar(cmd);
return res == null ? -1 : Convert.ToInt32(res);
}
public StoreHouse GetStoreHouses(string regionid,string housenumber)
{
DBHelper db=new DBHelper();
string sql = "select * from storehouse where regionid='" + regionid + "' and house_no='"+housenumber+"'";
DbCommand cmd = db.GetSqlStringCommond(sql);
comm.SaveLog("1",DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")+ "获取StoreHouse" + cmd.CommandText);
DataTable dt = db.ExecuteDataTable(cmd);
foreach (DataRow dataRow in dt.Rows)
{
StoreHouse storeHouse=new StoreHouse();
storeHouse.RegionCode = dataRow["RegionCode"].ToString();
storeHouse.RegionId =Guid.Parse(dataRow["RegionId"].ToString());
storeHouse.air_hum_pos =Convert.ToInt32(dataRow["air_hum_pos"].ToString());
storeHouse.air_tem_pos =Convert.ToInt32(dataRow["air_tem_pos"].ToString());
storeHouse.angle =Convert.ToDecimal(dataRow["angle"].ToString());
storeHouse.cable_x =Convert.ToInt32(dataRow["RegionCode"].ToString());
storeHouse.cable_y =Convert.ToInt32(dataRow["cable_y"].ToString());
storeHouse.cklx = dataRow["cklx"].ToString();
storeHouse.depot_hum_pos = Convert.ToInt32(dataRow["depot_hum_pos"]);
storeHouse.depot_tem_pos = Convert.ToInt32(dataRow["depot_tem_pos"]);
storeHouse.dim1 = Convert.ToInt32(dataRow["dim1"]);
storeHouse.dim2 = Convert.ToInt32(dataRow["dim2"]);
storeHouse.dim3 = Convert.ToInt32(dataRow["dim3"]);
storeHouse.dirx = Convert.ToInt32(dataRow["dirx"]);
storeHouse.diry = Convert.ToInt32(dataRow["diry"]);
storeHouse.distr_no = Convert.ToInt32(dataRow["distr_no"]);
storeHouse.house_no = Convert.ToInt32(dataRow["house_no"]);
storeHouse.housename = Convert.ToString(dataRow["housename"]);
storeHouse.memo = Convert.ToString(dataRow["memo"]);
storeHouse.node_z = Convert.ToInt32(dataRow["node_z"]);
storeHouse.regionName = Convert.ToString(dataRow["regionName"]);
storeHouse.storecount = Convert.ToInt32(dataRow["storecount"]);
storeHouse.typecode = Convert.ToInt32(dataRow["typecode"]);
// storeHouse.uploadTime = Convert.ToDateTime(dataRow["uploadTime"]);
storeHouse.x_scale = Convert.ToInt32(dataRow["x_scale"]);
storeHouse.y_scale = Convert.ToInt32(dataRow["y_scale"]);
comm.SaveLog("1","获取数据成功");
return storeHouse;
}
return null;
}
public Hashtable GetStoreSign()
{
Hashtable ht=new Hashtable();
DBHelper db=new DBHelper();
string sql = "SELECT RegionCode,[sign] FROM storename";
DbCommand cmd = db.GetSqlStringCommond(sql);
DataTable dt = db.ExecuteDataTable(cmd);
foreach (DataRow dataRow in dt.Rows)
{
ht.Add(dataRow["RegionCode"].ToString(), dataRow["sign"].ToString());
}
return ht;
}
public IList<HighBack> SelectHighBackBeanList(String where)
{
IList<HighBack> list = new List<HighBack>();
DBHelper db = new DBHelper();
DbCommand cmd = db.GetSqlStringCommond("SELECT * FROM HighBack WHERE " + where);
DataTable dt = db.ExecuteDataTable(cmd);
foreach (DataRow row in dt.Rows)
{
list.Add(this.DataRowToBean(row));
}
return list;
}
public IList<TestData> GetTestDataList(string sqlWhere)
{
IList<TestData> list=new List<TestData>();
DBHelper db=new DBHelper();
DbCommand cmd = db.GetSqlStringCommond("select * from testdata where 1=1 " + sqlWhere);
DataTable dt = db.ExecuteDataTable(cmd);
foreach (DataRow dataRow in dt.Rows)
{
TestData testData=new TestData();
testData.RegionCode = dataRow["RegionCode"].ToString();
testData.RegionId =Guid.Parse(dataRow["RegionId"].ToString());
testData.air_hum =Convert.ToInt16(dataRow["air_hum"].ToString());
testData.air_tem =Convert.ToInt16(dataRow["air_tem"].ToString());
testData.aver_tem =Convert.ToInt16(dataRow["aver_tem"].ToString());
testData.depot_hum =Convert.ToInt16(dataRow["depot_hum"].ToString());
testData.depot_tem =Convert.ToInt16(dataRow["depot_tem"].ToString());
testData.house_no =Convert.ToInt16(dataRow["house_no"].ToString());
testData.regionName = dataRow["regionName"].ToString();
testData.temperatureset = dataRow["temperatureset"].ToString();
testData.testdatetime = Convert.ToDateTime(dataRow["testdatetime"].ToString());
list.Add(testData);
}
return list;
}
