/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Lebi_Agent_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Lebi_Agent_User] set ");
strSql.Append("User_id= @User_id,");
strSql.Append("Angent1_Commission= @Angent1_Commission,");
strSql.Append("Angent2_Commission= @Angent2_Commission,");
strSql.Append("Angent3_Commission= @Angent3_Commission");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@User_id", SqlDbType.Int, 4),
new SqlParameter("@Angent1_Commission", SqlDbType.Decimal, 9),
new SqlParameter("@Angent2_Commission", SqlDbType.Decimal, 9),
new SqlParameter("@Angent3_Commission", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.id;
parameters[1].Value = model.User_id;
parameters[2].Value = model.Angent1_Commission;
parameters[3].Value = model.Angent2_Commission;
parameters[4].Value = model.Angent3_Commission;
SqlUtils.SqlUtilsInstance.TextExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 批量编辑会员推广佣金比例
/// </summary>
public void User_Update()
{
if (!EX_Admin.Power("agent_config", "代理-参数设置"))
{
AjaxNoPower();
return;
}
string ids = RequestTool.RequestSafeString("id");
List <Lebi_User> lists = B_Lebi_User.GetList("id in (lbsql{" + ids + "})", "");
foreach (Lebi_User list in lists)
{
Lebi_Agent_User model = B_Lebi_Agent_User.GetModel("User_id = " + list.id + "");
if (model == null)
{
model = new Lebi_Agent_User();
}
B_Lebi_Agent_User.SafeBindForm(model);
if (model.id == 0)
{
model.User_id = list.id;
B_Lebi_Agent_User.Add(model);
Log.Add("添加会员推广佣金比例", "Agent_User", list.id.ToString(), CurrentAdmin, "");
}
else
{
B_Lebi_Agent_User.Update(model);
Log.Add("编辑会员推广佣金比例", "Agent_User", list.id.ToString(), CurrentAdmin, "");
}
}
string result = "{\"msg\":\"OK\", \"id\":\"" + ids + "\"}";
Response.Write(result);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public Lebi_Agent_User ReaderBind(IDataReader dataReader)
{
Lebi_Agent_User model = new Lebi_Agent_User();
object ojb;
ojb = dataReader["id"];
if (ojb != null && ojb != DBNull.Value)
{
model.id = (int)ojb;
}
ojb = dataReader["User_id"];
if (ojb != null && ojb != DBNull.Value)
{
model.User_id = (int)ojb;
}
ojb = dataReader["Angent1_Commission"];
if (ojb != null && ojb != DBNull.Value)
{
model.Angent1_Commission = (decimal)ojb;
}
ojb = dataReader["Angent2_Commission"];
if (ojb != null && ojb != DBNull.Value)
{
model.Angent2_Commission = (decimal)ojb;
}
ojb = dataReader["Angent3_Commission"];
if (ojb != null && ojb != DBNull.Value)
{
model.Angent3_Commission = (decimal)ojb;
}
return(model);
}
/// <summary>
/// 编辑会员推广佣金比例
/// </summary>
public void User_Edit()
{
if (!EX_Admin.Power("agent_config", "代理-参数设置"))
{
AjaxNoPower();
return;
}
int id = RequestTool.RequestInt("id", 0);
Lebi_Agent_User model = B_Lebi_Agent_User.GetModel("User_id = " + id + "");
if (model == null)
{
model = new Lebi_Agent_User();
}
B_Lebi_Agent_User.SafeBindForm(model);
if (model.id == 0)
{
model.User_id = id;
B_Lebi_Agent_User.Add(model);
Log.Add("添加会员推广佣金比例", "Agent_User", id.ToString(), CurrentAdmin, "");
}
else
{
B_Lebi_Agent_User.Update(model);
Log.Add("编辑会员推广佣金比例", "Agent_User", id.ToString(), CurrentAdmin, "");
}
string result = "{\"msg\":\"OK\", \"id\":\"" + id + "\"}";
Response.Write(result);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Lebi_Agent_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Lebi_Agent_User](");
strSql.Append("User_id,Angent1_Commission,Angent2_Commission,Angent3_Commission)");
strSql.Append(" values (");
strSql.Append("@User_id,@Angent1_Commission,@Angent2_Commission,@Angent3_Commission)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@User_id", model.User_id),
new SqlParameter("@Angent1_Commission", model.Angent1_Commission),
new SqlParameter("@Angent2_Commission", model.Angent2_Commission),
new SqlParameter("@Angent3_Commission", model.Angent3_Commission)
};
object obj = SqlUtils.SqlUtilsInstance.TextExecuteNonQuery(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
public static Lebi_Agent_User User_Commission(int id)
{
Lebi_Agent_User model = B_Lebi_Agent_User.GetModel("User_id = " + id + "");
if (model == null)
{
model = new Lebi_Agent_User();
}
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!EX_Admin.Power("agent_config", "代理-参数设置"))
{
WindowNoPower();
}
id = RequestTool.RequestInt("id", 0);
model = B_Lebi_Agent_User.GetModel("User_id = " + id + "");
if (model == null)
{
model = new Lebi_Agent_User();
model.Angent1_Commission = -1;
model.Angent2_Commission = -1;
model.Angent3_Commission = -1;
}
}
private decimal GetAngentCommission3(Lebi_DT_Agent dt_agent, Lebi_User user)
{
if (user != null)
{
Lebi_UserLevel userlevel = B_Lebi_UserLevel.GetModel(user.UserLevel_id);
if (userlevel != null)
{
if (userlevel.IsUsedAgent == 0) //关闭推广佣金
{
return(0);
}
}
if (dt_agent != null)
{
if (dt_agent.IsUsedAgent == 0)
{
return(0);
}
if (dt_agent.Angent3_Commission != -1)
{
return(dt_agent.Angent3_Commission);
}
}
Lebi_Agent_User agent_user = B_Lebi_Agent_User.GetModel("User_id = " + user.id + "");
if (agent_user != null)
{
if (agent_user.Angent3_Commission != -1)
{
return(agent_user.Angent3_Commission);
}
}
Lebi_Agent_UserLevel agent_userlevel = B_Lebi_Agent_UserLevel.GetModel("UserLevel_id = " + user.UserLevel_id + "");
if (agent_userlevel != null)
{
if (agent_userlevel.Angent3_Commission != -1)
{
return(agent_userlevel.Angent3_Commission);
}
}
}
decimal yongjin = 0;//3级佣金比例
decimal.TryParse(bc.Angent3_Commission, out yongjin);
return(yongjin);
}
protected override void LoadPage(string themecode, int siteid, string languagecode, string pcode)
{
if (!Shop.LebiAPI.Service.Instanse.Check("plugin_agent"))
{
Response.Write(Tag("权限不足"));
Response.End();
}
if (CurrentUser.id == 0)
{
Response.Redirect(URL("P_Login", "" + HttpUtility.UrlEncode(RequestTool.GetRequestUrlNonDomain()) + "," + GetUrlToken(RequestTool.GetRequestUrlNonDomain()) + ""));
}
BaseConfig bc = ShopCache.GetBaseConfig();
LoadTheme(themecode, siteid, languagecode, pcode);
path = "<a href=\"" + URL("P_Index", "") + "\" class=\"home\" title=\"" + Tag("首页") + "\"><span>" + Tag("首页") + "</span></a><em class=\"home\">»</em><a href=\"" + URL("P_UserCenter", "") + "\"><span>" + Tag("会员中心") + "</span></a><em>»</em><a class=\"text\"><span>" + Tag("推广佣金") + "</span></a>";
decimal.TryParse(bc.Angent1_Commission, out Angent1_Commission);
decimal.TryParse(bc.Angent2_Commission, out Angent2_Commission);
Lebi_Agent_User agent_user = B_Lebi_Agent_User.GetModel("User_id = " + CurrentUser.id + "");
if (agent_user != null)
{
if (agent_user.Angent1_Commission != -1)
{
Angent1_Commission = agent_user.Angent1_Commission;
}
if (agent_user.Angent2_Commission != -1)
{
Angent2_Commission = agent_user.Angent2_Commission;
}
}
Lebi_Agent_User agent_userlevel = B_Lebi_Agent_User.GetModel("User_id = " + CurrentUser.UserLevel_id + "");
if (agent_userlevel != null)
{
if (agent_userlevel.Angent1_Commission != -1)
{
Angent1_Commission = agent_userlevel.Angent1_Commission;
}
if (agent_userlevel.Angent2_Commission != -1)
{
Angent2_Commission = agent_userlevel.Angent2_Commission;
}
}
}
/// <summary>
/// 得到一个对象实体 by id
/// </summary>
public Lebi_Agent_User GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [Lebi_Agent_User] ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Lebi_Agent_User model = new Lebi_Agent_User();
DataSet ds = SqlUtils.SqlUtilsInstance.TextExecuteDataset(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (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"].ToString() != "")
{
model.User_id = int.Parse(ds.Tables[0].Rows[0]["User_id"].ToString());
}
if (ds.Tables[0].Rows[0]["Angent1_Commission"].ToString() != "")
{
model.Angent1_Commission = decimal.Parse(ds.Tables[0].Rows[0]["Angent1_Commission"].ToString());
}
if (ds.Tables[0].Rows[0]["Angent2_Commission"].ToString() != "")
{
model.Angent2_Commission = decimal.Parse(ds.Tables[0].Rows[0]["Angent2_Commission"].ToString());
}
if (ds.Tables[0].Rows[0]["Angent3_Commission"].ToString() != "")
{
model.Angent3_Commission = decimal.Parse(ds.Tables[0].Rows[0]["Angent3_Commission"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Lebi_Agent_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Lebi_Agent_User](");
strSql.Append("[User_id],[Angent1_Commission],[Angent2_Commission],[Angent3_Commission])");
strSql.Append(" values (");
strSql.Append("@User_id,@Angent1_Commission,@Angent2_Commission,@Angent3_Commission)");
OleDbParameter[] parameters =
{
new OleDbParameter("@User_id", model.User_id),
new OleDbParameter("@Angent1_Commission", model.Angent1_Commission),
new OleDbParameter("@Angent2_Commission", model.Angent2_Commission),
new OleDbParameter("@Angent3_Commission", model.Angent3_Commission)
};
AccessUtils.Instance.TextExecuteNonQuery(strSql.ToString(), parameters);
return(1);
}
/// <summary>
/// 得到一个对象实体 by where条件
/// </summary>
public Lebi_Agent_User GetModel(string strWhere)
{
if (strWhere.IndexOf("lbsql{") > 0)
{
SQLPara para = new SQLPara(strWhere, "", "");
return(GetModel(para));
}
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [Lebi_Agent_User] ");
strSql.Append(" where " + strWhere + "");
Lebi_Agent_User model = new Lebi_Agent_User();
DataSet ds = SqlUtils.SqlUtilsInstance.TextExecuteDataset(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (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"].ToString() != "")
{
model.User_id = int.Parse(ds.Tables[0].Rows[0]["User_id"].ToString());
}
if (ds.Tables[0].Rows[0]["Angent1_Commission"].ToString() != "")
{
model.Angent1_Commission = decimal.Parse(ds.Tables[0].Rows[0]["Angent1_Commission"].ToString());
}
if (ds.Tables[0].Rows[0]["Angent2_Commission"].ToString() != "")
{
model.Angent2_Commission = decimal.Parse(ds.Tables[0].Rows[0]["Angent2_Commission"].ToString());
}
if (ds.Tables[0].Rows[0]["Angent3_Commission"].ToString() != "")
{
model.Angent3_Commission = decimal.Parse(ds.Tables[0].Rows[0]["Angent3_Commission"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Lebi_Agent_User model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Lebi_Agent_User] set ");
strSql.Append("[User_id]=@User_id,");
strSql.Append("[Angent1_Commission]=@Angent1_Commission,");
strSql.Append("[Angent2_Commission]=@Angent2_Commission,");
strSql.Append("[Angent3_Commission]=@Angent3_Commission");
strSql.Append(" where id=" + model.id);
OleDbParameter[] parameters =
{
new OleDbParameter("@User_id", model.User_id),
new OleDbParameter("@Angent1_Commission", model.Angent1_Commission),
new OleDbParameter("@Angent2_Commission", model.Angent2_Commission),
new OleDbParameter("@Angent3_Commission", model.Angent3_Commission)
};
AccessUtils.Instance.TextExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 安全方式绑定对象表单
/// </summary>
public Lebi_Agent_User SafeBindForm(Lebi_Agent_User model)
{
if (HttpContext.Current.Request["User_id"] != null)
{
model.User_id = Shop.Tools.RequestTool.RequestInt("User_id", 0);
}
if (HttpContext.Current.Request["Angent1_Commission"] != null)
{
model.Angent1_Commission = Shop.Tools.RequestTool.RequestDecimal("Angent1_Commission", 0);
}
if (HttpContext.Current.Request["Angent2_Commission"] != null)
{
model.Angent2_Commission = Shop.Tools.RequestTool.RequestDecimal("Angent2_Commission", 0);
}
if (HttpContext.Current.Request["Angent3_Commission"] != null)
{
model.Angent3_Commission = Shop.Tools.RequestTool.RequestDecimal("Angent3_Commission", 0);
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static void Update(Lebi_Agent_User model)
{
D_Lebi_Agent_User.Instance.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(Lebi_Agent_User model)
{
return(D_Lebi_Agent_User.Instance.Add(model));
}
/// <summary>
/// 安全方式绑定表单数据
/// </summary>
public static Lebi_Agent_User SafeBindForm(Lebi_Agent_User model)
{
return(D_Lebi_Agent_User.Instance.SafeBindForm(model));
}
public static Model Info(Lebi_User user)
{
BaseConfig bc = ShopCache.GetBaseConfig();
Model m = new Model();
decimal Money = 0;
string money_ = Common.GetValue("select sum(Money) from Lebi_Agent_Money where User_id=" + user.id + " and Type_id_AgentMoneyStatus=382 and datediff(d,Time_add,'" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')>" + bc.CommissionMoneyDays + "");
decimal.TryParse(money_, out Money);
int UserCount = 0;
UserCount = B_Lebi_User.Counts("User_id_parent=" + user.id + "");
int UserCountmonth = 0;
UserCountmonth = B_Lebi_User.Counts("User_id_parent=" + user.id + " and (datediff(d,Time_Reg,'" + System.DateTime.Now.Date.AddDays(0 - System.DateTime.Now.Day + 1).ToString("yyyy-MM-dd") + "')<=0 and datediff(d,Time_Reg,'" + System.DateTime.Now + "')>=0)");
int UserCountday = 0;
UserCountday = B_Lebi_User.Counts("User_id_parent=" + user.id + " and (datediff(d,Time_Reg,'" + System.DateTime.Now.Date.ToString("yyyy-MM-dd") + "')<=0 and datediff(d,Time_Reg,'" + System.DateTime.Now + "')>=0)");
decimal Commission1 = 0;
decimal Commission2 = 0;
decimal Commission3 = 0;
decimal.TryParse(bc.Angent1_Commission, out Commission1);
decimal.TryParse(bc.Angent2_Commission, out Commission2);
decimal.TryParse(bc.Angent3_Commission, out Commission3);
if (user.DT_id == 0)
{
Lebi_Agent_UserLevel agent_userlevel = B_Lebi_Agent_UserLevel.GetModel("UserLevel_id = " + user.UserLevel_id + "");
if (agent_userlevel != null)
{
if (agent_userlevel.Angent1_Commission != -1)
{
Commission1 = agent_userlevel.Angent1_Commission;
}
if (agent_userlevel.Angent2_Commission != -1)
{
Commission2 = agent_userlevel.Angent2_Commission;
}
if (agent_userlevel.Angent3_Commission != -3)
{
Commission3 = agent_userlevel.Angent3_Commission;
}
}
Lebi_Agent_User agent_user = B_Lebi_Agent_User.GetModel("User_id = " + user.id + "");
if (agent_user != null)
{
if (agent_user.Angent1_Commission != -1)
{
Commission1 = agent_user.Angent1_Commission;
}
if (agent_user.Angent2_Commission != -1)
{
Commission2 = agent_user.Angent2_Commission;
}
if (agent_user.Angent3_Commission != -1)
{
Commission3 = agent_user.Angent3_Commission;
}
}
}
else
{
Lebi_DT_Agent dt_agent = B_Lebi_DT_Agent.GetModel("DT_id = " + user.DT_id + "");
if (dt_agent != null)
{
if (dt_agent.IsUsedAgent == 1)
{
Commission1 = dt_agent.Angent1_Commission;
Commission2 = dt_agent.Angent2_Commission;
Commission3 = dt_agent.Angent3_Commission;
}
}
}
m.Money = Money;
m.UserCount = UserCount;
m.UserCountmonth = UserCountmonth;
m.UserCountday = UserCountday;
m.Commission1 = Commission1;
m.Commission2 = Commission2;
m.Commission3 = Commission3;
Lebi_UserLevel userlevel = B_Lebi_UserLevel.GetModel(user.UserLevel_id);
if (userlevel != null)
{
if (userlevel.IsUsedAgent == 0) //关闭注册
{
m.Commission1 = 0;
m.Commission2 = 0;
m.Commission3 = 0;
}
}
return(m);
}
