/// <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; }