protected void btnCancel_Click(object sender, EventArgs e)
{
int Uid = 0;
ChkAdminLevel("users", DTEnums.ActionEnum.Delete.ToString()); //檢查許可權
BLL.users bll = new BLL.users();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
Model.users mod = bll.GetModel(id);
if (mod != null)
{
string JiShaoRen = mod.dianming;
DataTable dtUser = bll.GetUser_Info(JiShaoRen);
if (dtUser != null)
{
int UserPoint = 0;
Uid = Utils.StringToNum(dtUser.Rows[0]["ID"].ToString());
int GroupID = Utils.StringToNum(dtUser.Rows[0]["group_id"].ToString());
switch (mod.group_id)
{
case 1:
UserPoint = 0;
break;
case 2:
UserPoint = 50;
break;
case 3:
UserPoint = 100;
break;
case 4:
UserPoint = 150;
break;
}
int bk = bll.UpJianPoint(Uid, UserPoint);
if (bk > 0)
{
BLL.point_log points = new BLL.point_log();
Model.point_log model = new Model.point_log();
model.user_id = Uid;
model.user_name = "";
model.value = UserPoint;
model.remark = "取消朋友成為會員回饋點數";
model.add_time = DateTime.Now;
model.type = 2;//2標誌點數是減少
int m = points.Add(model);
}
}
}
}
}
JscriptMsg("批次更改成功啦！", Utils.CombUrlTxt("regFee.aspx", "group_id={0}&keywords={1}",
this.group_id.ToString(), this.keywords), "Success");
}
public void CalculationPoint()
{
int UID = WEBUserCurrent.UserID;
if (!string.IsNullOrEmpty(UID.ToString()))
{
BLL.users User = new BLL.users();
Model.users mod = new Model.users();
mod = User.GetModel(UID);
if (mod != null)
{
point = mod.point.ToString();
pointMoney = point;
if (mod.point > 150)
{
pointMoney = "150";
}
else
{
pointMoney = point;
}
hidePoint.Value = pointMoney;
BLL.point_log points = new BLL.point_log();
Model.point_log model = new Model.point_log();
model.user_id = UID;
model.user_name = orderNo;
model.value = Utils.StringToNum(pointMoney);
model.remark = "購物時折抵點數";
model.add_time = DateTime.Now;
model.type = 2;//2標誌點數是減少
int m = points.Add(model);
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.point_log model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_point_log(");
strSql.Append("user_id,user_name,value,remark,add_time,type)");
strSql.Append(" values (");
strSql.Append("@user_id,@user_name,@value,@remark,@add_time,@type)");
strSql.Append(";set @ReturnValue= @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@user_id", SqlDbType.Int, 4),
new SqlParameter("@user_name", SqlDbType.NVarChar, 100),
new SqlParameter("@value", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.NVarChar, 500),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@type", SqlDbType.Int),
new SqlParameter("@ReturnValue", SqlDbType.Int, 4)
};
parameters[0].Value = model.user_id;
parameters[1].Value = model.user_name;
parameters[2].Value = model.value;
parameters[3].Value = model.remark;
parameters[4].Value = model.add_time;
parameters[5].Value = model.type;
parameters[6].Direction = ParameterDirection.Output;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("update dt_users set ");
if (model.value >= 0)
{
strSql2.Append(" exp=exp+" + model.value);
}
strSql2.Append(" where id=@id");
SqlParameter[] parameters2 =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters2[0].Value = model.user_id;
cmd = new CommandInfo(strSql2.ToString(), parameters2);
sqllist.Add(cmd);
DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist);
return((int)parameters[5].Value);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.point_log GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,user_id,user_name,value,remark,add_time,type from dt_point_log ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.point_log model = new Model.point_log();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
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]["user_id"] != null && ds.Tables[0].Rows[0]["user_id"].ToString() != "")
{
model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString());
}
if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "")
{
model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString();
}
if (ds.Tables[0].Rows[0]["value"] != null && ds.Tables[0].Rows[0]["value"].ToString() != "")
{
model.value = int.Parse(ds.Tables[0].Rows[0]["value"].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]["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]["type"] != null && ds.Tables[0].Rows[0]["type"].ToString() != "")
{
model.type = int.Parse(ds.Tables[0].Rows[0]["type"].ToString());
}
return(model);
}
else
{
return(null);
}
}
public int Add(int user_id, string user_name, int value, string remark)
{
Model.point_log model = new Model.point_log();
model.user_id = user_id;
model.user_name = user_name;
model.value = value;
model.remark = remark;
int result = dal.Add(model);
if (value > 0 && result > 0)
{
new BLL.users().Upgrade(user_id);
}
return result;
}
public int Add(int user_id, string user_name, int value, string remark)
{
Model.point_log model = new Model.point_log();
model.user_id = user_id;
model.user_name = user_name;
model.value = value;
model.remark = remark;
int result = dal.Add(model);
if (value > 0 && result > 0)
{
new BLL.users().Upgrade(user_id);
}
return(result);
}
public void UpUserPoint(decimal price)
{
int points = 0; int typeValue = 100;
int UID = WEBUserCurrent.UserID;
Model.users mod = new Model.users();
BLL.user_groups BLLGroup = new BLL.user_groups();
mod = User.GetModel(UID);
if (mod != null)
{
switch (mod.group_id)
{
case 1:
typeValue = BLLGroup.GetZheKou(mod.group_id);
break;
case 2:
typeValue = BLLGroup.GetZheKou(mod.group_id);
break;
case 3:
typeValue = BLLGroup.GetZheKou(mod.group_id);
break;
case 4:
typeValue = BLLGroup.GetZheKou(mod.group_id);
break;
}
double s = double.Parse(((price * typeValue) / 100).ToString());
string result = s.ToString("#0");
points = Utils.StringToNum(result);
User.UpPoint(UID, points);
BLL.point_log point = new BLL.point_log();
Model.point_log model = new Model.point_log();
model.user_id = UID;
model.user_name = hideNo.Value;
model.value = points;
model.remark = "購物回饋點數";
model.add_time = DateTime.Now;
model.type = 1;//2標誌點數是減少
int m = point.Add(model);
}
}
/// <summary>
/// 显示购物车中的产品
/// </summary>
private void Show_Car()
{
DataTable dt = (DataTable)Session["DGCart"];
//if (dt.Rows.Count < 1)
//{
// literalScript.Text = "<script type=\"text/javascript\">show(260, '您的购物车中没有商品！', 'u_Car.aspx');</script>";
// return;
//}
if (dt.Rows.Count > 0)
{
repddata.DataSource = dt.DefaultView;
repddata.DataBind();
}
decimal decimalTotal = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
decimalTotal = decimalTotal + Convert.ToDecimal(dt.Rows[i]["GoodsTotal"]);
}
//decimalTotal = decimalTotal + decimal.Parse(Fee);
TotalPrice = decimalTotal.ToString("0.00");
double zhekouPrice = double.Parse(((decimal.Parse(TotalPrice) * 15) / 100).ToString());
string result = zhekouPrice.ToString("#0");
int ZheKoupoints = Utils.StringToNum(result);
int UID = WEBUserCurrent.UserID;
if (!string.IsNullOrEmpty(UID.ToString()))
{
BLL.users User = new BLL.users();
Model.users mod = new Model.users();
mod = User.GetModel(UID);
if (mod != null)
{
point = mod.point.ToString();
pointMoney = point;
if (ZheKoupoints >= 150)
{
ZheKoupoints = 150;
}
if (mod.point > ZheKoupoints)
{
pointMoney = ZheKoupoints.ToString();
}
else
{
pointMoney = point;
}
hidePoint.Value = pointMoney;
BLL.point_log pointsLog = new BLL.point_log();
Model.point_log model = new Model.point_log();
model.user_id = UID;
model.user_name = orderNo;
model.value = Utils.StringToNum(pointMoney);
model.remark = "購物時折抵點數";
model.add_time = DateTime.Now;
model.type = 2;//2標誌點數是減少
int m = pointsLog.Add(model);
}
}
shengyu = (decimal.Parse(TotalPrice) - decimal.Parse(pointMoney) + decimal.Parse(Fee)).ToString();
PousePrice = (decimal.Parse(TotalPrice) + decimal.Parse(Fee)).ToString();
if (hideFee.Value == "2")
{
decimal FeeLv = TwoTypeFee;
if (decimal.Parse(TotalPrice) >= FeeLv)
{
PousePrice = TotalPrice;
shengyu = (decimal.Parse(TotalPrice) - decimal.Parse(pointMoney)).ToString();
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.point_log GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,user_id,user_name,value,remark,add_time from dt_point_log ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
Model.point_log model = new Model.point_log();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
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]["user_id"] != null && ds.Tables[0].Rows[0]["user_id"].ToString() != "")
{
model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString());
}
if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "")
{
model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString();
}
if (ds.Tables[0].Rows[0]["value"] != null && ds.Tables[0].Rows[0]["value"].ToString() != "")
{
model.value = int.Parse(ds.Tables[0].Rows[0]["value"].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]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString());
}
return model;
}
else
{
return null;
}
}
//取消訂單
protected void btnCancel_Click(object sender, EventArgs e)
{
ChkAdminLevel("orders", DTEnums.ActionEnum.Cancel.ToString()); //檢查許可權
BLL.orders bll = new BLL.orders();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
Model.orders model = bll.GetModel(id);
if (model != null && model.status == 1)
{
bll.UpdateField(id, "status=4");
int UID = 0, Point = 0;
string orNo = string.Empty;
#region 根据ID获取订单参数
UID = model.user_id;
// Point = model.point;
orNo = model.order_no;
#endregion
#region 更新点数
BLL.users BLLUser = new BLL.users();
BLL.point_log points = new BLL.point_log();
DataTable dtOrder = points.GetList(100, " user_name='" + orNo + "' ", " add_time desc").Tables[0];
if (dtOrder != null)
{
for (int k = 0; k < dtOrder.Rows.Count; k++)
{
Model.point_log modelPoint = new Model.point_log();
int type = Utils.StringToNum(dtOrder.Rows[k]["type"].ToString());
Point = Utils.StringToNum(dtOrder.Rows[k]["value"].ToString());
if (type == 1)
{
BLLUser.UpJianPoint(UID, Point);
#region 记录点数消费
modelPoint.user_id = UID;
modelPoint.user_name = orNo;
modelPoint.value = Point;
modelPoint.remark = "訂單取消購物回饋點數";
modelPoint.add_time = DateTime.Now;
modelPoint.type = 2;
int m = points.Add(modelPoint);
#endregion
}
if (type == 2)
{
BLLUser.UpPoint(UID, Point);
#region 记录点数消费
modelPoint.user_id = UID;
modelPoint.user_name = orNo;
modelPoint.value = Point;
modelPoint.remark = "訂單取消返還購物時折抵點數";
modelPoint.add_time = DateTime.Now;
modelPoint.type = 1;
int m = points.Add(modelPoint);
#endregion
}
}
}
#endregion
}
}
}
JscriptMsg("符合的訂單已取消！", Utils.CombUrlTxt("order_list.aspx", "status={0}&payment_status={1}&distribution_status={2}&keywords={3}",
this.status.ToString(), this.payment_status.ToString(), this.distribution_status.ToString(), this.keywords), "Success");
}
private bool DoEdit(int _id)
{
bool result = true;
BLL.users bll = new BLL.users();
Model.users model = new Model.users();
model.group_id = Utils.StringToNum(ddlGroupId.SelectedValue);
int point = 0;
switch (model.group_id)
{
case 1:
point = 0;
break;
case 2:
point = 50;
break;
case 3:
point = 100;
break;
case 4:
point = 150;
break;
}
//model.point = point;
model.isVip = 0;
if (chkVip.Checked == true)
{
model.isVip = 1;
}
model.is_lock = Utils.StringToNum(rblIsLock.SelectedValue);
if (!string.IsNullOrEmpty(txtPassword.Text.Trim()))
{
model.password = DESEncrypt.Encrypt(txtPassword.Text.Trim());
}
else
{
model.password = txtPwd.Value;
}
model.email = txtEmail.Text;
model.dianming = llbInTroduce.Text;
model.nick_name = txtNickName.Text;
model.user_name = txtUserName.Text.Trim();
model.avatar = txtAvatar.Text;
model.sex = rblSex.SelectedValue;
DateTime _birthday;
if (DateTime.TryParse(txtBirthday.Text.Trim(), out _birthday))
{
model.birthday = _birthday;
}
model.telphone = txtTelphone.Text.Trim();
model.mobile = txtMobile.Text.Trim();
model.qq = txtQQ.Text;
model.address = txtAddress.Text.Trim();
model.amount = decimal.Parse(txtAmount.Text.Trim());
BLL.siteconfig bllConfig = new BLL.siteconfig();
Model.siteconfig modelConfig = bllConfig.loadConfig(Utils.GetXmlMapPath(DTKeys.FILE_SITE_XML_CONFING));
#region 介紹售屋物件
if (modelConfig.weburl == DESEncrypt.Encrypt(txtManagePwd.Text))
{
if (!string.IsNullOrEmpty(txtSellHoursePoint.Text))
{
BLL.users BLLUser = new BLL.users();
if (txtSell.Value == "0")
{
point = Utils.StringToNum(txtSellHoursePoint.Text) * 5000;
BLLUser.UpPoint(id, point);
BLL.point_log points = new BLL.point_log();
Model.point_log modelP = new Model.point_log();
modelP.user_id = _id;
modelP.user_name = txtNickName.Text;
modelP.value = point;
modelP.remark = "介紹售屋物件回饋點數";
modelP.add_time = DateTime.Now;
modelP.type = 1;//2會員介紹物件已成交
int m = points.Add(modelP);
}
else
{
int Nums = System.Math.Abs(Utils.StringToNum(txtSellHoursePoint.Text) - Utils.StringToNum(txtSell.Value));
if (Nums != 0)
{
int jianPoint = Nums * 5000;
BLL.point_log points = new BLL.point_log();
Model.point_log modelP = new Model.point_log();
modelP.user_id = _id;
modelP.user_name = txtNickName.Text;
modelP.value = jianPoint;
modelP.add_time = DateTime.Now;
if ((Utils.StringToNum(txtSellHoursePoint.Text) - Utils.StringToNum(txtSell.Value)) < 0)
{
modelP.remark = "減去介紹售屋物件回饋點數";
modelP.type = 2;//2會員介紹物件已成交
BLLUser.UpJianPoint(id, jianPoint);
}
else
{
modelP.remark = "介紹售屋物件回饋點數";
modelP.type = 1;//2會員介紹物件已成交
BLLUser.UpPoint(id, jianPoint);
}
int m = points.Add(modelP);
}
}
model.isDonePoints = Utils.StringToNum(txtSellHoursePoint.Text);
}
}
else
{
model.isDonePoints = Utils.StringToNum(txtSell.Value);
}
#endregion
#region 介紹租屋物件
if (modelConfig.weburl == DESEncrypt.Encrypt(TextBox2.Text))
{
if (!string.IsNullOrEmpty(txtHireHoursePoint.Text))
{
BLL.users BLLUser = new BLL.users();
if (txtHire.Value == "0")
{
point = Utils.StringToNum(txtHireHoursePoint.Text) * 200;
BLLUser.UpPoint(id, point);
BLL.point_log points = new BLL.point_log();
Model.point_log modelP = new Model.point_log();
modelP.user_id = _id;
modelP.user_name = txtNickName.Text;
modelP.value = point;
modelP.remark = "介紹租屋物件回饋點數";
modelP.add_time = DateTime.Now;
modelP.type = 1;//2會員介紹物件已成交
int m = points.Add(modelP);
}
else
{
int Nums = System.Math.Abs(Utils.StringToNum(txtHireHoursePoint.Text) - Utils.StringToNum(txtHire.Value));
if (Nums != 0)
{
int jianPoint = Nums * 200;
BLL.point_log points = new BLL.point_log();
Model.point_log modelP = new Model.point_log();
modelP.user_id = _id;
modelP.user_name = txtNickName.Text;
modelP.value = jianPoint;
modelP.add_time = DateTime.Now;
if ((Utils.StringToNum(txtHireHoursePoint.Text) - Utils.StringToNum(txtHire.Value)) < 0)
{
modelP.remark = "減去介紹租屋物件回饋點數";
modelP.type = 2;//2會員介紹物件已成交
BLLUser.UpJianPoint(id, jianPoint);
}
else
{
modelP.remark = "介紹租屋物件回饋點數";
modelP.type = 1;//2會員介紹物件已成交
BLLUser.UpPoint(id, jianPoint);
}
int m = points.Add(modelP);
}
}
model.isHirePoints = Utils.StringToNum(txtHireHoursePoint.Text);
}
}
else
{
model.isHirePoints = Utils.StringToNum(txtHire.Value);
}
#endregion
#region 介紹租賃廣告
if (modelConfig.weburl == DESEncrypt.Encrypt(TextBox4.Text))
{
if (!string.IsNullOrEmpty(txtHireAdPoint.Text))
{
BLL.users BLLUser = new BLL.users();
if (txtAd.Value == "0")
{
point = Utils.StringToNum(txtHireAdPoint.Text) * 300;
BLLUser.UpPoint(id, point);
BLL.point_log points = new BLL.point_log();
Model.point_log modelP = new Model.point_log();
modelP.user_id = _id;
modelP.user_name = txtNickName.Text;
modelP.value = point;
modelP.remark = "介紹租賃廣告回饋點數";
modelP.add_time = DateTime.Now;
modelP.type = 1;//2會員介紹物件已成交
int m = points.Add(modelP);
}
else
{
int Nums = System.Math.Abs(Utils.StringToNum(txtHireAdPoint.Text) - Utils.StringToNum(txtAd.Value));
if (Nums != 0)
{
int jianPoint = Nums * 300;
BLL.point_log points = new BLL.point_log();
Model.point_log modelP = new Model.point_log();
modelP.user_id = _id;
modelP.user_name = txtNickName.Text;
modelP.value = jianPoint;
modelP.add_time = DateTime.Now;
if ((Utils.StringToNum(txtHireAdPoint.Text) - Utils.StringToNum(txtAd.Value)) < 0)
{
modelP.type = 2;//2會員介紹物件已成交
modelP.remark = "減去介紹租賃廣告回饋點數";
BLLUser.UpJianPoint(id, jianPoint);
}
else
{
modelP.type = 1;//2會員介紹物件已成交
modelP.remark = "介紹租賃廣告回饋點數";
BLLUser.UpPoint(id, jianPoint);
}
int m = points.Add(modelP);
}
}
model.isAd = Utils.StringToNum(txtHireAdPoint.Text);
}
}
else
{
model.isAd = Utils.StringToNum(txtAd.Value);
}
#endregion
#region 介紹精品廠商
if (modelConfig.weburl == DESEncrypt.Encrypt(TextBox6.Text))
{
if (!string.IsNullOrEmpty(txtHireMacPoint.Text))
{
BLL.users BLLUser = new BLL.users();
if (txtMac.Value == "0")
{
point = Utils.StringToNum(txtHireMacPoint.Text) * 800;
BLLUser.UpPoint(id, point);
BLL.point_log points = new BLL.point_log();
Model.point_log modelP = new Model.point_log();
modelP.user_id = _id;
modelP.user_name = txtNickName.Text;
modelP.value = point;
modelP.remark = "介紹精品廠商回饋點數";
modelP.add_time = DateTime.Now;
modelP.type = 1;//2會員介紹物件已成交
int m = points.Add(modelP);
}
else
{
int Nums = System.Math.Abs(Utils.StringToNum(txtHireMacPoint.Text) - Utils.StringToNum(txtMac.Value));
if (Nums != 0)
{
int jianPoint = Nums * 800;
BLL.point_log points = new BLL.point_log();
Model.point_log modelP = new Model.point_log();
modelP.user_id = _id;
modelP.user_name = txtNickName.Text;
modelP.value = jianPoint;
modelP.add_time = DateTime.Now;
if ((Utils.StringToNum(txtHireMacPoint.Text) - Utils.StringToNum(txtMac.Value)) < 0)
{
modelP.remark = "減去介紹精品廠商回饋點數";
modelP.type = 2;//2會員介紹物件已成交
BLLUser.UpJianPoint(id, jianPoint);
}
else
{
modelP.remark = "介紹精品廠商回饋點數";
modelP.type = 1;//2會員介紹物件已成交
BLLUser.UpPoint(id, jianPoint);
}
int m = points.Add(modelP);
}
}
model.isMac = Utils.StringToNum(txtHireMacPoint.Text);
}
}
else
{
model.isMac = Utils.StringToNum(txtMac.Value);
}
#endregion
//model.exp = Utils.StringToNum(txtExp.Text.Trim());
model.id = _id;
if (!bll.Update(model))
{
result = false;
}
return(result);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(chkPointValue.Value) || chkPointValue.Value == "否")
{
if (chkPoint.Checked == true)
{
//model.point = point + 5000;
BLL.users BLLUser = new BLL.users();
if (!string.IsNullOrEmpty(lblEmail.Text))
{
if (BLLUser.ExistsEmail(lblEmail.Text))
{
int UID = BLLUser.GetIDByExistsEmail(lblEmail.Text);
BLLUser.UpPoint(UID, 5000);
BLL.point_log point = new BLL.point_log();
Model.point_log model = new Model.point_log();
model.user_id = UID;
model.user_name = "";
model.value = 5000;
model.remark = "介紹房屋出售";
model.add_time = DateTime.Now;
model.type = 1;//2標誌點數是減少
int m = point.Add(model);
}
}
}
}
else if (chkPointValue.Value == "是")
{
if (chkPoint.Checked == false)
{
BLL.users BLLUser = new BLL.users();
if (!string.IsNullOrEmpty(lblEmail.Text))
{
if (BLLUser.ExistsEmail(lblEmail.Text))
{
int UID = BLLUser.GetIDByExistsEmail(lblEmail.Text);
BLLUser.UpJianPoint(UID, 5000);
BLL.point_log point = new BLL.point_log();
Model.point_log model = new Model.point_log();
model.user_id = UID;
model.user_name = "";
model.value = 5000;
model.remark = "取消介紹房屋出售點數";
model.type = 2;//2標誌點數是減少
model.add_time = DateTime.Now;
int m = point.Add(model);
}
}
}
}
string replayContent = txtReContent.Text.Trim();
Model.dt_feedback feedback = new Model.dt_feedback();
if (chkPoint.Checked == true)
{
feedback.user_Function = "是";
}
else
{
feedback.user_Function = "否";
}
feedback.reply_content = replayContent;
feedback.reply_time = DateTime.Now;
feedback.id = int.Parse(Request.QueryString["id"].ToString());
if (bllNot.Update(feedback))
{
setEmail();
Response.Redirect("admin/NoteBook.aspx");
JscriptMsg("留言回覆成功！", "admin/NoteBook.aspx.aspx", "Success");
}
}
/// <summary>
/// 显示购物车中的产品
/// </summary>
private void Show_Car()
{
repddata.DataSource = get_cart_list(string.Empty);
repddata.DataBind();
cartModel = GetTotal(DTKeys.COOKIE_SHOPPING_CART);
decimal decimalTotal = 0;
//decimalTotal = decimalTotal + decimal.Parse(Fee);
TotalPrice = decimalTotal.ToString("0.00");
double zhekouPrice = double.Parse(((decimal.Parse(TotalPrice) * 15) / 100).ToString());
string result = zhekouPrice.ToString("#0");
int ZheKoupoints = Utils.StringToNum(result);
int UID = WEBUserCurrent.UserID;
if (!string.IsNullOrEmpty(UID.ToString()))
{
BLL.users User = new BLL.users();
Model.users mod = new Model.users();
mod = User.GetModel(UID);
if (mod != null)
{
point = mod.point.ToString();
pointMoney = point;
if (ZheKoupoints >= 150)
{
ZheKoupoints = 150;
}
if (mod.point > ZheKoupoints)
{
pointMoney = ZheKoupoints.ToString();
}
else
{
pointMoney = point;
}
hidePoint.Value = pointMoney;
BLL.point_log pointsLog = new BLL.point_log();
Model.point_log model = new Model.point_log();
model.user_id = UID;
model.user_name = orderNo;
model.value = Utils.StringToNum(pointMoney);
model.remark = "購物時折抵點數";
model.add_time = DateTime.Now;
model.type = 2;//2標誌點數是減少
int m = pointsLog.Add(model);
}
}
shengyu = (cartModel.payable_amount - decimal.Parse(pointMoney) + decimal.Parse(Fee)).ToString();
PousePrice = (decimal.Parse(TotalPrice) + decimal.Parse(Fee)).ToString();
if (hideFee.Value == "2")
{
decimal FeeLv = TwoTypeFee;
if (decimal.Parse(TotalPrice) >= FeeLv)
{
PousePrice = TotalPrice;
shengyu = (decimal.Parse(TotalPrice) - decimal.Parse(pointMoney)).ToString();
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.point_log model)
{
return(dal.Add(model));
}
protected void btnCancel_Click(object sender, EventArgs e)
{
ChkAdminLevel("orders", DTEnums.ActionEnum.Cancel.ToString()); //檢查許可權
BLL.orders bll = new BLL.orders();
Model.orders model = bll.GetModel(this.id);
if (model == null && model.status > 2)
{
JscriptMsg("訂單不符合要求，無法取消！", "", "Error");
return;
}
bll.UpdateField(this.id, "status=4");
int UID = 0, Point = 0;
string orNo = string.Empty;
#region 根据ID获取订单参数
UID = model.user_id;
// Point = model.point;
orNo = model.order_no;
#endregion
#region 更新点数
BLL.users BLLUser = new BLL.users();
BLL.point_log points = new BLL.point_log();
DataTable dtOrder = points.GetList(100, " user_name='" + orNo + "' ", " add_time desc").Tables[0];
if (dtOrder != null)
{
for (int k = 0; k < dtOrder.Rows.Count; k++)
{
Model.point_log modelPoint = new Model.point_log();
int type = Utils.StringToNum(dtOrder.Rows[k]["type"].ToString());
Point = Utils.StringToNum(dtOrder.Rows[k]["value"].ToString());
if (type == 1)
{
BLLUser.UpJianPoint(UID, Point);
#region 记录点数消费
modelPoint.user_id = UID;
modelPoint.user_name = orNo;
modelPoint.value = Point;
modelPoint.remark = "訂單取消購物回饋點數";
modelPoint.add_time = DateTime.Now;
modelPoint.type = 2;
int m = points.Add(modelPoint);
#endregion
}
if (type == 2)
{
BLLUser.UpPoint(UID, Point);
#region 记录点数消费
modelPoint.user_id = UID;
modelPoint.user_name = orNo;
modelPoint.value = Point;
modelPoint.remark = "訂單取消返還購物時折抵點數";
modelPoint.add_time = DateTime.Now;
modelPoint.type = 1;
int m = points.Add(modelPoint);
#endregion
}
}
}
#endregion
JscriptMsg("訂單取消成功！", "order_edit.aspx?id=" + this.id, "Success");
}
