/// <summary>
/// 获得衰减数据
/// </summary>
/// <returns></returns>
public DataSet GetDecayCoeffiData()
{
DataSet dsReturn = new DataSet();
string sqlCommand = string.Empty;
try
{
BASE_DECAYCOEFFI _decayCoeffi = new BASE_DECAYCOEFFI();
Conditions _conditions = new Conditions();
_conditions.Add(DatabaseLogicOperator.And, BASE_DECAYCOEFFI.FIELDS_ISFLAG, DatabaseCompareOperator.Equal, "1");
sqlCommand = DatabaseTable.BuildQuerySqlStatement(_decayCoeffi, null, _conditions);
DataTable dtDecayCoeffi = db.ExecuteDataSet(CommandType.Text, sqlCommand).Tables[0];
dtDecayCoeffi.TableName = BASE_DECAYCOEFFI.DATABASE_TABLE_NAME;
dtDecayCoeffi.Columns.Add(BASE_DECAYCOEFFI.FIELDS_ISNEW);
dsReturn.Merge(dtDecayCoeffi, true, MissingSchemaAction.Add);
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, "");
}
catch (Exception ex)
{
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message);
LogService.LogError("GetDecayCoeffiData Error: " + ex.Message);
}
return(dsReturn);
}
public DataSet IsExistDecayCoeffiData(DataTable dtInsertDecayCoeffi)
{
DataSet dsReturn = new DataSet();
string sqlCommand = string.Empty;
try
{
BASE_DECAYCOEFFI _decayCoeffi = new BASE_DECAYCOEFFI();
foreach (DataRow dr in dtInsertDecayCoeffi.Rows)
{
Conditions _conditions = new Conditions();
_conditions.Add(DatabaseLogicOperator.And, BASE_DECAYCOEFFI.FIELDS_D_CODE, DatabaseCompareOperator.Equal, dr[BASE_DECAYCOEFFI.FIELDS_D_CODE].ToString());
_conditions.Add(DatabaseLogicOperator.And, BASE_DECAYCOEFFI.FIELDS_D_NAME, DatabaseCompareOperator.Equal, dr[BASE_DECAYCOEFFI.FIELDS_D_NAME].ToString());
_conditions.Add(DatabaseLogicOperator.And, BASE_DECAYCOEFFI.FIELDS_ISFLAG, DatabaseCompareOperator.Equal, "1");
sqlCommand = DatabaseTable.BuildQuerySqlStatement(_decayCoeffi, null, _conditions);
DataTable dtProModel = db.ExecuteDataSet(CommandType.Text, sqlCommand).Tables[0];
if (dtProModel.Rows.Count > 0)
{
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Format("衰减代码{0},不能重复!", dr[BASE_DECAYCOEFFI.FIELDS_D_CODE].ToString()));
break;
}
}
}
catch (Exception ex)
{
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message);
LogService.LogError("IsExistDecayCoeffiData Error: " + ex.Message);
}
return(dsReturn);
}
/// <summary>
/// 修改衰减数据
/// </summary>
/// <param name="dsProModel"></param>
/// <returns></returns>
public DataSet SaveDecayCoeffiData(DataSet dsDecayCoeffi)
{
DataSet dsReturn = new DataSet();
DataTable dtDecayCoeffi_Update = null, dtDecayCoeffi_Insert = null;
List <string> sqlCommandList = new List <string>();
if (dsDecayCoeffi.Tables.Contains(BASE_DECAYCOEFFI.DATABASE_TABLE_FORINSERT))
{
dtDecayCoeffi_Insert = dsDecayCoeffi.Tables[BASE_DECAYCOEFFI.DATABASE_TABLE_FORINSERT];
dtDecayCoeffi_Insert.Columns.Remove(BASE_DECAYCOEFFI.FIELDS_ISNEW);
}
if (dsDecayCoeffi.Tables.Contains(BASE_DECAYCOEFFI.DATABASE_TABLE_FORUPDATE))
{
dtDecayCoeffi_Update = dsDecayCoeffi.Tables[BASE_DECAYCOEFFI.DATABASE_TABLE_FORUPDATE];
dtDecayCoeffi_Update.Columns.Remove(BASE_DECAYCOEFFI.FIELDS_ISNEW);
}
using (DbConnection dbConn = db.CreateConnection())
{
//Open Connection
dbConn.Open();
//Create Transaction
DbTransaction dbTran = dbConn.BeginTransaction();
string sqlCommand = string.Empty;
BASE_DECAYCOEFFI decayCoeffi = new BASE_DECAYCOEFFI();
try
{
if (dtDecayCoeffi_Insert != null && dtDecayCoeffi_Insert.Rows.Count > 0)
{
foreach (DataRow dr in dtDecayCoeffi_Insert.Rows)
{
Hashtable hashTable = FanHai.Hemera.Share.Common.CommonUtils.ConvertRowToHashtable(dr);
sqlCommand = DatabaseTable.BuildInsertSqlStatement(decayCoeffi, hashTable, null);
db.ExecuteNonQuery(dbTran, CommandType.Text, sqlCommand);
}
}
if (dtDecayCoeffi_Update != null && dtDecayCoeffi_Update.Rows.Count > 0)
{
foreach (DataRow dr in dtDecayCoeffi_Update.Rows)
{
Hashtable hashTable = FanHai.Hemera.Share.Common.CommonUtils.ConvertRowToHashtable(dr);
WhereConditions wc = new WhereConditions(BASE_DECAYCOEFFI.FIELDS_DECOEFFI_KEY, hashTable[BASE_DECAYCOEFFI.FIELDS_DECOEFFI_KEY].ToString());
hashTable.Remove(BASE_DECAYCOEFFI.FIELDS_DECOEFFI_KEY);
sqlCommand = DatabaseTable.BuildUpdateSqlStatement(decayCoeffi, hashTable, wc);
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("SaveSpcControlPlan Error: " + ex.Message);
}
finally
{
//Close Connection
dbConn.Close();
}
}
return(dsReturn);
}
