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