public static bool AddCart(orderinfo item)
{
SqlParameter[] parms = new SqlParameter[7];
parms[0] = new SqlParameter("@id", SqlDbType.VarChar, 20);
parms[0].Direction = ParameterDirection.Output;
parms[1] = new SqlParameter("@productid", SqlDbType.NVarChar,50);
parms[1].Value = item.productid;
parms[2] = new SqlParameter("@userid", SqlDbType.NVarChar, 50);
parms[2].Value = item.userid;
parms[3] = new SqlParameter("adddate", SqlDbType.DateTime);
parms[3].Value = item.adddate;
parms[4] = new SqlParameter("@vipprice", SqlDbType.Decimal);
parms[4].Value = item.vipprice;
parms[5] = new SqlParameter("@buynum", SqlDbType.Int);
parms[5].Value =item.buynum;
parms[6] = new SqlParameter("@cartstate", SqlDbType.Int);
parms[6].Value = item.cartstate;
string sql = "exec dbo.www_getno 'usercart',10,@id output " +
"Insert into usercart(cartid,productid,userid,adddate,vipprice,buynum,cartstate) VALUES (@id,@productid,@userid,@adddate,@vipprice,@buynum,@cartstate)";
int result = 0;
try
{
result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
return result > 0;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
}
public string addcart(string productid, string userid, string buynum)
{
int pid = TypeParse.DbObjToInt(productid, 0);
int bnum = TypeParse.DbObjToInt(buynum, 1);
productinfo item = product.getproductinfo(pid);
bool cz = order.CheckCart(userid, pid);
if (cz)
{
string jstr = "{'productid':'" + productid + "','userid':'" + userid + "','buynum':'" + buynum + "'}";
return jstr;
}
else
{
orderinfo data = new orderinfo();
data.productid = pid;
data.vipprice = item.vipprice;
data.userid = userid;
data.buynum = bnum;
data.adddate = DateTime.Now;
bool result = order.AddCart(data);
if (result)
{
return "t";
}
else
{
return "f";
}
}
}
/// <summary>
/// 生成订单
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static bool addorder(orderinfo data)
{
SqlParameter[] parms = new SqlParameter[14];
parms[0] = new SqlParameter("@id", SqlDbType.VarChar, 20);
parms[0].Direction = ParameterDirection.Output;
parms[1] = new SqlParameter("@ordernumber", SqlDbType.NVarChar, 50);
parms[1].Value = data.ordernumber;
parms[2] = new SqlParameter("@orderdate", SqlDbType.DateTime);
parms[2].Value = data.orderdate;
parms[3] = new SqlParameter("@deliverydate", SqlDbType.DateTime);
parms[3].Value = data.deliverydate;
parms[4] = new SqlParameter("@allmoney", SqlDbType.Decimal);
parms[4].Value = data.allmoney;
parms[5] = new SqlParameter("@paymoney", SqlDbType.Decimal);
parms[5].Value = data.paymoney;
parms[6] = new SqlParameter("@orderstate", SqlDbType.Int);
parms[6].Value = data.orderstate;
parms[7] = new SqlParameter("@userid", SqlDbType.NVarChar,50);
parms[7].Value = data.userid;
parms[8] = new SqlParameter("@address", SqlDbType.VarChar, 50);
parms[8].Value = data.address;
parms[9] = new SqlParameter("@contact", SqlDbType.VarChar, 10);
parms[9].Value = data.contact;
parms[10] = new SqlParameter("@mobile", SqlDbType.VarChar, 30);
parms[10].Value = data.mobile;
parms[11] = new SqlParameter("@tel", SqlDbType.VarChar, 30);
parms[11].Value = data.tel;
parms[12] = new SqlParameter("@deliveryIid", SqlDbType.Int);
parms[12].Value = data.deliveryIid;
parms[13] = new SqlParameter("@deliveryIIid", SqlDbType.Int);
parms[13].Value = data.deliveryIIid;
string sql = "exec dbo.www_getno 'userorder',10,@id output " +
"insert into [userorder] (orderid,ordernumber,orderdate,deliverydate,allmoney,paymoney,orderstate,userid,address,contact,mobile,tel,deliveryIid,deliveryIIid) values(@id,@ordernumber,@orderdate,@deliverydate,@allmoney,@paymoney,@orderstate,@userid,@address,@contact,@mobile,@tel,@deliveryIid,@deliveryIIid)";
int result = 0;
try
{
result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return result > 0;
}
public static List<orderinfo> getphlist(string condition)
{
List<orderinfo> list = new List<orderinfo>();
string sql = "select sum(usercart.buynum) as n,product.productcode,product.productimg,product.productname from usercart,userorder,product where usercart.ordernumber=userorder.ordernumber and usercart.productid=product.productid "+condition+" group by usercart.productid,product.productcode,product.productname,product.productimg";
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.connectionstring, CommandType.Text, sql).Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
orderinfo item = new orderinfo();
item.tjbuynum = TypeParse.DbObjToInt(dr["n"].ToString(), 0);
item.productname = TypeParse.DbObjToString(dr["productname"].ToString(), "");
item.productcode = TypeParse.DbObjToString(dr["productcode"].ToString(), "");
item.productimg = TypeParse.DbObjToString(dr["productimg"].ToString(), "");
list.Add(item);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return list;
}
/// <summary>
/// 得到订单列表
/// </summary>
/// <param name="pdata"></param>
/// <returns></returns>
public static List<orderinfo> getorderlist(pageinfo pdata)
{
List<orderinfo> list = new List<orderinfo>();
try
{
DataTable dt = pagehelper.getpagedt(pdata);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
orderinfo item = new orderinfo();
item.orderid = TypeParse.DbObjToString(dr["orderid"].ToString(),"0");
item.tel = TypeParse.DbObjToString(dr["tel"].ToString(), "");
item.mobile = TypeParse.DbObjToString(dr["mobile"].ToString(), "");
item.address = TypeParse.DbObjToString(dr["address"].ToString(), "");
item.contact = TypeParse.DbObjToString(dr["contact"].ToString(), "");
item.allmoney =Decimal.Parse(TypeParse.DbObjToString(dr["allmoney"].ToString(), "0.00"));
item.paymoney =Decimal.Parse(TypeParse.DbObjToString(dr["paymoney"].ToString(), "0.00"));
item.orderstate = TypeParse.DbObjToInt(dr["orderstate"].ToString(), 0);
item.orderdate = TypeParse.DbObjToDateTime(dr["orderdate"].ToString(), DateTime.Now);
item.deliverydate = TypeParse.DbObjToDateTime(dr["deliverydate"].ToString(), DateTime.Now);
item.ordernumber = TypeParse.DbObjToString(dr["ordernumber"].ToString(), "");
item.deliveryI = TypeParse.DbObjToString(dr["deliveryI"].ToString(), "");
item.deliveryII = TypeParse.DbObjToString(dr["deliveryII"].ToString(), "");
switch (item.orderstate)
{
case 0:
item.orderstatestr = "进行中";
break;
case 10:
item.orderstatestr = "已完成";
break;
case 44:
item.orderstatestr = "待处理";
break;
default:
item.orderstatestr = "进行中";
break;
}
list.Add(item);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return list;
}
/// <summary>
/// 得到单个订单信息
/// </summary>
/// <param name="orderid"></param>
/// <returns></returns>
public static orderinfo getorderinfo(string orderid)
{
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@orderid", SqlDbType.NVarChar,50);
parms[0].Value = orderid;
orderinfo item = new orderinfo();
string sql = "select a.orderid,a.ordernumber,a.allmoney,a.paymoney,a.deliveryIid,a.deliveryIIid,a.orderdate,a.deliverydate,a.orderstate,a.contact,a.tel,a.mobile,a.address,c.deliveryI,d.deliveryII from [userorder] a,deliveryI c,deliveryII d where a.deliveryIid=c.deliveryIid and a.deliveryIIid=d.deliveryIIid and orderid=@orderid";
try
{
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionstring, CommandType.Text, sql, parms);
if (dr.Read())
{
item.orderid = TypeParse.DbObjToString(dr["orderid"].ToString(), "0");
item.tel = TypeParse.DbObjToString(dr["tel"].ToString(), "");
item.ordernumber = TypeParse.DbObjToString(dr["ordernumber"].ToString(), "");
item.mobile = TypeParse.DbObjToString(dr["mobile"].ToString(), "");
item.address = TypeParse.DbObjToString(dr["address"].ToString(), "");
item.contact = TypeParse.DbObjToString(dr["contact"].ToString(), "");
item.allmoney = Decimal.Parse(TypeParse.DbObjToString(dr["allmoney"].ToString(), "0.00"));
item.paymoney = Decimal.Parse(TypeParse.DbObjToString(dr["paymoney"].ToString(), "0.00"));
item.orderstate = TypeParse.DbObjToInt(dr["orderstate"].ToString(), 0);
item.orderdate = TypeParse.DbObjToDateTime(dr["orderdate"].ToString(), DateTime.Now);
item.deliverydate = TypeParse.DbObjToDateTime(dr["deliverydate"].ToString(), DateTime.Now);
item.ordernumber = TypeParse.DbObjToString(dr["ordernumber"].ToString(), "");
item.deliveryI = TypeParse.DbObjToString(dr["deliveryI"].ToString(), "");
item.deliveryII = TypeParse.DbObjToString(dr["deliveryII"].ToString(), "");
item.deliveryIid = TypeParse.DbObjToInt(dr["deliveryIid"].ToString(), 0);
item.deliveryIIid = TypeParse.DbObjToInt(dr["deliveryIIid"].ToString(), 0);
switch (item.orderstate)
{
case 0:
item.orderstatestr = "进行中";
break;
case 10:
item.orderstatestr = "已完成";
break;
case 44:
item.orderstatestr = "待处理";
break;
default:
item.orderstatestr = "进行中";
break;
}
dr.Close();
dr.Dispose();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return item;
}
public static List<orderinfo> getcartlistbyordernumber(string ordernumber)
{
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@ordernumber", SqlDbType.NVarChar, 50);
parms[0].Value = ordernumber;
List<orderinfo> list = new List<orderinfo>();
string sql = "select a.cartid,a.buynum,a.ordernumber,a.vipprice,a.userid, b.productname,b.productimg,b.productcode from usercart a,product b where a.ordernumber=@ordernumber and a.productid=b.productid";
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.connectionstring, CommandType.Text, sql, parms).Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
orderinfo item = new orderinfo();
item.cartid = TypeParse.DbObjToString(dr["cartid"].ToString(), "0");
item.buynum = TypeParse.DbObjToInt(dr["buynum"].ToString(), 0);
item.ordernumber = TypeParse.DbObjToString(dr["ordernumber"].ToString(), "");
item.vipprice =Decimal.Parse(TypeParse.DbObjToString(dr["vipprice"].ToString(), "0.00"));
item.userid = TypeParse.DbObjToString(dr["userid"].ToString(), "0");
item.productname = TypeParse.DbObjToString(dr["productname"].ToString(), "");
item.productcode = TypeParse.DbObjToString(dr["productcode"].ToString(), "");
item.productimg = TypeParse.DbObjToString(dr["productimg"].ToString(), "");
list.Add(item);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return list;
}
//根据购物车状态得到购物车产品
public static List<orderinfo> getcartlist(int state, string userid)
{
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@state", SqlDbType.Int);
parms[0].Value = state;
parms[1] = new SqlParameter("@userid", SqlDbType.NVarChar,50);
parms[1].Value = userid;
string sql;
List<orderinfo> list = new List<orderinfo>();
sql = "select a.cartid,a.vipprice,a.userid,a.productid,a.cartstate,a.adddate,a.buynum,b.productimg,b.productname from usercart a,product b where a.userid=@userid and a.productid=b.productid and a.cartstate=@state";
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.connectionstring, CommandType.Text, sql, parms).Tables[0];
foreach (DataRow dr in dt.Rows)
{
orderinfo item = new orderinfo();
item.cartid = TypeParse.DbObjToString(dr["cartid"].ToString(), "0");
item.productid = TypeParse.DbObjToInt(dr["productid"].ToString(), 0);
item.productname = TypeParse.DbObjToString(dr["productname"].ToString(), "");
item.cartstate = TypeParse.DbObjToInt(dr["cartstate"].ToString(), 0);
item.vipprice =Decimal.Parse(TypeParse.DbObjToString(dr["vipprice"].ToString(),"0.00"));
item.productimg = TypeParse.DbObjToString(dr["productimg"].ToString(), "");
item.buynum = TypeParse.DbObjToInt(dr["buynum"].ToString(), 1);
list.Add(item);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return list;
}
/// <summary>
///编辑订单
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static bool editorder(orderinfo data)
{
SqlParameter[] parms = new SqlParameter[5];
parms[0] = new SqlParameter("@id", SqlDbType.VarChar, 20);
parms[0].Value = data.orderid;
parms[1] = new SqlParameter("@deliverydate", SqlDbType.DateTime);
parms[1].Value = data.deliverydate;
parms[2] = new SqlParameter("@orderstate", SqlDbType.Int);
parms[2].Value = data.orderstate;
parms[3] = new SqlParameter("@deliveryIid", SqlDbType.Int);
parms[3].Value = data.deliveryIid;
parms[4] = new SqlParameter("@deliveryIIid", SqlDbType.Int);
parms[4].Value = data.deliveryIIid;
string sql = "update [userorder] set deliverydate=@deliverydate,orderstate=@orderstate,deliveryIid=@deliveryIid,deliveryIIid=@deliveryIIid where orderid=@id";
int result = 0;
try
{
result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return result > 0;
}
public string editorderinfo(string orderid, string d1, string d2, string deliverydate, string orderstate)
{
int d1id = TypeParse.DbObjToInt(d1, 0);
int d2id = TypeParse.DbObjToInt(d2, 0);
int state = TypeParse.DbObjToInt(orderstate, 0);
orderinfo data = new orderinfo();
data.deliverydate = TypeParse.DbObjToDateTime(deliverydate, DateTime.Now);
data.deliveryIid = d1id;
data.deliveryIIid = d2id;
data.orderstate = state;
data.orderid = orderid;
bool result = order.editorder(data);
if (result)
{
return "t";
}
else
{
return "f";
}
}
public string addorder(string ddate)
{
string uid = "";
int addressid;
if (HttpContext.Current.Request.Cookies["tfuid"] != null)
{
string userid = HttpContext.Current.Request.Cookies["tfuid"].Value.ToString();
uid = userid;
}
//是否有默认收货地址
List<addressinfo> alist = address.getaddressinfobyuid(uid);
if (alist.Count < 1)
{
return "address_f";
}
else
{
addressid = alist[0].addressid;
}
List<orderinfo> cartlist = order.getcartlist(0, uid);
int ccount = cartlist.Count;
if (ccount > 0)
{
userinfo udata = user.getuserinfo(uid);
decimal udiscount = udata.atdiscount;
decimal pmoney = order.getallprice(uid);
decimal dmoney = pmoney - pmoney * udiscount;
decimal paymoney = pmoney * udiscount;
orderinfo odata = new orderinfo();
odata.userid = uid;
odata.address = alist[0].address;
odata.contact = alist[0].contact;
odata.tel = alist[0].tel;
odata.mobile = alist[0].mobile;
odata.deliveryIid = alist[0].deliveryIid;
odata.deliveryIIid = alist[0].deliveryIIid;
odata.allmoney = pmoney;
odata.paymoney = paymoney;
odata.orderdate = DateTime.Now;
odata.ordernumber = order.getordernumber(uid);
odata.orderstate = 0;
DateTime dt;
if (DateTime.Now.Hour >= 16)
{
dt = DateTime.Now.AddDays(1);
}
else
{
dt = DateTime.Now;
}
odata.deliverydate = TypeParse.DbObjToDateTime(ddate, dt);
bool r1 = order.addorder(odata);
if (r1)
{
bool r2 = order.changecartstate(odata.ordernumber, uid);
if (r2)
{
return "t";
}
else
{
return "f";
}
}
else
{
return "f";
}
}
else
{
return "buynum_f";
}
}
