/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ICS_THEME_CONENT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ICS_THEME_CONTENT set ");
strSql.Append("USERID=" + model.USERID + ",");
strSql.Append("THEMEID=" + model.THEMEID + ",");
strSql.Append("DISPLAY_NAME='" + model.DISPLAY_NAME + "',");
strSql.Append("AUTO_REFRESH=" + model.AUTO_REFRESH + ",");
strSql.Append("AUTO_REFRESH_INTERVAL=" + model.AUTO_REFRESH_INTERVAL + ",");
strSql.Append("CONTENTID=" + model.CONTENTID + "");
strSql.Append(" where ID=" + model.ID + " ");
DbHelperSQL.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
private ICS_THEME_CONENT GetModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,USERID,THEMEID,DISPLAY_NAME,AUTO_REFRESH,AUTO_REFRESH_INTERVAL,CONTENTID");
strSql.Append(" FROM ICS_THEME_CONTENT ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by ID");
ICS_THEME_CONENT model = new ICS_THEME_CONENT();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
model.DISPLAY_NAME = ds.Tables[0].Rows[0]["DISPLAY_NAME"].ToString();
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["USERID"].ToString() != "")
{
model.USERID = int.Parse(ds.Tables[0].Rows[0]["USERID"].ToString());
}
if (ds.Tables[0].Rows[0]["THEMEID"].ToString() != "")
{
model.THEMEID = int.Parse(ds.Tables[0].Rows[0]["THEMEID"].ToString());
}
if (ds.Tables[0].Rows[0]["AUTO_REFRESH"].ToString() != "")
{
model.AUTO_REFRESH = int.Parse(ds.Tables[0].Rows[0]["AUTO_REFRESH"].ToString());
}
if (ds.Tables[0].Rows[0]["AUTO_REFRESH_INTERVAL"].ToString() != "")
{
model.AUTO_REFRESH_INTERVAL = int.Parse(ds.Tables[0].Rows[0]["AUTO_REFRESH_INTERVAL"].ToString());
}
if (ds.Tables[0].Rows[0]["CONTENTID"].ToString() != "")
{
model.CONTENTID = int.Parse(ds.Tables[0].Rows[0]["CONTENTID"].ToString());
}
return(model);
}
else
{
return(null);
}
}
private List <ICS_THEME_CONENT> GetList(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,USERID,THEMEID,DISPLAY_NAME,AUTO_REFRESH,AUTO_REFRESH_INTERVAL,CONTENTID");
strSql.Append(" FROM ICS_THEME_CONTENT ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
DataSet ds = DbHelperSQL.Query(strSql.ToString());
List <ICS_THEME_CONENT> list = new List <ICS_THEME_CONENT>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ICS_THEME_CONENT model = new ICS_THEME_CONENT();
model.DISPLAY_NAME = ds.Tables[0].Rows[i]["DISPLAY_NAME"].ToString();
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["USERID"].ToString() != "")
{
model.USERID = int.Parse(ds.Tables[0].Rows[0]["USERID"].ToString());
}
if (ds.Tables[0].Rows[0]["THEMEID"].ToString() != "")
{
model.THEMEID = int.Parse(ds.Tables[0].Rows[0]["THEMEID"].ToString());
}
if (ds.Tables[0].Rows[0]["AUTO_REFRESH"].ToString() != "")
{
model.AUTO_REFRESH = int.Parse(ds.Tables[0].Rows[0]["AUTO_REFRESH"].ToString());
}
if (ds.Tables[0].Rows[0]["AUTO_REFRESH_INTERVAL"].ToString() != "")
{
model.AUTO_REFRESH_INTERVAL = int.Parse(ds.Tables[0].Rows[0]["AUTO_REFRESH_INTERVAL"].ToString());
}
if (ds.Tables[0].Rows[0]["CONTENTID"].ToString() != "")
{
model.CONTENTID = int.Parse(ds.Tables[0].Rows[0]["CONTENTID"].ToString());
}
list.Add(model);
}
return(list);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ICS_THEME_CONENT model)
{
model.ID = GetMaxID() + 1;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ICS_THEME_CONTENT(");
strSql.Append("ID,USERID,THEMEID,DISPLAY_NAME,AUTO_REFRESH,AUTO_REFRESH_INTERVAL,CONTENTID");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(model.ID + ",");
strSql.Append(model.USERID + ",");
strSql.Append(model.THEMEID + ",");
strSql.Append("'" + model.DISPLAY_NAME + "',");
strSql.Append(model.AUTO_REFRESH + ",");
strSql.Append(model.AUTO_REFRESH_INTERVAL + ",");
strSql.Append(model.CONTENTID);
strSql.Append(")");
DbHelperSQL.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ICS_THEME_CONENT model)
{
dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ICS_THEME_CONENT model)
{
dal.Add(model);
}