public static IEnumerable <SubscribeMessage> LoadMessages(MessageQueryFilter filter, out int totalCount) { var sql = DataCommandHelper.GetDataCommandSql("LoadMessages", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { string whereStr = "WHERE 1 = 1"; if (!string.IsNullOrWhiteSpace(filter.Topic)) { whereStr += " AND `subscribemessage`.`Topic`=@Topic"; } if (!string.IsNullOrWhiteSpace(filter.ReferenceIdentifier)) { whereStr += " AND `message`.`ReferenceIdentifier`=@ReferenceIdentifier"; } if (filter.CreateDateFrom.HasValue) { whereStr += " AND `message`.`CreateDate`>=@CreateDateFrom"; } if (filter.CreateDateTo.HasValue) { whereStr += " AND `message`.`CreateDate`<@CreateDateTo"; } whereStr += " Order By `message`.`CreateDate` DESC"; sql = sql.Replace("#StrWhere#", whereStr); var result = conn.QueryMultiple(sql, filter); var messages = result.Read <SubscribeMessage>(); totalCount = result.ReadFirstOrDefault <int>(); return(messages); } }
public static void UpdateMessageStatusToFail(Guid messageId, string topic) { var sql = DataCommandHelper.GetDataCommandSql("UpdateMessageStatusToFail", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { conn.Execute(sql, new { MessageId = messageId, Topic = topic }); } }
public static void UpdateMessageStatusToSuccess(Guid messageId, string topic, long milliseconds) { var sql = DataCommandHelper.GetDataCommandSql("UpdateMessageStatusToSuccess", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { conn.Execute(sql, new { MessageId = messageId, Topic = topic, TimePeriod = milliseconds }); } }
public static void UpdateMessageStatusToPrepared(Guid messageId) { var sql = DataCommandHelper.GetDataCommandSql("UpdateMessageStatusToPrepared", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { conn.Execute(sql, new { MessageId = messageId }); } }
public static bool ExistsMessage(string hashFingerprint) { var sql = DataCommandHelper.GetDataCommandSql("ExistsMessage", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { return(conn.ExecuteScalar <bool>(sql, new { HashFingerprint = hashFingerprint })); } }
public static IEnumerable <ProcessFailRecord> LoadProcessFailRecords(Guid messageId) { var sql = DataCommandHelper.GetDataCommandSql("LoadProcessFailRecords", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { return(conn.Query <ProcessFailRecord>(sql, new { MessageId = messageId })); } }
public static void CreateProcessFailRecord(ProcessFailRecord record) { var sql = DataCommandHelper.GetDataCommandSql("CreateProcessFailRecord", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { conn.Execute(sql, record); } }
public static void CreateApp(App app) { var sql = DataCommandHelper.GetDataCommandSql("CreateApp", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { conn.Execute(sql, app); } }
public static IEnumerable <Topic> LoadTopics() { var sql = DataCommandHelper.GetDataCommandSql("LoadTopics", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { return(conn.Query <Topic>(sql)); } }
public static Topic LoadTopicByTopicName(string name) { var sql = DataCommandHelper.GetDataCommandSql("LoadTopicByTopicName", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { return(conn.QueryFirstOrDefault <Topic>(sql, new { Name = name })); } }
public static bool ExistsApp(string appId) { var sql = DataCommandHelper.GetDataCommandSql("ExistsApp", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { return(conn.ExecuteScalar <bool>(sql, new { AppID = appId })); } }
public static void EditTopic(Topic topic) { var sql = DataCommandHelper.GetDataCommandSql("EditTopic", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { conn.Execute(sql, topic); } }
public static Topic LoadTopicBySysNo(int sysno) { var sql = DataCommandHelper.GetDataCommandSql("LoadTopicBySysNo", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { return(conn.QueryFirstOrDefault <Topic>(sql, new { SysNo = sysno })); } }
public static void UpdateTopicStatusToInValid(int sysno) { var sql = DataCommandHelper.GetDataCommandSql("UpdateTopicStatusToInValid", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { conn.Execute(sql, new { SysNo = sysno }); } }
public static bool ExistsTopic(string topic) { var sql = DataCommandHelper.GetDataCommandSql("ExistsTopic", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { return(conn.ExecuteScalar <bool>(sql, new { Name = topic })); } }
public static void RemoveServerNode(string server) { var sql = DataCommandHelper.GetDataCommandSql("RemoveServerNode", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { conn.Execute(sql, new { ServerHost = server }); } }
public static void CreateExchange(Exchange exchange) { var sql = DataCommandHelper.GetDataCommandSql("CreateExchange", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { conn.Execute(sql, exchange); } }
public static bool ExistsServer(string server) { var sql = DataCommandHelper.GetDataCommandSql("ExistsServer", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { return(conn.ExecuteScalar <bool>(sql, new { ServerHost = server })); } }
/// <summary> /// 获取单位时间内发布失败的消息,单位小时 /// </summary> /// <param name="publishReloadTimeSpan"></param> /// <returns></returns> public static IEnumerable <Message> LoadPublishFailedMessage(int publishReloadTimeSpan) { var sql = DataCommandHelper.GetDataCommandSql("LoadPublishFailedMessage", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { return(conn.Query <Message>(sql, new { PublishReloadTimeSpan = publishReloadTimeSpan })); } }
static void Main(string[] args) { var fac = new MysqlFactory(); var result = fac.GetDatabaseConnection().GetDatabaseConnection(); Console.WriteLine(result); Console.ReadKey(); }
public static SubscribeMessage LoadMessage(Guid messageId, string topic) { var sql = DataCommandHelper.GetDataCommandSql("LoadMessage", out string connectionString); using (IDbConnection conn = MysqlFactory.CreateConnection(connectionString)) { var result = conn.QueryMultiple(sql, new { MessageId = messageId, Topic = topic }); var message = result.ReadFirstOrDefault <SubscribeMessage>(); message.ProcessFailRecords = result.Read <ProcessFailRecord>().AsList(); return(message); } }
/// <summary> /// 数据库录入 /// </summary> /// <param name="list">缓存列表</param> static void DataToBase(List <baidutb> list) { MysqlFactory.Instance.DefaultConnStr = MysqlFactory.GetConnStr("localhost", "root", "456123", "fortest"); ORMHelper.DefaultDataFactory = MysqlFactory.Instance; DataControl dc = ORMHelper.DefaultDataFactory.Create(); dc.BeginTransaction(); foreach (var item in list) { ORMHelper.InsertOrUpdate(item, dc); } dc.Commit(); dc.Close(); }
static void Main(string[] args) { #region Mysql string ip = CC.Utility.iniHelper.ReadValue(FilePath, "Mysql", "ip"); string user = CC.Utility.iniHelper.ReadValue(FilePath, "Mysql", "user"); string psw = CC.Utility.iniHelper.ReadValue(FilePath, "Mysql", "psw"); string dataBase = CC.Utility.iniHelper.ReadValue(FilePath, "Mysql", "dataBase"); MysqlFactory.Instance.DefaultConnStr = MysqlFactory.GetConnStr(ip, user, psw, dataBase); ORMHelper.DefaultDataFactory = MysqlFactory.Instance; #endregion TaskView t = new TaskView(); t.SetDlgTitle("Tmall_Skechers"); t.AddTask(GetLiningTmallData.Instance); //t.AddTask(GetLiningResult.Instance); t.ShowDialog(); }
static void Main(string[] args) { #region Mysql string ip = CC.Utility.iniHelper.ReadValue(FilePath, "Mysql", "ip"); string user = CC.Utility.iniHelper.ReadValue(FilePath, "Mysql", "user"); string psw = CC.Utility.iniHelper.ReadValue(FilePath, "Mysql", "psw"); string dataBase = CC.Utility.iniHelper.ReadValue(FilePath, "Mysql", "dataBase"); MysqlFactory.Instance.DefaultConnStr = MysqlFactory.GetConnStr(ip, user, psw, dataBase); ORMHelper.DefaultDataFactory = MysqlFactory.Instance; #endregion //GetData_CSV.GotResultCsv("Skechers_Tmall_20170328.xlsx", "20170328分析", "Skechers_Tmall_20170328"); TaskView t = new TaskView(); t.SetDlgTitle("Tmall_Skechers"); //t.AddTask(Get_SkechersResult.Instance); t.AddTask(Tmall_Skechers_Task.Instance); t.ShowDialog(); }