public int Add(Model.WxMessageModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Wx_messageinfo(");
strSql.Append("[MsgType],Contents,PicUrl,PShow,Title,Description,Url,HUrl,GroupCode,CreateTime,Author,OrderId)");
strSql.Append(" values (");
strSql.Append("@MsgType,@Contents,@PicUrl,@PShow,@Title,@Description,@Url,@HUrl,@GroupCode,@CreateTime,@Author,@OrderId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MsgType", model.MsgType),
new SqlParameter("@Contents", model.Contents),
new SqlParameter("@PicUrl", model.PicUrl),
new SqlParameter("@PShow", model.PShow),
new SqlParameter("@Title", model.Title),
new SqlParameter("@Description", model.Description),
new SqlParameter("@Url", model.Url),
new SqlParameter("@HUrl", model.HUrl),
new SqlParameter("@GroupCode", model.GroupCode),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@Author", model.Author),
new SqlParameter("@OrderId", model.OrderId)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public Model.WxMessageModel GetModel(string code)
{
string sql = "select * from Wx_messageinfo where GroupCode ='" + code + "'";
Model.WxMessageModel model = new Model.WxMessageModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
if (dr.Read())
{
model.MsgType = dr["MsgType"].ToString();
model.Contents = dr["Contents"].ToString();
model.Title = dr["Title"].ToString();
model.PicUrl = dr["PicUrl"].ToString();
model.PShow = Convert.ToInt32(dr["PShow"].ToString());
model.Description = dr["Description"].ToString();
model.Url = dr["Url"].ToString();
model.HUrl = dr["HUrl"].ToString();
model.GroupCode = dr["GroupCode"].ToString();
model.Author = dr["Author"].ToString();
model.CreateTime = Convert.ToDateTime(dr["CreateTime"].ToString());
model.Id = Convert.ToInt32(dr["Id"].ToString());
model.OrderId = Convert.ToInt32(dr["OrderId"].ToString());
}
return(model);
}
public int Update(Model.WxMessageModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Wx_messageinfo set ");
strSql.Append("MsgType=@MsgType,Author=@Author,Contents=@Contents,PicUrl=@PicUrl,PShow=@PShow,Title=@Title,Description=@Description,Url=@Url,HUrl=@HUrl,GroupCode=@GroupCode,CreateTime=@CreateTime ");
strSql.Append(" where Id = @Id ");
SqlParameter[] parameters =
{
new SqlParameter("@MsgType", model.MsgType),
new SqlParameter("@Contents", model.Contents),
new SqlParameter("@PicUrl", model.PicUrl),
new SqlParameter("@PShow", model.PShow),
new SqlParameter("@Title", model.Title),
new SqlParameter("@Description", model.Description),
new SqlParameter("@Url", model.Url),
new SqlParameter("@HUrl", model.HUrl),
new SqlParameter("@GroupCode", model.GroupCode),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@Author", model.Author),
new SqlParameter("@Id", model.Id),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Adds(Model.WxMessageModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Wx_messageinfo(");
strSql.Append("[MsgType],Contents,PicUrl,PShow,Title,Description,Url,HUrl,GroupCode,CreateTime,Author,OrderId)");
strSql.Append(" values (");
strSql.Append("@MsgType,@Contents,@PicUrl,@PShow,@Title,@Description,@Url,@HUrl,@GroupCode,@CreateTime,@Author,@OrderId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@MsgType", model.MsgType),
new SqlParameter("@Contents", model.Contents),
new SqlParameter("@PicUrl", model.PicUrl),
new SqlParameter("@PShow", model.PShow),
new SqlParameter("@Title", model.Title),
new SqlParameter("@Description", model.Description),
new SqlParameter("@Url", model.Url),
new SqlParameter("@HUrl", model.HUrl),
new SqlParameter("@GroupCode", model.GroupCode),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@Author", model.Author),
new SqlParameter("@OrderId", model.OrderId)
};
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (System.Data.SqlClient.SqlTransaction trans = conn.BeginTransaction())
{
try
{
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql.ToString(), parameters);
//return i;
string a = SqlHelper.ExecuteDataTable(trans, CommandType.Text, "select @@IDENTITY").Rows[0][0].ToString();
trans.Commit();
return(Convert.ToInt32(a));
}
catch (Exception)
{
trans.Rollback();
return(0);
}
}
}
}
