public orderObj update(orderObj _data)
{
#region QuerySQL
String _stQuery = String.Format
(@"
UPDATE systemOrder
SET USER_ID = @userId
,PRODUCT_ID = @productId
WHERE ORDER_ID = @orderId
");
#endregion QuerySQL
gmjDatabase dbQuery = new gmjDatabase();
dbQuery.CommandText = _stQuery;
dbQuery.CommandType = CommandType.Text;
dbQuery.CommandTimeout = 240000;
dbQuery.CreateParameter("orderId", _data.orderId);
dbQuery.CreateParameter("userId", _data.userId);
dbQuery.CreateParameter("productId", _data.productId);
dbQuery.ExecuteCommand();
return(_data);
}
public orderObj insert(orderObj _data)
{
#region QuerySQL
String _stQuery = String.Format
(@"
INSERT
INTO systemOrder
(
USER_ID
,PRODUCT_ID
,ORDER_DATE
)
VALUES
(
@userId
,@productId
,GETDATE()
)
");
#endregion QuerySQL
gmjDatabase dbQuery = new gmjDatabase();
dbQuery.CommandText = _stQuery;
dbQuery.CommandType = CommandType.Text;
dbQuery.CommandTimeout = 240000;
dbQuery.CreateParameter("userId", _data.userId);
dbQuery.CreateParameter("productId", _data.productId);
dbQuery.ExecuteCommand();
return(_data);
}
public List <orderListObj> selectAll(orderObj _data)
{
#region QuerySQL
String _stQuery = String.Format
(@"
SELECT B.PRODUCT_NAME
,B.PRODUCT_DATE
,A.ORDER_DATE
FROM systemOrder A WITH(NOLOCK)
JOIN systemProduct B WITH(NOLOCK) ON B.PRODUCT_ID = A.PRODUCT_ID
WHERE A.USER_ID = @userId
");
#endregion QuerySQL
gmjDatabase dbQuery = new gmjDatabase();
dbQuery.CommandText = _stQuery;
dbQuery.CommandType = CommandType.Text;
dbQuery.CommandTimeout = 240000;
dbQuery.CreateParameter("userId", _data.userId);
IDataReader iReader = dbQuery.ExecuteDataReader(CommandBehavior.CloseConnection);
List <orderListObj> _dataList = new List <orderListObj>();
while (iReader.Read())
{
_dataList.Add
(
new orderListObj()
{
productName = Convert.ToString(iReader["PRODUCT_NAME"])
, productDate = Convert.ToDateTime(iReader["PRODUCT_DATE"])
, orderDate = Convert.ToDateTime(iReader["ORDER_DATE"])
}
);
}
iReader.Close();
return(_dataList);
}
