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