/// <summary>
/// 更新一条数据
/// </summary>
public static Hashtable Update(Model.MemberApply model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("update MemberApply set ");
strSql.Append(" ApplyType = @ApplyType , ");
strSql.Append(" MID = @MID , ");
strSql.Append(" MQQ = @MQQ , ");
strSql.Append(" MQQGroup = @MQQGroup , ");
strSql.Append(" MTel = @MTel , ");
strSql.Append(" ApplyTime = @ApplyTime , ");
strSql.Append(" State = @State , ");
strSql.Append(" ConfirmTime = @ConfirmTime , ");
strSql.Append(" Remark = @Remark ");
strSql.Append(" where Id=@Id ");
strSql.AppendFormat(" ;select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@ApplyType", SqlDbType.VarChar, 50),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@MQQ", SqlDbType.VarChar, 20),
new SqlParameter("@MQQGroup", SqlDbType.VarChar, 20),
new SqlParameter("@MTel", SqlDbType.VarChar, 20),
new SqlParameter("@ApplyTime", SqlDbType.DateTime),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@ConfirmTime", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.ApplyType;
parameters[2].Value = model.MID;
parameters[3].Value = model.MQQ;
parameters[4].Value = model.MQQGroup;
parameters[5].Value = model.MTel;
parameters[6].Value = model.ApplyTime;
parameters[7].Value = model.State;
parameters[8].Value = model.ConfirmTime;
parameters[9].Value = model.Remark;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
protected override string btnAdd_Click()
{
//查询是否申请过了
Model.MemberApply app = BLL.MemberApply.CheckHasApplyed(TModel.MID, 0, Request.Form["rdoupmagecy"]);
if (app != null)
{
return("您已经申请过了，请等待管理员审核。");
}
Model.SHMoney shmoney = BLL.Configuration.Model.SHMoneyList[Request.Form["rdoupmagecy"]];
//查看直推人数
if (TModel.MConfig.TJCount < shmoney.TJCount || TModel.MConfig.YJCount < shmoney.TemaCount)
{
return("申请失败，要申请到" + shmoney.MAgencyName + ",必须达到推荐人数" + shmoney.TJCount + "，团队人数" + shmoney.TemaCount);
}
else
{
//查询推荐人数中有多少经理，高级经理，
string sql = "select count(1) from Member WHERE MTJ='" + TModel.MID + "' AND AgencyCode='" + shmoney.TJAgency + "'";
object objCount = BLL.CommonBase.GetSingle(sql);
if (Convert.ToInt16(objCount) < shmoney.TJCount || TModel.MConfig.YJCount < shmoney.TemaCount)
{
return("申请失败，您的推荐人数不足或团队人数不足");
}
else
{
Model.MemberApply apply = new Model.MemberApply();
apply.ApplyTime = DateTime.Now;
apply.ApplyType = shmoney.MAgencyType;
apply.MID = TModel.MID;
apply.MTel = TModel.Tel;
apply.State = 0;
if (BLL.MemberApply.Insert(apply))
{
return("申请成功，请等待管理员审核。");
}
}
}
return("申请失败");
}
public override void ProcessRequest(HttpContext context)
{
base.ProcessRequest(context);
string strWhere = "'1'='1'";
strWhere += " and MID in (select MID from MemberConfig where IsRegionalDirector=1)";
if (!string.IsNullOrEmpty(context.Request["mKey"]))
{
strWhere += string.Format(" and ( MID='{0}' or MName='{0}') ", (context.Request["mKey"]));
}
int count;
List <Model.Member> ListMember = BllModel.GetMemberEntityList(strWhere, pageIndex, pageSize, out count);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < ListMember.Count; i++)
{
sb.Append(ListMember[i].MID + "~");
sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~");
//sb.Append(ListMember[i].Province+ListMember[i].MConfig.Region.ToString() + "区~");
sb.Append(ListMember[i].MID + "~");
sb.Append(ListMember[i].MName + "~");
sb.Append(ListMember[i].MAgencyType.MAgencyName + "~");
Model.MemberApply obj = GetMemberApply(ListMember[i].MID, 2, 1);
if (obj != null)
{
sb.Append(obj.MQQ + "~");
sb.Append(obj.MQQGroup + "~");
sb.Append(obj.MTel + "~");
sb.Append(obj.ApplyTime.ToString("yyyy-MM-dd HH:mm") + "~");
sb.Append(Convert.ToDateTime(obj.ConfirmTime).ToString("yyyy-MM-dd HH:mm"));
}
sb.Append("≌");
}
var info = new { PageData = Traditionalized(sb), TotalCount = count };
context.Response.Write(JavaScriptConvert.SerializeObject(info));
}
/// <summary>
/// 实体转换
/// <summary>
private static Model.MemberApply TranEntity(DataRow dr)
{
if (dr != null)
{
Model.MemberApply model = new Model.MemberApply();
if (!string.IsNullOrEmpty(dr["Id"].ToString()))
{
model.Id = int.Parse(dr["Id"].ToString());
}
model.ApplyType = dr["ApplyType"].ToString();
model.MID = dr["MID"].ToString();
model.MQQ = dr["MQQ"].ToString();
model.MQQGroup = dr["MQQGroup"].ToString();
model.MTel = dr["MTel"].ToString();
if (!string.IsNullOrEmpty(dr["ApplyTime"].ToString()))
{
model.ApplyTime = DateTime.Parse(dr["ApplyTime"].ToString());
}
if (!string.IsNullOrEmpty(dr["State"].ToString()))
{
model.State = int.Parse(dr["State"].ToString());
}
if (!string.IsNullOrEmpty(dr["ConfirmTime"].ToString()))
{
model.ConfirmTime = DateTime.Parse(dr["ConfirmTime"].ToString());
}
model.Remark = dr["Remark"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 注册股东
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected override string btnAdd_Click()
{
Model.MemberApply model = new Model.MemberApply();
model.MID = TModel.MID;
model.MQQ = Request.Form["txtQQ"];
model.ApplyTime = DateTime.Now;
model.MQQGroup = Request.Form["txtQQGroup"];
model.State = 1;
model.MTel = Request.Form["txtTel"];
model.ApplyType = Request.Form["hidtype"];
if (model.ApplyType == "1")
{
if (int.Parse(TModel.MAgencyType.MAgencyType) < int.Parse("004"))
{
return("您当前的级别不够申请资格，请先升级！");
}
}
else if (model.ApplyType == "2" || model.ApplyType == "3")
{
if (int.Parse(TModel.MAgencyType.MAgencyType) < int.Parse("005"))
{
return("您当前的级别不够申请资格，请先升级！");
}
}
if (CheckHasApplyed(TModel.MID, model.State, model.ApplyType) != null)//查看是否申请过
{
return("您当前已经申请过，请等待管理员审核！");
}
if (BLL.MemberApply.Insert(model))
{
//BLL.Task.SendManage(TModel, "001", TModel.MName + "申请了报单中心!");//给管理员发消息
return("申请成功");
}
return("您已申请过了");
}
/// <summary>
/// 增加一条数据
/// </summary>
public static Hashtable Insert(Model.MemberApply model, Hashtable MyHs)
{
string guid = Guid.NewGuid().ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MemberApply(");
strSql.Append("ApplyType,MID,MQQ,MQQGroup,MTel,ApplyTime,State,ConfirmTime,Remark");
strSql.Append(") values (");
strSql.Append("@ApplyType,@MID,@MQQ,@MQQGroup,@MTel,@ApplyTime,@State,@ConfirmTime,@Remark");
strSql.Append(") ");
strSql.AppendFormat(";select '{0}'", guid);
SqlParameter[] parameters =
{
new SqlParameter("@ApplyType", SqlDbType.VarChar, 50),
new SqlParameter("@MID", SqlDbType.VarChar, 50),
new SqlParameter("@MQQ", SqlDbType.VarChar, 20),
new SqlParameter("@MQQGroup", SqlDbType.VarChar, 20),
new SqlParameter("@MTel", SqlDbType.VarChar, 20),
new SqlParameter("@ApplyTime", SqlDbType.DateTime),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@ConfirmTime", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500)
};
parameters[0].Value = model.ApplyType;
parameters[1].Value = model.MID;
parameters[2].Value = model.MQQ;
parameters[3].Value = model.MQQGroup;
parameters[4].Value = model.MTel;
parameters[5].Value = model.ApplyTime;
parameters[6].Value = model.State;
parameters[7].Value = model.ConfirmTime;
parameters[8].Value = model.Remark;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
public static bool Update(Model.MemberApply model)
{
return(WE_Project.DAL.MemberApply.Update(model));
}
public static Hashtable Update(Model.MemberApply model, Hashtable MyHs)
{
return(WE_Project.DAL.MemberApply.Update(model, MyHs));
}
public static bool Insert(Model.MemberApply model)
{
return(WE_Project.DAL.MemberApply.Insert(model));
}
public static Hashtable Insert(Model.MemberApply model, Hashtable MyHs)
{
return(WE_Project.DAL.MemberApply.Insert(model, MyHs));
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Insert(Model.MemberApply model)
{
return(DAL.CommonBase.RunHashtable(Insert(model, new Hashtable())));
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(Model.MemberApply model)
{
return(DAL.CommonBase.RunHashtable(Update(model, new Hashtable())));
}
