/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DTcms.Model.dt_historydata model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_historydata set ");
strSql.Append("name=@name,");
strSql.Append("value=@value,");
strSql.Append("updatetime=@updatetime,");
strSql.Append("type=@type,");
strSql.Append("checkcode=@checkcode,");
strSql.Append("functioncode=@functioncode,");
strSql.Append("datahead=@datahead,");
strSql.Append("item_id=@item_id,");
strSql.Append("online=@online,");
strSql.Append("trailerval=@trailerval,");
strSql.Append("warningval=@warningval");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@value", SqlDbType.VarChar, 200),
new SqlParameter("@updatetime", SqlDbType.DateTime),
new SqlParameter("@type", SqlDbType.Int, 4),
new SqlParameter("@checkcode", SqlDbType.VarChar, 32),
new SqlParameter("@functioncode", SqlDbType.VarChar, 32),
new SqlParameter("@datahead", SqlDbType.VarChar, 64),
new SqlParameter("@item_id", SqlDbType.Int, 4),
new SqlParameter("@online", SqlDbType.Bit, 1),
new SqlParameter("@trailerval", SqlDbType.VarChar, 500),
new SqlParameter("@warningval", SqlDbType.VarChar, 500),
new SqlParameter("@id", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@addtime", SqlDbType.DateTime)
};
parameters[0].Value = model.name;
parameters[1].Value = model.value;
parameters[2].Value = model.updatetime;
parameters[3].Value = model.type;
parameters[4].Value = model.checkcode;
parameters[5].Value = model.functioncode;
parameters[6].Value = model.datahead;
parameters[7].Value = model.item_id;
parameters[8].Value = model.online;
parameters[9].Value = model.trailerval;
parameters[10].Value = model.warningval;
parameters[11].Value = model.id;
parameters[12].Value = model.addtime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(DTcms.Model.dt_historydata model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_historydata(");
strSql.Append("id,name,value,addtime,updatetime,type,checkcode,functioncode,datahead,item_id,online,trailerval,warningval)");
strSql.Append(" values (");
strSql.Append("@id,@name,@value,@addtime,@updatetime,@type,@checkcode,@functioncode,@datahead,@item_id,@online,@trailerval,@warningval)");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@value", SqlDbType.VarChar, 200),
new SqlParameter("@addtime", SqlDbType.DateTime),
new SqlParameter("@updatetime", SqlDbType.DateTime),
new SqlParameter("@type", SqlDbType.Int, 4),
new SqlParameter("@checkcode", SqlDbType.VarChar, 32),
new SqlParameter("@functioncode", SqlDbType.VarChar, 32),
new SqlParameter("@datahead", SqlDbType.VarChar, 64),
new SqlParameter("@item_id", SqlDbType.Int, 4),
new SqlParameter("@online", SqlDbType.Bit, 1),
new SqlParameter("@trailerval", SqlDbType.VarChar, 500),
new SqlParameter("@warningval", SqlDbType.VarChar, 500)
};
parameters[0].Value = Guid.NewGuid();
parameters[1].Value = model.name;
parameters[2].Value = model.value;
parameters[3].Value = model.addtime;
parameters[4].Value = model.updatetime;
parameters[5].Value = model.type;
parameters[6].Value = model.checkcode;
parameters[7].Value = model.functioncode;
parameters[8].Value = model.datahead;
parameters[9].Value = model.item_id;
parameters[10].Value = model.online;
parameters[11].Value = model.trailerval;
parameters[12].Value = model.warningval;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DTcms.Model.dt_historydata GetModel(Guid id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,name,value,addtime,updatetime,type,checkcode,functioncode,datahead,item_id,online,trailerval,warningval from dt_historydata ");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = id;
DTcms.Model.dt_historydata model = new DTcms.Model.dt_historydata();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DTcms.Model.dt_historydata DataRowToModel(DataRow row)
{
DTcms.Model.dt_historydata model = new DTcms.Model.dt_historydata();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = new Guid(row["id"].ToString());
}
if (row["name"] != null)
{
model.name = row["name"].ToString();
}
if (row["value"] != null)
{
model.value = row["value"].ToString();
}
if (row["addtime"] != null && row["addtime"].ToString() != "")
{
model.addtime = DateTime.Parse(row["addtime"].ToString());
}
if (row["updatetime"] != null && row["updatetime"].ToString() != "")
{
model.updatetime = DateTime.Parse(row["updatetime"].ToString());
}
if (row["type"] != null && row["type"].ToString() != "")
{
model.type = int.Parse(row["type"].ToString());
}
if (row["checkcode"] != null)
{
model.checkcode = row["checkcode"].ToString();
}
if (row["functioncode"] != null)
{
model.functioncode = row["functioncode"].ToString();
}
if (row["datahead"] != null)
{
model.datahead = row["datahead"].ToString();
}
if (row["item_id"] != null && row["item_id"].ToString() != "")
{
model.item_id = int.Parse(row["item_id"].ToString());
}
if (row["online"] != null && row["online"].ToString() != "")
{
if ((row["online"].ToString() == "1") || (row["online"].ToString().ToLower() == "true"))
{
model.online = true;
}
else
{
model.online = false;
}
}
if (row["trailerval"] != null)
{
model.trailerval = row["trailerval"].ToString();
}
if (row["warningval"] != null)
{
model.warningval = row["warningval"].ToString();
}
}
return(model);
}
