public ChargeResultResponse ChargeResult(ChargeResultParams parameters) { ChargeResultResponse response = new ChargeResultResponse(); response.Lsh = parameters.Lsh; try { repository.SaveCharge(parameters); response.RspNo = "000000"; response.RspMsg = "success"; } catch (Exception ex) { log.Error("Got error when save charge: ", ex); response.RspNo = "111111"; response.RspMsg = ex.Message; } return(response); }
public void SaveCharge(ChargeResultParams result) { string queryString = "insert into db.jiao_fei(lsh, xmmc, xmsjje) values (@lsh, @xmmc, @je)"; using (SqlConnection connection = DbUtils.GetConnection()) { connection.Open(); var transaction = connection.BeginTransaction(); var lsh = result.Lsh; SqlCommand command = new SqlCommand(queryString, connection); command.Transaction = transaction; command.Parameters.AddWithValue("@lsh", lsh); try { foreach (var sfqj in result.SfqjList) { foreach (var item in sfqj.MxData) { var xmmc = item.Xmmc; var je = item.Xmsjje; // Create the Command and Parameter objects. command.Parameters.AddWithValue("@xmmc", xmmc); command.Parameters.AddWithValue("@je", je); command.ExecuteNonQuery(); } } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } finally { connection.Close(); } } }