/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Tunnel.Model.Tunnel_index model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@typeId", SqlDbType.Int, 4),
new SqlParameter("@title", SqlDbType.VarChar, 200),
new SqlParameter("@content", SqlDbType.Text),
new SqlParameter("@imagePaht", SqlDbType.VarChar, 100),
new SqlParameter("@htmlSource", SqlDbType.Text),
new SqlParameter("@setDate", SqlDbType.DateTime),
new SqlParameter("@userId", SqlDbType.Int, 4),
new SqlParameter("@files", SqlDbType.VarChar, 500),
new SqlParameter("@filename", SqlDbType.VarChar, 500),
new SqlParameter("@readUser", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.TypeId;
parameters[2].Value = model.Title;
parameters[3].Value = model.Content;
parameters[4].Value = model.ImagePaht;
parameters[5].Value = model.HtmlSource;
parameters[6].Value = model.SetDate;
parameters[7].Value = model.UserId;
parameters[8].Value = model.Files;
parameters[9].Value = model.Filename;
parameters[10].Value = model.ReadUser;
DbHelperSQL.RunProcedure("UP_Tunnel_Index_Update", parameters, out rowsAffected);
return(rowsAffected);
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="message">实体集</param>
/// <returns>列新结果</returns>
public int Update(Tunnel.Model.Tunnel_index index)
{
string strSQL = string.Format("UPDATE Tunnel_InfoItem SET title='{2}',content='{3}',imagePaht='{4}',htmlSource='{5}',setDate='{6}',userId='{7}',files='{8}',bum_bz='{9}',filename='{10}',readUser='******' WHERE id={0} AND typeid={1}",
index.Id, index.TypeId, index.Title, index.Content, index.ImagePaht, index.HtmlSource, index.SetDate, index.UserId, index.Files, index.Bum_bz, index.Filename, index.ReadUser);
object obj = DbHelperSQL.ExecuteSql(strSQL);
if (null != obj)
{
return(Convert.ToInt32(obj));
}
else
{
return(0);
}
}
/// <summary>
/// 新增一条数据
/// </summary>
/// <param name="message">实体集</param>
/// <returns>新增结果</returns>
public int Add(Tunnel.Model.Tunnel_index index)
{
string strSQL = string.Format("INSERT INTO Tunnel_InfoItem (typeid,title,content,imagePaht,htmlSource,setDate,userId,files,bum_bz,del,filename,readUser) "
+ "VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9]','{10}','{11}')", index.TypeId, index.Title, index.Content, index.ImagePaht,
index.HtmlSource, index.SetDate, index.UserId, index.Files, index.Bum_bz, 0, index.Filename, index.ReadUser);
object obj = DbHelperSQL.ExecuteSql(strSQL);
if (null != obj)
{
return(Convert.ToInt32(obj));
}
else
{
return(0);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Tunnel.Model.Tunnel_index GetModel(int id)
{
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Tunnel.Model.Tunnel_index model = new Tunnel.Model.Tunnel_index();
DataSet ds = DbHelperSQL.RunProcedure("UP_Tunnel_Index_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
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]["typeId"].ToString() != "")
{
model.TypeId = int.Parse(ds.Tables[0].Rows[0]["typeId"].ToString());
}
model.Title = ds.Tables[0].Rows[0]["title"].ToString();
model.Content = ds.Tables[0].Rows[0]["content"].ToString();
model.ImagePaht = ds.Tables[0].Rows[0]["imagePaht"].ToString();
model.HtmlSource = ds.Tables[0].Rows[0]["htmlSource"].ToString();
if (ds.Tables[0].Rows[0]["setDate"].ToString() != "")
{
model.SetDate = Convert.ToString(ds.Tables[0].Rows[0]["setDate"].ToString());
}
if (ds.Tables[0].Rows[0]["userId"].ToString() != "")
{
model.UserId = int.Parse(ds.Tables[0].Rows[0]["userId"].ToString());
}
model.Files = ds.Tables[0].Rows[0]["files"].ToString();
model.Filename = ds.Tables[0].Rows[0]["filename"].ToString();
model.ReadUser = ds.Tables[0].Rows[0]["readUser"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 获得信息实体集
/// </summary>
/// <param name="mesID">信息编号</param>
/// <returns>信息实体集</returns>
public Tunnel.Model.Tunnel_index GetInfoItemModel(int mesID)
{
Tunnel.Model.Tunnel_index model = new Tunnel.Model.Tunnel_index();
string strSQL = string.Format("SELECT * FROM Tunnel_InfoItem WHERE id={0}", mesID);
using (SqlDataReader reader = DbHelperSQL.ExecuteReader(strSQL))
{
if (reader.Read())
{
if (reader["id"].ToString() != "")
{
model.Id = int.Parse(reader["id"].ToString());
}
if (reader["typeId"].ToString() != "")
{
model.TypeId = int.Parse(reader["typeId"].ToString());
}
model.Title = reader["title"].ToString();
model.Content = reader["content"].ToString();
model.ImagePaht = reader["imagePaht"].ToString();
model.HtmlSource = reader["htmlSource"].ToString();
if (reader["setDate"].ToString() != "")
{
model.SetDate = Convert.ToString(reader["setDate"].ToString());
}
if (reader["userId"].ToString() != "")
{
model.UserId = int.Parse(reader["userId"].ToString());
}
model.Files = reader["files"].ToString();
model.Filename = reader["filename"].ToString();
model.ReadUser = reader["readUser"].ToString();
return(model);
}
}
return(model);
}
