// 删
public bool Delete(W_WeChatInfo weChatInfo)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("delete from [W_WeChatInfo] where WID=@WID", new SqlParameter("@WID", weChatInfo.WID));
return(rows > 0);
}
}
// 改
public bool Update(W_Menu menu)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("update [W_Menu] set WID=@WID,MenuName=@MenuName,MenuType=@MenuType,MenuURL=@MenuURL,MenuKey=@MenuKey,PMenuID=@PMenuID,ResponseType=@ResponseType,ResourcesID=@ResourcesID,CreateTime=@CreateTime,IsDelete=@IsDelete,Sort=@Sort where MenuID=@MenuID", new SqlParameter("@MenuID", menu.MenuID), new SqlParameter("@WID", menu.WID), new SqlParameter("@MenuName", menu.MenuName), new SqlParameter("@MenuType", menu.MenuType), new SqlParameter("@MenuURL", menu.MenuURL), new SqlParameter("@MenuKey", menu.MenuKey), new SqlParameter("@PMenuID", menu.PMenuID), new SqlParameter("@ResponseType", menu.ResponseType), new SqlParameter("@ResourcesID", menu.ResourcesID), new SqlParameter("@CreateTime", menu.CreateTime), new SqlParameter("@IsDelete", menu.IsDelete), new SqlParameter("@Sort", menu.Sort));
return(rows > 0);
}
}
{// 增
public bool Add(W_ViewPageItem viewPageItem)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("insert into [W_ViewPageItem] values (@VPItemID,@VPID,@VPItemTitle,@VPItemDescription,@VPItemUrl,@VPItemPicUrl,@CreateTime,@IsDelete)", new SqlParameter("@VPItemID", viewPageItem.VPItemID), new SqlParameter("@VPID", viewPageItem.VPID), new SqlParameter("@VPItemTitle", viewPageItem.VPItemTitle), new SqlParameter("@VPItemDescription", viewPageItem.VPItemDescription), new SqlParameter("@VPItemUrl", viewPageItem.VPItemUrl), new SqlParameter("@VPItemPicUrl", viewPageItem.VPItemPicUrl), new SqlParameter("@CreateTime", viewPageItem.CreateTime), new SqlParameter("@IsDelete", viewPageItem.IsDelete));
return(rows > 0);
}
}
// 增
public bool Add(W_Menu menu)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("insert into [W_Menu] values (@MenuID,@WID,@MenuName,@MenuType,@MenuURL,@MenuKey,@PMenuID,@ResponseType,@ResourceID,@CreateTime,@IsDelete,@Sort)", new SqlParameter("@MenuID", menu.MenuID), new SqlParameter("@WID", menu.WID), new SqlParameter("@MenuName", menu.MenuName), new SqlParameter("@MenuType", menu.MenuType), new SqlParameter("@MenuURL", menu.MenuURL), new SqlParameter("@MenuKey", menu.MenuKey), new SqlParameter("@PMenuID", menu.PMenuID), new SqlParameter("@ResponseType", menu.ResponseType), new SqlParameter("@ResourecesID", menu.ResourcesID), new SqlParameter("@CreateTime", menu.CreateTime), new SqlParameter("@IsDelete", menu.IsDelete), new SqlParameter("@Sort", menu.Sort));
return(rows > 0);
}
}
// 删
public bool Delete(W_Menu menu)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("delete from [W_Menu] where MenuID=@MenuID", new SqlParameter("@MenuID", menu.MenuID));
return(rows > 0);
}
}
// 增
public bool Add(W_ViewPage viewPage)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("insert into [W_ViewPage] values (@VPID,@CataID,@VPTYpe,@VPTitle,@VPDescription,@VPURL,@ImgURL,@CreateTime,@IsDelete)", new SqlParameter("@VPID", viewPage.VPID), new SqlParameter("@CataID", viewPage.CataID), new SqlParameter("@VPTYpe", viewPage.VPTYpe), new SqlParameter("@VPTitle", viewPage.VPTitle), new SqlParameter("@VPDescription", viewPage.VPDescription), new SqlParameter("@VPURL", viewPage.VPURL), new SqlParameter("@ImgURL", viewPage.ImgURL), new SqlParameter("@CreateTime", viewPage.CreateTime), new SqlParameter("@IsDelete", viewPage.IsDelete));
return(rows > 0);
}
}
// 改
public bool Update(W_ViewPage viewPage)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("update [W_ViewPage] set CataID=@CataID,VPTYpe=@VPTYpe,VPTitle=@VPTitle,VPDescription=@VPDescription,VPURL=@VPURL,ImgURL=@ImgURL,CreateTime=@CreateTime,IsDelete=@IsDelete where VPID=@VPID", new SqlParameter("@VPID", viewPage.VPID), new SqlParameter("@CataID", viewPage.CataID), new SqlParameter("@VPTYpe", viewPage.VPTYpe), new SqlParameter("@VPTitle", viewPage.VPTitle), new SqlParameter("@VPDescription", viewPage.VPDescription), new SqlParameter("@VPURL", viewPage.VPURL), new SqlParameter("@ImgURL", viewPage.ImgURL), new SqlParameter("@CreateTime", viewPage.CreateTime), new SqlParameter("@IsDelete", viewPage.IsDelete));
return(rows > 0);
}
}
// 改
public bool Update(W_ResourcesCata resourcesCata)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("update [W_ResourcesCata] set WID=@WID,CataName=@CataName,CreateTime=@CreateTime,IsDelete=@IsDelete where CataID=@CataID", new SqlParameter("@CataID", resourcesCata.CataID), new SqlParameter("@CataID", resourcesCata.CataID), new SqlParameter("@WID", resourcesCata.WID), new SqlParameter("@CataName", resourcesCata.CataName), new SqlParameter("@CreateTime", resourcesCata.CreateTime), new SqlParameter("@IsDelete", resourcesCata.IsDelete));
return(rows > 0);
}
}
// 增
public bool Add(W_ResourcesCata resourcesCata)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("insert into [W_ResourcesCata] values (@CataID,@WID,@CataName,@CreateTime,@IsDelete)", new SqlParameter("@CataID", resourcesCata.CataID), new SqlParameter("@WID", resourcesCata.WID), new SqlParameter("@CataName", resourcesCata.CataName), new SqlParameter("@CreateTime", resourcesCata.CreateTime), new SqlParameter("@IsDelete", resourcesCata.IsDelete));
return(rows > 0);
}
}
// 改
public bool Update(W_WeChatInfo weChatInfo)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("update [W_WeChatInfo] set AppID=@AppID,AppSecret=@AppSecret,Token=@Token,WechatID=@WechatID,AppNamespace=@AppNamespace,CreateTime=@CreateTime,IsDelete=@IsDelete where WID=@WID", new SqlParameter("@WID", weChatInfo.WID), new SqlParameter("@AppID", weChatInfo.AppID), new SqlParameter("@AppSecret", weChatInfo.AppSecret), new SqlParameter("@Token", weChatInfo.Token), new SqlParameter("@WechatID", weChatInfo.WechatID), new SqlParameter("@AppNamespace", weChatInfo.AppNamespace), new SqlParameter("@CreateTime", weChatInfo.CreateTime), new SqlParameter("@IsDelete", weChatInfo.IsDelete));
return(rows > 0);
}
}
// 改
public bool Update(W_ViewPageItem viewPageItem)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("update [W_ViewPageItem] set VPID=@VPID,VPItemTitle=@VPItemTitle,VPItemDescription=@VPItemDescription,VPItemUrl=@VPItemUrl,VPItemPicUrl=@VPItemPicUrl,CreateTime=@CreateTime,IsDelete=@IsDelete where VPItemID=@VPItemID", new SqlParameter("@VPItemID", viewPageItem.VPItemID), new SqlParameter("@VPID", viewPageItem.VPID), new SqlParameter("@VPItemTitle", viewPageItem.VPItemTitle), new SqlParameter("@VPItemDescription", viewPageItem.VPItemDescription), new SqlParameter("@VPItemUrl", viewPageItem.VPItemUrl), new SqlParameter("@VPItemPicUrl", viewPageItem.VPItemPicUrl), new SqlParameter("@CreateTime", viewPageItem.CreateTime), new SqlParameter("@IsDelete", viewPageItem.IsDelete));
return(rows > 0);
}
}
// 删
public bool Delete(W_ViewPageItem viewPageItem)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("delete from [W_ViewPageItem] where VPItemID=@VPItemID", new SqlParameter("@VPItemID", viewPageItem.VPItemID));
return(rows > 0);
}
}
public List <W_KeyWord> GetAll()
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
DataTable table = helper.ExecuteTable("select * from [W_KeyWord]");
return(SqlHelper.DataTableToEntities <W_KeyWord>(table) as List <W_KeyWord>);
}
}
// 删
public bool Delete(W_KeyWord keyWord)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("delete from [W_KeyWord] where KWID=@KWID", new SqlParameter("@KWID", keyWord.KWID));
return(rows > 0);
}
}
// 增
public bool Add(W_WeChatInfo weChatInfo)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("insert into [W_WeChatInfo] values (@WID,@AppID,@AppSecret,@Token,@WechatID,@AppNamespace,@CreateTime,@IsDelete)", new SqlParameter("@WID", weChatInfo.WID), new SqlParameter("@AppID", weChatInfo.AppID), new SqlParameter("@AppSecret", weChatInfo.AppSecret), new SqlParameter("@Token", weChatInfo.Token), new SqlParameter("@WechatID", weChatInfo.WechatID), new SqlParameter("@AppNamespace", weChatInfo.AppNamespace), new SqlParameter("@CreateTime", weChatInfo.CreateTime), new SqlParameter("@IsDelete", weChatInfo.IsDelete));
return(rows > 0);
}
}
// 改
public bool Update(W_KeyWord keyWord)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("update [W_KeyWord] set CataID=@CataID,WContent=@WContent,WOption=@WOption,WKey=@WKey,ResponseType=@ResponseType,ResourcesID=@ResourcesID,CreateTime=@CreateTime,IsDelete=@IsDelete where KWID=@KWID", new SqlParameter("@KWID", keyWord.KWID), new SqlParameter("@CataID", keyWord.CataID), new SqlParameter("@WContent", keyWord.WContent), new SqlParameter("@WOption", keyWord.WOption), new SqlParameter("@WKey", keyWord.WKey), new SqlParameter("@ResponseType", keyWord.ResponseType), new SqlParameter("@ResourcesID", keyWord.ResourcesID), new SqlParameter("@CreateTime", keyWord.CreateTime), new SqlParameter("@IsDelete", keyWord.IsDelete));
return(rows > 0);
}
}
// 增
public bool Add(W_KeyWord keyWord)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("insert into [W_KeyWord] values (@KWID,@CataID,@WContent,@WOption,@WKey,@ResponseType,@ResourcesID,@CreateTime,@IsDelete)", new SqlParameter("@KWID", keyWord.KWID), new SqlParameter("@CataID", keyWord.CataID), new SqlParameter("@WContent", keyWord.WContent), new SqlParameter("@WOption", keyWord.WOption), new SqlParameter("@WKey", keyWord.WKey), new SqlParameter("@ResponseType", keyWord.ResponseType), new SqlParameter("@ResourecesID", keyWord.ResourcesID), new SqlParameter("@CreateTime", keyWord.CreateTime), new SqlParameter("@IsDelete", keyWord.IsDelete));
return(rows > 0);
}
}
// 改
public bool Update(W_Resources resources)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("update [W_Resources] set CataID=@CataID,RContent=@RContent,RURL=@RURL,RHURL=@RHURL,RType=@RType,RTitle=@RTitle,RDescription=@RDescription,MediaID=@MediaID,CreateTime=@CreateTime,IsDelete=@IsDelete where RID=@RID", new SqlParameter("@RID", resources.RID), new SqlParameter("@CataID", resources.CataID), new SqlParameter("@RContent", resources.RContent), new SqlParameter("@RURL", resources.RURL), new SqlParameter("@RHURL", resources.RHURL), new SqlParameter("@RType", resources.RType), new SqlParameter("@RTitle", resources.RTitle), new SqlParameter("@RDescription", resources.RDescription), new SqlParameter("@MediaID", resources.MediaID), new SqlParameter("@CreateTime", resources.CreateTime), new SqlParameter("@IsDelete", resources.IsDelete));
return(rows > 0);
}
}
// 删
public bool Delete(W_Resources resources)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("delete from [W_Resources] where RID=@RID", new SqlParameter("@RID", resources.RID));
return(rows > 0);
}
}
// 增
public bool Add(W_Resources resources)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
int rows = helper.ExecuteNonQuery("insert into [W_Resources] values (@RID,@CataID,@RContent,@RURL,@RHURL,@RType,@RTitle,@RDescription,@MediaID,@CreateTime,@IsDelete)", new SqlParameter("@RID", resources.RID), new SqlParameter("@CataID", resources.CataID), new SqlParameter("@RContent", resources.RContent), new SqlParameter("@RURL", resources.RURL), new SqlParameter("@RHURL", resources.RHURL), new SqlParameter("@RType", resources.RType), new SqlParameter("@RTitle", resources.RTitle), new SqlParameter("@RDescription", resources.RDescription), new SqlParameter("@MediaID", resources.MediaID), new SqlParameter("@CreateTime", resources.CreateTime), new SqlParameter("@IsDelete", resources.IsDelete));
return(rows > 0);
}
}
// 查
public W_KeyWord GetById(string kwid)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
DataTable table = helper.ExecuteTable("select * from [W_KeyWord] where KWID=@KWID", new SqlParameter("@KWID", kwid));
DataRowCollection rows = table.Rows;
if (rows.Count > 0)
{
DataRow row = rows[0];
return(SqlHelper.DataRowToEntity <W_KeyWord>(row));
}
else
{
return(null);
}
}
}
// 查
public W_ViewPageItem GetById(string vpitemid)
{
using (SqlHelper helper = WechatDataBaseHelper.Create())
{
DataTable table = helper.ExecuteTable("select * from [W_ViewPageItem] where VPItemID=@VPItemID", new SqlParameter("@KWID", vpitemid));
DataRowCollection rows = table.Rows;
if (rows.Count > 0)
{
DataRow row = rows[0];
return(SqlHelper.DataRowToEntity <W_ViewPageItem>(row));
}
else
{
return(null);
}
}
}
