void SubmitHandler(TcpSocketClient client, Submit submit)
{
var resp = new Submit_Resp
{
SequenceNumber = submit.SequenceNumber,
Result = CommandError.Success
};
client.Send(resp.GetBytes());
//添加SP发送的Submit消息到数据库
var mSubmit = new MSubmit
{
TargetSequenceNumber = submit.SequenceNumber,
SequenceNumber = submit.SequenceNumberString,
SPNumber = submit.SPNumber,
UserNumber = submit.UserNumber,
ReportFlag = (int)submit.ReportFlag,
Content = submit.MessageContent,
Created = DateTime.Now,
Status = 0
};
StorageProvider <SubmitStorage> .GetStorage().Insert(mSubmit);
//转发给消息中心处理
MessageCenter.GetInstance().Commit(submit);
}
public MSubmit Get(string sequenceNumber)
{
MSubmit m = null;
string sql = @"SELECT * from Submit WHERE SequenceNumber = @SequenceNumber limit 0 , 1 ";
try
{
m = base.Query <MSubmit>(sql, new { SequenceNumber = sequenceNumber }).FirstOrDefault();
}
catch
{
throw;
}
return(m);
}
public int Insert(MSubmit m)
{
int count = 0;
string sql = @"INSERT INTO Submit (TargetSequenceNumber , SequenceNumber , SPNumber , UserNumber , ReportFlag , Content , Status , Created)
VALUES(@TargetSequenceNumber , @SequenceNumber , @SPNumber , @UserNumber , @ReportFlag , @Content , @Status , @Created)";
try
{
count += base.Execute(sql, m);
}
catch
{
throw;
}
return(count);
}
