/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">Orders对象</param>
public int Add(ClassLibrary.Model.Orders model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("INSERT INTO {0}(", table));
strSql.Append("OrderNumber,UserName,proTotalPrice,proQuantity,Linkman,Fax,Mobile,Telphone,Email,IdentityCard,ContractType,Payment,Remark,Status,CreatedTime");
strSql.Append(") VALUES (");
strSql.Append("@OrderNumber,@UserName,@proTotalPrice,@proQuantity,@Linkman,@Fax,@Mobile,@Telphone,@Email,@IdentityCard,@ContractType,@Payment,@Remark,@Status,@CreatedTime)");
SqlParameter[] parameters =
{
new SqlParameter("@OrderNumber", SqlDbType.VarChar, 32),
new SqlParameter("@UserName", SqlDbType.NVarChar, 100),
new SqlParameter("@proTotalPrice", SqlDbType.Decimal, 9),
new SqlParameter("@Linkman", SqlDbType.NVarChar, 40),
new SqlParameter("@Fax", SqlDbType.NVarChar, 40),
new SqlParameter("@Mobile", SqlDbType.NVarChar, 40),
new SqlParameter("@Telphone", SqlDbType.NVarChar, 40),
new SqlParameter("@Email", SqlDbType.NVarChar, 100),
new SqlParameter("@IdentityCard", SqlDbType.NVarChar, 40),
new SqlParameter("@ContractType", SqlDbType.NVarChar, 20),
new SqlParameter("@Payment", SqlDbType.NVarChar, 40),
new SqlParameter("@Remark", SqlDbType.NVarChar, 400),
new SqlParameter("@Status", SqlDbType.NVarChar, 20),
new SqlParameter("@CreatedTime", SqlDbType.DateTime, 8),
new SqlParameter("@proQuantity", SqlDbType.NVarChar, 20)
};
parameters[0].Value = model.OrderNumber;
parameters[1].Value = model.UserName;
parameters[2].Value = model.proTotalPrice;
parameters[3].Value = model.Linkman;
parameters[4].Value = model.Fax;
parameters[5].Value = model.Mobile;
parameters[6].Value = model.Telphone;
parameters[7].Value = model.Email;
parameters[8].Value = model.IdentityCard;
parameters[9].Value = model.ContractType;
parameters[10].Value = model.Payment;
parameters[11].Value = model.Remark;
parameters[12].Value = model.Status;
parameters[13].Value = model.CreatedTime;
parameters[14].Value = model.proQuantity;
return(SQLHelper.Execute(strSql.ToString(), parameters));
}
//保存订单
protected void SaveOrder()
{
string orderNumber = DateTime.Now.ToString("yyMMddHHssmmff");
ClassLibrary.BLL.Orders orderBLL = new ClassLibrary.BLL.Orders();
ClassLibrary.BLL.OrderDetail detailBLL = new ClassLibrary.BLL.OrderDetail();
try
{
string[] products = Request.Form["productList"].Split('|');
ClassLibrary.Model.Orders orderModel = new ClassLibrary.Model.Orders();
orderModel.OrderNumber = orderNumber;
orderModel.UserName = "";
orderModel.proQuantity = Request.Form["adultnum"] + "," + Request.Form["childnum"];
orderModel.proTotalPrice = Convert.ToDecimal(Request.Form["totalPrice"]);
orderModel.Linkman = Request.Form["Linkman"];
orderModel.Fax = "";
orderModel.Mobile = Request.Form["Mobile"];
orderModel.Telphone = Request.Form["Mobile"];
orderModel.Email = "";
orderModel.IdentityCard = "";
orderModel.ContractType = Request.Form["ContractType"];
orderModel.Payment = Request.Form["Payment"];
orderModel.Remark = string.Empty;
orderModel.Status = SysConfig.OrderType.未付款待处理.ToString();
orderModel.CreatedTime = DateTime.Now;
if (orderBLL.Add(orderModel) > 0)
{
ClassLibrary.Model.OrderDetail detailModel;
//依次将订单详情信息插入表中
foreach (string pro in products)
{
if (pro == "")
{
continue;
}
detailModel = new ClassLibrary.Model.OrderDetail();
detailModel.orderNumber = orderModel.OrderNumber;
detailModel.UserName = orderModel.UserName;
detailModel.routeID = Convert.ToInt32(pro.Split(',')[0]);
//string tempNum = pro.Split(',')[2];
//detailModel.Number = tempNum.Substring(0, tempNum.IndexOf("大")) + ",";
//tempNum = tempNum.Substring(tempNum.IndexOf("大") + 1);
//detailModel.Number += tempNum.Substring(0, tempNum.IndexOf("小"));
detailModel.Number = Request.Form["adultnum"] + "," + Request.Form["childnum"];
detailModel.RouteName = pro.Split(',')[1];
detailModel.RoutePrice = Convert.ToDecimal(Request.Form["totalPrice"]);
detailModel.RouteTime = pro.Split(',')[4];
detailModel.StartTime = pro.Split(',')[5];
detailBLL.Add(detailModel);
}
//扣钱
if (orderModel.Payment != SysConfig.Payment.支付宝.ToString())
{
Response.Redirect("/success/o" + orderModel.OrderNumber + ".html", false);
//Response.Redirect("/WebApp/appOrder.aspx?order=" + orderModel.OrderNumber, false);
}
else
{
//---use pay
string payURL = string.Format("/onlinepayment/alipay/default.aspx?order_no={0}&total_fee={1}",
orderModel.OrderNumber,
orderModel.proTotalPrice);
Response.Redirect(payURL, false);
//---
}
}
//发送短信
ClassLibrary.BLL.MsgLinks msg = new ClassLibrary.BLL.MsgLinks();
string customMsg = "尊敬的用户：您的订单" + orderNumber + "已提交成功，我们将尽快联系您，或拨打400-017-5761。";
string webRoutName = products[0].Split(',')[1].Replace("【", "").Replace("】", "").Replace("[", "").Replace("]", "")
.Replace("(", "").Replace(")", "").Replace("（", "").Replace("）", "").Replace("...", "");
string webMsg = "您有新订单" + orderNumber.Substring(10) + "！\n姓名：" + orderModel.Linkman + "\n电话：" + orderModel.Mobile + "\n日期：" + products[0].Split(',')[5]
+ "\n线路：" + Function.Clip(webRoutName, 16, false) + "。";
string backMsg = msg.sendMsg(orderModel.Mobile, customMsg);
ClassLibrary.BLL.WebMeta bll = new ClassLibrary.BLL.WebMeta();
ClassLibrary.Model.WebMeta webMeta = bll.GetModelList(string.Empty)[0];
msg.sendMsg(webMeta.Telphone, webMsg);
}
catch (Exception ex)
{
//回滚数据
orderBLL.Deletes("OrderNumber='" + orderNumber + "'");
detailBLL.Deletes("orderNumber='" + orderNumber + "'");
Response.Write("<script>alert('订单提交失败！');location.href='/shopcart/'</script>");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="OrderNumber">主键OrderNumber</param>
/// <returns>Orders对象</returns>
public ClassLibrary.Model.Orders GetModel(string OrderNumber)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT OrderNumber,UserName,proQuantity,proTotalPrice,Linkman,Fax,Mobile,Telphone,Email,IdentityCard,ContractType,Payment,Remark,Status,CreatedTime");
strSql.Append(" FROM ");
strSql.Append(table);
strSql.Append(string.Format(" WHERE {0}=@{0}", pk));
SqlParameter[] parameters =
{
new SqlParameter("@" + pk, SqlDbType.VarChar, 32)
};
parameters[0].Value = OrderNumber;
ClassLibrary.Model.Orders model = new ClassLibrary.Model.Orders();
DataTable dt = SQLHelper.Query(strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["OrderNumber"] != DBNull.Value)
{
model.OrderNumber = Convert.ToString(dt.Rows[0]["OrderNumber"]);
}
if (dt.Rows[0]["UserName"] != DBNull.Value)
{
model.UserName = Convert.ToString(dt.Rows[0]["UserName"]);
}
if (dt.Rows[0]["proTotalPrice"] != DBNull.Value)
{
model.proTotalPrice = Convert.ToDecimal(dt.Rows[0]["proTotalPrice"]);
}
if (dt.Rows[0]["proQuantity"] != DBNull.Value)
{
model.proQuantity = Convert.ToString(dt.Rows[0]["proQuantity"]);
}
if (dt.Rows[0]["Linkman"] != DBNull.Value)
{
model.Linkman = Convert.ToString(dt.Rows[0]["Linkman"]);
}
if (dt.Rows[0]["Fax"] != DBNull.Value)
{
model.Fax = Convert.ToString(dt.Rows[0]["Fax"]);
}
if (dt.Rows[0]["Mobile"] != DBNull.Value)
{
model.Mobile = Convert.ToString(dt.Rows[0]["Mobile"]);
}
if (dt.Rows[0]["Telphone"] != DBNull.Value)
{
model.Telphone = Convert.ToString(dt.Rows[0]["Telphone"]);
}
if (dt.Rows[0]["Email"] != DBNull.Value)
{
model.Email = Convert.ToString(dt.Rows[0]["Email"]);
}
if (dt.Rows[0]["IdentityCard"] != DBNull.Value)
{
model.IdentityCard = Convert.ToString(dt.Rows[0]["IdentityCard"]);
}
if (dt.Rows[0]["ContractType"] != DBNull.Value)
{
model.ContractType = Convert.ToString(dt.Rows[0]["ContractType"]);
}
if (dt.Rows[0]["Payment"] != DBNull.Value)
{
model.Payment = Convert.ToString(dt.Rows[0]["Payment"]);
}
if (dt.Rows[0]["Remark"] != DBNull.Value)
{
model.Remark = Convert.ToString(dt.Rows[0]["Remark"]);
}
if (dt.Rows[0]["Status"] != DBNull.Value)
{
model.Status = Convert.ToString(dt.Rows[0]["Status"]);
}
if (dt.Rows[0]["CreatedTime"] != DBNull.Value)
{
model.CreatedTime = Convert.ToDateTime(dt.Rows[0]["CreatedTime"]);
}
}
return(model);
}
