public static PageData <RuleConfig> GetConfigRules(int pageIndex, string keyWords, string requestType, string serviceName, int?runStatus, int?status) { var conn = DapperDbContext.GetConnection; var sqlBuilder = new StringBuilder(); sqlBuilder.AppendLine("select r.*,rownum as rowno from ruleconfig r where 1=1 "); if (!string.IsNullOrEmpty(keyWords)) { sqlBuilder.AppendFormat("and (Upper(r.Description) like Upper('%{0}%') or Upper(r.Method) like Upper('%{0}%') or Upper(r.PostBody) like Upper('%{0}%') or Upper(r.ContentType) like Upper('%{0}%') or Upper(userName) like Upper('%{0}%')) ", keyWords.ToUpper()).AppendLine(); } if (!string.IsNullOrEmpty(requestType)) { sqlBuilder.AppendFormat("and upper(r.method) like Upper('%{0}%') ", requestType.ToUpper()).AppendLine(); } if (runStatus.HasValue && runStatus > 0) { sqlBuilder.AppendFormat("and r.RunStatus = {0} ", runStatus.Value).AppendLine(); } if (status.HasValue && status > 0) { sqlBuilder.AppendFormat("and r.status = {0} ", status.Value).AppendLine(); } if (!string.IsNullOrEmpty(serviceName)) { sqlBuilder.AppendFormat("and Upper(r.ServiceName) like Upper('%{0}') ", serviceName.ToUpper()).AppendLine(); } return(DapperDbContext.ExecuteWithPageing <RuleConfig>(sqlBuilder.ToString(), pageIndex)); }
/// <summary> /// 构造初始化 /// </summary> public SharedService() { var dapperDbContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200DbConnectionString)); _accountUser = new DapperRepository <AccountUser>(dapperDbContext); }
private static void Query(DapperDbContext db) { var a1 = db.Query <User>(x => x.Name == "张三").Select(x => new { title = x.Name }).ToList(); var a2 = db.Query <User>(x => x.Id > 0).ToList(); var a3 = db.SqlQueryDynamic(" select * from users ", null); var a4 = db.Query <User>(x => x.Id == 12).FirstOrDefault(); var a5 = db.Query <User>(x => x.Id > 1).OrderBy(x => x.Id).ThenByDescending(x => x.Age).ToList(); var total = 0; var a6 = db.Query <User>(x => x.Id > 1).OrderBy(x => x.Id).ThenByDescending(x => x.Age).ToPageList(1, 5, out total); var a7 = db.Query <User>(x => x.Id > 0).GroupBy(x => x.Age).Select(x => x.Id).ToList(); var a8 = db.Query <User>(x => x.Id > 0).Max(x => x.Id); var a9 = db.Query <User>().Where("age=1").FirstOrDefault(); var id = 10; var a10 = db.Query <User>(x => x.Id == id).FirstOrDefault(); var g = true; var a11 = db.Query <User>(x => x.Gender1 && x.Gender1 == g).FirstOrDefault(); }
/// <summary> /// 初始化 /// </summary> public SettingsService() { var dapperDbContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200DbConnectionString)); _smsTemplateDapperRepository = new DapperRepository <SmsTemplates>(dapperDbContext); }
private void button2_Click(object sender, EventArgs e) { DapperDbContext context = new DapperDbContext(CurrentConfig.ConnectionString); var list = context.QueryAmountData(dateTimePicker1.Value, dateTimePicker2.Value); dataGridView1.DataSource = list; }
void refreshList() { DapperDbContext context = new DapperDbContext(CurrentConfig.ConnectionString); var list = context.QueryTableConfigs(); dataGridView1.DataSource = list; }
public static PageData <MonitorLogRecordConfigView> GetConfigRulesWithLogs(int pageIndex, string keyWords, string method, string serviceName, int?status, DateTime beginTime, DateTime endTime) { var sqlBuilder = new StringBuilder(); sqlBuilder.AppendLine("select m.responseMessage,m.ruleconfigid,m.operationtype,m.message,m.createtime,m.executetime,m.statusCode,m.statusCodeDescription,r.*,rownum as rowno from monitorlogrecord m inner join ruleconfig r on m.ruleconfigid = r.id where 1=1 "); if (!string.IsNullOrEmpty(keyWords)) { sqlBuilder.AppendFormat("and (Upper(r.Description) like Upper('%{0}%') or Upper(r.Method) like Upper('%{0}%') or Upper(r.PostBody) like Upper('%{0}%') or Upper(r.ContentType) like Upper('%{0}%') or Upper(userName) like Upper('%{0}%')) ", keyWords.ToUpper()).AppendLine(); } if (!string.IsNullOrEmpty(method)) { sqlBuilder.AppendFormat("and upper(r.Method) like Upper('%{0}%') ", method.ToUpper()).AppendLine(); } if (status.HasValue && status > 0) { sqlBuilder.AppendFormat("and r.Status = {0} ", status.Value).AppendLine(); } if (!string.IsNullOrEmpty(serviceName)) { sqlBuilder.AppendFormat("and upper(r.ServiceName) like Upper('%{0}') ", serviceName.ToUpper()).AppendLine(); } sqlBuilder.AppendFormat("and m.CreateTime >= to_date('{0:yyyy-MM-dd}','yyyy-mm-dd') ", beginTime).AppendLine(); sqlBuilder.AppendFormat("and m.CreateTime <= to_date('{0:yyyy-MM-dd}','yyyy-mm-dd') ", endTime.AddDays(1)).AppendLine(); return(DapperDbContext.ExecuteWithPageing <MonitorLogRecordConfigView>(sqlBuilder.ToString(), pageIndex)); }
public GoodsService() { var dapperDbContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200DbConnectionString)); _goodsSummaryRepository = new DapperRepository <GoodsInfoSummary>(dapperDbContext); }
private void button1_Click(object sender, EventArgs e) { TableConfig item = new TableConfig { name = textBox1.Text.Trim(), alias = textBox2.Text.Trim(), url = textBox3.Text.Trim(), Bid = textBox4.Text.Trim(), sourcesite = comboBox1.SelectedItem.ToString().Trim() }; try { DapperDbContext context = new DapperDbContext(CurrentConfig.ConnectionString); if (!context.InsertTableConfigs(item)) { MessageBox.Show("新增保存失败."); return; } } catch (Exception exception) { MessageBox.Show(exception.Message); return; } refreshList(); }
/// <summary> /// 不同币种的订单和订单详情数据入库 /// </summary> /// <param name="prefix"></param> /// <param name="order"></param> /// <param name="list"></param> private void RequestHandler_NotifyOrderData(string prefix, OrderEntity order, List <OrderDetailEntity> list) { DapperDbContext context = new DapperDbContext(CurrentConfig.ConnectionString); context.InsertOrderData(prefix, order, list); //BTMrefreshSign = true; }
public DefaultLogger() { var dapperDbContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.WebAPILogDbConnection)); _requestlogRepository = new DapperRepository <RequestLog>(dapperDbContext); _logRepository = new DapperRepository <Log>(dapperDbContext); _nLogger = new NLogger(); }
public static int UpdateState(DapperDbContext db, long orderId, EnmOrderDetailState state) { var now = DateTime.Now; return(db.Update <OrderDetail>(x => x.Id == orderId, x => new OrderDetail { Status = state, ReceivingTime = now })); }
public static void Init(DapperDbContext db) { //var user = db.Query<User>(x => x.Name == "张三").FirstOrDefault(); //Add(db); //Delete(db); Update(db, 200202, EnmUserGender.男); //Query(db); }
public UserCouponService() { var dapperContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200DbConnectionString)); _couponInfoDapperRepository = new DapperRepository <CouponInfo>(dapperContext); _couponListDapperRepository = new DapperRepository <CouponList>(dapperContext); }
public ExpensesService() { var dapperDbContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200DbConnectionString)); _expensesRepository = new DapperRepository <PayRecord>(dapperDbContext); _expensesCategoryRepository = new DapperRepository <PayClass>(dapperDbContext); _cacheManager = new NullCache(); }
public FeedbackService() { var dapperContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200SysDbConnectionString)); _checkSysTaskDailyDapperRepository = new DapperRepository <string>(dapperContext); _sysTaskDailyDapperRepository = new DapperRepository <SysTaskDaily>(dapperContext); _sysAccountDapperRepository = new DapperRepository <SysAccount>(dapperContext); }
void BindBiCheckBoxList() { DapperDbContext context = new DapperDbContext(CurrentConfig.ConnectionString); var list = context.QueryTableConfigs(); checkedListBox1.DataSource = list; checkedListBox1.DisplayMember = "name"; checkedListBox1.ValueMember = "alias"; }
/// <summary> /// 初始化 /// </summary> public MoodService() { var dapperContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200DbConnectionString)); _accountUserLogSignDapperRepository = new DapperRepository <LogSign>(dapperContext); _accountBusinessDapperRepository = new DapperRepository <Business>(dapperContext); _accountUserLogInfoDapperRepository = new DapperRepository <LogInfo>(dapperContext); _accountMoodDapperRepository = new DapperRepository <MoodInfo>(dapperContext); }
public void Main() { using (IQuery con = new DapperDbContext(DatabaseConst.SMSGateway)) { keywords = con.Query <QuizModel>("GetKeyword"); } ipStr = ConfigurationManager.AppSettings["SMSGWIPServer"]; portStr = ConfigurationManager.AppSettings["SMSGWPortServer"];; }
public void Main() { using (IQuery con = new DapperDbContext(DatabaseConst.SMSGateway)) { keywords = con.Query<QuizModel>("GetKeyword"); } ipStr = ConfigurationManager.AppSettings["SMSGWIPServer"]; portStr = ConfigurationManager.AppSettings["SMSGWPortServer"];; }
public BasicDataService() { var dapperDbContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200DbConnectionString)); _addressBaseRepository = new DapperRepository <AddressBase>(dapperDbContext); _accountRepository = new DapperRepository <Entity.Model.Account.Account>(dapperDbContext); _userRankRepository = new DapperRepository <UserRank>(dapperDbContext); _userInfoDetailRepository = new DapperRepository <UserInfoDetail>(dapperDbContext); }
/// <summary> /// 初始化 /// </summary> public ModuleService() { var dapperContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200DbConnectionString)); _moduleDapperRepository = new DapperRepository <Module>(dapperContext); _moduleAccountUserDapperRepository = new DapperRepository <AccountUserModule>(dapperContext); _moduleUserDapperRepository = new DapperRepository <Entity.Model.Modules.AccountUserModule>(dapperContext); _accountBusinessDapperRepository = new DapperRepository <Business>(dapperContext); }
public OnlineMallService() { var dapperDbContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200DbConnectionString)); _materialGoods = new DapperRepository <T_MaterialGoods2>(dapperDbContext); _materalgoodspic = new DapperRepository <T_MaterialGoodsPic>(dapperDbContext); _mobileEvaluation = new DapperRepository <MobileEvaluation>(dapperDbContext); _receiveAddress = new DapperRepository <T_Receiving_Address>(dapperDbContext); _receiveAddressAdd = new DapperRepository <ReceiveingAddressAdd>(dapperDbContext); }
private static void Delete(DapperDbContext db) { var user = db.Query <User>(x => x.Name == "张三").FirstOrDefault(); db.Delete(user); Add(db); db.Delete <User>(x => x.Name == "张三"); Add(db); db.DeleteAll <User>(); Add(db); }
public void AddDbContext(DapperDbContext dbContext) { if (ActiveDbContexts.ContainsKey(dbContext.GetKey())) { return; } ActiveDbContexts.Add(dbContext.GetKey(), dbContext); if (_dbContextAddedEvent != null) { _dbContextAddedEvent(dbContext); } }
private static void Update(DapperDbContext db, int id, EnmUserGender g) { //var user = db.Query<User>(x => x.Name == "张三").FirstOrDefault(); //user.Age = 20; var now = DateTime.Now; UpdateState(db, 3, EnmOrderDetailState.确认收货完成订单); //db.Update<User>(x => x.Id == id, x => new User { Gender = g, OpTime=now }); //db.Update(user); //db.Update<User>(x => x.Name == "张三", x => new User { Gender = EnmUserGender.男 }); }
private static void Add(DapperDbContext db) { var user = new User { Age = 1, Gender = EnmUserGender.女, Name = "张三", OpTime = DateTime.Now, Gender1 = true }; db.Add <User>(user); }
public AdvertService() { _logger = new NLogger(); var dapperDbContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200StationDbConnectionString)); _advertDataRepository = new DapperRepository <Entity.Model.Advert.Advert>(dapperDbContext); _advertResourcesDataRepository = new DapperRepository <AdvertResources>(dapperDbContext); _advertLogDataRepository = new DapperRepository <AdvertLog>(dapperDbContext); }
public UserStoreMoneyCardService() { var dapperDbContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200DbConnectionString)); _userInfoRepository = new DapperRepository <UserInfoDetail>(dapperDbContext); _userLogRepository = new DapperRepository <UserLogInfo>(dapperDbContext); _userStoreMoneyTransactionDapperRepository = new DapperRepository <UserStoreTransactionRecordResultItem>(dapperDbContext); _userStoreTransactionRecordSumRepository = new DapperRepository <UserStoreTransactionRecordResult>(dapperDbContext); _userStoreMoneyCardDapperRepository = new DapperRepository <UserStoreMoneySearchResultItem>(dapperDbContext); _useraddDapperRepository = new DapperRepository <UserHandle>(dapperDbContext); }
/// <summary> /// 初始化 /// </summary> public SalesService() { var dapperContext = new DapperDbContext(new SqlConnection(WebConfigSetting.Instance.I200DbConnectionString)); _salesDapperRepository = new DapperRepository <SalesInfo>(dapperContext); _salesListDapperRepository = new DapperRepository <SalesList>(dapperContext); _salesLogDapperRepository = new DapperRepository <SaleLogInfo>(dapperContext); _goodsSummaryDapperRepository = new DapperRepository <GoodsInfoSummary>(dapperContext); _iUserTimesCardService = new UserTimesCardService(); _iUserStoreMoneyCardService = new UserStoreMoneyCardService(); _iUserService = new UserService(); _accountDapperRepository = new DapperRepository <Entity.Model.Account.Account>(dapperContext); _userInfoDapperRepository = new DapperRepository <UserInfoDetail>(dapperContext); _userLogRepository = new DapperRepository <UserLogInfo>(dapperContext); }
public DapperDbContextDir(string tableName) { var key = settingDis.ContainsKey(tableName) ? tableName : "default"; SqlConnectionString(); config = settingDis[key]; if (dicDbConnectionPool.ContainsKey(key)) { return; } lock (dicDbConnectionPool) { if (!dicDbConnectionPool.ContainsKey(key)) { dicDbConnectionPool[key] = new DapperDbContext(config.ConnectionString); } } }
//public void OnDataSent(string data) //{ //} public void OnDataReceived(string data) { List<BaseResult<SMSReadResult>> list = JsonHelper.JsonDeserialize<List<BaseResult<SMSReadResult>>>(data); if (list.Count > 0) { foreach (BaseResult<SMSReadResult> read in list) { if (read.Response.TypeName.Contains("SMSRead")) { if (keywords.Any()) { foreach (QuizModel keyword in keywords) { Match match = new Regex(@"(.*[a-zA-Z]) (.*[a-zA-Z])").Match(keyword.Keyword); if (match.Success) { if (read.Response.Message.ToLower().Contains(match.Groups[1].Value.ToLower())) { string[] arg = read.Response.Message.ToLower().Split(new string[] { match.Groups[1].Value.ToLower() }, StringSplitOptions.RemoveEmptyEntries); using (IQuery con = new DapperDbContext(DatabaseConst.SMSGateway)) { List<Answer> result = con.Query<Answer>(keyword.Response, new { KeyID = arg[0].Trim() }); if (result.Any()) { smsSender = new GSMClient.Client(ipStr, Convert.ToInt32(portStr)); smsSender.Open(); smsSender.Send(string.Format(GSMClient.Command.CommandCollection.SMSSend, read.Response.From, result.SingleOrDefault().Description)); smsSender.Close(); } } break; } } } } } } } }