public bool ArquivarAcompanhamento(int idAcompanhamento) { try { using (dbDataContext db = getDataContext()) { String sSql = "update acompanhamentos set ativo = 0 where id = {0}"; int qtdRet = db.ExecuteCommand(sSql, idAcompanhamento); return(qtdRet > 0); } } catch (Exception e) { message = e.Message; return(false); } }
public string SetMembers(String Members, Guid UserKey, string _GameMode) { DateTime StartTime = DateTime.Now; DataTable MemberSource = new DataTable(); MemberSource.Columns.Add("User_Contact"); MemberSource.Columns.Add("User_ContactType"); MemberSource.Columns.Add("User_ContactID"); MemberSource.Columns.Add("User_ContactTEMPID"); MemberSource.Columns.Add("User_IsReply", typeof(Boolean)); MemberSource.Columns.Add("User_IsSendPic", typeof(Boolean)); MemberSource.Columns.Add("User_IsReceiveTransfer", typeof(Boolean)); MemberSource.Columns.Add("User_IsCaculateFuli", typeof(Boolean)); MemberSource.Columns.Add("User_SourceType"); MemberSource.Columns.Add("User_IsBoss", typeof(Boolean)); MemberSource.Columns.Add("User_IsBallPIC", typeof(Boolean)); MemberSource.Columns.Add("User_ISSendCard", typeof(Boolean)); MemberSource.Columns.Add("User_IsAdmin", typeof(Boolean)); MemberSource.Columns.Add("User_FiveMinuteMode", typeof(Boolean)); MemberSource.Columns.Add("User_HkMode", typeof(Boolean)); MemberSource.Columns.Add("User_AozcMode", typeof(Boolean)); MemberSource.Columns.Add("User_ChongqingMode", typeof(Boolean)); MemberSource.Columns.Add("User_TengXunShiFen", typeof(Boolean)); MemberSource.Columns.Add("User_TengXunWuFen", typeof(Boolean)); MemberSource.Columns.Add("User_HeNeiWuFen", typeof(Boolean)); MemberSource.Columns.Add("User_TengXunShiFenXin", typeof(Boolean)); MemberSource.Columns.Add("User_TengXunWuFenXin", typeof(Boolean)); MemberSource.Columns.Add("User_XinJiangShiShiCai", typeof(Boolean)); MemberSource.Columns.Add("User_VR", typeof(Boolean)); DataColumn[] dcs = { MemberSource.Columns["User_ContactTEMPID"], MemberSource.Columns["User_SourceType"] }; MemberSource.PrimaryKey = dcs; DateTime EachStart = DateTime.Now; JObject _Members = JObject.Parse(Members); dbDataContext db = new dbDataContext(System.Configuration.ConfigurationManager.ConnectionStrings["LocalSQLServer"].ConnectionString); db.ExecuteCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED"); //db.ObjectTrackingEnabled = false; //this.Invoke(new Action(() => { BS_Contact.DataSource = null; })); foreach (var item in (_Members["MemberList"]) as JArray) { EachStart = DateTime.Now; string UserNametempID = ""; string NickName = ""; string RemarkName = ""; string HeadImgUrl = ""; UserNametempID = (item["UserName"] as JValue).Value.ToString(); NickName = (item["NickName"] as JValue).Value.ToString(); RemarkName = (item["RemarkName"] as JValue).Value.ToString(); HeadImgUrl = (item["HeadImgUrl"] as JValue).Value.ToString(); //NetFramework.Console.WriteLine("更新联系人" + NickName); //Application.DoEvents(); System.Text.RegularExpressions.Regex FindSeq = new System.Text.RegularExpressions.Regex("seq=([0-9])+"); string Seq = FindSeq.Match(HeadImgUrl).Value; //Seq = Seq.Substring(Seq.IndexOf("=") + 1); Seq = RemarkName == "" ? CleanHtml(NickName) : RemarkName; //if (Seq.Contains("-")) //{ // string[] Names = Seq.Split("-".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); // Seq = Names[Names.Length-1]; //} WX_UserReply usrc = db.WX_UserReply.SingleOrDefault(t => t.aspnet_UserID == UserKey && t.WX_UserName == Seq && t.WX_SourceType == "微"); if (usrc == null) { WX_UserReply newusrc = new WX_UserReply(); newusrc.aspnet_UserID = UserKey; newusrc.WX_UserName = Seq; newusrc.WX_SourceType = "微"; newusrc.RemarkName = RemarkName; newusrc.NickName = CleanHtml(NickName); newusrc.IsCaculateFuli = true; if (UserNametempID.StartsWith("@@") == false) { newusrc.IsReply = true; } else { newusrc.IsReply = true; } db.WX_UserReply.InsertOnSubmit(newusrc); db.SubmitChanges(); ; } //初始化,添加到数据库或同步数据库 else { if ((usrc.RemarkName != RemarkName) || (usrc.NickName != CleanHtml(NickName)) ) { usrc.RemarkName = RemarkName; usrc.NickName = CleanHtml(NickName); } //if (UserNametempID.StartsWith("@@") == false && Seq != "0") { usrc.IsReply = true; } } //初始化,添加到数据库或同步数据库 WX_WebSendPICSetting webpcset = db.WX_WebSendPICSetting.SingleOrDefault(t => t.aspnet_UserID == UserKey && t.WX_SourceType == "微" && t.WX_UserName == Seq ); if (webpcset == null) { webpcset = new WX_WebSendPICSetting(); webpcset.aspnet_UserID = UserKey; webpcset.WX_SourceType = "微"; webpcset.WX_UserName = Seq; webpcset.ballinterval = 120; webpcset.footballPIC = false; webpcset.bassketballpic = false; webpcset.balluclink = false; webpcset.card = false; webpcset.cardname = ""; webpcset.shishicailink = false; webpcset.NumberPIC = false; webpcset.dragonpic = false; webpcset.numericlink = false; webpcset.dragonlink = false; webpcset.IsSendPIC = false; webpcset.NiuNiuPic = false; webpcset.NoBigSmallSingleDoublePIC = false; webpcset.NumberDragonTxt = true; webpcset.NumberPIC = false; webpcset.dragonpic = false; { webpcset.PIC_StartHour = 8; } { webpcset.PIC_StartMinute = 58; } { webpcset.PIC_EndHour = 2; } { webpcset.Pic_EndMinute = 3; } db.WX_WebSendPICSetting.InsertOnSubmit(webpcset); db.SubmitChanges(); } usrc = db.WX_UserReply.SingleOrDefault(t => t.aspnet_UserID == UserKey && t.WX_UserName == Seq && t.WX_SourceType == "微"); if (_GameMode != "") { usrc.ChongqingMode = (_GameMode == "重庆" ? true : false); usrc.VRMode = (_GameMode == "VR" ? true : false);; usrc.AozcMode = (_GameMode == "澳彩" ? true : false);; usrc.HkMode = (_GameMode == "香港" ? true : false); usrc.XinJiangMode = (_GameMode == "新疆" ? true : false); usrc.FiveMinuteMode = (_GameMode == "五分" ? true : false);; usrc.TengXunWuFenMode = (_GameMode == "腾五" ? true : false);; usrc.TengXunWuFenXinMode = (_GameMode == "腾五信" ? true : false);; usrc.TengXunShiFenMode = (_GameMode == "腾十" ? true : false);; usrc.TengXunShiFenXinMode = (_GameMode == "腾十信" ? true : false);; usrc.HeNeiWuFenMode = (_GameMode == "河内" ? true : false);; } DataRow[] Lists = { MemberSource.Rows.Find(new object[] { UserNametempID, "微" }) }; // //MemberSource.Select("User_ContactTEMPID='" + UserNametempID + "' and User_SourceType='微'"); DataRow newr = null; if (Lists.Length == 0 || Lists[0] == null) { newr = MemberSource.NewRow(); newr.SetField("User_ContactTEMPID", UserNametempID); newr.SetField("User_SourceType", "微"); MemberSource.Rows.Add(newr); } else { newr = Lists[0]; } newr.SetField("User_ContactID", Seq); newr.SetField("User_Contact", NickName); newr.SetField("User_ContactType", UserNametempID.StartsWith("@@") ? "群" : "个人"); newr.SetField("User_IsReply", usrc.IsReply); newr.SetField("User_IsSendPic", webpcset.IsSendPIC); newr.SetField("User_IsAdmin", usrc.IsAdmin); newr.SetField("User_IsBallPIC", usrc.IsBallPIC); //if (UserNametempID.StartsWith("@@") == false && Seq != "0") { newr.SetField("User_IsReply", usrc == null ? false : usrc.IsReply); } newr.SetField("User_IsReceiveTransfer", usrc == null ? false : usrc.IsReceiveTransfer); newr.SetField("User_IsCaculateFuli", usrc == null ? false : usrc.IsCaculateFuli); newr.SetField("User_IsBoss", usrc == null ? false : (usrc.IsBoss == null ? false : usrc.IsBoss)); newr.SetField("User_FiveMinuteMode", usrc == null ? false : (usrc.FiveMinuteMode == null ? false : usrc.FiveMinuteMode)); newr.SetField("User_HkMode", usrc == null ? false : (usrc.HkMode == null ? false : usrc.HkMode)); newr.SetField("User_AozcMode", usrc == null ? false : (usrc.AozcMode == null ? false : usrc.AozcMode)); newr.SetField("User_ChongqingMode", usrc == null ? false : (usrc.ChongqingMode == null ? false : usrc.ChongqingMode)); newr.SetField("User_TengXunShiFen", usrc == null ? false : (usrc.TengXunShiFenMode == null ? false : usrc.TengXunShiFenMode)); newr.SetField("User_TengXunWuFen", usrc == null ? false : (usrc.TengXunWuFenMode == null ? false : usrc.TengXunWuFenMode)); newr.SetField("User_TengXunShiFenXin", usrc == null ? false : (usrc.TengXunShiFenXinMode == null ? false : usrc.TengXunShiFenXinMode)); newr.SetField("User_TengXunWuFenXin", usrc == null ? false : (usrc.TengXunWuFenXinMode == null ? false : usrc.TengXunWuFenXinMode)); newr.SetField("User_XinJiangShiShiCai", usrc == null ? false : (usrc.XinJiangMode == null ? false : usrc.XinJiangMode)); newr.SetField("User_VR", usrc == null ? false : (usrc.VRMode == null ? false : usrc.VRMode)); newr.SetField("User_HeNeiWuFen", usrc == null ? false : (usrc.HeNeiWuFenMode == null ? false : usrc.HeNeiWuFenMode)); //var UpdateLogs = ReplySource.AsEnumerable().Where(t => t.Field<string>("Reply_ContactID") == Seq); //foreach (var logitem in UpdateLogs) //{ // logitem.SetField("Reply_ContactTEMPID", UserNametempID); // logitem.SetField("Reply_Contact", RemarkName == "" ? NickName : RemarkName); //} EachStart = DateTime.Now; db.SubmitChanges(); }//成员列表循环 return(JsonConvert.SerializeObject(MemberSource)); // BS_Contact.Sort = "User_Contact"; }