/// <summary>
/// DataSet转化为对象实体
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public Model.user_coupon DsSetToModel(DataSet ds)
{
Model.user_coupon model = new Model.user_coupon();
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "")
{
model.title = ds.Tables[0].Rows[0]["title"].ToString();
}
if (ds.Tables[0].Rows[0]["remark"] != null && ds.Tables[0].Rows[0]["remark"].ToString() != "")
{
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
}
if (ds.Tables[0].Rows[0]["type"] != null && ds.Tables[0].Rows[0]["type"].ToString() != "")
{
model.type = ds.Tables[0].Rows[0]["type"].ToString();
}
if (ds.Tables[0].Rows[0]["amount"].ToString() != "")
{
model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString());
}
if (ds.Tables[0].Rows[0]["str_code"] != null && ds.Tables[0].Rows[0]["str_code"].ToString() != "")
{
model.str_code = ds.Tables[0].Rows[0]["str_code"].ToString();
}
if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
}
if (ds.Tables[0].Rows[0]["start_time"] != null && ds.Tables[0].Rows[0]["start_time"].ToString() != "")
{
model.start_time = DateTime.Parse(ds.Tables[0].Rows[0]["start_time"].ToString());
}
if (ds.Tables[0].Rows[0]["end_time"] != null && ds.Tables[0].Rows[0]["end_time"].ToString() != "")
{
model.end_time = DateTime.Parse(ds.Tables[0].Rows[0]["end_time"].ToString());
}
if (ds.Tables[0].Rows[0]["status"] != null && ds.Tables[0].Rows[0]["status"].ToString() != "")
{
model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString());
}
if (ds.Tables[0].Rows[0]["userid"] != null && ds.Tables[0].Rows[0]["userid"].ToString() != "")
{
model.userid = int.Parse(ds.Tables[0].Rows[0]["userid"].ToString());
}
if (ds.Tables[0].Rows[0]["img_url"] != null && ds.Tables[0].Rows[0]["img_url"].ToString() != "")
{
model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString();
}
return(model);
}
else
{
return(null);
}
}
private bool DoAdd()
{
bool result = true;
Model.user_coupon model = new Model.user_coupon();
BLL.user_coupon bll = new BLL.user_coupon();
model.title = txtTitle.Text.Trim();
model.remark = txtRemark.Text.Trim();
model.type = RadioBut1.Checked == true ? "平台优惠券" : "品牌优惠券";
model.amount = Convert.ToDecimal(txtDecimal.Text);
model.start_time = Convert.ToDateTime(txtStartTime.Text);
model.end_time = Convert.ToDateTime(txtEndTime.Text);
int num = Convert.ToInt32(txtNum.Text);
string st = "";
for (int i = 1; i <= num; i++)
{
st = i.ToString().PadLeft(5, '0');//补齐优惠券的位数
string str_code = txtStrCode.Text + DateTime.Now.ToString("yyyyMMddhhmmss") + st;
model.str_code = Vincent._MD5Encrypt.GetMD5(str_code);
if (bll.Add(model) > 0)
{
result = true;
}
}
AddAdminLog(Vincent._DTcms.DTEnums.ActionEnum.Add.ToString(), "发布了" + num + "张优惠券:");//记录日志
return(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.user_coupon model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update " + databaseprefix + "user_coupon set ");
strSql.Append("title=@title,");
strSql.Append("remark=@remark,");
strSql.Append("type=@type,");
strSql.Append("amount=@amount,");
strSql.Append("str_code=@str_code,");
strSql.Append("add_time=@add_time,");
strSql.Append("start_time=@start_time,");
strSql.Append("end_time=@end_time,");
strSql.Append("status=@status,");
strSql.Append("userid=@userid,");
strSql.Append("img_url=@img_url");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@title", SqlDbType.NVarChar, 255),
new SqlParameter("@remark", SqlDbType.NVarChar, 500),
new SqlParameter("@type", SqlDbType.NVarChar, 50),
new SqlParameter("@amount", SqlDbType.Decimal, 5),
new SqlParameter("@str_code", SqlDbType.NVarChar, 255),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@start_time", SqlDbType.DateTime),
new SqlParameter("@end_time", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.TinyInt, 1),
new SqlParameter("@userid", SqlDbType.Int),
new SqlParameter("@id", SqlDbType.Int),
new SqlParameter("@img_url", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.title;
parameters[1].Value = model.remark;
parameters[2].Value = model.type;
parameters[3].Value = model.amount;
parameters[4].Value = model.str_code;
parameters[5].Value = model.add_time;
parameters[6].Value = model.start_time;
parameters[7].Value = model.end_time;
parameters[8].Value = model.status;
parameters[9].Value = model.userid;
parameters[10].Value = model.id;
parameters[11].Value = model.img_url;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 确认支付
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static bool ConfirmPay(int ID, int PayType, int pay)
{
orders bll = new orders("dt_");
Model.orders model = bll.GetModel(ID);
user_coupon coubll = new user_coupon("dt_");
Model.user_coupon coumodel = new Model.user_coupon();
if (model.str_code != "")
{
coumodel = coubll.GetModel(" str_code='" + model.str_code + "'");
}
if (model.status > 1 || model.payment_status == 2)
{
return(false);
}
model.payment_status = 2;
model.payment_time = DateTime.Now;
model.status = PayType;
model.payment_id = pay;
model.confirm_time = DateTime.Now;
if (bll.Update(model))
{
if (model.str_code != "")
{
coumodel.status = 2;
coubll.Update(coumodel);
users bll1 = new users("dt_");
Model.users userinfo = bll1.GetModel(model.user_id);
//优惠券使用记录
user_coupon_log cbll = new user_coupon_log("dt_");
Model.user_coupon_log cmodel = new Model.user_coupon_log();
cmodel.user_id = userinfo.id;
cmodel.user_name = userinfo.user_name;
cmodel.coupon_id = coumodel.id;
cmodel.str_code = model.str_code;
cmodel.order_id = model.id;
cmodel.order_no = model.order_no;
cmodel.add_time = coumodel.add_time;
cmodel.use_time = DateTime.Now;
cmodel.status = 2;
}
return(true);
}
return(false);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.user_coupon model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into " + databaseprefix + "user_coupon(");
strSql.Append("title,remark,type,amount,str_code,add_time,start_time,end_time,status,userid,img_url)");
strSql.Append(" values (");
strSql.Append("@title,@remark,@type,@amount,@str_code,@add_time,@start_time,@end_time,@status,@userid,@img_url)");
SqlParameter[] parameters =
{
new SqlParameter("@title", SqlDbType.NVarChar, 255),
new SqlParameter("@remark", SqlDbType.NVarChar, 500),
new SqlParameter("@type", SqlDbType.NVarChar, 50),
new SqlParameter("@amount", SqlDbType.Decimal, 5),
new SqlParameter("@str_code", SqlDbType.NVarChar, 255),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@start_time", SqlDbType.DateTime),
new SqlParameter("@end_time", SqlDbType.DateTime),
new SqlParameter("@status", SqlDbType.TinyInt, 1),
new SqlParameter("@userid", SqlDbType.Int),
new SqlParameter("@img_url", SqlDbType.NVarChar, 255)
};
parameters[0].Value = model.title;
parameters[1].Value = model.remark;
parameters[2].Value = model.type;
parameters[3].Value = model.amount;
parameters[4].Value = model.str_code;
parameters[5].Value = DateTime.Now;
parameters[6].Value = model.start_time;
parameters[7].Value = model.end_time;
parameters[8].Value = model.status;
parameters[9].Value = model.userid;
parameters[10].Value = model.img_url;
object obj = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.user_coupon model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.user_coupon model)
{
return(dal.Add(model));
}
/// <summary>
/// 获取订单总金额
/// </summary>
/// <param name="total_amount"></param>
protected void getTotalAmount()
{
total_amount = 0M;
coupon_amount = 0M;
refund_amount = 0M;
if (datetime == null)
{
BLL.orders bll = new BLL.orders();
DataTable dt;
if (this.outlet_id > 0)
{
dt = bll.GetOrderAmount(0, " status!=1 and status!=99 and store_id=" + this.outlet_id, " add_time desc,id desc").Tables[0];
}
else if (this.city_id > 0)
{
BLL.openarea open = new BLL.openarea();
Model.openarea openm = open.GetModel(this.city_id);
StringBuilder strTemp = new StringBuilder();
if (openm != null)
{
BLL.outlet outlet = new BLL.outlet();
DataTable dts = outlet.GetList(0, " city='" + openm.city + "'", " id").Tables[0];
if (dts.Rows.Count > 0)
{
StringBuilder st = new StringBuilder();
string ss = string.Empty;
st.Append("(");
foreach (DataRow item in dts.Rows)
{
st.Append(item["id"] + ",");
}
if (st.ToString().Trim() != "(")
{
ss = DelLastComma(st.ToString().Trim());
st.Append(")");
}
strTemp.Append(" and store_id in" + ss + ")");
}
else
{
strTemp.Append(" and store_id in(null)");
}
}
dt = bll.GetOrderAmount(0, " status!=1 and status!=99" + strTemp, " add_time desc,id desc").Tables[0];
}
else
{
dt = bll.GetOrderAmount(0, " status!=1 and status!=99", " add_time desc,id desc").Tables[0];
}
foreach (DataRow row in dt.Rows)
{
total_amount += decimal.Parse(row["order_amount"].ToString());
if (row["refund_status"].ToString() != "" && int.Parse(row["refund_status"].ToString()) == 3) //统计退款
{
refund_amount += decimal.Parse(row["order_amount"].ToString());
}
BLL.user_coupon_log couponbll = new BLL.user_coupon_log();//统计优惠券
if (row["str_code"].ToString() != "")
{
Model.user_coupon_log couponmodel = couponbll.GetModel(row["str_code"].ToString());
if (couponmodel != null && couponmodel.status == 2)
{
BLL.user_coupon copbl = new BLL.user_coupon();
Model.user_coupon copmo = copbl.GetModel(couponmodel.coupon_id);
if (copmo != null)
{
if (copmo.amount > decimal.Parse(row["order_amount"].ToString()))
{
coupon_amount += decimal.Parse(row["order_amount"].ToString());
}
else
{
coupon_amount += copmo.amount;
}
}
}
}
}
}
else
{
BLL.orders bll = new BLL.orders();
DataTable dt;
if (this.outlet_id > 0)
{
dt = bll.GetOrderAmount(0, " status!=1 and status!=99 and store_id=" + this.outlet_id, " add_time desc,id desc").Tables[0];
}
else
{
dt = bll.GetOrderAmount(0, " status!=1 and status!=99", " add_time desc,id desc").Tables[0];
}
//DataTable dt = bll.GetOrderAmount(0, " status!=1 and status!=99 and datediff(dd,add_time,'" + datetime + "')=0", " add_time desc,id desc").Tables[0];
foreach (DataRow row in dt.Rows)
{
total_amount += decimal.Parse(row["order_amount"].ToString());
if (row["refund_status"].ToString() != "" && int.Parse(row["refund_status"].ToString()) == 3)
{
refund_amount += decimal.Parse(row["order_amount"].ToString());
}
BLL.user_coupon_log couponbll = new BLL.user_coupon_log();//统计优惠券
if (row["str_code"].ToString() != "")
{
Model.user_coupon_log couponmodel = couponbll.GetModel(row["str_code"].ToString());
if (couponmodel != null && couponmodel.status == 2)
{
BLL.user_coupon copbl = new BLL.user_coupon();
Model.user_coupon copmo = copbl.GetModel(couponmodel.coupon_id);
if (copmo != null)
{
if (copmo.amount > decimal.Parse(row["order_amount"].ToString()))
{
coupon_amount += decimal.Parse(row["order_amount"].ToString());
}
else
{
coupon_amount += copmo.amount;
}
}
}
}
}
}
}
/// <summary>
/// 获取订单总金额
/// </summary>
/// <param name="total_amount"></param>
protected void getTotalAmount()
{
total_amount = 0M;
coupon_amount = 0M;
refund_amount = 0M;
if (date == null || date == "")
{
BLL.orders bll = new BLL.orders();
DataTable dt = bll.GetOrderAmount(0, " status!=1 and status!=99", " add_time desc,id desc").Tables[0];
foreach (DataRow row in dt.Rows)
{
total_amount += decimal.Parse(row["order_amount"].ToString());
if (row["refund_status"].ToString() != "" && int.Parse(row["refund_status"].ToString()) == 3) //统计退款
{
refund_amount += decimal.Parse(row["order_amount"].ToString());
}
BLL.user_coupon_log couponbll = new BLL.user_coupon_log();//统计优惠券
if (row["str_code"].ToString() != "")
{
Model.user_coupon_log couponmodel = couponbll.GetModel(row["str_code"].ToString());
if (couponmodel != null && couponmodel.status == 2)
{
BLL.user_coupon copbl = new BLL.user_coupon();
Model.user_coupon copmo = copbl.GetModel(couponmodel.coupon_id);
if (copmo != null)
{
if (copmo.amount > decimal.Parse(row["order_amount"].ToString()))
{
coupon_amount += decimal.Parse(row["order_amount"].ToString());
}
else
{
coupon_amount += copmo.amount;
}
}
}
}
}
}
else
{
BLL.orders bll = new BLL.orders();
DataTable dt = bll.GetOrderAmount(0, " status!=1 and status!=99 and datediff(dd,add_time,'" + date + "')=0", " add_time desc,id desc").Tables[0];
foreach (DataRow row in dt.Rows)
{
total_amount += decimal.Parse(row["order_amount"].ToString());
if (row["refund_status"].ToString() != "" && int.Parse(row["refund_status"].ToString()) == 3)
{
refund_amount += decimal.Parse(row["order_amount"].ToString());
}
BLL.user_coupon_log couponbll = new BLL.user_coupon_log();//统计优惠券
if (row["str_code"].ToString() != "")
{
Model.user_coupon_log couponmodel = couponbll.GetModel(row["str_code"].ToString());
if (couponmodel != null && couponmodel.status == 2)
{
BLL.user_coupon copbl = new BLL.user_coupon();
Model.user_coupon copmo = copbl.GetModel(couponmodel.coupon_id);
if (copmo != null)
{
if (copmo.amount > decimal.Parse(row["order_amount"].ToString()))
{
coupon_amount += decimal.Parse(row["order_amount"].ToString());
}
else
{
coupon_amount += copmo.amount;
}
}
}
}
}
}
}
public string SubmitOrder(string goods, string addressId, string expressId, string totalprice, string bill_type, string bill_rise, string down_order, string coupon_no, string store_name, string store_address, string store_id, string user_id, string remark)
{
string returnvalue = "";
Model.orders model = new Model.orders();
BLL.orders bll = new BLL.orders();
//验证优惠券
var j = 0;
BLL.user_coupon couponbll = new BLL.user_coupon();
Model.user_coupon coupon = null;
if (coupon_no != "")
{
coupon = couponbll.GetModel(" str_code='" + coupon_no + "'");
if (coupon == null)
{
j = 1;
}
else
{
if (DateTime.Compare(coupon.end_time, DateTime.Now) <= 0)
{
j = 2;
}
if (coupon.status == 2)
{
j = 3;
}
}
}
if (j == 1)
{
return(returnvalue = "{\"status\":0,\"msg\":\"优惠券编码输入有误！\"}");
}
if (j == 2)
{
return(returnvalue = "{\"status\":0,\"msg\":\"优惠券已经过期！\"}");
}
if (j == 3)
{
return(returnvalue = "{\"status\":0,\"msg\":\"优惠券已使用！\"}");
}
BLL.users bll1 = new BLL.users();
Model.users userinfo = bll1.GetModel(int.Parse(user_id));
if (addressId != "0")//快递收货
{
//订单信息
Model.user_address modelAddress = new BLL.user_address().GetModel(int.Parse(addressId));
Model.express modelExpress = new BLL.express().GetModel(int.Parse(expressId));
model.order_no = CreateOrderNo();
model.accept_name = modelAddress.acceptName;
model.area = modelAddress.id.ToString();
model.mobile = modelAddress.mobile;
model.address = modelAddress.address;
model.post_code = modelAddress.postcode.ToString();
model.add_time = DateTime.Now;
model.user_id = userinfo.id;
model.user_name = userinfo.user_name;
model.express_id = int.Parse(expressId);
model.express_fee = modelExpress.express_fee;
model.express_status = 1;
model.status = 1;
decimal real_amount = Decimal.Parse(totalprice) - modelExpress.express_fee;
model.real_amount = real_amount;
model.order_amount = Decimal.Parse(totalprice);
model.bill_type = int.Parse(bill_type);
if (int.Parse(bill_type) != 0)
{
model.is_bill = 1;
}
model.invoice_rise = bill_rise;
model.down_order = down_order;
model.remark = remark;
}
else
{
//订单信息
Model.express modelExpress = new BLL.express().GetModel(int.Parse(expressId));
model.order_no = CreateOrderNo();
model.add_time = DateTime.Now;
model.user_id = userinfo.id;
model.user_name = userinfo.user_name;
model.express_id = int.Parse(expressId);
model.express_fee = modelExpress.express_fee;
model.express_status = 1;
model.status = 1;
decimal real_amount = Decimal.Parse(totalprice) - modelExpress.express_fee;
model.real_amount = real_amount;
model.order_amount = Decimal.Parse(totalprice);
model.bill_type = int.Parse(bill_type);
if (int.Parse(bill_type) != 0)
{
model.is_bill = 1;
}
model.invoice_rise = bill_rise;
model.down_order = down_order;
model.store_name = store_name;
model.store_address = store_address;
model.store_id = int.Parse(store_id);
model.remark = remark;
}
var k = 0;
var p = 0;
if (coupon != null)
{
decimal payamount = Decimal.Parse(totalprice) - coupon.amount;
if (payamount > 0)
{
model.payable_amount = payamount;//实付款
model.str_code = coupon_no;
}
else
{
model.payable_amount = 0M;//实付款
model.str_code = coupon_no;
model.status = 2;
model.payment_status = 2;
p = bll.Add(model);
k = 1;
}
}
////商品信息value="<%#Eval("id") %>|<%#Eval("type") %>|<%#Eval("price") %>|<%#Eval("quantity") %>|<%#Eval("weight") %>|<%#Eval("img_url") %>"
List <Model.order_goods> list = new List <Model.order_goods>();
string[] strArr = Vincent._DTcms.Utils.DelLastChar(goods, "&").Split('&');
foreach (var item in strArr)
{
string[] strArr2 = item.Split('|');
Model.order_goods modelGoods = new Model.order_goods();
modelGoods.goods_id = int.Parse(strArr2[0].ToString());
modelGoods.goods_price = decimal.Parse(strArr2[1].ToString());
modelGoods.quantity = int.Parse(strArr2[2].ToString());
modelGoods.goods_pic = strArr2[3].ToString();
modelGoods.goods_title = strArr2[4].ToString();
list.Add(modelGoods);
}
model.order_goods = list;
int orderId = bll.Add(model);
//优惠券使用记录
BLL.user_coupon_log cbll = new BLL.user_coupon_log();
Model.user_coupon_log cmodel = new Model.user_coupon_log();
if (coupon != null)
{
cmodel.user_id = userinfo.id;
cmodel.user_name = userinfo.user_name;
cmodel.coupon_id = coupon.id;
cmodel.str_code = coupon.str_code;
cmodel.order_id = orderId;
cmodel.order_no = model.order_no;
cmodel.add_time = coupon.add_time;
cmodel.use_time = DateTime.Now;
cmodel.status = 1;
}
if (k == 1 && p > 0)
{
cmodel.status = 2;
cbll.Add(cmodel);
return(returnvalue = "{\"status\":3,\"msg\":\"订单提交成功！\"}");
}
if (orderId > 0)
{
if (coupon != null)
{
cbll.Add(cmodel);
}
return(returnvalue = "{\"status\":1,\"msg\":\"订单提交成功，请付款！\",\"orderId\":" + orderId + "}");
Web.UI.ShopCart.ClearCart("0");
}
else
{
if (coupon != null)
{
cbll.Add(cmodel);
}
return(returnvalue = "{\"status\":0,\"msg\":\"订单提交失败，请重新提交订单！\"}");
}
}
