public void TestDeployerLocalDb() { var dbName = "TestDeployerLocalSqlInstance"; if (File.Exists(dbName + ".mdf")) { File.Delete(dbName + ".mdf"); } if (File.Exists(dbName + "_log.ldf")) { File.Delete(dbName + "_log.ldf"); } var deployer = new SsdtLocalDbDeployer(dbName + ".mdf", true); deployer.DeployDacPac(Utils.Dacpac); Assert.IsFalse(DacHelper.DbExists(SsdtLocalDbDeployer.LocalDbDataSource, deployer.DbName)); var connectString = String.Format(SsdtLocalDbDeployer.LocalDbConnectionString, dbName + ".mdf"); using (var c = new SqlConnection(connectString)) { c.Open(); using (var cmd = c.CreateCommand()) { cmd.CommandText = "TRUNCATE TABLE TESTTABLE"; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } c.Close(); } deployer.DetachDb(); File.Delete(dbName + ".mdf"); File.Delete(dbName + "_log.ldf"); }
public void TestCreateSqlDb() { var dbName = "TestDeployerCraeteOnLocalSqlInstance"; var connectString = String.Format(Utils.LocalInstanceConnectionString, dbName); if (DacHelper.DbExists(".", dbName)) { var deployer2 = new SsdtServerDeployer(connectString, dbName, false); deployer2.DeleteDb(); } Assert.IsFalse(DacHelper.DbExists(".", dbName)); var deployer = new SsdtServerDeployer(connectString, dbName, false); var name = dbName + ".mdf"; deployer.CreatDb(name); Assert.IsTrue(File.Exists(name)); using (var c = new SqlConnection(connectString)) { c.Open(); c.Close(); } deployer.DeleteDb(); Assert.IsFalse(File.Exists(name)); try { using (var c = new SqlConnection(connectString)) { c.Open(); } Assert.Fail("Should have thrown Exception"); } catch (SqlException) { } }
// 지마켓 비밀번호 알아오기 public string FindPassword(string userId) { string query = "dbo.up_new_gdback_getcust_no"; object obj = new DacHelper(DbHelper, "tiger_read").SelectScalar(CommandType.StoredProcedure, query, SqlParameterHelper.CreateParameter("@login_id", userId, SqlDbType.VarChar, 10) ); return obj == null ? "" : obj.ToString(); }
public List<GepOrderNoT> GetGepOrderNo(string orderNos) { List<GepOrderNoT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<GepOrderNoT>( typeof(GepOrderNoT), GEPMappingCache.GetDataMappings("GepOrderNoT"), CommandType.StoredProcedure, "dbo.up_gmkt_front_gep_match_order_no", SqlParameterHelper.CreateParameter("@order_nos", orderNos, SqlDbType.VarChar) ); return list; }
public List<OrderDetailInfoT> GetOrderDetailInfo(int packNo, string custNo) { List<OrderDetailInfoT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<OrderDetailInfoT>( typeof(OrderDetailInfoT), GEPMappingCache.GetDataMappings("OrderDetailInfoT"), CommandType.StoredProcedure, "dbo.up_gmkt_front_my_gd_contract_info", SqlParameterHelper.CreateParameter("@pack_no", packNo, SqlDbType.Int), SqlParameterHelper.CreateParameter("@cust_no", custNo, SqlDbType.VarChar) ); return list; }
public List<OrderSelOptInfoT> GetOrderSelOptInfo(string itemNo, long orderNo) { List<OrderSelOptInfoT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<OrderSelOptInfoT>( typeof(OrderSelOptInfoT), GEPMappingCache.GetDataMappings("OrderSelOptInfoT"), CommandType.StoredProcedure, "goodsdaq.up_neo_get_selinfo_of_buy_order2", SqlParameterHelper.CreateParameter("@gd_no", itemNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@order_no", orderNo, SqlDbType.BigInt) ); return list; }
public List<BasketOrderReservedDiscountInfoT> GetBasketOrderReservedDiscountInfo(string pid) { List<BasketOrderReservedDiscountInfoT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<BasketOrderReservedDiscountInfoT>( typeof(BasketOrderReservedDiscountInfoT), GEPMappingCache.GetDataMappings("BasketOrderReservedDiscountInfoT"), CommandType.StoredProcedure, "dbo.up_gmkt_front_get_basket_order_cost_info", SqlParameterHelper.CreateParameter("@pid", pid, SqlDbType.VarChar) ); return list; }
public int CountUserList(string searchType, string searchText) { var obj = new DacHelper(DbHelper, "intradb_read").SelectScalar( CommandType.StoredProcedure, "dbo.UPAR_ASSETDB_Asset_CountAssetUserList" ); if (obj != null) //return (int)obj; return Convert.ToInt32(obj); else return 0; }
/// <summary> /// IP 리스트 정보를 가져온다. /// 2013-11-28 김두성 /// </summary> /// <param name="searchType"></param> /// <param name="searchText"></param> /// <param name="pageNo"></param> /// <param name="pageSize"></param> /// <returns></returns> public List<AssetIpInfoEX1T> SelectIpList(string searchType, string searchText, int pageNo, int pageSize) { List < AssetIpInfoEX1T > list = new DacHelper(DbHelper, "intradb_read").SelectMultipleEntities<AssetIpInfoEX1T>( typeof(AssetIpInfoEX1T), SystemAssetMappingCache.GetDataMappings("AssetIpInfoEX1T"), CommandType.StoredProcedure, "dbo.UPAR_ASSETDB_Asset_SelectAssetIPList", SqlParameterHelper.CreateParameter("@SEARCH_TYPE", searchType, SqlDbType.Char, 1), SqlParameterHelper.CreateParameter("@SEARCH_TEXT", searchText, SqlDbType.VarChar, 30), SqlParameterHelper.CreateParameter("@PAGE_NO", pageNo, SqlDbType.Int), SqlParameterHelper.CreateParameter("@PAGE_SIZE", pageSize, SqlDbType.Int) ); return list; }
public List<BasketCouponInfoT> GetBasketCouponInfo(string pid, string gdSelNo, string itemNo) { List<BasketCouponInfoT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<BasketCouponInfoT>( typeof(BasketCouponInfoT), GEPMappingCache.GetDataMappings("BasketCouponInfoT"), CommandType.StoredProcedure, "dbo.up_gmkt_front_get_basket_coupon_info", SqlParameterHelper.CreateParameter("@pid", pid, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@gd_sel_no", gdSelNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@gd_no", itemNo, SqlDbType.VarChar) ); return list; }
/// <summary> /// 소분류, 소분류 정보와 HSCODE를 가져온다. /// </summary> /// <param name="gdclCd"></param> /// <param name="gdmcCd"></param> /// <param name="gdscCd"></param> /// <returns></returns> internal List<CategoryHscodeT> GetCategoryHscodeT(string gdclCd, string gdmcCd, string gdscCd) { List<CategoryHscodeT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<CategoryHscodeT>( typeof(CategoryHscodeT), GEPMappingCache.GetDataMappings("CategoryHscodeT"), CommandType.StoredProcedure, "dbo.up_gmkt_admin_oversea_select_category_hscode_info", SqlParameterHelper.CreateParameter("@GDLC_CD", gdclCd, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GDMC_CD", gdmcCd, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GDSC_CD", gdscCd, SqlDbType.VarChar) ); return list; }
/// <summary> /// </summary> /// Asset 서버 리스트 총 카운트를 가져온다. /// 2013-11-22 문태중 /// </summary> /// <param name="searchType"></param> /// <param name="searchText"></param> /// <returns></returns> public int CountServerList(string searchType, string searchText) { object obj = new DacHelper(DbHelper, "intradb_read").SelectScalar( CommandType.StoredProcedure, "dbo.UPAR_ASSETDB_Asset_CountAssetServerList", SqlParameterHelper.CreateParameter("@SEARCH_TYPE", searchType, SqlDbType.Char, 1), SqlParameterHelper.CreateParameter("@SEARCH_TEXT", searchText, SqlDbType.VarChar, 30) ); if (obj != null) return (int)obj; else return 0; }
private void btSearch_Click(object sender, EventArgs e) { DacHelper dacHelper = new DacHelper(CONNSTR); DataSet ds = null; string soBenhAn = txtSoBenhAn.Text; ds = dacHelper.ExecuteQuery("sp_CUST_DieuChinhSoLe_PhieuDieuTri" , new string[] { "@ACTIONID", "@SoBenhAn" }, new object[] { "Select", soBenhAn }); if (ds != null) { ultraGrid1.DataSource = ds.Tables[0]; } }
/// <summary> /// G마켓 필터링 단일상품 조회 /// </summary> public SourceItemInfoT GetSourceItem(string ta_id, string gd_no) { SourceItemInfoT info = new DacHelper(DbHelper, "refer_read").SelectSingleEntity<SourceItemInfoT>( typeof(SourceItemInfoT), GEPMappingCache.GetDataMappings("SourceItemInfoT"), CommandType.StoredProcedure, "dbo.up_gmkt_gep_get_source_item_info", SqlParameterHelper.CreateParameter("@ta_id", ta_id, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@search_type", "GDNO", SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@search_value", gd_no, SqlDbType.VarChar) ); return info; }
public List<GmarketOrderListT> GetGmarketOrderList(string custNo, DateTime startDt, DateTime endDt, int packNo, int pageNo, int pageSize) { List<GmarketOrderListT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<GmarketOrderListT>( typeof(GmarketOrderListT), GEPMappingCache.GetDataMappings("GmarketOrderListT"), CommandType.StoredProcedure, "dbo.up_gmkt_front_get_op_myshopping_total_order_list_check_xdisplay", SqlParameterHelper.CreateParameter("@cust_no", custNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@start_dt", startDt, SqlDbType.DateTime), SqlParameterHelper.CreateParameter("@end_dt", endDt.AddDays(1), SqlDbType.DateTime), SqlParameterHelper.CreateParameter("@pack_no", packNo, SqlDbType.Int), SqlParameterHelper.CreateParameter("@page_no", pageNo, SqlDbType.Int), SqlParameterHelper.CreateParameter("@page_size", pageSize, SqlDbType.Int) ); return list; }
private void bFix_Click(object sender, EventArgs e) { if (_ds != null && _ds.Tables[0].Rows.Count != 0) { DacHelper dacHelper = new DacHelper(MainForm.CONNSTR); DataSet ds = null; try { ds = dacHelper.ExecuteQuery("sp_CUST_Sync_BenhAnKhuALenCenter", null, null); bShow_Click(sender, e); MessageBox.Show("Xong"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { MessageBox.Show("Không có dữ liệu"); } }
private void bShow_Click(object sender, EventArgs e) { DacHelper dacHelper = new DacHelper(MainForm.CONNSTR); _ds = dacHelper.ExecuteQuery("sp_CUST_BenhAnKhuAKhongDongBoLenCenter", null, null); if (_ds != null) { if (_ds.Tables[0].Rows.Count != 0) { bFix.Enabled = true; } else { bFix.Enabled = false; } ultraGrid1.DataSource = _ds.Tables[0]; } else { bFix.Enabled = false; } }
public List<PaymentInsertPolicyMultiResultT> SetPaymentInsertPolicyMulti(PaymentInsertPolicyMultiParamT entity) { List<PaymentInsertPolicyMultiResultT> list = new DacHelper(DbHelper, "tiger_write").SelectMultipleEntities<PaymentInsertPolicyMultiResultT>( typeof(PaymentInsertPolicyMultiResultT), GEPMappingCache.GetDataMappings("PaymentInsertPolicyMultiResultT"), CommandType.StoredProcedure, "dbo.up_gmkt_front_gep_payment_insert_order_goods_policy_multi", SqlParameterHelper.CreateParameter("@order_way_kind", entity.OrderWayKind, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@pid", entity.PaymentBasketPID, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@delivery_group_no_s", entity.PaymentDeliveryGroupNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@order_cnt_s", entity.PaymentAmount, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@order_zip_code", entity.ReceiverZipCode, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@gbank", entity.Gbank, SqlDbType.Int), SqlParameterHelper.CreateParameter("@vaccount", entity.Vaccount, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@installmonth", entity.Installmonth, SqlDbType.Int), SqlParameterHelper.CreateParameter("@seller_cust_no", entity.SellerCustNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@policy_order_src ", entity.PaymentOrderType, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@card_cash", entity.CardCash, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@acnt_type", entity.AcntType, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@pack_no", entity.PackNo, SqlDbType.Int) SqlParameterHelper.CreateParameter("@GD_NOS", entity.ItemNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GD_SEL_NOS", entity.PaymentGdSelNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@ORDER_IDXS", entity.PaymentOrderIdx, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GD_NMS", entity.GdNm, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GD_ENG_NMS", entity.GdEngNm, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GD_KINDS", entity.GdKind, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GD_ORIGINS", entity.GdOrigin, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GDLC_CDS", entity.GdlcCd, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GDMC_CDS", entity.GdmcCd, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GDSC_CDS", entity.GdscCd, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@MAKER_NMS", entity.MakerNm, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@BRAND_NMS", entity.BrandNm, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@DEAL_PRICE_KINDS", entity.DealPriceKind, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@DEAL_PRICES", entity.DealPrice, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@OP_GDS", entity.OpGd, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@AS_YNS", entity.AsYn, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@SELL_CUST_NOS", entity.SellCustNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GD_SHOPKINDS", entity.GdShopkind, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GD_SHOPKIND2S", entity.GdShopkind2, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GD_SHOPKIND3S", entity.GdShopkind3, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@TRAD_WAYS", entity.TradWay, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@TEMPLATE_TYPES", entity.TemplateType, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@ADULT_YNS", entity.AdultYn, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@HASADDEDFILES", entity.Hasaddedfile, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@INVENTORY_NOS", entity.InventoryNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@INVENTORYTYPES", entity.Inventorytype, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@OPT_INVENTORYNOS", entity.OptInventoryno, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@OPT_INVENTORYTYPES", entity.OptInventorytype, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GD_MADE_SDTS", entity.GdMadeSdt, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@ATTRIB_END_DTS", entity.AttribEndDt, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GD_BUYER_ML_RATES", entity.GdBuyerMlRate, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@GD_BUDDY_ML_RATES", entity.GdBuddyMlRate, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@USE_GUBUNS", entity.UseGubun, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@BUNDLE_TYPES", entity.BundleType, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@MIN_BUY_CNTS", entity.MinBuyCnt, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@BUY_UNIT_CNTS", entity.BuyUnitCnt, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@DANGOL_CHANCE_AMTS", entity.DangolChanceAmt, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@DANGOL_CHANCE_KINDS", entity.DangolChanceKind, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@JEHU_RSV_SERVICE_TYPES", entity.JehuRsvServiceType, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@JEHU_EST_TYPES", entity.JehuEstType, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@DNT_NOS", entity.DntNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@DNT_WHO_FEES", entity.DntWhoFee, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@DNT_SAVE_MONEYS", entity.DntSaveMoney, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@FREEC_SELLERCHARGEYNS", entity.FreecSellerchargeyn, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@ORDER_PRICES", entity.PaymentPrice, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@SEL_ITEM_PRICES", entity.PaymentSelItemPrice, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@ORDER_CNTS", entity.PaymentAmount, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@DEL_FEES", entity.PaymentDeliveryFee, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@COST_PRICES", entity.PaymentCostPrice, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@DELIVERY_GROUP_NOS", entity.PaymentDeliveryGroupNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@SHOP_GROUP_CDS", entity.ShopGroupCd, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@SHOP_GDLC_CDS", entity.ShopGdlcCd, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@SHOP_GDMC_CDS", entity.ShopGdmcCd, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@SHOP_GDSC_CDS", entity.ShopGdscCd, SqlDbType.VarChar) ); return list; }
public List<PaymentGEPOrderMultiResultT> SetPaymentGEPOrderMulti(PaymentOrderMultiParamT entity) { List<PaymentGEPOrderMultiResultT> list = new DacHelper(DbHelper, "tiger_write").SelectMultipleEntities < PaymentGEPOrderMultiResultT>( typeof(PaymentGEPOrderMultiResultT), GEPMappingCache.GetDataMappings("PaymentGEPOrderMultiResultT"), CommandType.StoredProcedure, "dbo.up_gmkt_common_payment_gep_insert_order_domestic_multi", SqlParameterHelper.CreateParameter("@order_way_kind", entity.OrderWayKind, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@pos_shop_cd_s", entity.PosShopCd, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@pos_class_cd_s", entity.PosClassCd, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@pos_class_kind_s", entity.PosClassKind, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@primary_check_value", entity.PrimaryCheckValue, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@shopping_guide_no_s", entity.ShoppingGuideNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@interest_group_no_s", entity.InterestGroupNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@pid", entity.BasketPID, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@gd_sel_no_s", entity.GdSelNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@g_jaehuid", entity.JaehuID, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@jaehuid_s", entity.JaehuIDs, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@gd_no_s", entity.GoodsCode, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@order_no_s", entity.OrderNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@order_price_s", entity.OrderPrice, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@order_cnt_s", entity.OrderCnts, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@sel_item_price_s", entity.SelItemPrice, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@inventory_seq_no_s", entity.InventorySeqNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@opt_inventory_seq_no_s", entity.OptInventorySeqNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@reservation_rsv_no", entity.ReservationRsvNo, SqlDbType.Int), //SqlParameterHelper.CreateParameter("@policy_no_s", entity.PolicyNos, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@deliverygoodsyn", entity.DeliveryGoodsYN, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@online_transport_sid", entity.OnlineTransportSid, SqlDbType.Int), //SqlParameterHelper.CreateParameter("@jehu_gd_no", entity.JehuGdCds, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@jehu_order_cnt", entity.JehuOrderCnts, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@jehu_order_no", entity.JehuOrderNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@jehu_l_type", entity.JehuLType, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@jehu_a_type", entity.JehuAtype, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@gift_pack_yn_s", entity.GiftPackYn, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@gift_shop_yn_s", entity.GiftShopYN, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@cost_price_s", entity.RealCostPrice, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@dealer_cost_price_s", entity.RealDealerCostPrice, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@dealer_cost_basis_no_s", entity.RealDealerCostBasisNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@sid_s", entity.Sid, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@bund_cond_no_s", entity.PlusDisBcCondNos, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@bund_satis_cnt_s", entity.PlusDisSatisCnts, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@set_cost_no_s", entity.SetCostScdNos, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@set_cond_no_s", entity.SetCondScdNos, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@pack_cost_no_s", entity.PackCostPcdNos, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@pack_cond_no_s", entity.PackCondPcdNos, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@pack_satis_cnt_s", entity.PackCostSatisCnts, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@auction_no_s", entity.AuctionNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@bid_price", entity.AuctionBidPrice, SqlDbType.Money), //SqlParameterHelper.CreateParameter("@bid_amt", entity.AuctionBidAmt, SqlDbType.Int), //SqlParameterHelper.CreateParameter("@bid_no", entity.BidNo, SqlDbType.Int), SqlParameterHelper.CreateParameter("@cust_no", entity.CustNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@login_id", entity.LoginID, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@member_type", entity.MemberWay, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@buyer_name", entity.BuyerName, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@buyer_tel_no", entity.BuyerTelNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@buyer_email", entity.BuyerEmail, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@buyer_ssn", entity.BuyerSSN, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@buyer_identification_no", entity.BuyerIdentificationNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@pay_auth_seq", entity.PayAuthSeq, SqlDbType.Int), SqlParameterHelper.CreateParameter("@card_cash", entity.CardCash, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@acnt_type", entity.AcntType, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@sttl_code", entity.PaymentCode, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@settle_limit_key", entity.SettleLimitKey, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@oncredit_yn", entity.OnCreditYN, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@gbank", entity.Gbank, SqlDbType.Int), SqlParameterHelper.CreateParameter("@deposit_nm", entity.DepositNm, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@vaccount", entity.Vaccount, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@vacnt_no", entity.VacntNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@gbank_gubun", entity.GbankGubun, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@foreign_money", entity.ForeignMoney, SqlDbType.Int), //SqlParameterHelper.CreateParameter("@transaction_no", entity.TransactionNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@trans_bank_no", entity.TransBankNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@trans_order_no", entity.TransOrderNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@trans_seq_no", entity.TransSeqNo, SqlDbType.TinyInt), SqlParameterHelper.CreateParameter("@iscorp_card", entity.IsCorpCard, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@virtual_card_kind", entity.VirtualCardKind, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@card_number", entity.CardNumber, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@installmonth", entity.Installmonth, SqlDbType.Int), SqlParameterHelper.CreateParameter("@fi_no", entity.FreeInterestNo, SqlDbType.Int), SqlParameterHelper.CreateParameter("@halbu_type", entity.HalbuType, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@year", entity.CardYear, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@month", entity.CardMonth, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@card_pwd", entity.CardPwd, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@social_no2", entity.SocialNo2, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@kcp_session_key", entity.KVPSessionkey, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@kcp_enc_data", entity.KVPEncdata, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@kcp_card_code", entity.KVPCardCode, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@xid", entity.Xid, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@eci", entity.Eci, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@cavv", entity.Cavv, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@save_yn", entity.PaySaveCardYN, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@fr_code ", entity.FrCode, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@cellphone_no", entity.CellPhoneHpNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@cellphone_kind", entity.CellPhoneAuthKind, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@cellphone_session_key", entity.CellPhoneSessionKey, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@cellphone_social_no", entity.CellPhoneAuthNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@cellphone_identification_no", entity.CellPhoneIdentificationNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@paypal_no", entity.PaypalNo, SqlDbType.Int), SqlParameterHelper.CreateParameter("@paypal_token", entity.PaypalToken, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@bibit_no", entity.BibitNo, SqlDbType.Int), //SqlParameterHelper.CreateParameter("@tcash_tid", entity.TCashID, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@tax_issue_yns", entity.TaxIssueYN, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@cash_issue_yns", entity.CashIssueYN, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@tax_charge_team", entity.TaxChargeTeam, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@tax_charge_name", entity.TaxChargeName, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@reg_no", entity.TaxRegNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@company_name", entity.TaxCompanyNm, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@boss", entity.TaxBoss, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@Address", entity.TaxAddress, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@Rcv_address", entity.TaxRcvAddress, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@zip_code", entity.TaxZipCode, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@category", entity.TaxCategory, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@kind", entity.TaxKind, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@tax_email", entity.TaxEmail, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@tax_phone", entity.TaxPhone, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@tax_memo", entity.TaxMemo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@receipt_type", entity.CashUseType, SqlDbType.Bit), SqlParameterHelper.CreateParameter("@id_number", entity.CashRegNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@demander", entity.CashName, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@contact", entity.CashPhone, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@email", entity.CashEmail, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@cash_receipt_yn", entity.CashReceiptYN, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@id_flag", entity.IdFlag, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@address_no", entity.AddressNo, SqlDbType.Int), SqlParameterHelper.CreateParameter("@order_zip_code", entity.ReceiverZipCode, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@address1", entity.ReceiverAddr1, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@address2", entity.ReceiverAddr2, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@rcv_nm", entity.ReceiverName, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@hp", entity.ReceiverHpNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@phone", entity.ReceiverPhoneNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@interval_s", entity.Interval, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@del_memo_s", entity.DelMemo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@coupon_gift_group_no", entity.CouponGiftGroupNo, SqlDbType.Int), //SqlParameterHelper.CreateParameter("@send_gift_yn", entity.SendGiftYN, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@gift_receiver_cust_no", entity.GiftReceiverCustNo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@gift_receiver_nm", entity.GiftRecevierNm, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@gift_receiver_hp_no", entity.GiftReceiverHp, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@gift_receiver_id", entity.GiftReceiverId, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@gift_receiver_email", entity.GiftReceiverEmail, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@gift_memo", entity.GiftMemo, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@sender_info_kind_i", entity.SenderInfoKindI, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@sender_info_kind_e", entity.SenderInfoKindE, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@sender_info_kind_h", entity.SenderInfoKindH, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@send_gift_way", entity.SendGiftWay, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@gift_msg_kind", entity.MsgKind, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@sender_nm", entity.GiftSenderNm, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@sender_id", entity.GiftSenderId, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@sender_email", entity.GiftSenderEmail, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@sender_hp_no", entity.GiftSenderHpNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@remote_ip", entity.RemoteAddr, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@svr_ip", entity.ServerIPAddr, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@receive_mail_yn", entity.ReceiveMailYN, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@receive_sms_yn", entity.ReceiveSmsYN, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@glink_nation_s", entity.GlinkNations, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@okcashbag_acc_yn", entity.OkCashBagSaveYn, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@buyerpwd", entity.Pwd, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@out_order_no_s", entity.OuterOrderNos, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@partner_gift_msg", entity.PartnerGiftMsg, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@partner_gift_msg_receiver", entity.PartnerGiftMsgReceiver, SqlDbType.VarChar), //SqlParameterHelper.CreateParameter("@partner_gift_msg_sender", entity.PartnerGiftMsgSender, SqlDbType.VarChar) SqlParameterHelper.CreateParameter("@pack_no", entity.PackNo, SqlDbType.Int), SqlParameterHelper.CreateParameter("@item_count", entity.ItemCount, SqlDbType.Int) ); return list; }
public List<SelectOptionInfoT> GetSelectOptionInfo(string itemNo, string infoType) { string strSortType = string.Empty; List<SelectOptionInfoT> list = new DacHelper(DbHelper, "item_read").SelectMultipleEntities<SelectOptionInfoT>( typeof(SelectOptionInfoT), GEPMappingCache.GetDataMappings("SelectOptionInfoT"), CommandType.StoredProcedure, "dbo.up_gcts_front_goods_select_option_info_get", SqlParameterHelper.CreateParameter("@gd_no", itemNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@info_type", infoType, SqlDbType.Char), SqlParameterHelper.CreateParameter("@sort_type", strSortType, SqlDbType.Char) ); return list; }
/// <summary> /// Asset Storage 정보 추가 및 업데이트 /// 2013-11-27 변승현 /// </summary> /// <param name="model"></param> /// <returns></returns> public int UpdateStorageInfo(AssetStorageInfoT model) { var SEQ = new DacHelper(DbHelper, "intradb_write").SelectScalar( CommandType.StoredProcedure, "dbo.UPAR_ASSETDB_Asset_UpdateAssetStorageInfo", SqlParameterHelper.CreateParameter("@SEQ", model.Seq == null ? 0 : model.Seq.Value, SqlDbType.BigInt), SqlParameterHelper.CreateParameter("@BUY_DATE", model.BuyDate, SqlDbType.DateTime), SqlParameterHelper.CreateParameter("@SAP_NO", model.SapNo, SqlDbType.VarChar, 50), SqlParameterHelper.CreateParameter("@EQUIP_TYPE_CODE", model.EquipTypeCode, SqlDbType.VarChar, 10), SqlParameterHelper.CreateParameter("@SERIAL_NO", model.SerialNo, SqlDbType.VarChar, 50), SqlParameterHelper.CreateParameter("@SERVER_NAME", model.ServerName, SqlDbType.VarChar, 20), SqlParameterHelper.CreateParameter("@SITE_CODE", model.SiteCode, SqlDbType.VarChar, 10), SqlParameterHelper.CreateParameter("@IDC_SEQ", model.IdcCode, SqlDbType.VarChar, 20), SqlParameterHelper.CreateParameter("@RACK_SEQ", model.RackCode, SqlDbType.VarChar, 20), SqlParameterHelper.CreateParameter("@RACK_START_LOCATION_VALUE", model.RackStartLocationValue.Value, SqlDbType.Int), SqlParameterHelper.CreateParameter("@VENDER_CODE", model.VenderCode, SqlDbType.VarChar, 20), SqlParameterHelper.CreateParameter("@QTY", model.Qty.Value, SqlDbType.Int), SqlParameterHelper.CreateParameter("@CONTENT", model.Content, SqlDbType.VarChar, 4000), SqlParameterHelper.CreateParameter("@INS_OPRT", model.InsOprt, SqlDbType.VarChar, 30) ); return Convert.ToInt32(SEQ); }
public List<PaymentDataCostBasisInfoT> GetCostBasisInfo(int packNo, long buyOrderNo, string itemNo, int orderCnt, int orderPrice , string pid, long orderIdx, decimal pdcDiscountPrice, int bundSatisCnt, int packSatisCnt , string gdShopkind, string gdShopkind2, string gdShopkind3, decimal deliveryFee , string deliveryFeeCondition, decimal deliveryFeePolicy, int selItemPrice, DateTime orderDt) { List<PaymentDataCostBasisInfoT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<PaymentDataCostBasisInfoT>( typeof(PaymentDataCostBasisInfoT), GEPMappingCache.GetDataMappings("PaymentCostBasisInfoT"), CommandType.StoredProcedure, "dbo.up_gmkt_front_gep_get_payment_dm_cost_basis_info", SqlParameterHelper.CreateParameter("@pack_no", packNo, SqlDbType.Int), SqlParameterHelper.CreateParameter("@buy_order_no", buyOrderNo, SqlDbType.BigInt), SqlParameterHelper.CreateParameter("@gd_no", itemNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@order_cnt", orderCnt, SqlDbType.Int), SqlParameterHelper.CreateParameter("@order_price", orderPrice, SqlDbType.Int), SqlParameterHelper.CreateParameter("@pid", pid, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@order_idx", orderIdx, SqlDbType.BigInt), SqlParameterHelper.CreateParameter("@pdc_discount_price", pdcDiscountPrice, SqlDbType.Money), SqlParameterHelper.CreateParameter("@bund_satis_cnt", bundSatisCnt, SqlDbType.Int), SqlParameterHelper.CreateParameter("@pack_satis_cnt", packSatisCnt, SqlDbType.Int), SqlParameterHelper.CreateParameter("@gd_shopkind", gdShopkind, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@gd_shopkind2", gdShopkind2, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@gd_shopkind3", gdShopkind3, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@delivery_fee", deliveryFee, SqlDbType.Money), SqlParameterHelper.CreateParameter("@delivery_fee_condition", deliveryFeeCondition, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@delivery_fee_policy", deliveryFeePolicy, SqlDbType.Money), SqlParameterHelper.CreateParameter("@sel_item_price", selItemPrice, SqlDbType.Int), SqlParameterHelper.CreateParameter("@order_dt", orderDt, SqlDbType.DateTime) ); return list; }
public List<GEPBasketItemBasicInfoT> GetGEPBasketItemBasicInfo(string pid, string orderGubun, string selectOrderIdx) { List<GEPBasketItemBasicInfoT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<GEPBasketItemBasicInfoT>( typeof(GEPBasketItemBasicInfoT), GEPMappingCache.GetDataMappings("GEPBasketItemBasicInfoT"), CommandType.StoredProcedure, "dbo.up_gmkt_gep_basket_goods_get_basic_info", SqlParameterHelper.CreateParameter("@pid", pid, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@order_gubun", orderGubun, SqlDbType.Char, 1), SqlParameterHelper.CreateParameter("@sel_order_idxs", selectOrderIdx, SqlDbType.VarChar) ); return list; }
/// <summary> /// G마켓 필터링 상품리스트 조회 /// </summary> public List<SourceItemInfoT> GetSourceItemList(string ta_id, string lcategory_code, string mcategory_code, string scategory_code, string has_selection, string has_addition, string made_gep, decimal start_price, decimal end_price, string price_chg_cnt, string seller_agree, decimal start_weight, decimal end_weight, decimal start_avg_delivery_duration, decimal end_avg_delivery_duration, string overseas_delivery, string date_type, DateTime start_date, DateTime end_date, string overseas_sold_cnt, string search_type, string search_value, string order_by, int page_no, int page_size) { List<SourceItemInfoT> list = new DacHelper(DbHelper, "refer_read").SelectMultipleEntities<SourceItemInfoT>( typeof(SourceItemInfoT), GEPMappingCache.GetDataMappings("SourceItemInfoT"), CommandType.StoredProcedure, "dbo.up_gmkt_gep_get_source_item_info", SqlParameterHelper.CreateParameter("@ta_id", ta_id, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@lcategory_code", lcategory_code, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@mcategory_code", mcategory_code, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@scategory_code", scategory_code, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@has_selection", has_selection, SqlDbType.Char), SqlParameterHelper.CreateParameter("@has_addition", has_addition, SqlDbType.Char), SqlParameterHelper.CreateParameter("@made_gep", made_gep, SqlDbType.Char), SqlParameterHelper.CreateParameter("@start_price", start_price, SqlDbType.Money), SqlParameterHelper.CreateParameter("@end_price", end_price, SqlDbType.Money), SqlParameterHelper.CreateParameter("@price_chg_cnt", price_chg_cnt, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@seller_agree", seller_agree, SqlDbType.Char), SqlParameterHelper.CreateParameter("@start_weight", start_weight, SqlDbType.Decimal), SqlParameterHelper.CreateParameter("@end_weight", end_weight, SqlDbType.Decimal), SqlParameterHelper.CreateParameter("@start_avg_delivery_duration", start_avg_delivery_duration, SqlDbType.Decimal), SqlParameterHelper.CreateParameter("@end_avg_delivery_duration", end_avg_delivery_duration, SqlDbType.Decimal), SqlParameterHelper.CreateParameter("@overseas_delivery", overseas_delivery, SqlDbType.Char), SqlParameterHelper.CreateParameter("@date_type", date_type, SqlDbType.Char), SqlParameterHelper.CreateParameter("@start_date", start_date, SqlDbType.DateTime), SqlParameterHelper.CreateParameter("@end_date", end_date, SqlDbType.DateTime), SqlParameterHelper.CreateParameter("@overseas_sold_cnt", overseas_sold_cnt, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@search_type", search_type, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@search_value", search_value, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@order_by", order_by, SqlDbType.VarChar)//, //SqlParameterHelper.CreateParameter("@page_no", page_no, SqlDbType.Int), //SqlParameterHelper.CreateParameter("@page_size", page_size, SqlDbType.Int) ); return list; }
private void btUpdate_Click(object sender, EventArgs e) { UltraGridCell cell = ultraGrid1.ActiveCell; cell.Row.Selected = true; ultraGrid1.UpdateData(); ultraGrid1.PerformAction(UltraGridAction.ExitEditMode); UltraGridRow row = ultraGrid1.Selected.Rows[0]; if (row != null) { string chungTu = row.Cells[9].Value.ToString(); if (chungTu != string.Empty) { MessageBox.Show("Đã có chứng từ, không thể update"); return; } else { int toaThuocID = int.Parse(row.Cells[0].Value.ToString()); decimal soLuong = decimal.Parse(row.Cells[3].Value.ToString()); DataTable table = new DataTable(); DataSet dsUpdate = new DataSet(); table.Columns.Add("ToaThuoc_id", typeof(int)); table.Columns.Add("SoLuong", typeof(decimal)); DataRow r = table.NewRow(); r["ToaThuoc_id"] = toaThuocID; r["SoLuong"] = soLuong; table.Rows.Add(r); table.Rows[0].AcceptChanges(); table.Rows[0].SetModified(); dsUpdate.Merge(table); DacHelper dacHelper = new DacHelper(CONNSTR); SqlTransaction trans = dacHelper.BeginTransaction(); string soBenhAn = txtSoBenhAn.Text; bool saveOK = false; try { saveOK = dacHelper.ExecuteUpdateData(dsUpdate, "sp_CUST_DieuChinhSoLe_PhieuDieuTri" , new string[] { "@ToaThuoc_id", "@SoLuong" } , dsUpdate.Tables[0].TableName, trans); } catch { saveOK = false; } finally { if (trans != null) { if (saveOK) { trans.Commit(); ClearData(); MessageBox.Show("Đã update"); } else { trans.Rollback(); MessageBox.Show("Update thất bại"); } trans.Dispose(); } trans = null; } } } }
/// <summary> /// G마켓 상품 필수선택 정보 조회 /// </summary> public SourceItemOptionInfoT GetSourceItemOptionInfo(string gd_no) { SourceItemOptionInfoT info = new DacHelper(DbHelper, "item_read").SelectSingleEntity<SourceItemOptionInfoT>( typeof(SourceItemOptionInfoT), GEPMappingCache.GetDataMappings("SourceItemOptionInfoT"), CommandType.StoredProcedure, "dbo.up_gmkt_ich_get_goods_option", SqlParameterHelper.CreateParameter("@process_flag", "IG", SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@gd_no", gd_no, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@info_type", "", SqlDbType.Char) ); return info; }
public List<GEPBasketOptionInfoT> GetGEPCartOptionInfo(string orderType, string pid, string orderGubun, string itemNo, string gdSelNo, string xml) { List<GEPBasketOptionInfoT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<GEPBasketOptionInfoT>( typeof(GEPBasketOptionInfoT), GEPMappingCache.GetDataMappings("GEPBasketOptionInfoT"), CommandType.StoredProcedure, "dbo.up_gmkt_front_gep_cart_select_option_info_get", SqlParameterHelper.CreateParameter("@order_type", orderType, SqlDbType.Char), SqlParameterHelper.CreateParameter("@pid", pid, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@order_gubun", orderGubun, SqlDbType.Char), SqlParameterHelper.CreateParameter("@gd_no", itemNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@gd_sel_no", gdSelNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@orderXml", xml, SqlDbType.Xml) ); return list; }
public List<ItemDiscountT> GetItemDiscountInfo(string itemNo) { //상품별 할인 값만 가져오기 때문에 다른 정보가 필요 없음 int iSid = 0; string strJaehuId = string.Empty; string strDealerCustNo = string.Empty; List<ItemDiscountT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<ItemDiscountT>( typeof(ItemDiscountT), GEPMappingCache.GetDataMappings("ItemDiscountT"), CommandType.StoredProcedure, "dbo.up_neo_get_discount_info_plural", SqlParameterHelper.CreateParameter("@gd_no", itemNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@sid", iSid, SqlDbType.Int), SqlParameterHelper.CreateParameter("@jaehuid", strJaehuId, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@dealer_cust_no", strDealerCustNo, SqlDbType.VarChar) ); return list; }
public List<CategoryGmktInfoT> GetGmktCategory(string stepName, string parentCode) { List<CategoryGmktInfoT> list = new DacHelper(DbHelper, "item_read").SelectMultipleEntities<CategoryGmktInfoT>( typeof(CategoryGmktInfoT), GEPMappingCache.GetDataMappings("CategoryGmktInfoT"), CommandType.StoredProcedure, "dbo.up_GMKT_GSM_Category_GetInfo", SqlParameterHelper.CreateParameter("@gubun", stepName, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@strvalue1", parentCode, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@strvalue2", "GEP", SqlDbType.VarChar) ); return list; }
internal List<GMKTContrResultT> GetGMKTContrResult(DateTime startDate, DateTime endDate) { List<GMKTContrResultT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<GMKTContrResultT>( typeof(GMKTContrResultT), GEPMappingCache.GetDataMappings("GMKTContrResultT"), CommandType.StoredProcedure, "dbo.up_cbt_gep_select_payment_result", SqlParameterHelper.CreateParameter("@sDate", startDate, SqlDbType.DateTime), SqlParameterHelper.CreateParameter("@eDate", endDate, SqlDbType.DateTime) ); return list; }
/// <summary> /// G마켓 판매자 동의여부 변경 건 조회 /// </summary> public List<SellerAgreementT> GetChangedSellerAgreement() { List<SellerAgreementT> list = new DacHelper(DbHelper, "refer_read").SelectMultipleEntities<SellerAgreementT>( typeof(SellerAgreementT), GEPMappingCache.GetDataMappings("SellerAgreementT"), CommandType.StoredProcedure, "dbo.up_gmkt_gep_get_seller_agreement_change" ); return list; }
public List<ItemAttributeInfoT> GetItemAttributeInfo(string itemNo) { List<ItemAttributeInfoT> list = new DacHelper(DbHelper, "item_read").SelectMultipleEntities<ItemAttributeInfoT>( typeof(ItemAttributeInfoT), GEPMappingCache.GetDataMappings("ItemAttributeInfoT"), CommandType.StoredProcedure, "dbo.up_gcts_front_goods_attribute_info_get", SqlParameterHelper.CreateParameter("@gd_no", itemNo, SqlDbType.VarChar) ); return list; }
/// <summary> /// 获取查询数据的JSON结果(多表查询,WEB用) /// </summary> /// <param name="sqlCmdName">执行的SQL</param> ///<param name="filter">查询参数</param> ///<param name="where">过滤语句</param> ///<param name="orderBy">结果排序</param> /// <param name="hsDDL">列表中的下拉框</param> /// <returns>JSON结果</returns> public string GetCmdQueryData(string sqlCmdName, Hashtable filter, string where, string orderBy, Hashtable hsDDL) { #region 查询结果集 /* * command.config文件 SELECT T_.*, ROW_NUMBER() OVER(ORDER BY 行号标志字段) RN FROM ( SQL语句) T_ WHERE 1=1 */ int pageindex = 0, pagesize = 0; int draw = 0; if (HttpContext.Current.Request["draw"] != null) int.TryParse(HttpContext.Current.Request["draw"], out draw); if (HttpContext.Current.Request["start"] != null) int.TryParse(HttpContext.Current.Request["start"], out pageindex); pageindex = pageindex == 0 ? 1 : pageindex; if (HttpContext.Current.Request["length"] != null) int.TryParse(HttpContext.Current.Request["length"], out pagesize); if (pagesize == 0) pageindex = 1; else pageindex = pageindex / pagesize + 1; if (pagesize == 0) pagesize = 10;//默认10条 if (!string.IsNullOrEmpty(orderBy)) { orderBy = " order by " + orderBy; } var cmd = ds.GetCommand(sqlCmdName); DacHelper.PrepareCommand(cmd, filter); if (!string.IsNullOrEmpty(where)) { if (!where.Trim().ToLower().StartsWith("and")) { cmd.DbCommand.CommandText += " AND " + where; } else { cmd.DbCommand.CommandText += where; } } var oldCmdText = cmd.DbCommand.CommandText; cmd.DbCommand.CommandText = string.Format("select count(1) from ({0}) c_", oldCmdText); object count = cmd.ExecuteScalar(); cmd.DbCommand.CommandText = string.Format("select * from ({0}) list_ where list_.RN>{1} and list_.RN<={2} {3}", oldCmdText, pagesize * (pageindex - 1), pagesize * pageindex, orderBy); var dt = cmd.ExecuteDataTable(); if (hsDDL != null && hsDDL.Count > 0) { cod.ConvertTabDdl(dt, hsDDL); } #endregion 查询结果集 #region 新增"审批类型",“审批岗位描述”两列 //添加"审批类型",“审批岗位描述”两列 dt.Columns.Add("APPROVE_TYPE", typeof(string)); //数据类型为 文本 dt.Columns.Add("POST_NOTE", typeof(string)); //数据类型为 文本 //添加"撤销审批类型",“撤销审批岗位描述”两列 dt.Columns.Add("REVOKE_APPROVE_TYPE", typeof(string)); //数据类型为 文本 dt.Columns.Add("REVOKE_POST_NOTE", typeof(string)); //数据类型为 文本 #endregion 新增"审批类型",“审批岗位描述”两列 #region 给"审批类型",“审批岗位描述”两列赋值 foreach (DataRow row in dt.Rows) { //审批类型 row["APPROVE_TYPE"] = GetApproveType(row["DOC_TYPE"].ToString(), WKF_VLAUES.DECLARE_TYPE_D); //审批岗位描述 row["POST_NOTE"] = GetPostNote(row["DOC_TYPE"].ToString()); //撤销审批类型 row["REVOKE_APPROVE_TYPE"] = GetApproveType(row["DOC_TYPE"].ToString(), WKF_VLAUES.DECLARE_TYPE_R); //撤销审批岗位描述 row["REVOKE_POST_NOTE"] = GetPostNote_Revoke(row["DOC_TYPE"].ToString()); } #endregion 给"审批类型",“审批岗位描述”两列赋值 //return string.Format("{{\"total\":{0},\"rows\":[{1}]}}", count == null ? 0 : Convert.ToInt32(count), Json.DatatableToJson(dt)); return string.Format("{{\"draw\":{0},\"recordsTotal\":{1},\"recordsFiltered\":{2},\"data\":[{3}]}}", draw, count == null ? 0 : Convert.ToInt32(count), dt.Rows.Count, Json.DatatableToJson(dt)); }
public List<PaymentOptionDsSelOrderInfoT> GetPaymentDsSelOrderInfo(string itemNo, long orderNo) { List<PaymentOptionDsSelOrderInfoT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<PaymentOptionDsSelOrderInfoT>( typeof(PaymentOptionDsSelOrderInfoT), GEPMappingCache.GetDataMappings("PaymentOptionDsSelOrderInfoT"), CommandType.StoredProcedure, "dbo.up_gmkt_front_payment_option_info_get", SqlParameterHelper.CreateParameter("@gd_no", itemNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@order_no", orderNo, SqlDbType.BigInt) ); return list; }
public List<PaymentContractInfoT> GetPaymentContractInfo(int packNo, string custNo, int nb2eIid, string buyerNm, string buyerTelno) { List<PaymentContractInfoT> list = new DacHelper(DbHelper, "tiger_read").SelectMultipleEntities<PaymentContractInfoT>( typeof(PaymentContractInfoT), GEPMappingCache.GetDataMappings("PaymentContractInfoT"), CommandType.StoredProcedure, "dbo.up_gmkt_front_my_gd_contract_info", SqlParameterHelper.CreateParameter("@pack_no", packNo, SqlDbType.Int), SqlParameterHelper.CreateParameter("@cust_no", custNo, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@nb2e_iid", nb2eIid, SqlDbType.Int), SqlParameterHelper.CreateParameter("@buyer_nm", buyerNm, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@buyer_telno", buyerTelno, SqlDbType.VarChar) ); return list; }
/// <summary> /// G마켓 상품 필수선택 상세리스트 조회 /// </summary> public List<SourceItemOptionRecordT> GetSourceItemOptionRecord(string gd_no, string info_type) { List<SourceItemOptionRecordT> list = new DacHelper(DbHelper, "item_read").SelectMultipleEntities<SourceItemOptionRecordT>( typeof(SourceItemOptionRecordT), GEPMappingCache.GetDataMappings("SourceItemOptionRecordT"), CommandType.StoredProcedure, "dbo.up_gmkt_ich_get_goods_option", SqlParameterHelper.CreateParameter("@process_flag", "IO", SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@gd_no", gd_no, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@info_type", info_type, SqlDbType.Char) ); return list; }
public List<PaymentItemInfoPolicyT> GetPaymentItemInfoPolicy(string pid, string goodsInfo) { List<PaymentItemInfoPolicyT> list = new DacHelper(DbHelper, "item_read").SelectMultipleEntities<PaymentItemInfoPolicyT>( typeof(PaymentItemInfoPolicyT), GEPMappingCache.GetDataMappings("PaymentItemInfoPolicyT"), CommandType.StoredProcedure, "dbo.up_gmkt_common_payment_item_info_policy", SqlParameterHelper.CreateParameter("@PID", pid, SqlDbType.VarChar), SqlParameterHelper.CreateParameter("@goods_info", goodsInfo, SqlDbType.Xml) ); return list; }