/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MDL.DeviceInfoMDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into deviceinfo(");
strSql.Append("TID,DeviceType,DeviceID,DeviceName,DeviceIP,ProductType,DeviceState,StationID,`Desc` )");
strSql.Append(" values (");
strSql.Append("@TID,@DeviceType,@DeviceID,@DeviceName,@DeviceIP,@ProductType,@DeviceState,@StationID,@Desc)");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@TID", model.TID),
new SQLiteParameter("@DeviceType", model.DeviceType),
new SQLiteParameter("@DeviceID", model.DeviceID),
new SQLiteParameter("@DeviceName", model.DeviceName),
new SQLiteParameter("@DeviceIP", model.DeviceIP),
new SQLiteParameter("@ProductType", model.ProductType),
new SQLiteParameter("@DeviceState", model.DeviceState),
new SQLiteParameter("@StationID", model.StationID),
new SQLiteParameter("@Desc", model.Desc)
};
int rows = SQLiteHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.DeviceInfoMDL DataRowToModel(DataRow row)
{
MDL.DeviceInfoMDL model = new MDL.DeviceInfoMDL();
if (row != null)
{
if (row["TID"] != null && row["TID"].ToString() != "")
{
model.TID = long.Parse(row["TID"].ToString());
}
if (row["DeviceType"] != null)
{
model.DeviceType = row["DeviceType"].ToString();
}
if (row["DeviceID"] != null)
{
model.DeviceID = row["DeviceID"].ToString();
}
if (row["DeviceName"] != null)
{
model.DeviceName = row["DeviceName"].ToString();
}
if (row["DeviceIP"] != null)
{
model.DeviceIP = row["DeviceIP"].ToString();
}
if (row["ProductType"] != null)
{
model.ProductType = row["ProductType"].ToString();
}
if (row["DeviceState"] != null && row["DeviceState"].ToString() != "")
{
model.DeviceState = int.Parse(row["DeviceState"].ToString());
}
if (row["StationID"] != null)
{
model.StationID = row["StationID"].ToString();
}
if (row["Desc"] != null)
{
model.Desc = row["Desc"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.DeviceInfoMDL GetModel(string str)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TID,DeviceType,DeviceID,DeviceName,DeviceIP,ProductType,DeviceState,StationID,`Desc` from deviceinfo ");
if (!string.IsNullOrEmpty(str))
{
strSql.Append("where " + str);
}
MDL.DeviceInfoMDL model = new MDL.DeviceInfoMDL();
DataSet ds = SQLiteHelper.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MDL.DeviceInfoMDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update deviceinfo set ");
strSql.Append("DeviceType=@DeviceType,");
strSql.Append("DeviceID=@DeviceID,");
strSql.Append("DeviceName=@DeviceName,");
strSql.Append("DeviceIP=@DeviceIP,");
strSql.Append("ProductType=@ProductType,");
strSql.Append("DeviceState=@DeviceState,");
strSql.Append("StationID=@StationID,");
strSql.Append("Desc=@Desc");
strSql.Append(" where TID=@TID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@DeviceType", model.DeviceType),
new SQLiteParameter("@DeviceID", model.DeviceID),
new SQLiteParameter("@DeviceName", model.DeviceName),
new SQLiteParameter("@DeviceIP", model.DeviceIP),
new SQLiteParameter("@ProductType", model.ProductType),
new SQLiteParameter("@DeviceState", model.DeviceState),
new SQLiteParameter("@StationID", model.StationID),
new SQLiteParameter("@Desc", model.Desc),
new SQLiteParameter("@TID", model.TID)
};
int rows = SQLiteHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.DeviceInfoMDL GetModel(long TID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TID,DeviceType,DeviceID,DeviceName,DeviceIP,ProductType,DeviceState,StationID,`Desc` from deviceinfo ");
strSql.Append(" where TID=@TID");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@TID", TID)
};
MDL.DeviceInfoMDL model = new MDL.DeviceInfoMDL();
DataSet ds = SQLiteHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.DeviceInfoMDL GetModel(string TID, string DeviceID, string IP)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("do", "get");
dict.Add("method", "model");
dict.Add("TID", TID);
dict.Add("DeviceID", DeviceID);
dict.Add("DeviceIP", IP);
string str = Http.POST(requestUrl, dict);
var obj = JsonHelper.JsonDeSerializer <ReturnInfo>(str);
ReturnInfo ReturnData = (ReturnInfo)obj;
if (ReturnData != null && ReturnData.Code == "1")
{
var data = JsonHelper.JsonDeSerializer <MDL.DeviceInfoMDL>(ReturnData.Data.ToString());
MDL.DeviceInfoMDL Model = (MDL.DeviceInfoMDL)data;
return(Model);
}
else
{
return(null);
}
}
