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