public void Update(Model.CMS.Column entity) { using (IDbConnection conn = SqlString.GetMySqlConnection()) { conn.Execute("UPDATE cms_column SET Sort=@Sort,ColumnName=@ColumnName,Pid=@Pid,Lv=@Lv WHERE Column_Id =@Column_Id", entity); } }
public bool Insert(Model.CMS.Column entity) { using (IDbConnection conn = SqlString.GetMySqlConnection()) { int i = conn.Execute("INSERT INTO cms_column(Sort,ColumnName)" + "VALUES(@Sort,@ColumnName)", entity); if (i > 0) { return(true); } else { return(false); } } }