public void AddNewFilter(string id, string msg) { //元フォームから直接呼ばれる ButtonNew.Enabled = false; ButtonEdit.Enabled = false; ButtonRuleUp.Enabled = false; ButtonRuleDown.Enabled = false; ButtonRuleCopy.Enabled = false; ButtonRuleMove.Enabled = false; ButtonDelete.Enabled = false; ButtonClose.Enabled = false; EditFilterGroup.Enabled = true; ListTabs.Enabled = false; GroupTab.Enabled = false; ListFilters.Enabled = false; RadioAND.Checked = true; RadioPLUS.Checked = false; UID.Text = id; UID.SelectAll(); MSG1.Text = msg; MSG1.SelectAll(); MSG2.Text = id + msg; MSG2.SelectAll(); TextSource.Text = ""; UID.Enabled = true; MSG1.Enabled = true; MSG2.Enabled = false; CheckRegex.Checked = false; CheckURL.Checked = false; CheckCaseSensitive.Checked = false; CheckRetweet.Checked = false; CheckLambda.Checked = false; RadioExAnd.Checked = true; RadioExPLUS.Checked = false; ExUID.Text = ""; ExUID.SelectAll(); ExMSG1.Text = ""; ExMSG1.SelectAll(); ExMSG2.Text = ""; ExMSG2.SelectAll(); TextExSource.Text = ""; ExUID.Enabled = true; ExMSG1.Enabled = true; ExMSG2.Enabled = false; CheckExRegex.Checked = false; CheckExURL.Checked = false; CheckExCaseSensitive.Checked = false; CheckExRetweet.Checked = false; CheckExLambDa.Checked = false; OptCopy.Checked = true; CheckMark.Checked = true; UID.Focus(); _mode = EDITMODE.AddNew; _directAdd = true; }
private void ShowDetail() { if (_directAdd) { return; } if (ListFilters.SelectedIndex > -1) { FiltersClass fc = (FiltersClass)ListFilters.SelectedItem; if (fc.SearchBoth) { RadioAND.Checked = true; RadioPLUS.Checked = false; UID.Enabled = true; MSG1.Enabled = true; MSG2.Enabled = false; UID.Text = fc.NameFilter; UID.SelectAll(); MSG1.Text = ""; MSG2.Text = ""; foreach (string bf in fc.BodyFilter) { MSG1.Text += bf + " "; } MSG1.Text = MSG1.Text.Trim(); MSG1.SelectAll(); } else { RadioPLUS.Checked = true; RadioAND.Checked = false; UID.Enabled = false; MSG1.Enabled = false; MSG2.Enabled = true; UID.Text = ""; MSG1.Text = ""; MSG2.Text = ""; foreach (string bf in fc.BodyFilter) { MSG2.Text += bf + " "; } MSG2.Text = MSG2.Text.Trim(); MSG2.SelectAll(); } TextSource.Text = fc.Source; CheckRegex.Checked = fc.UseRegex; CheckURL.Checked = fc.SearchUrl; CheckCaseSensitive.Checked = fc.CaseSensitive; CheckRetweet.Checked = fc.IsRt; CheckLambda.Checked = fc.UseLambda; if (fc.ExSearchBoth) { RadioExAnd.Checked = true; RadioExPLUS.Checked = false; ExUID.Enabled = true; ExMSG1.Enabled = true; ExMSG2.Enabled = false; ExUID.Text = fc.ExNameFilter; ExUID.SelectAll(); ExMSG1.Text = ""; ExMSG2.Text = ""; foreach (string bf in fc.ExBodyFilter) { ExMSG1.Text += bf + " "; } ExMSG1.Text = ExMSG1.Text.Trim(); ExMSG1.SelectAll(); } else { RadioExPLUS.Checked = true; RadioExAnd.Checked = false; ExUID.Enabled = false; ExMSG1.Enabled = false; ExMSG2.Enabled = true; ExUID.Text = ""; ExMSG1.Text = ""; ExMSG2.Text = ""; foreach (string bf in fc.ExBodyFilter) { ExMSG2.Text += bf + " "; } ExMSG2.Text = ExMSG2.Text.Trim(); ExMSG2.SelectAll(); } TextExSource.Text = fc.ExSource; CheckExRegex.Checked = fc.ExUseRegex; CheckExURL.Checked = fc.ExSearchUrl; CheckExCaseSensitive.Checked = fc.ExCaseSensitive; CheckExRetweet.Checked = fc.IsExRt; CheckExLambDa.Checked = fc.ExUseLambda; if (fc.MoveFrom) { OptMove.Checked = true; } else { OptCopy.Checked = true; } CheckMark.Checked = fc.SetMark; ButtonEdit.Enabled = true; ButtonDelete.Enabled = true; ButtonRuleUp.Enabled = true; ButtonRuleDown.Enabled = true; ButtonRuleCopy.Enabled = true; ButtonRuleMove.Enabled = true; } else { RadioAND.Checked = true; RadioPLUS.Checked = false; UID.Enabled = true; MSG1.Enabled = true; MSG2.Enabled = false; UID.Text = ""; MSG1.Text = ""; MSG2.Text = ""; TextSource.Text = ""; CheckRegex.Checked = false; CheckURL.Checked = false; CheckCaseSensitive.Checked = false; CheckRetweet.Checked = false; CheckLambda.Checked = false; RadioExAnd.Checked = true; RadioExPLUS.Checked = false; ExUID.Enabled = true; ExMSG1.Enabled = true; ExMSG2.Enabled = false; ExUID.Text = ""; ExMSG1.Text = ""; ExMSG2.Text = ""; TextExSource.Text = ""; CheckExRegex.Checked = false; CheckExURL.Checked = false; CheckExCaseSensitive.Checked = false; CheckExRetweet.Checked = false; CheckExLambDa.Checked = false; OptCopy.Checked = true; CheckMark.Checked = true; ButtonEdit.Enabled = false; ButtonDelete.Enabled = false; ButtonRuleUp.Enabled = false; ButtonRuleDown.Enabled = false; ButtonRuleCopy.Enabled = false; ButtonRuleMove.Enabled = false; } }
private void ShowDetail() { if (_directAdd) { return; } if (ListFilters.SelectedIndex > -1) { PostFilterRule fc = (PostFilterRule)ListFilters.SelectedItem; if (fc.UseNameField) { RadioAND.Checked = true; RadioPLUS.Checked = false; UID.Enabled = true; MSG1.Enabled = true; MSG2.Enabled = false; UID.Text = fc.FilterName; UID.SelectAll(); MSG1.Text = string.Join(" ", fc.FilterBody); MSG1.SelectAll(); MSG2.Text = ""; } else { RadioPLUS.Checked = true; RadioAND.Checked = false; UID.Enabled = false; MSG1.Enabled = false; MSG2.Enabled = true; UID.Text = ""; MSG1.Text = ""; MSG2.Text = string.Join(" ", fc.FilterBody); MSG2.SelectAll(); } TextSource.Text = fc.FilterSource; CheckRegex.Checked = fc.UseRegex; CheckURL.Checked = fc.FilterByUrl; CheckCaseSensitive.Checked = fc.CaseSensitive; CheckRetweet.Checked = fc.FilterRt; CheckLambda.Checked = fc.UseLambda; if (fc.ExUseNameField) { RadioExAnd.Checked = true; RadioExPLUS.Checked = false; ExUID.Enabled = true; ExMSG1.Enabled = true; ExMSG2.Enabled = false; ExUID.Text = fc.ExFilterName; ExUID.SelectAll(); ExMSG1.Text = string.Join(" ", fc.ExFilterBody); ExMSG1.SelectAll(); ExMSG2.Text = ""; } else { RadioExPLUS.Checked = true; RadioExAnd.Checked = false; ExUID.Enabled = false; ExMSG1.Enabled = false; ExMSG2.Enabled = true; ExUID.Text = ""; ExMSG1.Text = ""; ExMSG2.Text = string.Join(" ", fc.ExFilterBody); ExMSG2.SelectAll(); } TextExSource.Text = fc.ExFilterSource; CheckExRegex.Checked = fc.ExUseRegex; CheckExURL.Checked = fc.ExFilterByUrl; CheckExCaseSensitive.Checked = fc.ExCaseSensitive; CheckExRetweet.Checked = fc.ExFilterRt; CheckExLambDa.Checked = fc.ExUseLambda; if (fc.MoveMatches) { OptMove.Checked = true; } else { OptCopy.Checked = true; } CheckMark.Checked = fc.MarkMatches; ButtonEdit.Enabled = true; ButtonDelete.Enabled = true; ButtonRuleUp.Enabled = true; ButtonRuleDown.Enabled = true; ButtonRuleCopy.Enabled = true; ButtonRuleMove.Enabled = true; } else { RadioAND.Checked = true; RadioPLUS.Checked = false; UID.Enabled = true; MSG1.Enabled = true; MSG2.Enabled = false; UID.Text = ""; MSG1.Text = ""; MSG2.Text = ""; TextSource.Text = ""; CheckRegex.Checked = false; CheckURL.Checked = false; CheckCaseSensitive.Checked = false; CheckRetweet.Checked = false; CheckLambda.Checked = false; RadioExAnd.Checked = true; RadioExPLUS.Checked = false; ExUID.Enabled = true; ExMSG1.Enabled = true; ExMSG2.Enabled = false; ExUID.Text = ""; ExMSG1.Text = ""; ExMSG2.Text = ""; TextExSource.Text = ""; CheckExRegex.Checked = false; CheckExURL.Checked = false; CheckExCaseSensitive.Checked = false; CheckExRetweet.Checked = false; CheckExLambDa.Checked = false; OptCopy.Checked = true; CheckMark.Checked = true; ButtonEdit.Enabled = false; ButtonDelete.Enabled = false; ButtonRuleUp.Enabled = false; ButtonRuleDown.Enabled = false; ButtonRuleCopy.Enabled = false; ButtonRuleMove.Enabled = false; } }
public async Task <MSG2ReturnModels> SetMessageOperationResult(MSG2 MSG2) { var returnModel = new MSG2ReturnModels(); try { if (MSG2 == null || MSG2.SequenceID <= 0) { returnModel.ErrMSG = string.Format("Set结果设定异常:SequenceID={0}", MSG2 != null ? MSG2.SequenceID : -1); returnModel.NextSequenceID = null; return(returnModel); } userid = HttpContext.Current.User.Identity.GetUserId(); var systemCode = UserManager.FindById(userid).SystemCode; if (!string.IsNullOrEmpty(MSG2.ErrorMSG)) { var oMSG = _db.OMSG.Find(MSG2.SequenceID); MSG2.Status = oMSG.Status + 1; } else { MSG2.Status = 0; } var sqlcmdExists = string.Format(@"SELECT T0.* FROM IF_MSG2 T0 WHERE T0.SequenceID = {0} AND T0.TargetSystem = '{1}' ", MSG2.SequenceID, systemCode); var dataExists = _db.Database.SqlQuery <MSG2>(sqlcmdExists); if (dataExists.Count() == 0) { MSG2.CreateTime = DateTime.Now; } else { MSG2.CreateTime = dataExists.First().CreateTime; } MSG2.TargetSystem = systemCode; MSG2.UpdateTime = DateTime.Now; _db.MSG2.AddOrUpdate(MSG2); _db.SaveChanges(); //写入日志表 var sqlLog2 = string.Format(@"INSERT INTO dbo.IF_MSG2_Log( SequenceID ,TargetSystem ,Status ,ErrorMSG ,CreateTime ,MSGOriContent ,MSGJXContent ,TargetDB ,TargetType ,TargetValue ,Remark ,UpdateUser) SELECT T0.SequenceID,'{0}',T2.Status,T2.ErrorMSG,GETDATE(),T1.Content,'' AS MSGJXContent,T2.TargetDB,T2.TargetType,T2.TargetValue,N'' AS Remark,'{1}' FROM DBO.IF_OMSG T0 JOIN DBO.IF_MSG1 T1 ON T1.SequenceID = T0.SequenceID JOIN DBO.IF_MSG2 T2 ON T2.SequenceID = T0.SequenceID AND T2.TargetSystem = '{2}' WHERE T2.SequenceID = {3}", systemCode, userid, systemCode, MSG2.SequenceID); _db.Database.ExecuteSqlCommand(sqlLog2); returnModel.ErrMSG = ""; //成功后返回下一条SequenceID var sqlcmd = string.Format(@"SELECT TOP 1 T0.SequenceID FROM IF_OMSG T0 JOIN IF_OMSG3 T1 ON T0.FromSystem = T1.FromSystem AND T0.FromCompany = T1.FromCompany AND T0.Flag = T1.Flag AND T0.ObjectType = T1.ObjectType AND T1.ToSystem = '{0}' LEFT JOIN IF_MSG2 T2 ON T0.SequenceID = T2.SequenceID AND T2.targetsystem = '{0}' WHERE (T0.Status <> -1) AND (( T2.status IS NULL) OR (T2.status <>0 AND T2.status <= T0.Status)) ORDER BY T0.SequenceID ", systemCode); var data = _db.Database.SqlQuery <int>(sqlcmd); if (data.Count() > 0) { var nextsequenceId = _db.Database.SqlQuery <int>(sqlcmd).First(); returnModel.NextSequenceID = nextsequenceId; } else { returnModel.NextSequenceID = null; } return(returnModel); } catch (Exception ex) { returnModel.ErrMSG = ex.Message + ex.InnerException.InnerException.Message; returnModel.NextSequenceID = null; return(returnModel); } }