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