public Database(IDb db, DbQueries dbQueries) { TableName = dbQueries.TableName.Split('.').Last(); Schema = dbQueries.Schema; _dbQueries = dbQueries; _db = db; }
static void Main(string[] args) { // Hook up DependencyManager.InjectRavenDbContext(RavenContext.Instance); _db = DependencyManager.Db; _logger = DependencyManager.Logger; var action = Action.NotSet; Console.WriteLine("Choose action:"); Console.WriteLine("1. Add ids to products"); Console.WriteLine(""); Console.WriteLine("--- Update scripts ---"); var input = Console.ReadLine(); action = (Action)Convert.ToInt32(input); if(action == Action.AddIdToProducts) { var products = _db.Products.GetAllProductsInDb(); var en = products as Product[] ?? products.ToArray(); foreach (var product in en) { product.Enterprise = "enterprises-jessetinell"; } _db.Products.UpdateProducts(en); } }
public BaseController(IDb db, ILogger logger, IAuthentication authentication = null) { Db = db; Logger = logger; Authentication = authentication ?? DependencyManager.Authentication; }
public void Execute(IDb db) { foreach (var record in db.Read(_selectStatement)) { ExecuteScripts(record); db.Write(_updateStatement, (object)record); } }
public void Setup() { var commandStub = new Mock<IDbCommand>().SetupAllProperties().Object; var connection = new Mock<IDbConnection>(); connection.Setup(c => c.CreateCommand()).Returns(commandStub); _db = new Db(connection.Object); }
internal Table(IDb Db, IDataReader DataReader) { _db = Db; _schemeName = (string)DataReader[ReaderSchemeNameField]; _name = (string)DataReader[ReaderNameFieldName]; }
public override MultiResultSet<Person, Address> SelectPersonAndAddress(IDb db) { var query = "BEGIN\r\n" + $" OPEN :Cur1 FOR {SelectPeople}" + $" OPEN :Cur2 FOR {SelectAddresses};" + "END;"; return db.Sql(query) .WithParameter(new OracleParameter("Cur1", OracleDbType.RefCursor, ParameterDirection.Output)) .WithParameter(new OracleParameter("Cur2", OracleDbType.RefCursor, ParameterDirection.Output)) .AsMultiResultSet<Person, Address>(); }
public SetupManager( IApplicationEnvironment appEnv, ILogger<SetupManager> logger, IOptions<SetupOptions> setupOptionsAccessor, IDb dbImplementation, IVersionProviderFactory versionProviderFactory, SiteManager siteManager) { appBasePath = appEnv.ApplicationBasePath; this.siteManager = siteManager; log = logger; db = dbImplementation; this.versionProviderFactory = versionProviderFactory; setupOptions = setupOptionsAccessor.Options; }
public SystemInfoManager( IRuntimeEnvironment runtimeEnvironment, IHostingEnvironment hostingEnvironment, IApplicationEnvironment appEnvironment, IVersionProviderFactory versionProviderFactory, IDb database, ILogRepository logRepository) { runtimeInfo = runtimeEnvironment; appInfo = appEnvironment; hostingInfo = hostingEnvironment; db = database; logRepo = logRepository; versionProviders = versionProviderFactory; cloudscribeVersionProvider = versionProviders.Get("cloudscribe-core"); }
public static void Set(this IDb db, Keccak key, byte[] value) { db[key.Bytes] = value; }
public static void Set(this IDb db, BigInteger key, byte[] value) { db[key.ToBigEndianByteArray()] = value; }
/// <summary> /// Default constructor. /// </summary> /// <param name="app">The current app</param> public CmsController(IApi api, IDb db, IModelLoader loader) { _api = api; _db = db; _loader = loader; }
public TaskStatusRepository(IDb db, ILogger logger) { _db = db; _logger = logger; }
public void deleteOrderHistData(SqlLib lib, IDb db, object obj, ref DataTable outDt) { string sql = ""; bool ret = true; try { OrderInfo orderInfo = new OrderInfo(); ret = DataHandle.CompareObjectType(obj, orderInfo); if (ret) { //get the correct list. orderInfo = (OrderInfo)obj; } else { return; } if (outDt == null) { throw new NullReferenceException("outDt is null"); } DataTable localDt = new DataTable(); //每次删除一条或者多条. sql = lib.GetSql("SqlOrderInfo/OrderInfo", "GetOrderInfo"); if (!string.IsNullOrEmpty(orderInfo.ORDERID)) { sql = sql + " and ORDERID= '" + orderInfo.ORDERID + "'"; } else { //不允许都为空的情况,那样就全部删除了。抛出异常。 throw new NullReferenceException("产品详细关联号不可以为空!"); } if (!string.IsNullOrEmpty(sql)) { localDt = db.GetTable(sql); } for (int i = 0; i < localDt.Rows.Count; i++) { DataRow dr = localDt.Rows[i]; dr.Delete(); } //ScmProviderData li = new ScmProviderData(); //ret = DataHandle.CompareObjectType(obj, li); //if (ret) //{ // //get the correct list. // li = (ScmProviderData)obj; //} //else //{ // return; //} //if (outDtPlace == null) //{ // throw new NullReferenceException("outDtPlace is null"); //} //DataTable localDt = new DataTable(); ////每次删除一条或者多条. //sql = lib.GetSql("SqlPlace/PlaceProdInfo", "GetPlaceProdRelationInfo"); //if (!string.IsNullOrEmpty(li.PROVIDERID)) //{ // sql = sql + " and PROVIDERID= '" + li.PROVIDERID + "'"; //} //else //{ // //不允许都为空的情况,那样就全部删除了。抛出异常。 // throw new NullReferenceException("场所号和场所产品关联号不可以同时为空!"); //} //if (!string.IsNullOrEmpty(sql)) //{ // localDt = db.GetTable(sql); //} //for (int i = 0; i < localDt.Rows.Count; i++) //{ // DataRow dr = localDt.Rows[i]; // dr.Delete(); //} //outDtPlace.Merge(localDt, true); outDt.Merge(localDt, true); } catch (NullReferenceException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteContractData" + ex.Message); } catch (ArrayTypeMismatchException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteContractData" + ex.Message); } catch (Exception ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteContractData" + ex.Message); throw; } }
public JsonController(IDb db, ILogger logger) : base(db, logger) { }
/// <summary> /// Default constructor. /// </summary> /// <param name="db">The current db context</param> /// <param name="factory">The content service factory</param> public PageRepository(IDb db, IContentServiceFactory factory) { _db = db; _contentService = factory.CreatePageService(); }
public void deleteInsuranceUsrData(SqlLib lib, IDb db, object obj, ref DataTable outInsuranceUsrDt) { string sql = ""; bool ret = true; try { InsuranceUsrInfo InsuranceUsr = new InsuranceUsrInfo(); ret = DataHandle.CompareObjectType(obj, InsuranceUsr); if (ret) { InsuranceUsr = (InsuranceUsrInfo)obj; } else { return; } if (outInsuranceUsrDt == null) { throw new NullReferenceException("outInsuranceUsrDt is null"); } DataTable localdt = new DataTable(); sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetInsuranceUsrInfo"); if (!string.IsNullOrEmpty(InsuranceUsr.INSURANCE_USRID)) { sql += " and INSURANCE_USRID='" + InsuranceUsr.INSURANCE_USRID + " '"; } else { throw new NullReferenceException("保单详细信息不能为空"); } if (!string.IsNullOrEmpty(sql)) { localdt = db.GetTable(sql); } for (int i = 0; i < localdt.Rows.Count; i++) { DataRow dr = localdt.Rows[i]; dr.Delete(); } outInsuranceUsrDt.Merge(localdt); } catch (NullReferenceException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message); } catch (ArrayTypeMismatchException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message); } catch (Exception ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message); throw; } }
/// <summary> /// Default constructor. /// </summary> /// <param name="db">The current db context</param> /// <param name="cache">The optional model cache</param> public TagRepository(IDb db, ICache cache = null) : base(db, cache) { }
/// <summary> /// Default constructor. /// </summary> /// <param name="api">The current api</param> /// <param name="db">The current db connection</param> /// <param name="modelCache">The optional model cache</param> public PageRepository(Api api, IDb db, ICache modelCache = null) { this.api = api; this.db = db; this.cache = modelCache; }
public PersistentTxStorage(IDb database) { _database = database; }
public SnapshotableDb(IDb db) { _db = db; }
public CategoryEquipmentRepository(ILogger logger) { _db = new Db(); _logger = logger; }
public void addNewOrderDetData(SqlLib lib, IDb db, object obj, ref DataTable outOrderDetDt) { string sql = ""; string localID = ""; bool ret = false; try { OrderDetInfo li = new OrderDetInfo(); ret = DataHandle.CompareObjectType(obj, li); if (ret) { li = (OrderDetInfo)obj; } else { return; } if (outOrderDetDt == null) { throw new NullReferenceException("outOrderDetDt is null"); } DataTable localDt = new DataTable(); //只取一条记录,以便得到表结构,如果一条都没有,那么会有什么结果?能够取出表结构。 sql = lib.GetSql("SqlOrderDetInfo/OrderDetInfo", "GetOrderDetStructInfo"); localDt = db.GetTable(sql); //新增加的记录,在oracle中需要取到sequence编号 sql = lib.GetSql("SqlOrderDetInfo/OrderDetInfo", "GetNewOrderDetId"); DataTable dt = new DataTable(); dt = db.GetTable(sql); if (dt.Rows.Count > 0) { localID = dt.Rows[0][0].ToString(); dt.Reset(); } if (string.IsNullOrEmpty(localID)) { return; } DataRow dr = localDt.NewRow(); dr["ORDERDETID"] = DataHandle.EmptyString2DBNull(localID); dr["ACCOUNTINGCOST"] = DataHandle.EmptyString2DBNull(li.ACCOUNTINGCOST); dr["BACKDT"] = DataHandle.EmptyString2DBNull(li.BACKDT); dr["BACKMONEY"] = DataHandle.EmptyString2DBNull(li.BACKMONEY); dr["BREASON"] = DataHandle.EmptyString2DBNull(li.BREASON); dr["CARDRIGHTNUM"] = DataHandle.EmptyString2DBNull(li.CARDRIGHTNUM); dr["CLEARFEE"] = DataHandle.EmptyString2DBNull(li.CLEARFEE); dr["CONTACTID"] = DataHandle.EmptyString2DBNull(li.CONTACTID); dr["CRDT"] = DataHandle.EmptyString2DBNull(li.CRDT); dr["FBDT"] = DataHandle.EmptyString2DBNull(li.FBDT); dr["FEEDBACK"] = DataHandle.EmptyString2DBNull(li.FEEDBACK); dr["FREIGHT"] = DataHandle.EmptyString2DBNull(li.FREIGHT); dr["GOODSBACK"] = DataHandle.EmptyString2DBNull(li.GOODSBACK); dr["ISREFUND"] = DataHandle.EmptyString2DBNull(li.ISREFUND); dr["ORDERID"] = DataHandle.EmptyString2DBNull(li.ORDERID); dr["PAYMENT"] = DataHandle.EmptyString2DBNull(li.PAYMENT); dr["POSTFEE"] = DataHandle.EmptyString2DBNull(li.POSTFEE); dr["PRODBANKID"] = DataHandle.EmptyString2DBNull(li.PRODBANKID); dr["PRODDETID"] = DataHandle.EmptyString2DBNull(li.PRODDETID); dr["PRODNUM"] = DataHandle.EmptyString2DBNull(li.PRODNUM); dr["PRODUCTTYPE1"] = DataHandle.EmptyString2DBNull(li.PRODUCTTYPE1); dr["RECKONING"] = DataHandle.EmptyString2DBNull(li.RECKONING); dr["RECKONINGDT"] = DataHandle.EmptyString2DBNull(li.RECKONINGDT); dr["REFUNDDT"] = DataHandle.EmptyString2DBNull(li.REFUNDDT); dr["SOLDWITH"] = DataHandle.EmptyString2DBNull(li.SOLDWITH); dr["STATUS"] = DataHandle.EmptyString2DBNull(li.STATUS); dr["UPRICE"] = DataHandle.EmptyString2DBNull(li.UPRICE); localDt.Rows.Add(dr); outOrderDetDt.Merge(localDt, true); } catch (NullReferenceException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderDetData" + ex.Message); } catch (ArrayTypeMismatchException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderDetData" + ex.Message); } catch (Exception ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderDetData" + ex.Message); throw; } }
/// <summary> /// Default constructor. /// </summary> /// <param name="db">The current db context</param> public AliasRepository(IDb db) { _db = db; }
public void addNewInsuranceUsrData(SqlLib lib, IDb db, object obj, ref DataTable outInsuranceUsrDt) { string sql = ""; string localID = ""; bool ret = false; try { InsuranceUsrInfo li = new InsuranceUsrInfo(); ret = DataHandle.CompareObjectType(obj, li); if (ret) { li = (InsuranceUsrInfo)obj; } else { return; } if (outInsuranceUsrDt == null) { throw new NullReferenceException("outInsuranceUsrDt is null"); } DataTable localdt = new DataTable(); sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetInsuranceUsrStructInfo"); localdt = db.GetTable(sql); sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetNewInsuranceUsrId"); DataTable dt = new DataTable(); dt = db.GetTable(sql); if (dt.Rows.Count > 0) { localID = dt.Rows[0][0].ToString(); dt.Reset(); } if (string.IsNullOrEmpty(localID)) { return; } DataRow dr = localdt.NewRow(); dr["INSURANCE_USRID"] = DataHandle.EmptyString2DBNull(localID); dr["Proportion"] = DataHandle.EmptyString2DBNull(li.Proportion); dr["CRDT"] = DataHandle.EmptyString2DBNull(li.CRDT); dr["CRUSR"] = DataHandle.EmptyString2DBNull(li.CRUSR); dr["DSC"] = DataHandle.EmptyString2DBNull(li.DSC); dr["IDCARDNO"] = DataHandle.EmptyString2DBNull(li.IDCARDNO); dr["IDCARDTYPE"] = DataHandle.EmptyString2DBNull(li.IDCARDTYPE); dr["IDPERIOD"] = DataHandle.EmptyString2DBNull(li.IDPERIOD); dr["MDDT"] = DataHandle.EmptyString2DBNull(li.MDDT); dr["MDUSR"] = DataHandle.EmptyString2DBNull(li.MDUSR); dr["NAME"] = DataHandle.EmptyString2DBNull(li.NAME); dr["POST"] = DataHandle.EmptyString2DBNull(li.POST); dr["PROFESSION"] = DataHandle.EmptyString2DBNull(li.PROFESSION); dr["SEX"] = DataHandle.EmptyString2DBNull(li.SEX); localdt.Rows.Add(dr); outInsuranceUsrDt.Merge(localdt, true); } catch (NullReferenceException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewInsuranceUsrData" + ex.Message); } catch (ArrayTypeMismatchException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewInsuranceUsrData" + ex.Message); } catch (Exception ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewInsuranceUsrData" + ex.Message); throw; } }
public CliqueSealEngine(CliqueConfig config, IEthereumSigner signer, PrivateKey key, IDb blocksDb, IBlockTree blockTree, ILogManager logManager) { _logger = logManager?.GetClassLogger() ?? throw new ArgumentNullException(nameof(logManager)); _config = config ?? throw new ArgumentNullException(nameof(config)); _blocksDb = blocksDb ?? throw new ArgumentNullException(nameof(blocksDb)); _signer = signer ?? throw new ArgumentNullException(nameof(signer)); _blockTree = blockTree ?? throw new ArgumentNullException(); _key = key ?? throw new ArgumentNullException(nameof(key)); if (config.Epoch == 0) { config.Epoch = Clique.DefaultEpochLength; } }
public void addNewOrderHistData(SqlLib lib, IDb db, object obj, ref DataTable outDt) { string sql = ""; string localID = ""; bool ret = false; try { OrderInfo li = new OrderInfo(); ret = DataHandle.CompareObjectType(obj, li); if (ret) { //get the correct list. li = (OrderInfo)obj; } else { return; } if (outDt == null) { throw new NullReferenceException("outDt is null"); } DataTable localDt = new DataTable(); //只取一条记录,以便得到表结构,如果一条都没有,那么会有什么结果?能够取出表结构。 sql = lib.GetSql("SqlOrderInfo/OrderInfo", "GetOrderHistStructInfo"); localDt = db.GetTable(sql); //新增加的记录,在oracle中需要取到sequence编号 sql = lib.GetSql("SqlOrderInfo/OrderInfo", "GetNewOrderHistId"); DataTable dt = new DataTable(); dt = db.GetTable(sql); if (dt.Rows.Count > 0) { localID = dt.Rows[0][0].ToString(); dt.Reset(); } if (string.IsNullOrEmpty(localID)) { return; } DataRow dr = localDt.NewRow(); dr["orderid"] = DataHandle.EmptyString2DBNull(localID); dr["contactid"] = DataHandle.EmptyString2DBNull(li.CONTACTID); dr["addressid"] = DataHandle.EmptyString2DBNull(li.ADDRESSID); dr["ACCDT"] = DataHandle.EmptyString2DBNull(li.ACCDT); dr["AMORTISATION"] = DataHandle.EmptyString2DBNull(li.AMORTISATION); dr["BENEFICIARIES"] = DataHandle.EmptyString2DBNull(li.BENEFICIARIES); dr["BILL"] = DataHandle.EmptyString2DBNull(li.BILL); dr["BILLDEMONDDSC"] = DataHandle.EmptyString2DBNull(li.BILLDEMONDDSC); dr["BILLDEMONDED"] = DataHandle.EmptyString2DBNull(li.BILLDEMONDED); dr["BILLTITLE"] = DataHandle.EmptyString2DBNull(li.BILLTITLE); dr["CARDID"] = DataHandle.EmptyString2DBNull(li.CARDID); dr["CARDRIGHTNUM"] = DataHandle.EmptyString2DBNull(li.CARDRIGHTNUM); dr["CLEARFEE"] = DataHandle.EmptyString2DBNull(li.CLEARFEE); dr["CONFIRM"] = DataHandle.EmptyString2DBNull(li.CONFIRM); dr["CONSIGNEE"] = DataHandle.EmptyString2DBNull(li.CONSIGNEE); dr["CONSIGNPHN"] = DataHandle.EmptyString2DBNull(li.CONSIGNPHN); dr["CRUSR"] = DataHandle.EmptyString2DBNull(li.CRUSR); dr["DEMONDDT"] = DataHandle.EmptyString2DBNull(li.DEMONDDT); dr["DISCOUNT"] = DataHandle.EmptyString2DBNull(li.DISCOUNT); dr["FBDT"] = DataHandle.EmptyString2DBNull(li.FBDT); dr["GRPID"] = DataHandle.EmptyString2DBNull(li.GRPID); dr["HEALTHINTRO"] = DataHandle.EmptyString2DBNull(li.HEALTHINTRO); dr["INSURANCEID"] = DataHandle.EmptyString2DBNull(li.INSURANCEID); dr["INSURANT"] = DataHandle.EmptyString2DBNull(li.INSURANT); dr["MAILPRICE"] = DataHandle.EmptyString2DBNull(li.MAILPRICE); dr["MDDT"] = DataHandle.EmptyString2DBNull(li.MDDT); dr["MDUSR"] = DataHandle.EmptyString2DBNull(li.MDUSR); dr["MONITORRECORDER"] = DataHandle.EmptyString2DBNull(li.MONITORRECORDER); dr["NOTE"] = DataHandle.EmptyString2DBNull(li.NOTE); dr["NOWMONEY"] = DataHandle.EmptyString2DBNull(li.NOWMONEY); dr["POLICYHOLDER"] = DataHandle.EmptyString2DBNull(li.POLICYHOLDER); dr["POSTFEE"] = DataHandle.EmptyString2DBNull(li.POSTFEE); dr["PRODPRICE"] = DataHandle.EmptyString2DBNull(li.PRODPRICE); dr["PRODUCTINTRO"] = DataHandle.EmptyString2DBNull(li.PRODUCTINTRO); dr["RESULT"] = DataHandle.EmptyString2DBNull(li.RESULT); dr["SENDDT"] = DataHandle.EmptyString2DBNull(li.SENDDT); dr["SPECIALDSC"] = DataHandle.EmptyString2DBNull(li.SPECIALDSC); dr["STATUS"] = DataHandle.EmptyString2DBNull(li.STATUS); dr["TOTALPRICE"] = DataHandle.EmptyString2DBNull(li.TOTALPRICE); dr["URGENT"] = DataHandle.EmptyString2DBNull(li.URGENT); dr["ordertype"] = DataHandle.EmptyString2DBNull(li.ordertype); dr["paytype"] = DataHandle.EmptyString2DBNull(li.paytype); dr["mailtype"] = DataHandle.EmptyString2DBNull(li.mailtype); dr["CRDT"] = DataHandle.EmptyString2DBNull(li.crdt); localDt.Rows.Add(dr); outDt.Merge(localDt, true); } catch (NullReferenceException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderHistData" + ex.Message); } catch (ArrayTypeMismatchException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderHistData" + ex.Message); } catch (Exception ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in addNewOrderHistData" + ex.Message); throw; } }
public static Purchasing_PurchaseOrderTableQuery <Purchasing_PurchaseOrder> Purchasing_PurchaseOrders(this IDb db) { var query = new Purchasing_PurchaseOrderTableQuery <Purchasing_PurchaseOrder>(db as IDb); return(query); }
public DomainLogicRoot(IProductWebpageDownloader productWebpageDownloader, IDb database) { var productPageParser = new ProductPageParser(); GetHandler = new RequestHandler(productWebpageDownloader, productPageParser, database); }
public Purchasing_PurchaseOrderTableQuery(IDb db) : base(db) { }
public virtual void Exec(IDb db, string procName, string[] parameterName, object[] parameters, IList list) { int len = (parameters == null) ? 0 : parameters.Length; string sql = GetExecSql(procName); IDbCommand cmd = null; IDataReader reader = null; try { cmd = db.Connection.CreateCommand(); cmd.CommandText = sql; cmd.CommandType = CommandType.StoredProcedure; cmd.Transaction = db.Transaction; db.AddParameters(cmd, parameterName, parameters, db.Transaction); TraceObject.Instance.TraceCommand(cmd); reader = cmd.ExecuteReader(); FillByName(reader, list); } finally { if (reader != null) { if (!reader.IsClosed) reader.Close(); reader.Dispose(); reader = null; } if (cmd != null) { cmd.Dispose(); cmd = null; } } FireTriggers(list, new TriggerEventArgs(db, Timing.AfterActivate)); }
/// <summary> /// Default constructor. /// </summary> /// <param name="api">The current api</param> /// <param name="db">The current db connection</param> /// <param name="modelCache">The optional model cache</param> public PostRepository(Api api, IDb db, ICache modelCache = null) : base(api, db, modelCache) { }
public TaskStatusRepository(ILogger logger) { _db = new Db(); _logger = logger; }
public RosterHistoryService(IDb db) { _db = db; }
public Tracer(IBlockchainProcessor processor, IReceiptStorage receiptStorage, IBlockTree blockTree, IDb traceDb) { _processor = processor ?? throw new ArgumentNullException(nameof(processor)); _receiptStorage = receiptStorage ?? throw new ArgumentNullException(nameof(receiptStorage)); _blockTree = blockTree ?? throw new ArgumentNullException(nameof(blockTree)); _traceDb = traceDb ?? throw new ArgumentNullException(nameof(traceDb)); }
/// <summary> /// Default constructor. /// </summary> /// <param name="api">The current api</param> /// <param name="db">The current db connection</param> /// <param name="modelCache">The optional model cache</param> protected ContentRepository(Api api, IDb db, ICache modelCache = null) { this.api = api; this.db = db; this.cache = modelCache; }
public static void Delete(this IDb db, Keccak key) { db.Remove(key.Bytes); }
public FillVisitor(SqlDataReader reader, IDb db, IObjectFillerFactory objectFillerFactory) { this.reader = reader; Db = db; this.objectFillerFactory = objectFillerFactory; }
public static byte[] Get(this IDb db, BigInteger key) { return(db[key.ToBigEndianByteArray()]); }
/// <summary> /// Default constructor. /// </summary> /// <param name="db">The current db connection</param> /// <param name="factory">The content service factory</param> public ContentRepository(IDb db, IContentServiceFactory factory) { _db = db; _service = factory.CreateContentService(); }
public void updateOrderDetData(SqlLib lib, IDb db, object obj, ref DataTable outOrderDetDt) { string sql = ""; bool ret = true; try { OrderDetInfo li = new OrderDetInfo(); ret = DataHandle.CompareObjectType(obj, li); if (ret) { li = (OrderDetInfo)obj; } else { return; } if (outOrderDetDt == null) { throw new NullReferenceException("outOrderDerDt is null"); } DataTable localDt = new DataTable(); //根据Id更新一条数据信息 sql = lib.GetSql("SqlOrderDetInfo/OrderDetInfo", "GetOrderDetInfo"); localDt = db.GetTable(sql); if (!string.IsNullOrEmpty(li.ORDERID)) { sql += " and ORDERDETID='" + li.ORDERDETID + "'"; localDt = db.GetTable(sql); if (localDt.Rows.Count > 0) { DataRow dr = localDt.NewRow(); dr["ORDERDETID"] = DataHandle.EmptyString2DBNull(li.ORDERDETID); dr["ACCOUNTINGCOST"] = DataHandle.EmptyString2DBNull(li.ACCOUNTINGCOST); dr["BACKDT"] = DataHandle.EmptyString2DBNull(li.BACKDT); dr["BACKMONEY"] = DataHandle.EmptyString2DBNull(li.BACKMONEY); dr["BREASON"] = DataHandle.EmptyString2DBNull(li.BREASON); dr["CARDRIGHTNUM"] = DataHandle.EmptyString2DBNull(li.CARDRIGHTNUM); dr["CLEARFEE"] = DataHandle.EmptyString2DBNull(li.CLEARFEE); dr["CONTACTID"] = DataHandle.EmptyString2DBNull(li.CONTACTID); dr["CRDT"] = DataHandle.EmptyString2DBNull(li.CRDT); dr["FBDT"] = DataHandle.EmptyString2DBNull(li.FBDT); dr["FEEDBACK"] = DataHandle.EmptyString2DBNull(li.FEEDBACK); dr["FREIGHT"] = DataHandle.EmptyString2DBNull(li.FREIGHT); dr["GOODSBACK"] = DataHandle.EmptyString2DBNull(li.GOODSBACK); dr["ISREFUND"] = DataHandle.EmptyString2DBNull(li.ISREFUND); dr["ORDERID"] = DataHandle.EmptyString2DBNull(li.ORDERID); dr["PAYMENT"] = DataHandle.EmptyString2DBNull(li.PAYMENT); dr["POSTFEE"] = DataHandle.EmptyString2DBNull(li.POSTFEE); dr["PRODBANKID"] = DataHandle.EmptyString2DBNull(li.PRODBANKID); dr["PRODDETID"] = DataHandle.EmptyString2DBNull(li.PRODDETID); dr["PRODNUM"] = DataHandle.EmptyString2DBNull(li.PRODNUM); dr["PRODUCTTYPE1"] = DataHandle.EmptyString2DBNull(li.PRODUCTTYPE1); dr["RECKONING"] = DataHandle.EmptyString2DBNull(li.RECKONING); dr["RECKONINGDT"] = DataHandle.EmptyString2DBNull(li.RECKONINGDT); dr["REFUNDDT"] = DataHandle.EmptyString2DBNull(li.REFUNDDT); dr["SOLDWITH"] = DataHandle.EmptyString2DBNull(li.SOLDWITH); dr["STATUS"] = DataHandle.EmptyString2DBNull(li.STATUS); dr["UPRICE"] = DataHandle.EmptyString2DBNull(li.UPRICE); dr.EndEdit(); outOrderDetDt.Merge(localDt, true); } } } catch (NullReferenceException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderDetData" + ex.Message); } catch (ArrayTypeMismatchException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderDetData" + ex.Message); } catch (Exception ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderDetData" + ex.Message); throw; } }
public ReceiptRocksRepository(IDb database, IRlpNdmDecoder <DataDeliveryReceiptDetails> rlpDecoder) { _database = database; _rlpDecoder = rlpDecoder; }
public void updateInsuranceUsrData(SqlLib lib, IDb db, object obj, ref DataTable outInsuranceUsrDt) { string sql = ""; bool ret = true; try { InsuranceUsrInfo li = new InsuranceUsrInfo(); ret = DataHandle.CompareObjectType(obj, li); if (ret) { li = (InsuranceUsrInfo)obj; } else { return; } if (outInsuranceUsrDt == null) { throw new NullReferenceException("outInsuranceUsrDt is null"); } DataTable localDt = new DataTable(); //根据Id更新一条数据信息 sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetInsuranceUsrInfo"); localDt = db.GetTable(sql); if (!string.IsNullOrEmpty(li.INSURANCE_USRID)) { sql += " and INSURANCE_USRID='" + li.INSURANCE_USRID + "'"; localDt = db.GetTable(sql); if (localDt.Rows.Count > 0) { DataRow dr = localDt.NewRow(); dr["INSURANCE_USRID"] = DataHandle.EmptyString2DBNull(li.INSURANCE_USRID); dr["Proportion"] = DataHandle.EmptyString2DBNull(li.Proportion); dr["CRDT"] = DataHandle.EmptyString2DBNull(li.CRDT); dr["CRUSR"] = DataHandle.EmptyString2DBNull(li.CRUSR); dr["DSC"] = DataHandle.EmptyString2DBNull(li.DSC); dr["IDCARDNO"] = DataHandle.EmptyString2DBNull(li.IDCARDNO); dr["IDCARDTYPE"] = DataHandle.EmptyString2DBNull(li.IDCARDTYPE); dr["IDPERIOD"] = DataHandle.EmptyString2DBNull(li.IDPERIOD); dr["MDDT"] = DataHandle.EmptyString2DBNull(li.MDDT); dr["MDUSR"] = DataHandle.EmptyString2DBNull(li.MDUSR); dr["NAME"] = DataHandle.EmptyString2DBNull(li.NAME); dr["POST"] = DataHandle.EmptyString2DBNull(li.POST); dr["PROFESSION"] = DataHandle.EmptyString2DBNull(li.PROFESSION); dr["SEX"] = DataHandle.EmptyString2DBNull(li.SEX); outInsuranceUsrDt.Merge(localDt, true); } } } catch (NullReferenceException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderDetData" + ex.Message); } catch (ArrayTypeMismatchException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderDetData" + ex.Message); } catch (Exception ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderDetData" + ex.Message); throw; } }
public HospitalController(IDb service) { _service = service; }
public bool updataInsuranceUsrDataTable(SqlLib lib, IDb db, DataTable indt) { bool ret = false; try { if (indt.Rows.Count == 0) { //没有记录,相当于这方法没有执行。 return ret; } //更新OrderHist表 //循环更新所有的。 for (int i = 0; i < indt.Rows.Count; i++) { DataRow dr = indt.Rows[i]; string localOrderid = ""; if (dr.RowState == DataRowState.Unchanged) { //do nothing.jump out the loop. continue; } else if (dr.RowState == DataRowState.Deleted) { //do nothing. } else { localOrderid = dr["INSURANCE_USRID"].ToString(); } string sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetInsuranceUsrStructInfo"); CTrace.WriteLine(CTrace.TraceLevel.Info, "updateOrderDetDataTable sql={0}.", sql); ret = db.Save(indt, sql); CTrace.WriteLine(CTrace.TraceLevel.Info, "updataInsuranceUsrDataTable result={0}.", ret.ToString()); if (ret) { //return true. } else { db.Rollback(); localOrderid = ""; CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updataInsuranceUsrDataTable" + db.Error.Message); } } } catch (NullReferenceException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updataInsuranceUsrDataTable" + ex.Message); } catch (ArrayTypeMismatchException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updataInsuranceUsrDataTable" + ex.Message); } catch (Exception ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updataInsuranceUsrDataTable" + ex.Message); throw; } return ret; }
public void deleteOrderHistAllInsurantData(SqlLib lib, IDb db, object obj, ref DataTable outInsuranceUsrDt) { string sql = ""; bool ret = true; try { OrderInfo localOrderInfo = new OrderInfo(); ret = DataHandle.CompareObjectType(obj, localOrderInfo); if (ret) { localOrderInfo = (OrderInfo)obj; } else { return; } if (outInsuranceUsrDt == null) { throw new NullReferenceException("outInsuranceUsrDt is null"); } string InsuranceUsrID = ""; sql = lib.GetSql("SqlOrderInfo/OrderInfo", "GetOrderHistInfo"); sql = sql + string.Format(" and orderid = '{0}'", localOrderInfo.ORDERID); /// 保险人信息 InsuranceUsrInfo localInsuranceUsrInfo = new InsuranceUsrInfo(); CTrace.WriteLine(CTrace.TraceLevel.Info, "insurance.outOrderInfo sql={0}.", sql); DataTable dt = db.GetTable(sql); if (dt != null && dt.Rows.Count > 0) { DataRow locaorderDr = dt.Rows[0]; localOrderInfo = DataRowToOrderModel(locaorderDr); if (localOrderInfo.BENEFICIARIES != null && !string.IsNullOrEmpty(localOrderInfo.BENEFICIARIES)) { InsuranceUsrID = "'" + localOrderInfo.BENEFICIARIES.ToString() + "',"; } if (localOrderInfo.BENEFICIARIES2 !=null && !string.IsNullOrEmpty(localOrderInfo.BENEFICIARIES2)) { InsuranceUsrID = InsuranceUsrID +"'" + localOrderInfo.BENEFICIARIES2.ToString() + "',"; } if (localOrderInfo.BENEFICIARIES3 != null && !string.IsNullOrEmpty(localOrderInfo.BENEFICIARIES3)) { InsuranceUsrID = InsuranceUsrID + "'" + localOrderInfo.BENEFICIARIES3.ToString() + "',"; } if (localOrderInfo.INSURANT != null && !string.IsNullOrEmpty(localOrderInfo.INSURANT)) { InsuranceUsrID = InsuranceUsrID + "'" + localOrderInfo.INSURANT.ToString() + "',"; } if (localOrderInfo.POLICYHOLDER !=null && !string.IsNullOrEmpty(localOrderInfo.POLICYHOLDER)) { InsuranceUsrID = InsuranceUsrID + "'" + localOrderInfo.POLICYHOLDER.ToString() + "',"; } } if (string.IsNullOrEmpty(InsuranceUsrID)) { return; } DataTable localdt = new DataTable(); sql = lib.GetSql("SqlInsuranceUsrInfo/InsuranceUsrInfo", "GetInsuranceUsrInfo"); if (!string.IsNullOrEmpty(InsuranceUsrID)) { InsuranceUsrID = InsuranceUsrID.Substring(0, InsuranceUsrID.Length - 1); sql += " and INSURANCE_USRID in (" + InsuranceUsrID + " )"; } else { throw new NullReferenceException("保单详细信息不能为空"); } if (!string.IsNullOrEmpty(sql)) { localdt = db.GetTable(sql); } for (int i = 0; i < localdt.Rows.Count; i++) { DataRow dr = localdt.Rows[i]; dr.Delete(); } outInsuranceUsrDt.Merge(localdt, true); } catch (NullReferenceException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message); } catch (ArrayTypeMismatchException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message); } catch (Exception ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteInsuranceUsrData" + ex.Message); throw; } }
public void updateOrderHistData(SqlLib lib, IDb db, object obj, ref DataTable outOrderHistDt) { string sql = ""; bool ret = true; try { OrderInfo li = new OrderInfo(); ret = DataHandle.CompareObjectType(obj, li); if (ret) { //get the correct list. li = (OrderInfo)obj; } else { return; } if (outOrderHistDt == null) { throw new NullReferenceException("outOrderHistDt is null"); } DataTable localDt = new DataTable(); //每次更新一条数据 sql = lib.GetSql("SqlOrderInfo/OrderInfo", "GetOrderInfo"); if (!string.IsNullOrEmpty(li.ORDERID)) { sql = sql + " and orderid= '" + li.ORDERID + "'"; localDt = db.GetTable(sql); if (localDt.Rows.Count == 1) { DataRow dr = localDt.Rows[0]; dr.BeginEdit(); dr["orderid"] = DataHandle.EmptyString2DBNull(li.ORDERID); dr["contactid"] = DataHandle.EmptyString2DBNull(li.CONTACTID); dr["addressid"] = DataHandle.EmptyString2DBNull(li.ADDRESSID); dr["ACCDT"] = DataHandle.EmptyString2DBNull(li.ACCDT); dr["AMORTISATION"] = DataHandle.EmptyString2DBNull(li.AMORTISATION); dr["BENEFICIARIES"] = DataHandle.EmptyString2DBNull(li.BENEFICIARIES); dr["BILL"] = DataHandle.EmptyString2DBNull(li.BILL); dr["BILLDEMONDDSC"] = DataHandle.EmptyString2DBNull(li.BILLDEMONDDSC); dr["BILLDEMONDED"] = DataHandle.EmptyString2DBNull(li.BILLDEMONDED); dr["BILLTITLE"] = DataHandle.EmptyString2DBNull(li.BILLTITLE); dr["CARDID"] = DataHandle.EmptyString2DBNull(li.CARDID); dr["CARDRIGHTNUM"] = DataHandle.EmptyString2DBNull(li.CARDRIGHTNUM); dr["CLEARFEE"] = DataHandle.EmptyString2DBNull(li.CLEARFEE); dr["CONFIRM"] = DataHandle.EmptyString2DBNull(li.CONFIRM); dr["CONSIGNEE"] = DataHandle.EmptyString2DBNull(li.CONSIGNEE); dr["CONSIGNPHN"] = DataHandle.EmptyString2DBNull(li.CONSIGNPHN); dr["CRUSR"] = DataHandle.EmptyString2DBNull(li.CRUSR); dr["DEMONDDT"] = DataHandle.EmptyString2DBNull(li.DEMONDDT); dr["DISCOUNT"] = DataHandle.EmptyString2DBNull(li.DISCOUNT); dr["FBDT"] = DataHandle.EmptyString2DBNull(li.FBDT); dr["GRPID"] = DataHandle.EmptyString2DBNull(li.GRPID); dr["HEALTHINTRO"] = DataHandle.EmptyString2DBNull(li.HEALTHINTRO); dr["INSURANCEID"] = DataHandle.EmptyString2DBNull(li.INSURANCEID); dr["INSURANT"] = DataHandle.EmptyString2DBNull(li.INSURANT); dr["MAILPRICE"] = DataHandle.EmptyString2DBNull(li.MAILPRICE); dr["MDDT"] = DataHandle.EmptyString2DBNull(li.MDDT); dr["MDUSR"] = DataHandle.EmptyString2DBNull(li.MDUSR); dr["MONITORRECORDER"] = DataHandle.EmptyString2DBNull(li.MONITORRECORDER); dr["NOTE"] = DataHandle.EmptyString2DBNull(li.NOTE); dr["NOWMONEY"] = DataHandle.EmptyString2DBNull(li.NOWMONEY); dr["POLICYHOLDER"] = DataHandle.EmptyString2DBNull(li.POLICYHOLDER); dr["POSTFEE"] = DataHandle.EmptyString2DBNull(li.POSTFEE); dr["PRODPRICE"] = DataHandle.EmptyString2DBNull(li.PRODPRICE); dr["PRODUCTINTRO"] = DataHandle.EmptyString2DBNull(li.PRODUCTINTRO); dr["RESULT"] = DataHandle.EmptyString2DBNull(li.RESULT); dr["SENDDT"] = DataHandle.EmptyString2DBNull(li.SENDDT); dr["SPECIALDSC"] = DataHandle.EmptyString2DBNull(li.SPECIALDSC); dr["STATUS"] = DataHandle.EmptyString2DBNull(li.STATUS); dr["TOTALPRICE"] = DataHandle.EmptyString2DBNull(li.TOTALPRICE); dr["URGENT"] = DataHandle.EmptyString2DBNull(li.URGENT); dr["ordertype"] = DataHandle.EmptyString2DBNull(li.ordertype); dr["paytype"] = DataHandle.EmptyString2DBNull(li.paytype); dr["mailtype"] = DataHandle.EmptyString2DBNull(li.mailtype); dr["CRDT"] = DataHandle.EmptyString2DBNull(li.crdt); dr.EndEdit(); outOrderHistDt.Merge(localDt, true); } else { //do nothing } } else { //do nothing } //ScmProviderData li = new ScmProviderData(); //ret = DataHandle.CompareObjectType(obj, li); //if (ret) //{ // //get the correct list. // li = (ScmProviderData)obj; //} //else //{ // return; //} //if (outDtPlace == null) //{ // throw new NullReferenceException("outDtPlace is null"); //} //DataTable localDt = new DataTable(); ////每次更新一条。 //sql = lib.GetSql("SqlPlace/PlaceProdInfo", "GetPlaceProdRelationInfo"); //if (!string.IsNullOrEmpty(li.PROVIDERID)) //{ // sql = sql + " and PROVIDERID= '" + li.PROVIDERID + "'"; // localDt = db.GetTable(sql); // //have one record // if (localDt.Rows.Count == 1) // { // // only one record. // DataRow dr = localDt.Rows[0]; // dr.BeginEdit(); // dr["PROVIDERID"] = DataHandle.EmptyString2DBNull(li.PROVIDERID); // dr["CRDT"] = DataHandle.EmptyString2DBNull(li.CRDT); // dr["CRUSR"] = DataHandle.EmptyString2DBNull(li.CRUSR); // dr["DSC"] = DataHandle.EmptyString2DBNull(li.DSC.ToString()); // dr["MDDT"] = DataHandle.EmptyString2DBNull(li.MDDT); // dr["MDUSR"] = DataHandle.EmptyString2DBNull(li.MDUSR); // dr["NAME"] = DataHandle.EmptyString2DBNull(li.NAME.ToString()); // dr.EndEdit(); // outDtPlace.Merge(localDt, true); // } // else // { // //do nothing. // } //} //else //{ // // do nothing //} } catch (NullReferenceException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderHistData" + ex.Message); } catch (ArrayTypeMismatchException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderHistData" + ex.Message); } catch (Exception ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in updateOrderHistData" + ex.Message); throw; } }
public void SetUp() { unitOfWork = new UnitOfWork(sessionProvider); blogRepository = new Db(unitOfWork); }
public void deleteOrderHistAllDetData(SqlLib lib, IDb db, object obj, ref DataTable outOrderDetDt) { string sql = ""; bool ret = true; try { OrderInfo localOrderinfo = new OrderInfo(); ret = DataHandle.CompareObjectType(obj, localOrderinfo); if (ret) { localOrderinfo = (OrderInfo)obj; } else { return; } if (outOrderDetDt == null) { throw new NullReferenceException("outOrderDetInfo is null"); } DataTable localdt = new DataTable(); sql = lib.GetSql("SqlOrderDetInfo/OrderDetInfo", "GetOrderDetInfo"); if (!string.IsNullOrEmpty(localOrderinfo.ORDERID)) { sql += " and ORDERID='" + localOrderinfo.ORDERID + "'"; } else { throw new NullReferenceException("保单信息不能为空"); } if (!string.IsNullOrEmpty(sql)) { localdt = db.GetTable(sql); } for (int i = 0; i < localdt.Rows.Count; i++) { DataRow dr = localdt.Rows[i]; dr.Delete(); } outOrderDetDt.Merge(localdt, true); } catch (NullReferenceException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteOrderHistAllDetData" + ex.Message); } catch (ArrayTypeMismatchException ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteOrderHistAllDetData" + ex.Message); } catch (Exception ex) { CTrace.WriteLine(CTrace.TraceLevel.Fail, "in deleteOrderHistAllDetData" + ex.Message); throw; } }
public CabaretController(IDb db, ILogger logger) : base(db, logger) { }
public ManageController(IDb db, ILogger logger) : base(db, logger) { }
public TriggerEventArgs(IDb db, Timing timing) : base() { this.db = db; this.timing = timing; }
public virtual object Find(IDb session, object key) { ErrorIfSPResult(); SqlColumn pk = null; object result = null; foreach (SqlColumn c in columns) { if (c.IsPK) { pk = c; break; } } if (pk != null) { SqlQuery q = new SqlQuery(); q.Constrain(pk.Alias).Equal(key); IList list = new ArrayList(1); Select(session, q, list); if (list.Count > 0) result = list[0]; } return result; }
public IIdQuery(IDb db) : base(db) { }
public CommentApiController(IDb service) { _service = service; }
public virtual void Exec(IDb db, string procName, object[] parameters, IList list) { int len = (parameters == null) ? 0 : parameters.Length; string sql = GetExecSql(procName, len); IDbCommand cmd = null; IDataReader reader = null; try { cmd = db.Connection.CreateCommand(); cmd.CommandText = sql; cmd.CommandType = CommandType.Text; cmd.Transaction = db.Transaction; for (int i = 0; i < len; i++) { int j = i + 1; IDbDataParameter p = cmd.CreateParameter(); p.ParameterName = string.Format("@{0}", j); SqlUtils.PrepParam(p, parameters[i]); cmd.Parameters.Add(p); } TraceObject.Instance.TraceCommand(cmd); reader = cmd.ExecuteReader(); FillByName(reader, list); } finally { if (reader != null) { if (!reader.IsClosed) reader.Close(); reader.Dispose(); reader = null; } if (cmd != null) { cmd.Dispose(); cmd = null; } } FireTriggers(list, new TriggerEventArgs(db, Timing.AfterActivate)); }
public DbTest(string name) { _target = DbTargetFactory.Create(name); _db = CreateDb(); }
public AccountingPolicyService(IDb db) { _table = db.GetTable <AccountingPolicy>(); }
public AccountController(IDb db, ILogger logger, IAuthentication authentication = null) : base(db, logger, authentication) { }
public HomeController(IDb repository, ISendEmail mailRepo) { this.dbRepository = repository; this.sendEmail = mailRepo; }