public static string Add(Model.Task model) { if (CommonBase.RunHashtable(Add(model, new Hashtable()))) { return("操作成功"); } return("操作失败"); }
/// <summary> /// 删除会员 /// </summary> /// <param name="mid"></param> /// <returns></returns> public static string DeleteMember(string midList) { string[] mids = midList.Split(','); Hashtable MyHs = new Hashtable(); int count = mids.Length; int successcount = 0; foreach (string mid in mids) { if (string.IsNullOrEmpty(mid)) { continue; } lock (DAL.Member.tempMemberList) { //DAL.Member.tempMemberList.Clear(); //Model.Member model = DAL.Member.GetModel(mid); //List<Model.ChangeMoney> ChangeMoneyList = ChangeMoneyCollection.GetChangeMoneyEntityList(string.Format("SHMID='{0}'", mid)); //List<Model.MConfigChange> MConfigChangeList = MConfigChange.GetMConfigChangeEntityList(string.Format("SHMID='{0}'", mid)); //DAL.Member.tempMemberList.Clear();//清空临时字典 //string guid = Guid.NewGuid().ToString(); //foreach (Model.ChangeMoney item in ChangeMoneyList) //{ // if (item.CState) // { // DAL.ChangeMoney.TranChangeTran(item.ToMID, item.FromMID, item.Money - item.TakeOffMoney, item.MoneyType, MyHs); // } //} //foreach (Model.MConfigChange item in MConfigChangeList) //{ // guid = Guid.NewGuid().ToString(); // if (item.IsValue) // { // MyHs.Add(string.Format("update MemberConfig set {0} = '{1}' where MID = '{2}' " + " and '" + guid + "'='" + guid + "'", item.ConfigName, item.ConfigValue, item.MID), null); // } // else // { // MyHs.Add(string.Format("update MemberConfig set {0} ={0}- {1} where MID = '{2}' " + " and '" + guid + "'='" + guid + "'", item.ConfigName, item.ConfigValue, item.MID), null); // } //} MyHs.Add(string.Format("delete from ChangeMoney where SHMID='{0}'", mid), null); MyHs.Add(string.Format("delete from Member where MID='{0}'", mid), null); MyHs.Add(string.Format("delete from MemberConfig where MID='{0}'", mid), null); MyHs.Add(string.Format("delete from MConfigChange where SHMID='{0}'", mid), null); if (CommonBase.RunHashtable(MyHs)) { DAL.Member.tempMemberList.Clear();//清空临时字典 successcount++; } } } DAL.Member.tempMemberList.Clear();//清空临时字典 return(string.Format("成功:{0},失败{1}", successcount, count - successcount)); }
/// <summary> /// 删除会员 /// </summary> /// <param name="mid"></param> /// <returns></returns> public static string DeleteMemberW(string midList, string tjmid) { string[] mids = midList.Split(','); Hashtable MyHs = new Hashtable(); int count = mids.Length; foreach (string mid in mids) { Model.Member model = DAL.Member.GetModel(mid); if (DAL.Member.GetModel(tjmid).Role.IsAdmin) { MyHs.Add("delete from member where mid='" + model.MID + "'; delete from memberconfig where mid ='" + model.MID + "';", null); } else if (model.MTJ == tjmid && model.AgencyCode == "001") { MyHs.Add("delete from member where mid='" + model.MID + "'; delete from memberconfig where mid ='" + model.MID + "';", null); } } if (CommonBase.RunHashtable(MyHs)) { return("操作成功"); } return("操作失败"); }