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));
}
