| | |
|---|
| | | GwOrder o = new GwOrder(); |
|---|
| | | if (string.IsNullOrEmpty(orderId)) |
|---|
| | | return o; |
|---|
| | | using (OracleDataReader reader = OracleHelper.ExecuteReader(string.Format("select * from GW_ORDER where ORDER_ID=:ORDER_ID"), OracleHelper.Connection, new OracleParameter(":ORDER_ID", (object)orderId))) |
|---|
| | | using (OracleDataReader reader = OracleHelper.ExecuteReader(string.Format("select gwo.*, gc.COMPANY, gp.name PRODUCT_NAME from gw_order gwo left join gw_client gc on gc.client_id = gwo.client_id left join gw_product gp on gp.id = gwo.product_id where gwo.ORDER_ID=:ORDER_ID"), OracleHelper.Connection, new OracleParameter(":ORDER_ID", (object)orderId))) |
|---|
| | | { |
|---|
| | | if (((DbDataReader)reader).Read()) |
|---|
| | | { |
|---|
| | |
|---|
| | | o.Company = oracleReaderWrapper.GetString("COMPANY", ""); |
|---|
| | | o.ClientName = oracleReaderWrapper.GetString("CLIENT_NAME", ""); |
|---|
| | | o.ProductId = oracleReaderWrapper.GetString("PRODUCT_ID", ""); |
|---|
| | | o.ProductName = oracleReaderWrapper.GetString("PRODUCT_NAME", ""); |
|---|
| | | o.ComboId = oracleReaderWrapper.GetString("COMBO_ID", ""); |
|---|
| | | o.BasicNum = oracleReaderWrapper.GetInt("BASIC_NUM", 0); |
|---|
| | | o.GivingNum = oracleReaderWrapper.GetInt("GIVING_NUM", 0); |
|---|
