/// <summary>
/// 新增订单信息
/// </summary>
/// <param name="_uid"></param>
/// <param name="_truename"></param>
/// <param name="_address"></param>
/// <param name="_zipcode"></param>
/// <param name="_mobiletel"></param>
/// <returns></returns>
public bool NewOrder(string _uid, string _truename, string _address, string _zipcode, string _mobiletel)
{
using (DbOperHandler _doh = new Common().Doh())
{
string _ordernum = GetProductOrderNum();//订单号
int page = 1;
int PSize = 1000;
int countNum = 0;
string sqlStr = "";
string joinStr = "A.[ProductId]=B.Id";
string whereStr1 = "A.State=0 AND A.UserId=" + _uid;
string whereStr2 = "State=0 AND UserId=" + _uid;
_doh.Reset();
_doh.ConditionExpress = whereStr2;
countNum = _doh.Count("jcms_normal_user_cart");
sqlStr = JumboECMS.Utils.SqlHelp.GetSql0("A.*,b.price1 as unitprice,(b.price1*a.buycount) as totalprice,b.id as productid,b.title as productname,b.img as productimg", "jcms_normal_user_cart", "jcms_module_product", "Id", PSize, page, "desc", joinStr, whereStr1, whereStr2);
_doh.Reset();
_doh.SqlCmd = sqlStr;
DataTable dt = _doh.GetDataTable();
if (dt.Rows.Count == 0)
{
return(false);
}
float _money = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
JumboECMS.Entity.Normal_UserGoods _goods = new JumboECMS.Entity.Normal_UserGoods();
_goods.UserId = Str2Int(_uid);
_goods.OrderNum = _ordernum;
_goods.ProductId = Str2Int(dt.Rows[i]["ProductId"].ToString());
_goods.ProductName = dt.Rows[i]["ProductName"].ToString();
_goods.ProductImg = dt.Rows[i]["ProductImg"].ToString();
_goods.ProductLink = dt.Rows[i]["ProductLink"].ToString();
_goods.UnitPrice = Convert.ToSingle(dt.Rows[i]["UnitPrice"].ToString());
_goods.BuyCount = Str2Int(dt.Rows[i]["BuyCount"].ToString());
_goods.TotalPrice = Convert.ToSingle(dt.Rows[i]["TotalPrice"].ToString());
new JumboECMS.DAL.Normal_UserGoodsDAL().NewGoods(_goods);
_money += _goods.TotalPrice;
}
dt.Clear();
dt.Dispose();
_doh.Reset();
_doh.AddFieldItem("UserId", _uid);
_doh.AddFieldItem("OrderNum", _ordernum);
_doh.AddFieldItem("TrueName", _truename);
_doh.AddFieldItem("Address", _address);
_doh.AddFieldItem("ZipCode", _zipcode);
_doh.AddFieldItem("MobileTel", _mobiletel);
_doh.AddFieldItem("Money", _money);
_doh.AddFieldItem("State", 0);
_doh.AddFieldItem("OrderTime", DateTime.Now.ToString());
_doh.AddFieldItem("OrderIP", IPHelp.ClientIP);
_doh.Insert("jcms_normal_user_order");
_doh.Reset();
_doh.SqlCmd = string.Format("UPDATE [jcms_normal_user_cart] SET [State]=1 WHERE UserId={0}", _uid);
_doh.ExecuteSqlNonQuery();
return(true);
}
}
/// <summary>
/// 新增购物信息
/// </summary>
/// <param name="_goods"></param>
/// <returns></returns>
public int NewGoods(JumboECMS.Entity.Normal_UserGoods _goods)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.AddFieldItem("UserId", _goods.UserId);
_doh.AddFieldItem("OrderNum", _goods.OrderNum);
_doh.AddFieldItem("ProductId", _goods.ProductId);
_doh.AddFieldItem("ProductName", _goods.ProductName);
_doh.AddFieldItem("ProductImg", _goods.ProductImg);
_doh.AddFieldItem("ProductLink", _goods.ProductLink);
_doh.AddFieldItem("UnitPrice", _goods.UnitPrice);
_doh.AddFieldItem("BuyCount", _goods.BuyCount);
_doh.AddFieldItem("TotalPrice", _goods.TotalPrice);
_doh.AddFieldItem("State", 0);
_doh.AddFieldItem("GoodsTime", DateTime.Now.ToString());
int _newid = _doh.Insert("jcms_normal_user_goods");
return(_newid);
}
}
