public int Add(WebMenus model) { string sql = "insert into WebMenus(WebMenus_Id,WebMenus_Title,WebMenus_Link,WebMenus_Icon,WebMenus_DeleteId,WebMenus_ParentId,WebMenus_CreateTime,WebMenus_UpdateTime) " + "values(@WebMenus_Id,@WebMenus_Title,@WebMenus_Link,@WebMenus_Icon,@WebMenus_DeleteId,@WebMenus_ParentId,@WebMenus_CreateTime,@WebMenus_UpdateTime)"; return(SqlHelper <WebMenus> .ExceuteNonQuery(sql, model)); }
public int EditWebMenus(WebMenus webMenus) { string sql = "update WebMenus set WebMenus_Title = @WebMenus_Title,WebMenus_Link = @WebMenus_Link,WebMenus_UpdateTime = @WebMenus_UpdateTime where WebMenus_Id = @WebMenus_Id"; SqlParameter[] param = { new SqlParameter("@WebMenus_Title", webMenus.WebMenus_Title), new SqlParameter("@WebMenus_Link", webMenus.WebMenus_Link), new SqlParameter("@WebMenus_UpdateTime", webMenus.UpdateTime), new SqlParameter("@WebMenus_Id", webMenus.Id) }; return(SqlHelper.ExecuteNonQuery(sql, param)); }
public int AddWebMenus(WebMenus webMenus) { string sql = "insert into WebMenus(WebMenus_Id,WebMenus_Title,WebMenus_Link,WebMenus_ParentId,WebMenus_Icon,WebMenus_DeleteId,WebMenus_CreateTime,WebMenus_UpdateTime)values(@WebMenus_Id,@WebMenus_Title,@WebMenus_Link,@WebMenus_ParentId,@WebMenus_Icon,@WebMenus_DeleteId,@WebMenus_CreateTime,@WebMenus_UpdateTime)"; SqlParameter[] param = { new SqlParameter("@WebMenus_Id", webMenus.Id), new SqlParameter("@WebMenus_Title", webMenus.WebMenus_Title), new SqlParameter("@WebMenus_Link", webMenus.WebMenus_Link), new SqlParameter("@WebMenus_ParentId", webMenus.WebMenus_ParentId), new SqlParameter("@WebMenus_Icon", webMenus.WebMenus_Icon), new SqlParameter("@WebMenus_DeleteId", webMenus.DeleteId), new SqlParameter("@WebMenus_CreateTime", webMenus.CreateTime), new SqlParameter("@WebMenus_UpdateTime", webMenus.UpdateTime), }; return(SqlHelper.ExecuteNonQuery(sql, param)); }
public List <WebMenus> FillData(DataTable dt) { var list = new List <WebMenus>(); foreach (DataRow dr in dt.Rows) { var item = new WebMenus() { Id = Guid.Parse(dr["WebMenus_Id"].ToString()), WebMenus_Title = dr["WebMenus_Titl"].ToString(), WebMenus_Link = dr["WebMenus_Link"].ToString(), WebMenus_ParentId = Guid.Parse(dr["WebMenus_ParentId"].ToString()), WebMenus_Icon = dr["WebMenus_Icon"].ToString(), DeleteId = int.Parse(dr["WebMenus_DeleteId"].ToString()), UpdateTime = DateTime.Parse(dr["WebMenus_UpdateTime"].ToString()) }; list.Add(item); } return(list); }
public int Edit(WebMenus model) { return(dal.Edit(model)); }
public int Add(WebMenus model) { return(dal.Add(model)); }
public int Edit(WebMenus model) { string sql = "update WebMenus set WebMenus_Title = @WebMenus_Title ,WebMenus_Link = @WebMenus_Link,WebMenus_Icon = @WebMenus_Icon,WebMenus_ParentId = @WebMenus_ParentId,WebMenus_UpdateTime = @WebMenus_UpdateTime where WebMenus_Id = @WebMenus_Id"; return(SqlHelper <WebMenus> .ExceuteNonQuery(sql, model)); }
public int EditWebMenus(WebMenus webMenus) { return(wm.EditWebMenus(webMenus)); }
public int AddWebMenus(WebMenus webMenus) { return(wm.AddWebMenus(webMenus)); }