/// <summary> /// 增加一条地区数据 /// </summary> /// <param name="region">地区模型变量</param> public int AddRegion(RegionInfo region) { SqlParameter[] parameters = { new SqlParameter("@fatherID", SqlDbType.Int), new SqlParameter("@orderID", SqlDbType.Int), new SqlParameter("@regionName", SqlDbType.NVarChar) }; parameters[0].Value = region.FatherID; parameters[1].Value = region.OrderID; parameters[2].Value = region.RegionName; Object id = ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddRegion", parameters); return(Convert.ToInt32(id)); }
/// <summary> /// 检查用户名是否被占用 /// </summary> /// <param name="userName">用户名</param> /// <returns></returns> public int CheckUserName(string userName) { int userID = 0; SqlParameter[] parameters = { new SqlParameter("@userName", SqlDbType.NVarChar) }; parameters[0].Value = userName; object obj = ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "CheckUserName", parameters); if (obj != null && obj != DBNull.Value) { userID = Convert.ToInt32(obj); } return(userID); }
/// <summary> /// 增加一条链接数据 /// </summary> /// <param name="link">链接模型变量</param> public int AddLink(LinkInfo link) { SqlParameter[] parameters = { new SqlParameter("@linkClass", SqlDbType.Int), new SqlParameter("@display", SqlDbType.NVarChar), new SqlParameter("@uRL", SqlDbType.NVarChar), new SqlParameter("@orderID", SqlDbType.Int), new SqlParameter("@remark", SqlDbType.NVarChar) }; parameters[0].Value = link.LinkClass; parameters[1].Value = link.Display; parameters[2].Value = link.URL; parameters[3].Value = link.OrderID; parameters[4].Value = link.Remark; Object id = ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddLink", parameters); return(Convert.ToInt32(id)); }
/// <summary> /// 在指定的id前剩余的积分 /// </summary> /// <param name="id"></param> /// <param name="userID"></param> /// <returns></returns> public int ReadPointLeftBeforID(int id, int userID) { int pointLeft = 0; SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@userID", SqlDbType.Int) }; parameters[0].Value = id; parameters[1].Value = userID; Object oj = ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "ReadPointLeftBeforID", parameters); if (oj != DBNull.Value) { pointLeft = Convert.ToInt32(oj); } return(pointLeft); }
/// <summary> /// 在指定的id前剩余的资金 /// </summary> /// <param name="id"></param> /// <param name="userID"></param> /// <returns></returns> public decimal ReadMoneyLeftBeforID(int id, int userID) { decimal moneyLeft = 0; SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int), new SqlParameter("@userID", SqlDbType.Int) }; parameters[0].Value = id; parameters[1].Value = userID; Object oj = ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "ReadMoneyLeftBeforID", parameters); if (oj != DBNull.Value) { moneyLeft = Convert.ToDecimal(oj); } return(moneyLeft); }
/// <summary> /// 增加一条缺货登记数据 /// </summary> /// <param name="bookingProduct">缺货登记模型变量</param> public int AddBookingProduct(BookingProductInfo bookingProduct) { SqlParameter[] parameters = { new SqlParameter("@productID", SqlDbType.Int), new SqlParameter("@productName", SqlDbType.NVarChar), new SqlParameter("@relationUser", SqlDbType.NVarChar), new SqlParameter("@email", SqlDbType.NVarChar), new SqlParameter("@tel", SqlDbType.NVarChar), new SqlParameter("@userNote", SqlDbType.NVarChar), new SqlParameter("@bookingDate", SqlDbType.DateTime), new SqlParameter("@bookingIP", SqlDbType.NVarChar), new SqlParameter("@isHandler", SqlDbType.Int), new SqlParameter("@handlerDate", SqlDbType.DateTime), new SqlParameter("@handlerAdminID", SqlDbType.Int), new SqlParameter("@handlerAdminName", SqlDbType.NVarChar), new SqlParameter("@handlerNote", SqlDbType.NVarChar), new SqlParameter("@userID", SqlDbType.Int), new SqlParameter("@userName", SqlDbType.NVarChar) }; parameters[0].Value = bookingProduct.ProductID; parameters[1].Value = bookingProduct.ProductName; parameters[2].Value = bookingProduct.RelationUser; parameters[3].Value = bookingProduct.Email; parameters[4].Value = bookingProduct.Tel; parameters[5].Value = bookingProduct.UserNote; parameters[6].Value = bookingProduct.BookingDate; parameters[7].Value = bookingProduct.BookingIP; parameters[8].Value = bookingProduct.IsHandler; parameters[9].Value = bookingProduct.HandlerDate; parameters[10].Value = bookingProduct.HandlerAdminID; parameters[11].Value = bookingProduct.HandlerAdminName; parameters[12].Value = bookingProduct.HandlerNote; parameters[13].Value = bookingProduct.UserID; parameters[14].Value = bookingProduct.UserName; Object id = ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddBookingProduct", parameters); return(Convert.ToInt32(id)); }
/// <summary> /// 增加一条商品回复数据 /// </summary> /// <param name="productReply">商品回复模型变量</param> public int AddProductReply(ProductReplyInfo productReply) { SqlParameter[] parameters = { new SqlParameter("@productID", SqlDbType.Int), new SqlParameter("@commentID", SqlDbType.Int), new SqlParameter("@content", SqlDbType.NText), new SqlParameter("@userIP", SqlDbType.NVarChar), new SqlParameter("@postDate", SqlDbType.DateTime), new SqlParameter("@userID", SqlDbType.Int), new SqlParameter("@userName", SqlDbType.NVarChar) }; parameters[0].Value = productReply.ProductID; parameters[1].Value = productReply.CommentID; parameters[2].Value = productReply.Content; parameters[3].Value = productReply.UserIP; parameters[4].Value = productReply.PostDate; parameters[5].Value = productReply.UserID; parameters[6].Value = productReply.UserName; Object id = ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddProductReply", parameters); return(Convert.ToInt32(id)); }
/// <summary> /// 增加一条菜单数据 /// </summary> /// <param name="Menu">菜单模型变量</param> public int AddMenu(MenuInfo Menu) { SqlParameter[] parameters = { new SqlParameter("@fatherID", SqlDbType.Int), new SqlParameter("@orderID", SqlDbType.Int), new SqlParameter("@menuName", SqlDbType.NVarChar), new SqlParameter("@menuImage", SqlDbType.Int), new SqlParameter("@uRL", SqlDbType.NVarChar), new SqlParameter("@date", SqlDbType.DateTime), new SqlParameter("@iP", SqlDbType.NVarChar) }; parameters[0].Value = Menu.FatherID; parameters[1].Value = Menu.OrderID; parameters[2].Value = Menu.MenuName; parameters[3].Value = Menu.MenuImage; parameters[4].Value = Menu.URL; parameters[5].Value = Menu.Date; parameters[6].Value = Menu.IP; Object id = ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "AddMenu", parameters); return(Convert.ToInt32(id)); }
/// <summary> /// 检查购物车是否存在该商品(普通商品购买需判断) /// </summary> /// <param name="productID"></param> /// <param name="productName"></param> /// <param name="userID"></param> public bool IsProductInCart(int productID, string productName, int userID) { bool isIn = false; SqlParameter[] parameters = { new SqlParameter("@productID", SqlDbType.Int), new SqlParameter("@productName", SqlDbType.NVarChar), new SqlParameter("@userID", SqlDbType.Int) }; parameters[0].Value = productID; parameters[1].Value = productName; parameters[2].Value = userID; object oj = ShopMssqlHelper.ExecuteScalar(ShopMssqlHelper.TablePrefix + "IsProductInCart", parameters); if (oj != null && oj != DBNull.Value) { if (Convert.ToUInt32(oj) > 0) { isIn = true; } } return(isIn); }