/// <summary>
/// 更新--加密--参数设置
/// </summary>
/// <param name="ess">修改后的参数</param>
/// <returns>返回是否成功</returns>
public static bool EditSetting(IList <EncryptionSetting> ess)
{
bool reState = false;
IList <EncryptionSetting> essOld = GetAllSetting();
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open(); //打开连接
SqlTransaction tran = conn.BeginTransaction(); //开启事务
try
{
foreach (EncryptionSetting es in ess)
{
foreach (EncryptionSetting esOld in essOld)
{
if (es.EncryptionKey == esOld.EncryptionKey && es.EncryptionValue != esOld.EncryptionValue)
{
if (es.EncryptionKey == "--Name--")
{
EncryptionDAL.UpdateName(tran, es.EncryptionValue);
}
else if (es.EncryptionKey == "--Tele--")
{
EncryptionDAL.UpdateTele(tran, es.EncryptionValue);
}
else if (es.EncryptionKey == "--Address--")
{
EncryptionDAL.UpdateAddress(tran, es.EncryptionValue);
}
else if (es.EncryptionKey == "--Card--")
{
EncryptionDAL.UpdateCard(tran, es.EncryptionValue);
}
else if (es.EncryptionKey == "--Number--")
{
EncryptionDAL.UpdateNumber(tran, es.EncryptionValue);
}
}
}
}
tran.Commit();
reState = true;
}
catch (Exception ex)
{
string aa = ex.Message;
tran.Rollback();
}
finally
{
conn.Close();
}
}
return(reState);
}
/// <summary>
/// 获取所有设置
/// </summary>
/// <returns>设置参数值</returns>
public static IList <EncryptionSetting> GetAllSetting()
{
return(EncryptionDAL.SelectAll());
}
