/// <summary>
/// 更新币种信息操作
/// </summary>
/// <param name="Model"></param>
/// <returns>true 更新成功 : false 更新失败</returns>
public static bool UpdateCurrTypeSetting(CurrencyTypeSettingModel Model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Update Officedba.CurrencyTypeSetting set CompanyCD=@CompanyCD, ");
sql.AppendLine("CurrencyName=@CurrencyName,CurrencySymbol=@CurrencySymbol,isMaster=@isMaster,ExchangeRate=@ExchangeRate,ConvertWay=@ConvertWay,");
sql.AppendLine("ChangeTime=@ChangeTime,UsedStatus=@UsedStatus,EndRate=@EndRate where CompanyCD=@CompanyCD and ID=@ID ");
SqlParameter[] parms = new SqlParameter[10];
parms[0] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD);
parms[1] = SqlHelper.GetParameter("@CurrencyName", Model.CurrencyName);
parms[2] = SqlHelper.GetParameter("@CurrencySymbol", Model.CurrencySymbol);
parms[3] = SqlHelper.GetParameter("@isMaster", Model.isMaster);
parms[4] = SqlHelper.GetParameter("@ExchangeRate", Model.ExchangeRate);
parms[5] = SqlHelper.GetParameter("@ConvertWay", Model.ConvertWay);
parms[6] = SqlHelper.GetParameter("@ChangeTime", Model.ChangeTime);
parms[7] = SqlHelper.GetParameter("@UsedStatus", Model.UsedStatus);
parms[8] = SqlHelper.GetParameter("@ID", Model.ID);
parms[9] = SqlHelper.GetParameter("@EndRate", Model.ExchangeRate);
SqlHelper.ExecuteTransSql(sql.ToString(), parms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
/// <summary>
/// 更新币种信息
/// </summary>
/// <param name="Model"></param>
/// <returns></returns>
public static bool UpdateCurrTypeSetting(CurrencyTypeSettingModel Model)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
if (Model == null) return false;
if (Model.CompanyCD == null) Model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
bool succ = false;
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
LogInfoModel logModel = InitLogInfo(Model.ID.ToString());
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = CurrTypeSettingDBHelper.UpdateCurrTypeSetting(Model);
if (!succ)
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
else
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
LogDBHelper.InsertLog(logModel);
return succ;
}
catch (Exception ex)
{
WriteSystemLog(userInfo, ex);
throw ex;
}
}
/// <summary>
/// 插入币种类别信息
/// </summary>
/// <param name="Model"></param>
/// <returns>true 添加成功 : false 添加失败</returns>
public static bool InSertCurrTypeSetting(CurrencyTypeSettingModel Model)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("Insert into Officedba.CurrencyTypeSetting ( CompanyCD,CurrencyName, ");
sql.AppendLine("CurrencySymbol,isMaster,ExchangeRate,ConvertWay,ChangeTime,UsedStatus,EndRate )");
sql.AppendLine("Values(@CompanyCD,@CurrencyName,@CurrencySymbol,");
sql.AppendLine("@isMaster,@ExchangeRate,@ConvertWay,@ChangeTime,@UsedStatus,@EndRate )");
SqlParameter[] parms = new SqlParameter[9];
parms[0] = SqlHelper.GetParameter("@CompanyCD", Model.CompanyCD);
parms[1] = SqlHelper.GetParameter("@CurrencyName", Model.CurrencyName);
parms[2] = SqlHelper.GetParameter("@CurrencySymbol", Model.CurrencySymbol);
parms[3] = SqlHelper.GetParameter("@isMaster", Model.isMaster);
parms[4] = SqlHelper.GetParameter("@ExchangeRate", Model.ExchangeRate);
parms[5] = SqlHelper.GetParameter("@ConvertWay", Model.ConvertWay);
parms[6] = SqlHelper.GetParameter("@ChangeTime", Model.ChangeTime);
parms[7] = SqlHelper.GetParameter("@UsedStatus", Model.UsedStatus);
parms[8] = SqlHelper.GetParameter("@EndRate", Model.ExchangeRate);
SqlHelper.ExecuteTransSql(sql.ToString(), parms);
return SqlHelper.Result.OprateCount > 0 ? true : false;
}
