public static void Add(ProductModel info)
{
string sql = @"INSERT INTO odnshop_product(
productname ,
includepicpath ,
productpics,
iscommend,
productcode ,
description ,
specification ,
salecount ,
hits ,productcount,
price,itemprice,categoryid,createtime) VALUES (?productname,?includepicpath,?productpics,?iscommend,?productcode,?description,?specification,?salecount,?hits,?productcount,?price,?itemprice,?categoryid,?createtime)";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?productname", MySqlDbType.VarChar, 50, info.productname),
MySqlDbHelper.MakeInParam("?includepicpath", MySqlDbType.VarChar, 50, info.includepicpath),
MySqlDbHelper.MakeInParam("?productpics", MySqlDbType.MediumText, 0, info.productpics),
MySqlDbHelper.MakeInParam("?iscommend", MySqlDbType.Bit, 1, info.iscommend),
MySqlDbHelper.MakeInParam("?productcode", MySqlDbType.Int32, 4, info.productcode),
MySqlDbHelper.MakeInParam("?description", MySqlDbType.VarChar, 0, info.description),
MySqlDbHelper.MakeInParam("?specification", MySqlDbType.VarChar, 0, info.specification),
MySqlDbHelper.MakeInParam("?salecount", MySqlDbType.Int32, 4, info.salecount),
MySqlDbHelper.MakeInParam("?hits", MySqlDbType.Int32, 4, info.hits),
MySqlDbHelper.MakeInParam("?productcount", MySqlDbType.Int32, 4, info.productcount),
MySqlDbHelper.MakeInParam("?price", MySqlDbType.Decimal, 8, info.price),
MySqlDbHelper.MakeInParam("?itemprice", MySqlDbType.VarChar, 0, info.itemprice),
MySqlDbHelper.MakeInParam("?categoryid", MySqlDbType.Int32, 4, info.categoryid),
MySqlDbHelper.MakeInParam("?createtime", MySqlDbType.Date, 8, info.createtime)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void Update(UserModel info)
{
string sql = @"update odnshop_user set
nickname = ?nickname,
openid = ?openid,
fullname = ?fullname,
sex = ?sex,
tel = ?tel,
address = ?address,
headpicurl = ?headpicurl,
jbnum = ?jbnum,
jfnum = ?jfnum,
createdate = ?createdate,
fromuid = ?fromuid,
usertype = ?usertype where uid = ?uid";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?nickname", MySqlDbType.VarChar, 50, info.nickname),
MySqlDbHelper.MakeInParam("?openid", MySqlDbType.VarChar, 255, info.openid),
MySqlDbHelper.MakeInParam("?fullname", MySqlDbType.VarChar, 50, info.fullname),
MySqlDbHelper.MakeInParam("?sex", MySqlDbType.VarChar, 50, info.sex),
MySqlDbHelper.MakeInParam("?tel", MySqlDbType.VarChar, 50, info.tel),
MySqlDbHelper.MakeInParam("?address", MySqlDbType.VarChar, 50, info.address),
MySqlDbHelper.MakeInParam("?headpicurl", MySqlDbType.VarChar, 255, info.headpicurl),
MySqlDbHelper.MakeInParam("?jbnum", MySqlDbType.Int32, 4, info.jbnum),
MySqlDbHelper.MakeInParam("?jfnum", MySqlDbType.Int32, 4, info.jfnum),
MySqlDbHelper.MakeInParam("?createdate", MySqlDbType.Date, 8, info.createdate),
MySqlDbHelper.MakeInParam("?fromuid", MySqlDbType.Int32, 4, info.fromuid),
MySqlDbHelper.MakeInParam("?usertype", MySqlDbType.Int32, 4, info.usertype),
MySqlDbHelper.MakeInParam("?uid", MySqlDbType.Int32, 4, info.uid)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void UpdateUsertype(int uid, int usertype)
{
string sql = @"update odnshop_user set usertype=?usertype where uid = ?uid";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?usertype", MySqlDbType.Int32, 4, usertype),
MySqlDbHelper.MakeInParam("?uid", MySqlDbType.Int32, 4, uid)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void UpdateOrderStatus(string orderno, int orderstatus)
{
string sql = "UPDATE odnshop_order set orderstatus=?orderstatus where orderno=?orderno";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?orderstatus", MySqlDbType.Int32, 4, orderstatus),
MySqlDbHelper.MakeInParam("?orderno", MySqlDbType.VarChar, 32, orderno)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void UpdateStatus(int orderstatus, int orderid)
{
string sql = "UPDATE odnshop_order set orderstatus=?orderstatus where orderid=?orderid";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?orderstatus", MySqlDbType.Int32, 4, orderstatus),
MySqlDbHelper.MakeInParam("?orderid", MySqlDbType.Int32, 4, orderid)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void Update(ProductCategoryModel info)
{
string sql = @"update odnshop_productcategory set categoryname = ?categoryname,orderid = ?orderid,parentid = ?parentid where categoryid = ?categoryid";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?categoryname", MySqlDbType.VarChar, 50, info.categoryname),
MySqlDbHelper.MakeInParam("?orderid", MySqlDbType.Int32, 4, info.orderid),
MySqlDbHelper.MakeInParam("?parentid", MySqlDbType.Int32, 4, info.parentid),
MySqlDbHelper.MakeInParam("?categoryid", MySqlDbType.Int32, 4, info.categoryid)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void Add(FavoriteModel info)
{
string sql = @"INSERT INTO odnshop_favorite (uid,productid,createtime,productxml) VALUES (?uid,?productid,?createtime,?productxml)";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?uid", MySqlDbType.Int32, 4, info.uid),
MySqlDbHelper.MakeInParam("?productid", MySqlDbType.Int32, 4, info.productid),
MySqlDbHelper.MakeInParam("?createtime", MySqlDbType.Datetime, 8, info.createtime),
MySqlDbHelper.MakeInParam("?productxml", MySqlDbType.VarChar, 0, SerializeHelper.SaveToString(info.product))
};
MySqlDbHelper.Query(sql, parameters);
}
//salecount,增加的销量=减少的库存量
public static void UpdateSalecount(int productid, int salecount)
{
string sql = @"UPDATE odnshop_product set
salecount=salecount+?salecount ,
productcount=productcount-?salecount WHERE productid = ?productid";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?salecount", MySqlDbType.Int32, 4, salecount),
MySqlDbHelper.MakeInParam("?productcount", MySqlDbType.Int32, 4, salecount),
MySqlDbHelper.MakeInParam("?productid", MySqlDbType.Int32, 4, productid)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void Add(ProductCategoryModel info)
{
string sql = @"INSERT INTO odnshop_productcategory (
categoryname ,
orderid ,
parentid) VALUES (?categoryname,?orderid,?parentid)";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?categoryname", MySqlDbType.VarChar, 50, info.categoryname),
MySqlDbHelper.MakeInParam("?orderid", MySqlDbType.Int32, 4, info.orderid),
MySqlDbHelper.MakeInParam("?parentid", MySqlDbType.Int32, 4, info.parentid)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void Update(UserGroupModel info)
{
string sql = "UPDATE odnshop_usergroup set groupname=?groupname,picurl=?picurl,grouplevel=?grouplevel,isdefalut=?isdefalut,upgradejf=?upgradejf,discount=?discount where groupid=?groupid";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?groupname", MySqlDbType.VarChar, 50, info.groupname),
MySqlDbHelper.MakeInParam("?picurl", MySqlDbType.VarChar, 50, info.picurl),
MySqlDbHelper.MakeInParam("?grouplevel", MySqlDbType.VarChar, 100, info.grouplevel),
MySqlDbHelper.MakeInParam("?isdefalut", MySqlDbType.Int32, 4, info.isdefalut?1:0),
MySqlDbHelper.MakeInParam("?upgradejf", MySqlDbType.Int32, 4, info.upgradejf),
MySqlDbHelper.MakeInParam("?discount", MySqlDbType.Date, 8, info.discount),
MySqlDbHelper.MakeInParam("?groupid", MySqlDbType.Int32, 4, info.groupid)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void Update(OrderModel info)
{
string sql = "UPDATE odnshop_order set customername=?customername,tel=?tel,address=?address,orderstatus=?orderstatus,deliverstatus=?deliverstatus,createtime=?createtime,orderxml=?orderxml where orderid=?orderid";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?customername", MySqlDbType.VarChar, 50, info.customername),
MySqlDbHelper.MakeInParam("?tel", MySqlDbType.VarChar, 50, info.tel),
MySqlDbHelper.MakeInParam("?address", MySqlDbType.VarChar, 100, info.address),
MySqlDbHelper.MakeInParam("?orderstatus", MySqlDbType.Int32, 4, info.orderstatus),
MySqlDbHelper.MakeInParam("?deliverstatus", MySqlDbType.Int32, 4, info.deliverstatus),
MySqlDbHelper.MakeInParam("?createtime", MySqlDbType.Date, 8, info.createtime),
MySqlDbHelper.MakeInParam("?orderxml", MySqlDbType.VarChar, 0, SerializeHelper.SaveToString(info)),
MySqlDbHelper.MakeInParam("?orderid", MySqlDbType.Int32, 4, info.orderid)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void Add(OrderModel info)
{
string sql = @"INSERT INTO odnshop_order (orderno,uid,customername,tel,address,orderstatus,deliverstatus,createtime,orderxml) VALUES (?orderno,?uid,?customername,?tel,?address,?orderstatus,?deliverstatus,?createtime,?orderxml)";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?orderno", MySqlDbType.VarChar, 32, info.orderno),
MySqlDbHelper.MakeInParam("?uid", MySqlDbType.Int32, 4, info.uid),
MySqlDbHelper.MakeInParam("?customername", MySqlDbType.VarChar, 50, info.customername),
MySqlDbHelper.MakeInParam("?tel", MySqlDbType.VarChar, 50, info.tel),
MySqlDbHelper.MakeInParam("?address", MySqlDbType.VarChar, 100, info.address),
MySqlDbHelper.MakeInParam("?orderstatus", MySqlDbType.Int32, 4, info.orderstatus),
MySqlDbHelper.MakeInParam("?deliverstatus", MySqlDbType.Int32, 4, info.deliverstatus),
MySqlDbHelper.MakeInParam("?createtime", MySqlDbType.Datetime, 8, info.createtime),
MySqlDbHelper.MakeInParam("?orderxml", MySqlDbType.VarChar, 0, SerializeHelper.SaveToString(info))
};
MySqlDbHelper.Query(sql, parameters);
}
public static void Add(UserModel info)
{
string sql = @"INSERT INTO odnshop_user(nickname,openid,fullname,sex,tel,address,headpicurl,jbnum,jfnum,createdate,fromuid,usertype) VALUES(?nickname,?openid,?fullname,?sex,?tel,?address,?headpicurl,?jbnum,?jfnum,?createdate,?fromuid,?usertype)";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?nickname", MySqlDbType.VarChar, 50, info.nickname),
MySqlDbHelper.MakeInParam("?openid", MySqlDbType.VarChar, 255, info.openid),
MySqlDbHelper.MakeInParam("?fullname", MySqlDbType.VarChar, 50, info.fullname),
MySqlDbHelper.MakeInParam("?sex", MySqlDbType.VarChar, 50, info.sex),
MySqlDbHelper.MakeInParam("?tel", MySqlDbType.VarChar, 50, info.tel),
MySqlDbHelper.MakeInParam("?address", MySqlDbType.VarChar, 50, info.address),
MySqlDbHelper.MakeInParam("?headpicurl", MySqlDbType.VarChar, 255, info.headpicurl),
MySqlDbHelper.MakeInParam("?jbnum", MySqlDbType.Int32, 4, info.jbnum),
MySqlDbHelper.MakeInParam("?jfnum", MySqlDbType.Int32, 4, info.jfnum),
MySqlDbHelper.MakeInParam("?createdate", MySqlDbType.Datetime, 8, info.createdate),
MySqlDbHelper.MakeInParam("?fromuid", MySqlDbType.Int32, 4, info.fromuid),
MySqlDbHelper.MakeInParam("?usertype", MySqlDbType.Int32, 4, info.usertype)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void UpdateJb(int uid, int jb)
{
int jbnum = 0;
string sql = string.Empty;
if (jb >= 0)
{
jbnum = jb;
sql = @"update odnshop_user set jbnum=jbnum+?jbnum where uid = ?uid";
}
else
{
jbnum = -jb;
sql = @"update odnshop_user set jbnum=jbnum-?jbnum where uid = ?uid";
}
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?jbnum", MySqlDbType.Int32, 4, jbnum),
MySqlDbHelper.MakeInParam("?uid", MySqlDbType.Int32, 4, uid)
};
MySqlDbHelper.Query(sql, parameters);
}
public static void Update(ProductModel info)
{
string sql = @"UPDATE odnshop_product set
productname=?productname ,
includepicpath=?includepicpath ,
productpics=?productpics,
iscommend = ?iscommend ,
productcode=?productcode ,
description=?description ,
specification=?specification ,
salecount=?salecount ,
hits=?hits ,
productcount=?productcount,
price=?price,itemprice=?itemprice,categoryid=?categoryid,createtime=?createtime WHERE productid = ?productid";
MySqlParameter[] parameters =
{
MySqlDbHelper.MakeInParam("?productname", MySqlDbType.VarChar, 50, info.productname),
MySqlDbHelper.MakeInParam("?includepicpath", MySqlDbType.VarChar, 50, info.includepicpath),
MySqlDbHelper.MakeInParam("?productpics", MySqlDbType.MediumText, 0, info.productpics),
MySqlDbHelper.MakeInParam("?iscommend", MySqlDbType.Int16, 1, info.iscommend),
MySqlDbHelper.MakeInParam("?productcode", MySqlDbType.Int32, 4, info.productcode),
MySqlDbHelper.MakeInParam("?description", MySqlDbType.VarChar, 0, info.description),
MySqlDbHelper.MakeInParam("?specification", MySqlDbType.VarChar, 0, info.specification),
MySqlDbHelper.MakeInParam("?salecount", MySqlDbType.Int32, 4, info.salecount),
MySqlDbHelper.MakeInParam("?hits", MySqlDbType.Int32, 4, info.hits),
MySqlDbHelper.MakeInParam("?productcount", MySqlDbType.Int32, 4, info.productcount),
MySqlDbHelper.MakeInParam("?price", MySqlDbType.Decimal, 8, info.price),
MySqlDbHelper.MakeInParam("?itemprice", MySqlDbType.VarChar, 0, info.itemprice),
MySqlDbHelper.MakeInParam("?categoryid", MySqlDbType.Int32, 4, info.categoryid),
MySqlDbHelper.MakeInParam("?createtime", MySqlDbType.Datetime, 8, info.createtime),
MySqlDbHelper.MakeInParam("?productid", MySqlDbType.Int32, 4, info.productid)
};
MySqlDbHelper.Query(sql, parameters);
}
