/// <summary> /// 通过网络图删除会员 /// </summary> /// <param name="member">会员编号</param> /// <returns></returns> public string DelMembersDeclarationTreeNet(string member) { string info = ""; //判断该会员是否当前期注册 int regQishu = browsememberordersDAL.GetMemberRegisterQS(member); int maxExcept = Convert.ToInt32(CommonDataDAL.GetMaxExpect()); if (regQishu < maxExcept) { info = "对不起,该会员不是当前期注册的,不可以删除!"; return(info); } //判断该会员是否有复效单 int result = browsememberordersDAL.GetHasOrderAgain(member); if (result > 0) { info = "对不起!该会员有重复消费请先删除重复消费!"; return(info); } //int tjCount = browsememberordersDAL.GetTuiJianCount(member,false); //if (tjCount > 0) //{ // info = "对不起!该会员已经推荐了其他会员,不能删除!"; // return info; //} //int azCount = browsememberordersDAL.GetTuiJianCount(member, true); //if (azCount > 0) //{ // info = "对不起!该会员已经安置了其他会员,不能删除!"; // return info; //} int xh = browsememberordersDAL.GetXHanzhi(member); if (xh > 0) { info = "对不起!删除该会员后安置人数以超过2人,请将上级位置空出后再操作。!"; return(info); } string orderId = browsememberordersDAL.GetOrderID(member); string storeId = browsememberordersDAL.GetStoreID(member); using (SqlConnection conn = new SqlConnection(DBHelper.connString)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { //删除后 下面的人紧缩上来 (用循环调网其下面的人) browsememberordersDAL.XunHuanTW(member, maxExcept, tran); browsememberordersDAL.DelNew(member, maxExcept, tran); addOrderDataDAL.Del_Horder(tran, orderId, storeId, CommonDataBLL.OperateBh, CommonDataBLL.OperateIP); tran.Commit(); info = "删除成功"; } catch (Exception) { info = "抱歉!系统异常,删除失败!"; tran.Rollback(); conn.Close(); return(info); } finally { conn.Close(); conn.Dispose(); } } return(info); }