/// <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()))); }