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