private void AddSearchTokenFilter(QueryCommandConfig query) { if (string.IsNullOrWhiteSpace(_DbNetGridConfiguration.SearchToken)) { return; } var filter = new List <string>(); foreach (DbColumn column in _DbNetGridConfiguration.Columns) { if (column.SimpleSearch) { filter.Add($"{StripColumnRename(column.ColumnExpression)} like {Db.ParameterName("simplesearchtoken")}"); } } if (filter.Any() == false) { return; } query.Sql += $" where ({string.Join(" or ", filter)})"; query.Params["simplesearchtoken"] = $"%{_DbNetGridConfiguration.SearchToken}%"; }
public static void CalXsVegdata(string gs_guid, string xs_guid, ref VegData vegdata, DbNetDataProxy db) { decimal packweight = 1; string key = string.Concat(gs_guid, xs_guid, vegdata.Vegname); if (!packDic.ContainsKey(key)) { QueryCommandConfig qry = new QueryCommandConfig("select cfgdata from t_lk_chcfg where xs_guid = @xs_guid limit 1"); qry.Params["xs_guid"] = xs_guid; object cfg = db.ExecuteScalar(qry); if (cfg != null) { DataTable cfgDt = Rest.PackOrb.JsonToObj <DataTable>(cfg.ToString()); foreach (DataRow cfgR in cfgDt.Rows) { packDic.Add(string.Concat(gs_guid, xs_guid, cfgR.Field <string>("vegname")), Convert.ToDecimal(cfgR["packweight"])); if (cfgR.Field <string>("vegname").Equals(vegdata.Vegname)) { packweight = Convert.ToDecimal(cfgR["packweight"]); } } } } else { packweight = packDic[key]; } vegdata.Amount = decimal.Round(vegdata.Amount * packweight, 3); vegdata.Totalcost = vegdata.Totalcost; vegdata.Unitcost = decimal.Round(vegdata.Unitcost / packweight, 3); }
private DataTable getCfgData() { DataTable dt = null; string key = string.Concat(gs_guid, xs_guid); if (cfgDataDic.ContainsKey(key)) { dt = cfgDataDic[key]; } else { string addLk = ""; QueryCommandConfig qry = new QueryCommandConfig(); if (!string.IsNullOrWhiteSpace(gs_guid)) { addLk = "and lk_guid in (select org_guid from t_org_reginfo where super_guid = @gs_guid and org_type = 2)"; qry.Params["gs_guid"] = gs_guid; } qry.Sql = string.Format("select cfgdata from t_lk_chcfg where xs_guid = @xs_guid {0}", addLk); qry.Params["xs_guid"] = xs_guid; dt = db.GetDataTable(qry); cfgDataDic.Add(key, dt); } return(dt); }
private int getVegunit(string gs_guid, string xs_guid) { if (this.vegunit != 0) { return(this.vegunit); } else { try { QueryCommandConfig qry = new QueryCommandConfig("select vegunit from t_org_reginfo where org_guid = @xs_guid"); qry.Params["xs_guid"] = xs_guid; object vegunitObj = db.ExecuteScalar(qry); if (vegunitObj == null) { return(1); } else { this.vegunit = int.Parse(vegunitObj.ToString()); return(this.vegunit); } } catch (Exception ex) { DC.DCLogger.LogError(ex.Message); } } return(1); }
public static string CalZonestr(int zoneid, DbNetDataProxy db) { if (!zoneStrDic.ContainsKey(zoneid)) { string sql = null; int[] matchs = null; List <string> zoneList = new List <string>(); matchs = new int[] { zoneid, 1000 * (int)Math.Floor(zoneid / 1000d), 100000 * (int)Math.Floor(zoneid / 100000d), 10000000 * (int)Math.Floor(zoneid / 10000000d) }; sql = string.Format("select * from t_dic_zone where zoneid in ({0}) order by zoneid", string.Join(",", matchs)); QueryCommandConfig CmdConfig = new QueryCommandConfig(sql); DataTable dt = db.GetDataTable(CmdConfig); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { zoneList.Add(r.Field <string>("zonename")); } } zoneStrDic.Add(zoneid, string.Join("-", zoneList)); } return(zoneStrDic[zoneid]); }
public DataTable GetQuery(string query, string countQuery, ListDictionary parameters, out int aux) { aux = 0; try { QueryCommandConfig Query = new QueryCommandConfig(countQuery); Query.Params = parameters; db.ExecuteSingletonQuery(Query); var count = (int?)db.ReaderValue(0); if (count.HasValue) { aux = count.Value; } QueryCommandConfig queryCmd = new QueryCommandConfig(query); queryCmd.Params = parameters; db.ReturnAutoIncrementValue = true; var d = db.GetDataTable(queryCmd); db.Transaction.Commit(); return(d); } catch (Exception ex) { if (db.Conn.State == ConnectionState.Open) { db.Transaction.Rollback(); } UDLA.FLUJOS.PASANTIAS.Comun.Logger.ExLogger(ex); } return(null); }
public DataTable ExecuteDataTable(QueryCommandConfig cmd) { using (DbNetData db = CreateDbNetData()) { DataTable tbl = db.GetDataTable(cmd); return(tbl); } }
private void AddOrderBy(QueryCommandConfig query) { if (string.IsNullOrEmpty(_DbNetGridConfiguration.OrderByColumn)) { _DbNetGridConfiguration.OrderByColumn = _DbNetGridConfiguration.Columns.First().ColumnName; _DbNetGridConfiguration.OrderBySequence = "asc"; } query.Sql += $" order by {_DbNetGridConfiguration.OrderByColumn} {_DbNetGridConfiguration.OrderBySequence}"; }
private void AddDropDownFilter(QueryCommandConfig query) { if (string.IsNullOrWhiteSpace(_DbNetGridConfiguration.DropDownFilterValue)) { return; } query.Sql += $"{(query.Sql.Contains(" where ") ? " and " : " where ")}({_DbNetGridConfiguration.DropDownFilterColumn} = {Db.ParameterName("DropDownFilterValue")})"; query.Params["DropDownFilterValue"] = $"{_DbNetGridConfiguration.DropDownFilterValue}"; }
public void Execute(IJobExecutionContext context) { IConfig c = new IniConfigSource(System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "ConsoleJob.ini")).Configs["config"]; DbNetDataProxy dbp = new DbNetDataProxy(c.Get("DbConnectionString")); DbNetData db = null; try { db = dbp.GetDb(); db.BeginTransaction(); Dictionary <string, VegunitTrans> vtDic = new Dictionary <string, VegunitTrans>(); QueryCommandConfig XsQry = new QueryCommandConfig("select * from t_xs_wdat_xsmx where recdate >= @startdate and recdate <= @enddate and amount=kilo"); XsQry.Params["startdate"] = DateTime.Now.AddDays(-30); XsQry.Params["enddate"] = DateTime.Now; DataTable xsDt = db.GetDataTable(XsQry); foreach (DataRow r in xsDt.Rows) { string xs_guid = Convert.ToString(r["xs_guid"]); if (!vtDic.ContainsKey(xs_guid)) { vtDic.Add(xs_guid, new VegunitTrans(null, xs_guid.ToString(), dbp)); } VegunitTrans vt = vtDic[xs_guid]; UpdateCommandConfig upd = new UpdateCommandConfig("t_xs_wdat_xsmx"); upd.FilterParams["recid"] = r["recid"]; upd.FilterParams["recdate"] = r["recdate"]; upd.FilterParams["gs_guid"] = r["gs_guid"]; upd.FilterParams["xs_guid"] = r["xs_guid"]; upd.FilterParams["vegname"] = r["vegname"]; upd.Params["kilo"] = vt.CalWeight(Convert.ToString(r["vegname"]), Convert.ToDecimal(r["amount"])); db.ExecuteUpdate(upd); } db.Commit(); DC.DCLogger.LogTrace("Job successed [Job_GenerateXsmxKilo]"); } catch (Exception ex) { DC.DCLogger.LogError("Job failed [Job_GenerateXsmxKilo]:{0}", ex); } finally { if (db.Transaction != null) { db.Transaction.Dispose(); } dbp.PutDb(db); } }
public void Execute(IJobExecutionContext context) { IConfig c = new IniConfigSource(System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "ConsoleJob.ini")).Configs["config"]; DbNetDataProxy dbp = new DbNetDataProxy(c.Get("DbConnectionString")); DbNetData db = null; try { db = dbp.GetDb(); QueryCommandConfig qry = new QueryCommandConfig("select adv_id,adv_date,adv_cate,attachments from t_adv_vegsad where adv_date > @startdate and approved = 1 and dealed != 1"); qry.Params["startdate"] = DateTime.Now.AddDays(-4); DataTable dt = db.GetDataTable(qry); if (dt.Rows.Count > 0) { db.BeginTransaction(); Random ran = new Random(); //do market_xs foreach (DataRow r in dt.Rows) { CommandConfig updCmd = new CommandConfig("update t_adv_vegsad set readcount_fake = readcount_fake + @add where adv_cate=@adv_cate and adv_id=@adv_id and adv_date=@adv_date"); updCmd.Params["adv_cate"] = r["adv_cate"]; updCmd.Params["adv_id"] = r["adv_id"]; updCmd.Params["adv_date"] = r["adv_date"]; if (r["attachments"] != DBNull.Value && r["attachments"].ToString().Length > 0) { updCmd.Params["add"] = ran.Next(4); } else { updCmd.Params["add"] = ran.Next(2); } db.ExecuteNonQuery(updCmd); } db.Commit(); } DC.DCLogger.LogTrace("Job successed [Job_AddAdvReadcount]"); } catch (Exception ex) { DC.DCLogger.LogError("Job failed [Job_AddAdvReadcount]:{0}", ex); } finally { if (db.Transaction != null) { db.Transaction.Dispose(); } dbp.PutDb(db); } }
public static void CalXsVegdata(string gs_guid, string xs_guid, ref DataTable vegdata, DbNetDataProxy db) { QueryCommandConfig qry = new QueryCommandConfig("select vegunit from t_org_reginfo where org_guid = @xs_guid"); qry.Params["xs_guid"] = xs_guid; object vegunitObj = db.ExecuteScalar(qry); if (vegunitObj == null) { return; } int vegunit = int.Parse(vegunitObj.ToString()); if (vegunit != 2) { return; } string vegname = "vegname"; string amount = "amount"; string unitcost = "unitcost"; if (vegdata.Columns.Contains("unitprice")) { unitcost = "unitprice"; } string totalcost = "totalcost"; if (vegdata.Columns.Contains("totalprice")) { totalcost = "totalprice"; } if (vegdata != null && vegdata.Rows.Count > 0) { foreach (DataRow r in vegdata.Rows) { VegData vd = new VegData { Vegname = r.Field <string>(vegname), Amount = r.Field <decimal>(amount), Unitcost = r.Field <decimal>(unitcost), Totalcost = r.Field <decimal>(totalcost) }; CalXsVegdata(gs_guid, xs_guid, ref vd, db); r[amount] = vd.Amount; r[unitcost] = vd.Unitcost; r[totalcost] = vd.Totalcost; } } }
public void Execute(IJobExecutionContext context) { IConfig c = new IniConfigSource(System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "ConsoleJob.ini")).Configs["config"]; DbNetDataProxy dbp = new DbNetDataProxy(c.Get("DbConnectionString")); DbNetData db = null; try { db = dbp.GetDb(); db.BeginTransaction(); QueryCommandConfig xsQry = new QueryCommandConfig("select org_guid from t_org_reginfo where org_type =3"); DataTable xsDt = db.GetDataTable(xsQry); foreach (DataRow r in xsDt.Rows) { QueryCommandConfig vegQry = new QueryCommandConfig("select vegname,amount from t_xs_wdat_kc where xs_guid = @xs_guid"); vegQry.Params["xs_guid"] = r["org_guid"]; DataTable vegDt = dbp.GetDataTable(vegQry); if (vegDt.Rows.Count > 0) { var vegEnum = from veg in vegDt.AsEnumerable() orderby veg.Field <decimal>("amount") descending select veg.Field <string>("vegname"); UpdateCommandConfig xskcUpd = new UpdateCommandConfig("t_org_reginfo"); xskcUpd.FilterParams["org_guid"] = r["org_guid"]; xskcUpd.Params["business"] = string.Join("|", vegEnum); db.ExecuteUpdate(xskcUpd); } } db.Commit(); DC.DCLogger.LogTrace("Job successed [Job_GenerateXsBusiness]"); } catch (Exception ex) { DC.DCLogger.LogError("Job failed [Job_GenerateXsBusiness]:{0}", ex); } finally { if (db.Transaction != null) { db.Transaction.Dispose(); } dbp.PutDb(db); } }
public object GetSingleQuery(string query, ListDictionary parameters) { try { QueryCommandConfig Query = new QueryCommandConfig(query); Query.Params = parameters; db.ExecuteSingletonQuery(Query); return(db.ReaderValue(0)); db.Transaction.Commit(); } catch (Exception ex) { db.Transaction.Rollback(); UDLA.FLUJOS.PASANTIAS.Comun.Logger.ExLogger(ex); } return(null); }
public void ExecuteGenericQuery(string query, ListDictionary parameters) { try { QueryCommandConfig queryCmd = new QueryCommandConfig(query); queryCmd.Params = parameters; db.ExecuteNonQuery(queryCmd); db.Transaction.Commit(); } catch (Exception ex) { if (db.Conn.State == ConnectionState.Open) { db.Transaction.Rollback(); } UDLA.FLUJOS.PASANTIAS.Comun.Logger.ExLogger(ex); } }
public DataTable GetDataTable(QueryCommandConfig CmdConfig) { DbNetData db = dbp.GetObject(); try { DataTable r = db.GetDataTable(CmdConfig); return(r); } catch { throw; } finally { dbp.PutObject(db); } }
public object ExecuteScalar(QueryCommandConfig QryCmd) { DbNetData db = dbp.GetObject(); try { object r = db.ExecuteScalar(QryCmd); return(r); } catch { throw; } finally { dbp.PutObject(db); } }
private void AddLookupData() { foreach (GridColumn gc in _DbNetGridConfiguration.Columns) { if (string.IsNullOrEmpty(gc.Lookup)) { continue; } QueryCommandConfig query = new QueryCommandConfig(); query.Sql = gc.Lookup; Db.ExecuteQuery(query); while (Db.GetDataReader().Read()) { gc.LookupData[Db.ReaderString(0)] = Db.ReaderString(1); } } }
public static List <string> CalFuncset(string res_type, List <string> rolesetList, DbNetDataProxy db) { List <string> funcset_List = new List <string>(); QueryCommandConfig funcQryCmd = new QueryCommandConfig( string.Format("select funcset from t_dic_resrole where res_type = @res_type and role_name in ('{0}')", string.Join("','", rolesetList))); funcQryCmd.Params["res_type"] = res_type; DataTable funcDt = db.GetDataTable(funcQryCmd); if (funcDt != null && funcDt.Rows.Count > 0) { foreach (DataRow r in funcDt.Rows) { funcset_List = new List <string>(funcset_List.Union(r.Field <string>(0).Split('|'))); } funcset_List.Sort(); } return(funcset_List); }
public DataTable ExecuteQuery(string query, ListDictionary parameters) { try { QueryCommandConfig queryCmd = new QueryCommandConfig(query); queryCmd.Params = parameters; db.ReturnAutoIncrementValue = true; var d = db.GetDataTable(queryCmd); db.Transaction.Commit(); return(d); } catch (Exception ex) { if (db.Conn.State == ConnectionState.Open) { db.Transaction.Rollback(); } UDLA.FLUJOS.PASANTIAS.Comun.Logger.ExLogger(ex); } return(null); }
private void GetPage() { string Sql = $"select {ColumnList()} from {_DbNetGridConfiguration.TableName} where 1=2"; DataTable dt = Db.GetDataTable(Sql); QueryCommandConfig query = new QueryCommandConfig(); query.Sql = $"select {ColumnList()} from {_DbNetGridConfiguration.TableName}"; AddSearchTokenFilter(query); AddDropDownFilter(query); AddOrderBy(query); AddLookupData(); int firstRecord = (_DbNetGridConfiguration.PageSize * (_DbNetGridConfiguration.CurrentPage - 1)) + 1; int lastRecord = (firstRecord + (_DbNetGridConfiguration.PageSize - 1)); int recordCounter = 0; Db.ExecuteQuery(query); while (Db.GetDataReader().Read()) { recordCounter++; if (recordCounter >= firstRecord && recordCounter <= lastRecord) { DataRow row = dt.NewRow(); for (var i = 0; i < Db.GetDataReader().FieldCount; i++) { row[i] = Db.ReaderValue(i); } dt.Rows.Add(row); } } _DbNetGridConfiguration.TotalRows = recordCounter; _DbNetGridConfiguration.PageData = dt; }
public void Execute(IJobExecutionContext context) { IConfig c = new IniConfigSource(System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "ConsoleJob.ini")).Configs["config"]; DbNetDataProxy dbp = new DbNetDataProxy(c.Get("DbConnectionString")); DbNetData db = null; try { db = dbp.GetDb(); db.BeginTransaction(); //do market_xs QueryCommandConfig XsQry = new QueryCommandConfig("select sn,orgs,veg_hidden from t_dic_market_xs where orgs is not null and orgs !='' and veg_hidden is not null and veg_hidden !=''"); DataTable xsDt = db.GetDataTable(XsQry); foreach (DataRow r in xsDt.Rows) { List <string> orgs = new List <string>(Convert.ToString(r["orgs"]).Split(',')); List <string> veg_hidden = new List <string>(Convert.ToString(r["veg_hidden"]).Split(',')); List <string> veg_hidden_new = new List <string>(veg_hidden); foreach (string veg in veg_hidden) { QueryCommandConfig xsmxQry = new QueryCommandConfig(string.Format("select count(*) from t_xs_wdat_xsmx where recdate >= @startdate and vegname = @vegname and xs_guid in ({0})", "'" + string.Join("','", orgs) + "'")); xsmxQry.Params["startdate"] = DateTime.Now.AddDays(-3); xsmxQry.Params["vegname"] = veg; int count = Convert.ToInt32(db.ExecuteScalar(xsmxQry)); if (count > 0) { veg_hidden_new.Remove(veg); } } if (veg_hidden.Count > veg_hidden_new.Count) { UpdateCommandConfig upd = new UpdateCommandConfig("t_dic_market_xs"); upd.FilterParams["sn"] = r["sn"]; upd.Params["veg_hidden"] = string.Join(",", veg_hidden_new); db.ExecuteUpdate(upd); } } //do market_lk QueryCommandConfig LkQry = new QueryCommandConfig("select sn,orgs,veg_hidden from t_dic_market_lk where orgs is not null and orgs !='' and veg_hidden is not null and veg_hidden !=''"); DataTable lkDt = db.GetDataTable(LkQry); foreach (DataRow r in lkDt.Rows) { List <string> orgs = new List <string>(Convert.ToString(r["orgs"]).Split(',')); List <string> veg_hidden = new List <string>(Convert.ToString(r["veg_hidden"]).Split(',')); List <string> veg_hidden_new = new List <string>(veg_hidden); foreach (string veg in veg_hidden) { QueryCommandConfig xsmxQry = new QueryCommandConfig(string.Format("select count(*) from t_lkdesk_wdat_jhd where Date >= @startdate and MerchandiseName = @vegname and lk_guid in ({0})", "'" + string.Join("','", orgs) + "'")); xsmxQry.Params["startdate"] = DateTime.Now.AddDays(-3); xsmxQry.Params["vegname"] = veg; int count = Convert.ToInt32(db.ExecuteScalar(xsmxQry)); if (count > 0) { veg_hidden_new.Remove(veg); } } if (veg_hidden.Count > veg_hidden_new.Count) { UpdateCommandConfig upd = new UpdateCommandConfig("t_dic_market_lk"); upd.FilterParams["sn"] = r["sn"]; upd.Params["veg_hidden"] = string.Join(",", veg_hidden_new); db.ExecuteUpdate(upd); } } db.Commit(); DC.DCLogger.LogTrace("Job successed [Job_DelMarketVeghidden]"); } catch (Exception ex) { DC.DCLogger.LogError("Job failed [Job_DelMarketVeghidden]:{0}", ex); } finally { if (db.Transaction != null) { db.Transaction.Dispose(); } dbp.PutDb(db); } }
public static List <string> GetRegSet(string token, DbNetData db) { if (!regSetDic.ContainsKey(token)) { List <string> regset = new List <string>(); QueryCommandConfig qry = new QueryCommandConfig("select funcset,roleset from t_usr where login_token = @token"); qry.Params["token"] = token; DataTable dt = db.GetDataTable(qry); if (dt.Rows.Count > 0) { List <string> roleset = new List <string>(); if (dt.Rows[0].Field <string>("roleset") != null) { roleset = dt.Rows[0].Field <string>("roleset").Split('|').ToList(); } List <string> funcset = new List <string>(); if (dt.Rows[0].Field <string>("funcset") != null) { funcset = dt.Rows[0].Field <string>("funcset").Split('|').ToList(); } List <string> apiset = new List <string>(); if (roleset.Count > 0) { QueryCommandConfig qry2 = new QueryCommandConfig(string.Format("select funcset from t_dic_role where role_name in ({0})", "'" + string.Join("','", roleset) + "'")); DataTable fsdt = db.GetDataTable(qry2); foreach (DataRow r in fsdt.Rows) { List <string> temp_funcset = r.Field <string>("funcset").Split('|').ToList(); funcset = funcset.Union(temp_funcset).ToList(); } } QueryCommandConfig qry3 = new QueryCommandConfig(string.Format("select apiset from t_dic_func where func_name in ({0})", "'" + string.Join("','", funcset) + "'")); DataTable asdt = db.GetDataTable(qry3); foreach (DataRow r in asdt.Rows) { List <string> temp_apiset = r.Field <string>("apiset").Split('|').ToList(); apiset = apiset.Union(temp_apiset).ToList(); } foreach (string apiurl in apiset) { regset.Add("^" + apiurl.Replace("*", "\\S+") + "$"); } } regSetDic.Add(token, regset); regSetTouch.Add(token, DateTime.Now); } else { regSetTouch[token] = DateTime.Now; } List <string> outTimeTokens = new List <string>(); foreach (string key in regSetTouch.Keys) { if (DateTime.Now.Subtract(regSetTouch[token]).TotalMinutes > 60) { outTimeTokens.Add(key); } } foreach (string key in outTimeTokens) { regSetDic.Remove(key); regSetTouch.Remove(key); } return(regSetDic[token]); }
private byte[] manage_register(string extInfo, byte[] req) { RegisterData para; byte[] checkResult = PackOrb.CheckRequest <RegisterData>(req, out para, new string[] { "MobileNumber", "Account", "Password", }); if (checkResult != null) { return(checkResult); } if (!Regex.IsMatch(para.Account, "^[A-Za-z][A-Za-z0-9_]*$")) { return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.BadRequest, }, new ListDictionary { { "respnum", -1 }, { "respmsg", "帐号必须以英文字母开始,且只能由英文、数字和下划线组成" }, } )); } if (!Regex.IsMatch(para.MobileNumber, "^[0-9]*$")) { return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.BadRequest, }, new ListDictionary { { "respnum", -1 }, { "respmsg", "手机号必须以数字组成" }, } )); } #region 保存register信息 long ret = 0; string mb_guid = Guid.NewGuid().ToString("N"); try { QueryCommandConfig QryCmdConfig = new QueryCommandConfig("select count(*) from t_mobapp_reginfo where MobileNumber = @MobileNumber or Account = @Account"); QryCmdConfig.Params["MobileNumber"] = para.MobileNumber; QryCmdConfig.Params["Account"] = para.Account; object ob = db.ExecuteScalar(QryCmdConfig); if (ob != null && Int32.Parse(ob.ToString()) > 0) { return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.BadRequest, }, new ListDictionary { { "respnum", -1 }, { "respmsg", "该手机号或帐号已注册" }, } )); } CommandConfig CmdConfig = new CommandConfig("t_mobapp_reginfo"); CmdConfig.Params["mb_guid"] = mb_guid; CmdConfig.Params["MobileNumber"] = para.MobileNumber; CmdConfig.Params["Account"] = para.Account; CmdConfig.Params["Password"] = para.Password; ret -= db.ExecuteInsert(CmdConfig); } catch (Exception e) { DCLogger.LogError(e.Message); return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.ServerSideError, }, new ListDictionary { { "respnum", -2 }, { "respmsg", e.Message }, } )); } return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.Succeed, }, new ListDictionary { { "respnum", ret }, { "respmsg", "用户注册成功" }, { "mb_guid", mb_guid }, } )); #endregion }
public void Execute(IJobExecutionContext context) { IConfig c = new IniConfigSource(System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "ConsoleJob.ini")).Configs["config"]; DbNetDataProxy dbp = new DbNetDataProxy(c.Get("DbConnectionString")); DbNetData db = null; try { db = dbp.GetDb(); db.BeginTransaction(); Dictionary <string, VegunitTrans> vtDic = new Dictionary <string, VegunitTrans>(); QueryCommandConfig xskcQry = new QueryCommandConfig("select * from t_xs_wdat_kc"); DataTable xskcDt = db.GetDataTable(xskcQry); foreach (DataRow r in xskcDt.Rows) { string statSql = "SELECT vegname,date_format(recdate, '%Y-%m-%d') as date,round(max(totalprice/kilo),3) as max,round(min(totalprice/kilo),3) as min,round(avg(totalprice/kilo),3) as avg FROM t_xs_wdat_xsmx where recdate >= @startdate and recdate < @enddate and amount != kilo and vegname = @vegname and xs_guid in ({0}) group by vegname,date_format(recdate, '%Y-%m-%d')"; QueryCommandConfig statQry = new QueryCommandConfig(string.Format(statSql, "'" + r["xs_guid"] + "'")); statQry.Params["startdate"] = DateTime.Now.Date.AddMonths(-6); statQry.Params["enddate"] = DateTime.Now.Date.AddDays(1); statQry.Params["vegname"] = r["vegname"]; DataTable statDt = dbp.GetDataTable(statQry); if (statDt.Rows.Count > 0) { var result = from statTbl in statDt.AsEnumerable() orderby DateTime.Parse(statTbl.Field <string>("date")) descending where DateTime.Parse(statTbl.Field <string>("date")) <= DateTime.Now.Date.AddDays(1) select new ResponseData { max = statTbl.Field <decimal?>("max") ?? 0, min = statTbl.Field <decimal?>("min") ?? 0, }; decimal min = 0; decimal max = 0; foreach (ResponseData d in result) { if (d.max > 0 || d.min > 0) { min = d.min; max = d.max; break; } } DataRow statR = statDt.Rows[0]; UpdateCommandConfig xskcUpd = new UpdateCommandConfig("t_xs_wdat_kc"); xskcUpd.FilterParams["xs_guid"] = r["xs_guid"]; xskcUpd.FilterParams["vegname"] = r["vegname"]; xskcUpd.Params["xs_price_min"] = min; xskcUpd.Params["xs_price_max"] = max; db.ExecuteUpdate(xskcUpd); } } db.Commit(); DC.DCLogger.LogTrace("Job successed [Job_CalXsgh]"); } catch (Exception ex) { DC.DCLogger.LogError("Job failed [Job_CalXsgh]:{0}", ex); } finally { if (db.Transaction != null) { db.Transaction.Dispose(); } dbp.PutDb(db); } }
private byte[] dic_list(string extInfo, byte[] req) { DicListQry para; byte[] checkResult = PackOrb.CheckRequest <DicListQry>(req, out para, new string[] { "dicname", }); if (checkResult != null) { return(checkResult); } #region 查询字典信息 try { string dicTbl = null; switch (para.dicname) { case "蔬菜名称": dicTbl = "t_dic_vegname"; break; case "蔬菜种类": dicTbl = "t_dic_vegtype"; break; default: return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.ServerSideError, }, new ListDictionary { { "respnum", -2 }, { "respmsg", "不存在此字典" }, } )); } QueryCommandConfig CmdConfig = new QueryCommandConfig(string.Format("select * from {0} order by code", dicTbl)); DataTable dt = db.GetDataTable(CmdConfig); return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.Succeed, }, new ListDictionary { { "respnum", dt.Rows.Count }, { "respmsg", "获取字典成功" }, { "count", dt.Rows.Count }, { "data", dt }, } )); } catch (Exception e) { DCLogger.LogError(e.Message); return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.ServerSideError, }, new ListDictionary { { "respnum", -2 }, { "respmsg", e.Message }, } )); } #endregion }
private byte[] manage_login(string extInfo, byte[] req) { ClientLogin para; byte[] checkResult = PackOrb.CheckRequest <ClientLogin>(req, out para, new string[] { "LoginName", "Password", }); if (checkResult != null) { return(checkResult); } #region 登录验证 try { string loginCol = "Account"; if (Regex.IsMatch(para.LoginName, "^[0-9]*$")) { loginCol = "MobileNumber"; } QueryCommandConfig CmdConfig = new QueryCommandConfig(string.Format("select mb_guid,Password from t_mobapp_reginfo where {0} = @LoginName", loginCol)); CmdConfig.Params["LoginName"] = para.LoginName; DataTable dt = db.GetDataTable(CmdConfig); if (dt.Rows.Count == 0) { return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.BadRequest, }, new ListDictionary { { "respnum", -1 }, { "respmsg", "未找到此用户" }, } )); } if (dt.Rows[0]["Password"].ToString().Equals(para.Password)) { return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.Succeed, }, new ListDictionary { { "respnum", 1 }, { "respmsg", "用户登录成功" }, { "mb_guid", dt.Rows[0]["mb_guid"].ToString() }, } )); } else { return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.BadRequest, }, new ListDictionary { { "respnum", -1 }, { "respmsg", "密码错误" }, } )); } } catch (Exception e) { DCLogger.LogError(e.Message); return(PackOrb.PackRespose( new HttpHeadInfo { StatusCode = HttpStatusCode.ServerSideError, }, new ListDictionary { { "respnum", -2 }, { "respmsg", e.Message }, } )); } #endregion }