private void DisplayData(int packNo)
{
BOQv7Das_Net.IDas objDas = null;
try
{
objDas = new BOQv7Das_Net.IDas();
objDas.Open(DAS_HOST);
objDas.CommandType = CommandType.StoredProcedure;
objDas.CodePage = DAS_CODEPAGE;
objDas.AddParam("@pi_intPackNo", DBType.adInteger, packNo, 0, ParameterDirection.Input);
objDas.AddParam("@po_strPname", DBType.adVarWChar, DBNull.Value, 20, ParameterDirection.Output);
objDas.AddParam("@po_intPrice", DBType.adInteger, DBNull.Value, 0, ParameterDirection.Output);
//프로시져 호출
objDas.SetQuery("UP_PACKAGE_DTL_UR_LST"); //Execute Query
string itemList = "";
int totalP = 0;
while (objDas.Read())
{
packImageViewUpd.Src = objDas["PACKIMG"].ToString().Replace("D:\\WEBHOSTING\\ejdo\\User", "http://ejdo.payletter.com");
packNameUpd.Value = objDas.GetParam("@po_strPname");
packCntUpd.Value = objDas["CNT"].ToString();
packPriceUpd.Value = objDas.GetParam("@po_intPrice");
itemList += objDas["itemNo"] + ",";
totalP += Convert.ToInt32(objDas["ITEMPRICE"]);
}
itemListUpd.Value = itemList;
totalPrice.Value = totalP.ToString();
}
catch
{
}
finally
{
//Close
if (objDas != null)
{
objDas.Close();
objDas = null;
}
}
return;
}
///----------------------------------------------------------------------
/// <summary>
/// 회원 정보 보기
/// </summary>
///----------------------------------------------------------------------
private void DisplayData(int userNo)
{
BOQv7Das_Net.IDas objDas = null;
try
{
objDas = new BOQv7Das_Net.IDas();
objDas.Open(DAS_HOST);
objDas.CommandType = CommandType.StoredProcedure;
objDas.CodePage = DAS_CODEPAGE;
objDas.AddParam("@pi_intUserNo", DBType.adInteger, userNo, 0, ParameterDirection.Input);
//프로시져 호출
objDas.SetQuery("dbo.UP_USER_INFO_AR_LST"); //Execute Query
while (objDas.Read())
{
UserID.Value = objDas["UserId"].ToString();
Name.Value = objDas["Name"].ToString();
Birth.Value = objDas["Birth"].ToString();
Sex.Value = objDas["Sex"].ToString();
Phone.Value = objDas["Phone"].ToString();
Email.Value = objDas["Email"].ToString();
postcode.Value = objDas["Postcode"].ToString();
address1.Value = objDas["Address1"].ToString();
address2.Value = objDas["Address2"].ToString();
}
}
catch
{
}
finally
{
//Close
if (objDas != null)
{
objDas.Close();
objDas = null;
}
}
return;
}
///----------------------------------------------------------------------
/// <summary>
/// 게시글 조회
/// </summary>
///----------------------------------------------------------------------
private void getBoardDetail(int boardNo)
{
BOQv7Das_Net.IDas objDas = null;
try
{
objDas = new BOQv7Das_Net.IDas();
objDas.Open(DAS_HOST);
objDas.CommandType = CommandType.StoredProcedure;
objDas.CodePage = DAS_CODEPAGE;
objDas.AddParam("@pi_intBoardNo", DBType.adInteger, boardNo, 0, ParameterDirection.Input);
objDas.AddParam("@po_intRetVal", DBType.adInteger, DBNull.Value, 0, ParameterDirection.Output);
objDas.AddParam("@po_strMsg", DBType.adVarChar, DBNull.Value, 256, ParameterDirection.Output);
//프로시져 호출
objDas.SetQuery("UP_BOARD_DTL_AR_LST"); //Execute Query
while (objDas.Read())
{
titleDetail.Value = objDas["TITLE"].ToString();
userIdDetail.Value = objDas["USERID"].ToString();
regDateDetail.Value = objDas["REGDATE"].ToString();
contentDetail.Value = objDas["CONTENT"].ToString();
userNoDetail.Value = objDas["USERNO"].ToString();
}
}
catch
{
}
finally
{
//Close
if (objDas != null)
{
objDas.Close();
objDas = null;
}
}
return;
}
///----------------------------------------------------------------------
/// <summary>
/// 게시글 조회
/// </summary>
///----------------------------------------------------------------------
private void DisplayData(int boardNo)
{
BOQv7Das_Net.IDas objDas = null;
try
{
objDas = new BOQv7Das_Net.IDas();
objDas.Open(DAS_HOST);
objDas.CommandType = CommandType.StoredProcedure;
objDas.CodePage = DAS_CODEPAGE;
objDas.AddParam("@pi_intBoardNo", DBType.adInteger, boardNo, 0, ParameterDirection.Input);
//프로시져 호출
objDas.SetQuery("UP_BOARD_DTL_AR_LST"); //Execute Query
while (objDas.Read())
{
titleUpd.Value = objDas["Title"].ToString();
contentUpd.Value = objDas["Content"].ToString();
if (objDas["NOTICEYN"].ToString().Equals("Y"))
{
noticeYN.Checked = true;
}
}
}
catch
{
}
finally
{
//Close
if (objDas != null)
{
objDas.Close();
objDas = null;
}
}
return;
}
///----------------------------------------------------------------------
/// <summary>
/// 상품 조회
/// </summary>
///----------------------------------------------------------------------
private void DisplayData(int itemNo)
{
BOQv7Das_Net.IDas objDas = null;
try
{
objDas = new BOQv7Das_Net.IDas();
objDas.Open(DAS_HOST);
objDas.CommandType = CommandType.StoredProcedure;
objDas.CodePage = DAS_CODEPAGE;
objDas.AddParam("@pi_intitemNo", DBType.adInteger, itemNo, 0, ParameterDirection.Input);
//프로시져 호출
objDas.SetQuery("UP_ITEM_DTL_AR_LST"); //Execute Query
while (objDas.Read())
{
itemImageViewUpd.Src = objDas["ITEMIMG"].ToString().Replace("D:\\WEBHOSTING\\ejdo\\User", "http://ejdo.payletter.com");
itemNameUpd.Text = objDas["ITEMNAME"].ToString();
itemPriceUpd.Text = objDas["PRICE"].ToString();
itemDetailUpd.InnerText = objDas["DETAIL"].ToString();
}
}
catch
{
}
finally
{
//Close
if (objDas != null)
{
objDas.Close();
objDas = null;
}
}
return;
}