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