/// <summary>
/// 删除原因代码和类型的关联。
/// </summary>
/// <param name="dsParams">包含原因代码和类型关联的数据集对象。</param>
/// <returns>包含执行结果的数据集对象。</returns>
public DataSet DeleteReasonCategory(DataSet dsParams)
{
//get dynamic dataset constructor
DataSet dataDs = new DataSet();
try
{
if (dsParams.Tables.Contains(FMM_REASON_R_CATEGORY_FIELDS.DATABASE_TABLE_NAME))
{
DataTable dataTable = dsParams.Tables[FMM_REASON_R_CATEGORY_FIELDS.DATABASE_TABLE_NAME];
FMM_REASON_R_CATEGORY_FIELDS categoryTable = new FMM_REASON_R_CATEGORY_FIELDS();
using (DbConnection dbConn = db.CreateConnection())
{
//Open Connection
dbConn.Open();
//Create Transaction
DbTransaction dbTran = dbConn.BeginTransaction();
try
{
foreach (DataRow row in dataTable.Rows)
{
string categoryKey = Convert.ToString(row[FMM_REASON_R_CATEGORY_FIELDS.FIELD_CATEGORY_KEY]);
string codeKey = Convert.ToString(row[FMM_REASON_R_CATEGORY_FIELDS.FIELD_REASON_CODE_KEY]);
string sqlCommand = string.Format(@"DELETE FROM FMM_REASON_R_CATEGORY
WHERE CATEGORY_KEY = '{0}'
AND REASON_CODE_KEY = '{1}'",
categoryKey.PreventSQLInjection(),
codeKey.PreventSQLInjection());
db.ExecuteNonQuery(dbTran, CommandType.Text, sqlCommand);
}
//Commit Transaction
dbTran.Commit();
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dataDs, "");
}
catch (Exception ex)
{
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dataDs, ex.Message);
//Rollback Transaction
dbTran.Rollback();
LogService.LogError("DeleteReasonCategory Error: " + ex.Message);
}
finally
{
dbTran = null;
//Close Connection
dbConn.Close();
}
}
}
}
catch (Exception ex)
{
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dataDs, ex.Message);
LogService.LogError("DeleteReasonCategory Error: " + ex.Message);
}
return(dataDs);
}
/// <summary>
/// 添加原因代码和类型的关联。
/// </summary>
/// <param name="dsParams">包含原因代码和类型关联的数据集对象。</param>
/// <returns>包含执行结果的数据集对象。</returns>
public DataSet AddReasonCategory(DataSet dsParams)
{
DataSet dsReturn = new DataSet();
try
{
if (dsParams.Tables.Contains(FMM_REASON_R_CATEGORY_FIELDS.DATABASE_TABLE_NAME))
{
DataTable dataTable = dsParams.Tables[FMM_REASON_R_CATEGORY_FIELDS.DATABASE_TABLE_NAME];
FMM_REASON_R_CATEGORY_FIELDS categoryTable = new FMM_REASON_R_CATEGORY_FIELDS();
using (DbConnection dbConn = db.CreateConnection())
{
//Open Connection
dbConn.Open();
//Create Transaction
DbTransaction dbTran = dbConn.BeginTransaction();
try
{
foreach (DataRow row in dataTable.Rows)
{
Hashtable fields = new Hashtable()
{
{ FMM_REASON_R_CATEGORY_FIELDS.FIELD_CATEGORY_KEY,
row[FMM_REASON_R_CATEGORY_FIELDS.FIELD_CATEGORY_KEY] },
{ FMM_REASON_R_CATEGORY_FIELDS.FIELD_REASON_CODE_KEY,
row[FMM_REASON_R_CATEGORY_FIELDS.FIELD_REASON_CODE_KEY] }
};
string sqlCommand = DatabaseTable.BuildInsertSqlStatement(categoryTable, fields, null);
db.ExecuteNonQuery(dbTran, CommandType.Text, sqlCommand);
}
//Commit Transaction
dbTran.Commit();
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, "");
}
catch (Exception ex)
{
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message);
//Rollback Transaction
dbTran.Rollback();
LogService.LogError("AddReasonCategory Error: " + ex.Message);
}
finally
{
dbTran = null;
//Close Connection
dbConn.Close();
}
}
}
}
catch (Exception ex)
{
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message);
LogService.LogError("AddReasonCategory Error: " + ex.Message);
}
return(dsReturn);
}
