private bool SetData(STRowRcpData item, out string msg, OracleConnection connection) { if (connection is null) { throw new ArgumentNullException(nameof(connection)); } msg = null; try { string query = "INSERT INTO Rcd.VALID_RCPDATA (SHIFTDATE, SALESUM, EMTCODEFRM, AZSCODE, DOCNUMBER, POSNUMBER, DOCDATE, OPERCODE, REALDOSE, PRICE, CURRCODE, EMTCODETO, VSTYPE, " + "VSCODE, WTCASHTYPE, DESCRIPT, CARDBANK, RRN, S_DIIS, NAMEPRODUCT) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20)"; OracleCommand command = new OracleCommand(query, connection); command.Parameters.Add(crp(OracleType.DateTime, item.SHIFTDATE, "1", false)); command.Parameters.Add(crp(OracleType.Number, item.SALESUM, "2", false)); command.Parameters.Add(crp(OracleType.Int32, item.EMTCODEFRM, "3", false)); command.Parameters.Add(crp(OracleType.Int32, item.AZSCODE, "4", false)); command.Parameters.Add(crp(OracleType.Int32, item.DOCNUMBER, "5", false)); command.Parameters.Add(crp(OracleType.Int32, item.POSNUMBER, "6", false)); command.Parameters.Add(crp(OracleType.DateTime, item.DOCDATE, "7", false)); command.Parameters.Add(crp(OracleType.Int32, item.OPERCODE, "8", false)); command.Parameters.Add(crp(OracleType.Number, item.REALDOSE, "9", false)); command.Parameters.Add(crp(OracleType.Number, item.PRICE, "10", false)); command.Parameters.Add(crp(OracleType.Int32, item.CURRCODE, "11", false)); command.Parameters.Add(crp(OracleType.Int32, item.EMTCODETO, "12", false)); command.Parameters.Add(crp(OracleType.Int32, item.VSTYPE, "13", false)); command.Parameters.Add(crp(OracleType.Int32, item.VSCODE, "14", false)); command.Parameters.Add(crp(OracleType.Int32, item.WTCASHTYPE, "15", false)); command.Parameters.Add(crp(OracleType.Char, item.DESCRIPT, "16", false)); command.Parameters.Add(crp(OracleType.Char, item.CARDBANK, "17", false)); command.Parameters.Add(crp(OracleType.Char, item.RRN, "18", false)); command.Parameters.Add(crp(OracleType.Number, item.S_DIIS, "19", false)); command.Parameters.Add(crp(OracleType.Char, item.NAMEPRODUCT, "20", false)); command.ExecuteNonQuery(); } catch (Exception ex) { msg = ex.Message; return(false); } return(true); }
private bool read(SqlDataReader reader, out STRowRcpData data, out string msg) { bool ret = true; data = new STRowRcpData(); msg = null; try { if (!reader.IsDBNull(0)) { data.SHIFTDATE = reader.GetDateTime(0); } if (!reader.IsDBNull(1)) { data.SALESUM = reader.GetDouble(1); } if (!reader.IsDBNull(2)) { data.EMTCODEFRM = reader.GetInt32(2); } if (!reader.IsDBNull(3)) { data.AZSCODE = reader.GetInt32(3); } if (!reader.IsDBNull(4)) { data.DOCNUMBER = reader.GetInt32(4); } if (!reader.IsDBNull(5)) { data.POSNUMBER = reader.GetInt32(5); } if (!reader.IsDBNull(6)) { data.DOCDATE = reader.GetDateTime(6); } if (!reader.IsDBNull(7)) { data.OPERCODE = reader.GetInt32(7); } if (!reader.IsDBNull(8)) { data.REALDOSE = reader.GetDouble(8); } if (!reader.IsDBNull(9)) { data.PRICE = reader.GetDouble(9); } if (!reader.IsDBNull(10)) { data.CURRCODE = reader.GetInt32(10); } if (!reader.IsDBNull(11)) { data.EMTCODETO = reader.GetInt32(11); } if (!reader.IsDBNull(12)) { data.VSTYPE = reader.GetInt32(12); } if (!reader.IsDBNull(13)) { data.VSCODE = reader.GetInt32(13); } if (!reader.IsDBNull(14)) { data.WTCASHTYPE = reader.GetInt32(14); } if (!reader.IsDBNull(15)) { data.DESCRIPT = reader.GetString(15); } if (!reader.IsDBNull(16)) { data.CARDBANK = reader.GetString(16); } if (!reader.IsDBNull(17)) { data.RRN = reader.GetString(17); } if (!reader.IsDBNull(18)) { data.S_DIIS = reader.GetDouble(18); } if (!reader.IsDBNull(19)) { data.NAMEPRODUCT = reader.GetString(19); } } catch (Exception ex) { log.LogLine("CBookOwner.read() " + ex.Message); msg = ex.Message; ret = false; } return(ret); }