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