private static void Valid(ExchangeRateEntity exchangeRateEntity)
{
if (ExchangeRateDA.GetExistsByNameDiffPKID(exchangeRateEntity.Name, exchangeRateEntity.ActiveDate, exchangeRateEntity.PKID))
{
throw new Exception("货币名称和日期重复");
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
if (!Valid())
{
mpeInfo.Show();
return;
}
try
{
ExchangeRateEntity entity = new ExchangeRateEntity
{
Name = txtDialogName.Text.Trim(),
Rate = Convert.ToDecimal(txtDialogRate.Text),
PKID = hfPKID.Value.SafeToInt(),
ActiveDate = txtDialogActiveDate.Text.SafeToDateTime().GetValueOrDefault(),
Symbol = txtDialogSymbol.Text.Trim()
};
if (entity.PKID > 0)
{
ExchangeRateLogic.UpdateExchangeRate(entity);
}
else
{
ExchangeRateLogic.InsertExchangeRate(entity);
}
mpeInfo.Hide();
BindDataSource();
}
catch (Exception ex)
{
DialogMessage = "<span class='fontred'>" + ex.Message + "</span>";
mpeInfo.Show();
}
}
public string DeleteExchangeRate(ExchangeRateEntity exchangeRate)
{
const string sql = @"uspDelete_ExchangeRate";
object[] parms = { "@ExchangeRateId", exchangeRate.ExchangeRateId };
return(Db.Delete(sql, true, parms));
}
public static void InsertExchangeRate(ExchangeRateEntity exchangeRateEntity)
{
using (DataOperator dataOperator = new DataOperator(SqlHelper.HrmisConnectionString))
{
dataOperator.CommandText =
@"
INSERT INTO [dbo].[TExchangeRate](
[Name],
[Rate],
[Symbol],
[ActiveDate]
) VALUES(
@Name,
@Rate,
@Symbol,
@ActiveDate)
SELECT @@IDENTITY
";
dataOperator.SetParameter("@Name", exchangeRateEntity.Name, SqlDbType.NVarChar, 200);
dataOperator.SetParameter("@Rate", exchangeRateEntity.Rate, SqlDbType.Decimal, 12, 4);
dataOperator.SetParameter("@ActiveDate", exchangeRateEntity.ActiveDate, SqlDbType.SmallDateTime);
dataOperator.SetParameter("@Symbol", exchangeRateEntity.Symbol, SqlDbType.NVarChar, 5);
object obj = dataOperator.ExecuteScalar();
int returnValue;
int.TryParse(obj.ToString(), out returnValue);
exchangeRateEntity.PKID = returnValue;
}
}
public static List <IExchangeRate> GetExchangeRate(SearchCriteria searchCriteria)
{
string strExecution = "[chg].[uspGetExchangeRate]";
List <IExchangeRate> lstChg = new List <IExchangeRate>();
using (DbQuery oDq = new DbQuery(strExecution))
{
if (searchCriteria.Date.HasValue)
{
oDq.AddDateTimeParam("@SchExchangeDate", searchCriteria.Date.Value);
}
oDq.AddVarcharParam("@SortExpression", 50, searchCriteria.SortExpression);
oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
IExchangeRate chg = new ExchangeRateEntity(reader);
lstChg.Add(chg);
}
reader.Close();
}
return(lstChg);
}
private static object[] Take(ExchangeRateEntity exchangeRate)
{
return(new object[]
{
"@ExchangeRateID", exchangeRate.ExchangeRateId,
"@FromDate", exchangeRate.FromDate,
"@ToDate", exchangeRate.ToDate,
"@BudgetSourceCode", exchangeRate.BudgetSourceCode,
"@ExchangeRate", exchangeRate.ExchangeRate,
"@Description", exchangeRate.Description,
"@Inactive", exchangeRate.Inactive
});
}
private void SaveExchangeRate()
{
ChargeBLL chargeBll = new ChargeBLL();
IExchangeRate exchRate = new ExchangeRateEntity();
string message = string.Empty;
BuildExchangeRateEntity(exchRate);
message = chargeBll.SaveExchangeRate(exchRate, _userId);
if (message == string.Empty)
{
Response.Redirect("~/View/ManageExchRate.aspx");
}
else
{
GeneralFunctions.RegisterAlertScript(this, message);
}
}
public static ExchangeRateEntity GetExchangeRateByPKID(int pKID)
{
using (DataOperator dataOperator = new DataOperator(SqlHelper.HrmisConnectionString))
{
dataOperator.CommandText =
@"
SELECT
*
FROM [dbo].[TExchangeRate] WITH(NOLOCK)
WHERE
[PKID]=@PKID
";
dataOperator.SetParameter("@PKID", pKID, SqlDbType.Int);
ExchangeRateEntity exchangeRateEntity = dataOperator.ExecuteEntity <ExchangeRateEntity>();
return(exchangeRateEntity);
}
}
public static IExchangeRate GetExchangeRate(int exchangeRateID, SearchCriteria searchCriteria)
{
string strExecution = "[chg].[uspGetExchangeRate]";
IExchangeRate chg = null;
using (DbQuery oDq = new DbQuery(strExecution))
{
oDq.AddIntegerParam("@ExchangeRateID", exchangeRateID);
oDq.AddVarcharParam("@SortExpression", 50, searchCriteria.SortExpression);
oDq.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection);
DataTableReader reader = oDq.GetTableReader();
while (reader.Read())
{
chg = new ExchangeRateEntity(reader);
}
reader.Close();
}
return(chg);
}
public static void UpdateExchangeRate(ExchangeRateEntity exchangeRateEntity)
{
using (DataOperator dataOperator = new DataOperator(SqlHelper.HrmisConnectionString))
{
dataOperator.CommandText =
@"
UPDATE [dbo].[TExchangeRate] SET
[Name]=@Name,
[Rate]=@Rate,
[ActiveDate]=@ActiveDate,
[Symbol]=@Symbol
WHERE
[PKID]=@PKID
";
dataOperator.SetParameter("@PKID", exchangeRateEntity.PKID, SqlDbType.Int);
dataOperator.SetParameter("@Name", exchangeRateEntity.Name, SqlDbType.NVarChar, 200);
dataOperator.SetParameter("@Rate", exchangeRateEntity.Rate, SqlDbType.Decimal, 12, 4);
dataOperator.SetParameter("@ActiveDate", exchangeRateEntity.ActiveDate, SqlDbType.SmallDateTime);
dataOperator.SetParameter("@Symbol", exchangeRateEntity.Symbol, SqlDbType.NVarChar, 5);
dataOperator.ExecuteNonQuery();
}
}
public static void UpdateExchangeRate(ExchangeRateEntity exchangeRateEntity)
{
Valid(exchangeRateEntity);
ExchangeRateDA.UpdateExchangeRate(exchangeRateEntity);
}
public static void InsertExchangeRate(ExchangeRateEntity exchangeRateEntity)
{
Valid(exchangeRateEntity);
ExchangeRateDA.InsertExchangeRate(exchangeRateEntity);
}
public string UpdateExchangeRate(ExchangeRateEntity exchangeRate)
{
const string sql = @"uspUpdate_ExchangeRate";
return(Db.Update(sql, true, Take(exchangeRate)));
}
public int InsertExchangeRate(ExchangeRateEntity exchangeRate)
{
const string sql = @"uspInsert_ExchangeRate";
return(Db.Insert(sql, true, Take(exchangeRate)));
}
