public PaymentPostData GeneratePostDataFor(OrderPaymentRequest orderRequest) { PaymentPostData paymentPostData = new PaymentPostData(); NameValueCollection postDataAndValue = new NameValueCollection(); paymentPostData.PostDataAndValue = postDataAndValue; // When a real PayPal account is used, the form should be sent to https://www.paypal.com/cgi-bin/webscr. // For testing use "https://www.sandbox.paypal.com/cgi-bin/webscr" paymentPostData.PaymentPostToUrl = ApplicationSettingsFactory.GetApplicationSettings().PayPalPaymentPostToUrl; // For shopping cart purchases. postDataAndValue.Add("cmd", "_cart"); // Indicates the use of third party shopping cart. postDataAndValue.Add("upload", "1"); // This is the sellers email address. You must supply your own address here!!! postDataAndValue.Add("business", ApplicationSettingsFactory.GetApplicationSettings().PayPalBusinessEmail); // This field does not take part in the shopping process. // It simply will be passed to the IPN script at the time of transaction confirmation. postDataAndValue.Add("custom", orderRequest.Id.ToString()); // This parameter represents a currency code. postDataAndValue.Add("currency_code", "GBP"); postDataAndValue.Add("first_name", orderRequest.CustomerFirstName); postDataAndValue.Add("last_name", orderRequest.CustomerSecondName); postDataAndValue.Add("address1", orderRequest.DeliveryAddressAddressLine1); postDataAndValue.Add("address2", orderRequest.DeliveryAddressAddressLine2); postDataAndValue.Add("city", orderRequest.DeliveryAddressCity); postDataAndValue.Add("state", orderRequest.DeliveryAddressState); postDataAndValue.Add("country", orderRequest.DeliveryAddressCountry); postDataAndValue.Add("zip", orderRequest.DeliveryAddressZipCode); // This parameter determines whether the delivery address should be requested. // "1" means that the address will be requested; "0" means that it will be not. //postDataAndValue.Add("no_shipping", "0"); // This is the URL where the user will be redirected after the payment is successfully performed. // If this parameter is not passed, the buyer remains on the PayPal site. postDataAndValue.Add("return", Helpers.UrlHelper.Resolve("/Payment/PaymentComplete")); // This is the URL where the user will be redirected when he cancels the payment. // If the parameter is not passed, the buyer remains on the PayPal site. postDataAndValue.Add("cancel_return", Helpers.UrlHelper.Resolve("/Payment/PaymentCancel")); // This is the URL where PayPal will pass information about the transaction (IPN). // If the parameter is not passed, the value from the account settings will be used. // If this value is not defined in the account settings, IPN will not be used. postDataAndValue.Add("notify_url", Helpers.UrlHelper.Resolve("/Payment/PaymentCallBack")); int itemIndex = 1; foreach (OrderItemPaymentRequest item in orderRequest.Items) { postDataAndValue.Add("item_name_" + itemIndex.ToString(), item.ProductName); postDataAndValue.Add("amount_" + itemIndex.ToString(), item.Price.ToString()); postDataAndValue.Add("item_number_" + itemIndex.ToString(), item.Id.ToString()); postDataAndValue.Add("quantity_" + itemIndex.ToString(), item.Quantity.ToString()); itemIndex++; } postDataAndValue.Add("shipping", orderRequest.ShippingCharge.ToString()); return(paymentPostData); }
public Log4NetAdapter() { XmlConfigurator.Configure(); _log = LogManager .GetLogger(ApplicationSettingsFactory.GetApplicationSettings().LoggerName); }
public TimeAttendanceRepository() { base.ServiceURL = ApplicationSettingsFactory.GetApplicationSettings().BaseURL + serviceName; ChildGetLookup.Add(typeof(DayType), "getDT"); ChildGetLookup.Add(typeof(AttendanceSchedule), "getSC"); ChildGetLookup.Add(typeof(AttendanceScheduleDay), "getSD"); ChildGetLookup.Add(typeof(WorkingCalendar), "getCA"); ChildGetLookup.Add(typeof(CalendarYear), "getCY"); ChildGetLookup.Add(typeof(CalendarDay), "getCD"); ChildGetLookup.Add(typeof(BiometricDevice), "getBM"); ChildGetLookup.Add(typeof(Router), "getRO"); ChildGetLookup.Add(typeof(Geofence), "getGF"); ChildGetLookup.Add(typeof(Time), "getTA"); ChildGetLookup.Add(typeof(DashBoardTimeVariation), "getTV"); ChildGetLookup.Add(typeof(MonthlyLatenessPeriod), "getMLP"); ChildGetAllLookup.Add(typeof(DayType), "qryDT"); ChildGetAllLookup.Add(typeof(AttendanceSchedule), "qrySC"); ChildGetAllLookup.Add(typeof(AttendanceScheduleDay), "qrySD"); ChildGetAllLookup.Add(typeof(AttendanceBreak), "qrySB"); ChildGetAllLookup.Add(typeof(WorkingCalendar), "qryCA"); ChildGetAllLookup.Add(typeof(CalendarYear), "qryCY"); ChildGetAllLookup.Add(typeof(CalendarDay), "qryCD"); ChildGetAllLookup.Add(typeof(BiometricDevice), "qryBM"); ChildGetAllLookup.Add(typeof(AttendanceDay), "qryAD"); ChildGetAllLookup.Add(typeof(CheckMonitor), "qryCM"); ChildGetAllLookup.Add(typeof(ActiveCheck), "qryAC"); ChildGetAllLookup.Add(typeof(ActiveAbsence), "qryAA"); ChildGetAllLookup.Add(typeof(ActiveLate), "qryAL"); ChildGetAllLookup.Add(typeof(ActiveLeave), "qryAV"); ChildGetAllLookup.Add(typeof(ActiveOut), "qryAO"); ChildGetAllLookup.Add(typeof(MissedPunch), "qryMP"); ChildGetAllLookup.Add(typeof(Router), "qryRO"); ChildGetAllLookup.Add(typeof(Geofence), "qryGF"); ChildGetAllLookup.Add(typeof(AttendanceShift), "qryAS"); ChildGetAllLookup.Add(typeof(LeaveCalendarDay), "qryCD2"); ChildGetAllLookup.Add(typeof(OvertimeSetting), "qryOT"); ChildGetAllLookup.Add(typeof(FlatSchedule), "qryFS"); ChildGetAllLookup.Add(typeof(PendingTA), "pendingTA"); ChildGetAllLookup.Add(typeof(Time), "qryTA"); ChildGetAllLookup.Add(typeof(DashBoardTimeVariation), "qryTV"); ChildGetAllLookup.Add(typeof(DashBoardTimeVariation2), "qryMLD"); ChildGetAllLookup.Add(typeof(PendingPunch), "qryPP"); ChildGetAllLookup.Add(typeof(TimePerformance), "qryTP"); ChildGetAllLookup.Add(typeof(FlatPunch), "qryFP"); ChildGetAllLookup.Add(typeof(UnschedulePunch), "qryUP"); ChildGetAllLookup.Add(typeof(UnschedulePunchDetails), "qryUPD"); ChildGetAllLookup.Add(typeof(MonthlyLateness), "qryML"); ChildGetAllLookup.Add(typeof(MonthlyLatenessPeriod), "getMLP"); ChildGetAllLookup.Add(typeof(DashBoardTimeVariation3), "qryATV"); ChildGetAllLookup.Add(typeof(RT308A), "qryCH"); ChildAddOrUpdateLookup.Add(typeof(DayType), "setDT"); ChildAddOrUpdateLookup.Add(typeof(AttendanceSchedule), "setSC"); ChildAddOrUpdateLookup.Add(typeof(AttendanceScheduleDay), "setSD"); ChildAddOrUpdateLookup.Add(typeof(AttendanceBreak[]), "arrSB"); ChildAddOrUpdateLookup.Add(typeof(CalendarDay[]), "arrCD"); ChildAddOrUpdateLookup.Add(typeof(WorkingCalendar), "setCA"); ChildAddOrUpdateLookup.Add(typeof(CalendarYear), "setCY"); ChildAddOrUpdateLookup.Add(typeof(CalendarDay), "setCD"); ChildAddOrUpdateLookup.Add(typeof(BiometricDevice), "setBM"); ChildAddOrUpdateLookup.Add(typeof(CalendarPattern), "batCD"); ChildAddOrUpdateLookup.Add(typeof(SchedulePattern), "batSD"); ChildAddOrUpdateLookup.Add(typeof(Router), "setRO"); ChildAddOrUpdateLookup.Add(typeof(Geofence), "setGF"); ChildAddOrUpdateLookup.Add(typeof(AttendanceShift), "setAS"); ChildAddOrUpdateLookup.Add(typeof(AttendanceShift[]), "arrAS"); ChildAddOrUpdateLookup.Add(typeof(Check), "setCH"); ChildAddOrUpdateLookup.Add(typeof(CalendarAlternation), "altCD"); ChildAddOrUpdateLookup.Add(typeof(OvertimeSetting), "setOT"); ChildAddOrUpdateLookup.Add(typeof(GenerateAttendanceDay), "genFS"); ChildAddOrUpdateLookup.Add(typeof(FlatSchedule), "setFS"); ChildAddOrUpdateLookup.Add(typeof(Time), "setTA"); ChildAddOrUpdateLookup.Add(typeof(PendingPunch), "processPP"); ChildAddOrUpdateLookup.Add(typeof(DashBoardTimeVariation), "setTV"); ChildAddOrUpdateLookup.Add(typeof(RejectTimeVariationc), "setRTV"); ChildAddOrUpdateLookup.Add(typeof(MailFlatShedule), "mailFS"); ChildAddOrUpdateLookup.Add(typeof(OverrideTimeVariation), "overrideTV"); ChildAddOrUpdateLookup.Add(typeof(processUnscheduledPunch), "processUP"); ChildAddOrUpdateLookup.Add(typeof(SyncActivity), "syncTV"); ChildAddOrUpdateLookup.Add(typeof(ResetFlatSchedule), "resFS"); ChildAddOrUpdateLookup.Add(typeof(GenerationHeader), "genML"); ChildDeleteLookup.Add(typeof(AttendanceBreak), "delSB"); ChildDeleteLookup.Add(typeof(AttendanceSchedule), "delSC"); ChildDeleteLookup.Add(typeof(WorkingCalendar), "delCA"); ChildDeleteLookup.Add(typeof(DayType), "delDT"); ChildDeleteLookup.Add(typeof(BiometricDevice), "delBM"); ChildDeleteLookup.Add(typeof(Router), "delRO"); ChildDeleteLookup.Add(typeof(Geofence), "delGF"); ChildDeleteLookup.Add(typeof(AttendanceShift), "delAS"); ChildDeleteLookup.Add(typeof(OvertimeSetting), "delOT"); ChildDeleteLookup.Add(typeof(FlatSchedule), "delFS"); ChildDeleteLookup.Add(typeof(FlatScheduleRange), "delRangeFS"); ChildDeleteLookup.Add(typeof(PendingPunch), "delPP"); //Flat Schedule }
public SelfServiceRepository() { base.ServiceURL = ApplicationSettingsFactory.GetApplicationSettings().BaseURL + serviceName; ChildGetAllLookup.Add(typeof(MyInfo), "qryEM"); ChildGetAllLookup.Add(typeof(LetterSelfservice), "qryLE"); ChildGetAllLookup.Add(typeof(AssetAllowanceSelfService), "qryAA"); ChildGetAllLookup.Add(typeof(EmployeeComplaintSelfService), "qryCO"); ChildGetAllLookup.Add(typeof(LeaveDaySelfservice), "qryLD"); ChildGetAllLookup.Add(typeof(leaveRequetsSelfservice), "qryLR"); ChildGetAllLookup.Add(typeof(FlatScheduleSelfService), "qryFS"); ChildGetAllLookup.Add(typeof(AttendanceDay), "qryAD"); ChildGetAllLookup.Add(typeof(TimeVariationSelfService), "qryTV"); ChildGetAllLookup.Add(typeof(EmployeePayrollSelfService), "qryPE"); ChildGetAllLookup.Add(typeof(TimeSelfService), "qryTA"); ChildGetAllLookup.Add(typeof(LeaveType), "qryLT"); ChildGetAllLookup.Add(typeof(loanSelfService), "qryLO"); ChildGetAllLookup.Add(typeof(Dependant), "qryDE"); ChildGetAllLookup.Add(typeof(EmployeeContact), "qryCO"); ChildGetAllLookup.Add(typeof(EmployeeEmergencyContact), "qryEC"); ChildGetAllLookup.Add(typeof(DashBoardTimeVariation), "qryTV"); ChildGetAllLookup.Add(typeof(PayrollEntitlementDeduction), "qryED"); ChildGetAllLookup.Add(typeof(PayrollSocialSecurity), "qryES"); ChildGetAllLookup.Add(typeof(AdminDocTransfer), "qryTR"); ChildGetAllLookup.Add(typeof(AssetLoan), "qryAL"); ChildGetAllLookup.Add(typeof(GenerationHeader), "qryPE"); ChildGetAllLookup.Add(typeof(LeaveReplacementApproval), "qryRA"); ChildGetLookup.Add(typeof(MyInfo), "getEM1"); ChildGetLookup.Add(typeof(EmployeeComplaintSelfService), "getCO"); ChildGetLookup.Add(typeof(loanSelfService), "getLO"); ChildGetLookup.Add(typeof(TimeSelfService), "getTA"); ChildGetLookup.Add(typeof(UserInfoSelfService), "getUS"); ChildGetLookup.Add(typeof(LeaveRequest), "getLR"); ChildGetLookup.Add(typeof(EmployeeQuickView), "getQV"); //ChildGetLookup.Add(typeof(KeyValuePair<string, string>), "getDE"); ChildGetLookup.Add(typeof(Dependant), "getDE"); ChildGetLookup.Add(typeof(EmployeeContact), "getCO"); ChildGetLookup.Add(typeof(EmployeeEmergencyContact), "getEC"); ChildGetLookup.Add(typeof(GenerationHeader), "getPE"); ChildGetLookup.Add(typeof(LeaveReplacementApproval), "getRA"); ChildAddOrUpdateLookup.Add(typeof(MyInfo), "setEM"); ChildAddOrUpdateLookup.Add(typeof(UserInfoSelfService), "setUS"); ChildAddOrUpdateLookup.Add(typeof(LeaveRequest), "setLR"); ChildAddOrUpdateLookup.Add(typeof(loanSelfService), "setLO"); ChildAddOrUpdateLookup.Add(typeof(LetterSelfservice), "setLE"); ChildAddOrUpdateLookup.Add(typeof(LeaveDay[]), "arrLD"); ChildAddOrUpdateLookup.Add(typeof(EmployeeComplaintSelfService), "setCO"); ChildAddOrUpdateLookup.Add(typeof(TimeSelfService), "setTA"); ChildAddOrUpdateLookup.Add(typeof(Dependant), "setDE"); ChildAddOrUpdateLookup.Add(typeof(EmployeeContact), "setCO"); ChildAddOrUpdateLookup.Add(typeof(EmployeeEmergencyContact), "setEC"); ChildAddOrUpdateLookup.Add(typeof(DashBoardTimeVariation), "setTV"); ChildAddOrUpdateLookup.Add(typeof(AttendanceShift), "setAS"); ChildAddOrUpdateLookup.Add(typeof(AdminDocTransfer), "setTR"); ChildAddOrUpdateLookup.Add(typeof(GenerationHeader), "setPE"); ChildAddOrUpdateLookup.Add(typeof(LeaveReplacementApproval), "setRA"); ChildDeleteLookup.Add(typeof(MyInfo), "delEM"); ChildDeleteLookup.Add(typeof(EmployeeComplaintSelfService), "delCO"); ChildDeleteLookup.Add(typeof(Dependant), "delDE"); ChildDeleteLookup.Add(typeof(EmployeeContact), "delCO"); ChildDeleteLookup.Add(typeof(EmployeeEmergencyContact), "delEC"); ChildDeleteLookup.Add(typeof(leaveRequetsSelfservice), "delLR"); ChildDeleteLookup.Add(typeof(loanSelfService), "delLO"); ChildDeleteLookup.Add(typeof(AttendanceShift), "delAS"); ChildDeleteLookup.Add(typeof(GenerationHeader), "delPE"); ChildDeleteLookup.Add(typeof(LeaveReplacementApproval), "delRA"); }
private void ReadConfigFile() { string modbusConfigRelativePath = ApplicationSettingsFactory.GetApplicationSettings().ModbusConfigFilePath; string modbusConfigFile = System.IO.Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory, modbusConfigRelativePath); if (System.IO.File.Exists(modbusConfigFile)) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(modbusConfigFile); XmlNodeList moduleNodes = xmlDoc.SelectNodes("/ModbusConfig/Module"); if (null != moduleNodes && moduleNodes.Count > 0) { ClearConfigDictionary(); int moduleId = 0; int dataPointId = 0; foreach (XmlNode moduleNode in moduleNodes) { // Module moduleId++; XmlElement moduleElement = (XmlElement)moduleNode; string moduleNumber = Convert.ToString(moduleId); moduleElement.SetAttribute("Id", string.Format("{0:D4}", moduleId)); string moduleName = moduleElement.GetAttribute("Name"); string moduleDescription = moduleElement.GetAttribute("Description"); Module module = new Module(); //UnitOfWork机制和数据库外键的设计,决定了要预先设置数据库中的主键Id //尽管数据库自己生产主键。 module.Id = moduleId; AddModule(module, moduleNumber, moduleName, moduleDescription); //DataPoint XmlNodeList dataPointNodes = moduleNode.ChildNodes; if (dataPointNodes.Count > 0) { foreach (XmlNode dataPointNode in dataPointNodes) { dataPointId++; XmlElement dataPointElement = (XmlElement)dataPointNode; string dataPointNumber = Convert.ToString(dataPointId); dataPointElement.SetAttribute("Id", string.Format("{0:D5}", dataPointId)); string dataPointName = dataPointElement.GetAttribute("Name"); string deviceAddress = dataPointElement.GetAttribute("DeviceAddress"); string dataPointStartingRegister = dataPointElement.GetAttribute("StartingRegister"); string dataPointDataType = dataPointElement.GetAttribute("DataType"); string dataDataDataPointType = dataPointElement.GetAttribute("DataPointType"); string datapointDescription = dataPointElement.GetAttribute("Description"); DataPoint dataPoint = new DataPoint(); //UnitOfWork机制和数据库外键的设计,决定了要预先设置数据库中的主键Id //尽管数据库自己生产主键。 dataPoint.Id = dataPointId; AddDataPoint(module, dataPoint, dataPointNumber, deviceAddress, dataPointStartingRegister, dataPointName, dataPointDataType, dataDataDataPointType, datapointDescription); } } } xmlDoc.Save(modbusConfigFile); } } }
public DataBaseTest() { //初始化ApplicationSettingsFactory ApplicationSettingsFactory.InitApplicationSettingsFactory(new WebConfigApplicationSettings()); ToPreventDBDoesNotExist(); }
public CompanyStructureRepository() { base.ServiceURL = ApplicationSettingsFactory.GetApplicationSettings().BaseURL + serviceName; base.ChildGetLookup.Add(typeof(Branch), "getBR"); base.ChildGetLookup.Add(typeof(Department), "getDE"); base.ChildGetLookup.Add(typeof(Position), "getPO"); base.ChildGetLookup.Add(typeof(Division), "getDI"); base.ChildGetLookup.Add(typeof(LegalReference), "getBL"); base.ChildGetLookup.Add(typeof(Approval), "getAP"); base.ChildGetLookup.Add(typeof(ApprovelDepartment), "getAD"); base.ChildGetLookup.Add(typeof(ApprovalReason), "getAR"); base.ChildGetLookup.Add(typeof(WorkFlow), "getWF"); base.ChildGetLookup.Add(typeof(WorkSequence), "getWS"); base.ChildGetLookup.Add(typeof(Rule), "getRU"); base.ChildGetLookup.Add(typeof(RuleCondition), "getRC"); base.ChildGetLookup.Add(typeof(RuleMessage), "getRM"); base.ChildGetAllLookup.Add(typeof(Branch), "qryBR"); base.ChildGetAllLookup.Add(typeof(Department), "qryDE"); base.ChildGetAllLookup.Add(typeof(Position), "qryPO"); base.ChildGetAllLookup.Add(typeof(Division), "qryDI"); base.ChildGetAllLookup.Add(typeof(LegalReference), "qryBL"); base.ChildGetAllLookup.Add(typeof(Approval), "qryAP"); base.ChildGetAllLookup.Add(typeof(ApprovelDepartment), "qryAD"); base.ChildGetAllLookup.Add(typeof(ApprovalReason), "qryAR"); base.ChildGetAllLookup.Add(typeof(WorkFlow), "qryWF"); base.ChildGetAllLookup.Add(typeof(WorkSequence), "qryWS"); base.ChildGetAllLookup.Add(typeof(Rule), "qryRU"); base.ChildGetAllLookup.Add(typeof(RuleCondition), "qryRC"); base.ChildGetAllLookup.Add(typeof(RuleMessage), "qryRM"); base.ChildGetAllLookup.Add(typeof(RuleTrigger), "qryRT"); base.ChildAddOrUpdateLookup.Add(typeof(Branch), "setBR"); base.ChildAddOrUpdateLookup.Add(typeof(Department), "setDE"); base.ChildAddOrUpdateLookup.Add(typeof(Position), "setPO"); base.ChildAddOrUpdateLookup.Add(typeof(Division), "setDI"); base.ChildAddOrUpdateLookup.Add(typeof(LegalReference), "setBL"); base.ChildAddOrUpdateLookup.Add(typeof(Approval), "setAP"); base.ChildAddOrUpdateLookup.Add(typeof(ApprovelDepartment), "setAD"); base.ChildAddOrUpdateLookup.Add(typeof(ApprovalReason), "setAR"); base.ChildAddOrUpdateLookup.Add(typeof(WorkFlow), "setWF"); base.ChildAddOrUpdateLookup.Add(typeof(WorkSequence), "setWS"); base.ChildAddOrUpdateLookup.Add(typeof(Rule), "setRU"); base.ChildAddOrUpdateLookup.Add(typeof(RuleCondition), "setRC"); base.ChildAddOrUpdateLookup.Add(typeof(RuleMessage), "setRM"); base.ChildAddOrUpdateLookup.Add(typeof(RuleTrigger), "setRT"); ChildDeleteLookup.Add(typeof(Branch), "delBR"); ChildDeleteLookup.Add(typeof(Department), "delDE"); ChildDeleteLookup.Add(typeof(Position), "delPO"); ChildDeleteLookup.Add(typeof(Division), "delDI"); ChildDeleteLookup.Add(typeof(Approval), "delAP"); ChildDeleteLookup.Add(typeof(ApprovelDepartment), "delAD"); ChildDeleteLookup.Add(typeof(LegalReference), "delBL"); ChildDeleteLookup.Add(typeof(ApprovalReason), "delAR"); ChildDeleteLookup.Add(typeof(WorkFlow), "delWF"); ChildDeleteLookup.Add(typeof(WorkSequence), "delWS"); ChildDeleteLookup.Add(typeof(Rule), "delRU"); ChildDeleteLookup.Add(typeof(RuleCondition), "delRC"); ChildDeleteLookup.Add(typeof(RuleMessage), "delRM"); ChildDeleteLookup.Add(typeof(RuleTrigger), "delRT"); base.GetAllMethodName = ""; base.GetRecordMethodName = ""; base.DeleteMethodName = ""; base.AddOrUpdateMethodName = ""; }
public UsersRepository() { connectionString = ApplicationSettingsFactory.GetApplicationSettings().IndustryEnergy_SHConnectionString; dataFactory = new SqlServerDataFactory(connectionString); }
public Log4NetWebAdapter() { XmlConfigurator.ConfigureAndWatch(new FileInfo(HttpContext.Current.Server.MapPath("~/" + ApplicationSettingsFactory.GetApplicationSettings().LoggerConfigurationPath))); _log = LogManager.GetLogger(ApplicationSettingsFactory.GetApplicationSettings().LoggerName); }
public AllSafetyWarningDatasModel GetAllSafetyDatas() { string connectionString = ConfigurationManager.ConnectionStrings[ApplicationSettingsFactory.GetApplicationSettings().DBConnectionName].ConnectionString;//获得Web.config中的连接字符串 AllSafetyWarningDatasModel models = new AllSafetyWarningDatasModel(); using (SqlConnection conStr = new SqlConnection(connectionString)) //SQL数据库连接对象,以数据库链接字符串为参数 { SqlCommand comStr = new SqlCommand(AppConstants.SafetyWarningRealTimeProc, conStr); //SQL语句执行对象,第一个参数是要执行的语句,第二个是数据库连接对象 comStr.CommandType = CommandType.StoredProcedure; //因为要使用的是存储过程,所以设置执行 SqlParameter preFirstAssessmentReportTime = comStr.Parameters.Add("@preFirstAssessmentReportTime", SqlDbType.DateTime); preFirstAssessmentReportTime.Direction = ParameterDirection.Output; SqlParameter totalSafetyWarningResult = comStr.Parameters.Add("@totalSafetyWarningResult", SqlDbType.VarChar, 8000); totalSafetyWarningResult.Direction = ParameterDirection.Output; SqlParameter totalSafetyWarningColor = comStr.Parameters.Add("@totalSafetyWarningColor", SqlDbType.VarChar, 8000); totalSafetyWarningColor.Direction = ParameterDirection.Output; SqlParameter cableForceSafetyWarningResult = comStr.Parameters.Add("@cableForceSafetyWarningResult", SqlDbType.VarChar, 8000); cableForceSafetyWarningResult.Direction = ParameterDirection.Output; SqlParameter cableForceSafetyWarningColor = comStr.Parameters.Add("@cableForceSafetyWarningColor", SqlDbType.VarChar, 8000); cableForceSafetyWarningColor.Direction = ParameterDirection.Output; SqlParameter cableForceRedWarningTimes = comStr.Parameters.Add("@cableForceRedWarningTimes", SqlDbType.Int); cableForceRedWarningTimes.Direction = ParameterDirection.Output; SqlParameter cableForceYellowWarningTimes = comStr.Parameters.Add("@cableForceYellowWarningTimes", SqlDbType.Int); cableForceYellowWarningTimes.Direction = ParameterDirection.Output; SqlParameter displacementSafetyWarningResult = comStr.Parameters.Add("@displacementSafetyWarningResult", SqlDbType.VarChar, 8000); displacementSafetyWarningResult.Direction = ParameterDirection.Output; SqlParameter displacementSafetyWarningColor = comStr.Parameters.Add("@displacementSafetyWarningColor", SqlDbType.VarChar, 8000); displacementSafetyWarningColor.Direction = ParameterDirection.Output; SqlParameter displacementRedWarningTimes = comStr.Parameters.Add("@displacementRedWarningTimes", SqlDbType.Int); displacementRedWarningTimes.Direction = ParameterDirection.Output; SqlParameter displacementYellowWarningTimes = comStr.Parameters.Add("@displacementYellowWarningTimes", SqlDbType.Int); displacementYellowWarningTimes.Direction = ParameterDirection.Output; SqlParameter windLoadSafetyWarningResult = comStr.Parameters.Add("@windLoadSafetyWarningResult", SqlDbType.VarChar, 8000); windLoadSafetyWarningResult.Direction = ParameterDirection.Output; SqlParameter windLoadSafetyWarningColor = comStr.Parameters.Add("@windLoadSafetyWarningColor", SqlDbType.VarChar, 8000); windLoadSafetyWarningColor.Direction = ParameterDirection.Output; SqlParameter windLoadRedWarningTimes = comStr.Parameters.Add("@windLoadRedWarningTimes", SqlDbType.Int); windLoadRedWarningTimes.Direction = ParameterDirection.Output; SqlParameter windLoadYellowWarningTimes = comStr.Parameters.Add("@windLoadYellowWarningTimes", SqlDbType.Int); windLoadYellowWarningTimes.Direction = ParameterDirection.Output; SqlParameter temperatureSafetyWarningResult = comStr.Parameters.Add("@temperatureSafetyWarningResult", SqlDbType.VarChar, 8000); temperatureSafetyWarningResult.Direction = ParameterDirection.Output; SqlParameter temperatureSafetyWarningColor = comStr.Parameters.Add("@temperatureSafetyWarningColor", SqlDbType.VarChar, 8000); temperatureSafetyWarningColor.Direction = ParameterDirection.Output; SqlParameter temperatureRedWarningTimes = comStr.Parameters.Add("@temperatureRedWarningTimes", SqlDbType.Int); temperatureRedWarningTimes.Direction = ParameterDirection.Output; SqlParameter temperatureYellowWarningTimes = comStr.Parameters.Add("@temperatureYellowWarningTimes", SqlDbType.Int); temperatureYellowWarningTimes.Direction = ParameterDirection.Output; conStr.Open(); //打开数据库连接 comStr.ExecuteNonQuery().ToString(); //执行存储过程 models.PreFirstAssessmentReportTime = comStr.Parameters["@preFirstAssessmentReportTime"].Value.ToString();//在执行完存储过程之后,可得到输出参数 models.TotalSafetyPreWarningState = comStr.Parameters["@totalSafetyWarningResult"].Value.ToString(); models.TotalSafetyPreWarningColor = comStr.Parameters["@totalSafetyWarningColor"].Value.ToString(); models.CableForceSafetyPreWarningState = comStr.Parameters["@cableForceSafetyWarningResult"].Value.ToString(); models.CableForceSafetyPreWarningColor = comStr.Parameters["@cableForceSafetyWarningColor"].Value.ToString(); models.CableForceWarningGrade3Times = Convert.ToInt32(comStr.Parameters["@cableForceRedWarningTimes"].Value); models.CableForceWarningGrade2Times = Convert.ToInt32(comStr.Parameters["@cableForceYellowWarningTimes"].Value); models.DisplacementSafetyPreWarningState = comStr.Parameters["@displacementSafetyWarningResult"].Value.ToString(); models.DisplacementSafetyPreWarningColor = comStr.Parameters["@displacementSafetyWarningColor"].Value.ToString(); models.DisplacementWarningGrade3Times = Convert.ToInt32(comStr.Parameters["@displacementRedWarningTimes"].Value); models.DisplacementWarningGrade2Times = Convert.ToInt32(comStr.Parameters["@displacementYellowWarningTimes"].Value); models.WindLoadSafetyPreWarningState = comStr.Parameters["@windLoadSafetyWarningResult"].Value.ToString(); models.WindLoadSafetyPreWarningColor = comStr.Parameters["@windLoadSafetyWarningColor"].Value.ToString(); models.WindLoadWarningGrade3Times = Convert.ToInt32(comStr.Parameters["@windLoadRedWarningTimes"].Value); models.WindLoadWarningGrade2Times = Convert.ToInt32(comStr.Parameters["@windLoadYellowWarningTimes"].Value); models.TemperatureSafetyPreWarningState = comStr.Parameters["@temperatureSafetyWarningResult"].Value.ToString(); models.TemperatureSafetyPreWarningColor = comStr.Parameters["@temperatureSafetyWarningColor"].Value.ToString(); models.TemperatureWarningGrade3Times = Convert.ToInt32(comStr.Parameters["@temperatureRedWarningTimes"].Value); models.TemperatureWarningGrade2Times = Convert.ToInt32(comStr.Parameters["@temperatureYellowWarningTimes"].Value); } return(models); }
public bool SendEmail(string to, string from, string cc, string bcc, string subject, string body, bool enablessl, Stream attachmentPath, string attachmentName) { System.Net.Mail.SmtpClient cl = new System.Net.Mail.SmtpClient(); cl.Host = ApplicationSettingsFactory.GetApplicationSettings().SmtpHost; cl.UseDefaultCredentials = false; cl.Credentials = new System.Net.NetworkCredential(ApplicationSettingsFactory.GetApplicationSettings().SmtpUsername, ApplicationSettingsFactory.GetApplicationSettings().SmtpPassword); cl.EnableSsl = enablessl; cl.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network; try { System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage(from, to, subject, body); // CC and BCC optional if (!string.IsNullOrEmpty(cc)) { string[] ccArray = cc.Split(','); foreach (string sCC in ccArray) { msg.CC.Add(sCC); } } // You can specify Address directly as string if (!string.IsNullOrEmpty(bcc)) { string[] bccArray = bcc.Split(','); foreach (string sBCC in bccArray) { msg.Bcc.Add(sBCC); } } if (attachmentPath != null) { var att = new System.Net.Mail.Attachment(attachmentPath, attachmentName); msg.Attachments.Add(att); } msg.IsBodyHtml = true; ServicePointManager.ServerCertificateValidationCallback = delegate(object s, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return(true); }; cl.Send(msg); } catch (Exception ex) { throw ex; } return(true); }
public PayrollRepository() { base.ServiceURL = ApplicationSettingsFactory.GetApplicationSettings().BaseURL + serviceName; ChildGetAllLookup.Add(typeof(FiscalYear), "qryYE"); ChildGetAllLookup.Add(typeof(GenerationHeader), "qryHE"); ChildGetAllLookup.Add(typeof(FiscalPeriod), "qryPE"); ChildGetAllLookup.Add(typeof(EmployeePayroll), "qryEM"); ChildGetAllLookup.Add(typeof(PayrollEntitlementDeduction), "qryED"); ChildGetAllLookup.Add(typeof(TimeSchedule), "qryTS"); ChildGetAllLookup.Add(typeof(TimeCode), "qryTC"); ChildGetAllLookup.Add(typeof(SocialSecuritySchedule), "qrySS"); ChildGetAllLookup.Add(typeof(SocialSecurityScheduleSetup), "qrySC"); ChildGetAllLookup.Add(typeof(FinalSettlement), "qryFS"); ChildGetAllLookup.Add(typeof(FinalEntitlementsDeductions), "qryFD"); ChildGetAllLookup.Add(typeof(PayCode), "qryPC"); ChildGetAllLookup.Add(typeof(PayrollSocialSecurity), "qryES"); ChildGetAllLookup.Add(typeof(PayrollIndemnity), "qryIS"); ChildGetAllLookup.Add(typeof(PayrollIndemnityDetails), "qryID"); ChildGetAllLookup.Add(typeof(PayrollIndemnityRecognition), "qryIR"); ChildGetAllLookup.Add(typeof(LeavePayment), "qryLP"); ChildGetAllLookup.Add(typeof(Bank), "qryBA"); ChildGetAllLookup.Add(typeof(PenaltyType), "qryPT"); ChildGetAllLookup.Add(typeof(PenaltyDetail), "qryPD"); ChildGetAllLookup.Add(typeof(PayrollArgument), "qryAR"); ChildGetAllLookup.Add(typeof(PayrollBenefitSchedule), "qryBS"); ChildGetAllLookup.Add(typeof(PayrollBenefit), "qryBE"); ChildAddOrUpdateLookup.Add(typeof(FiscalYear), "setYE"); ChildAddOrUpdateLookup.Add(typeof(GenerationHeader), "setHE"); ChildAddOrUpdateLookup.Add(typeof(EmployeePayroll), "setEM"); ChildAddOrUpdateLookup.Add(typeof(PayrollEntitlementDeduction[]), "arrED"); ChildAddOrUpdateLookup.Add(typeof(PayrollEntitlementDeduction), "setED"); ChildAddOrUpdateLookup.Add(typeof(SyncED), "syncED"); ChildAddOrUpdateLookup.Add(typeof(TimeSchedule), "setTS"); ChildAddOrUpdateLookup.Add(typeof(TimeCode[]), "arrTC"); ChildAddOrUpdateLookup.Add(typeof(SocialSecuritySchedule), "setSS"); ChildAddOrUpdateLookup.Add(typeof(SocialSecurityScheduleSetup), "setSC"); ChildAddOrUpdateLookup.Add(typeof(FinalSettlement), "setFS"); ChildAddOrUpdateLookup.Add(typeof(FinalEntitlementsDeductions), "setFD"); ChildAddOrUpdateLookup.Add(typeof(PayCode), "setPC"); ChildAddOrUpdateLookup.Add(typeof(PayrollIndemnity), "setIS"); ChildAddOrUpdateLookup.Add(typeof(PayrollIndemnityDetails), "setID"); ChildAddOrUpdateLookup.Add(typeof(PayrollIndemnityDetails[]), "arrID"); ChildAddOrUpdateLookup.Add(typeof(PayrollIndemnityRecognition[]), "arrIR"); ChildAddOrUpdateLookup.Add(typeof(LeavePayment), "setLP"); ChildAddOrUpdateLookup.Add(typeof(Bank), "setBA"); ChildAddOrUpdateLookup.Add(typeof(PenaltyType), "setPT"); ChildAddOrUpdateLookup.Add(typeof(PenaltyDetail), "setPD"); ChildAddOrUpdateLookup.Add(typeof(TimeCode), "setTC"); ChildAddOrUpdateLookup.Add(typeof(FiscalPeriod), "setPE"); ChildAddOrUpdateLookup.Add(typeof(MailEmployee), "mailEM"); ChildAddOrUpdateLookup.Add(typeof(PayrollArgument), "setAR"); ChildAddOrUpdateLookup.Add(typeof(GeneratePayroll), "genEM"); ChildAddOrUpdateLookup.Add(typeof(CheckExpression), "checkEX"); ChildAddOrUpdateLookup.Add(typeof(PayrollBenefitSchedule), "setBS"); ChildAddOrUpdateLookup.Add(typeof(PayrollBenefit), "setBE"); ChildAddOrUpdateLookup.Add(typeof(DeletePayroll), "delEM"); ChildDeleteLookup.Add(typeof(FiscalYear), "delYE"); ChildDeleteLookup.Add(typeof(PayrollEntitlementDeduction), "delED"); ChildDeleteLookup.Add(typeof(GenerationHeader), "delHE"); ChildDeleteLookup.Add(typeof(TimeSchedule), "delTS"); ChildDeleteLookup.Add(typeof(SocialSecuritySchedule), "delSS"); ChildDeleteLookup.Add(typeof(SocialSecurityScheduleSetup), "delSC"); ChildDeleteLookup.Add(typeof(FinalSettlement), "delFS"); ChildDeleteLookup.Add(typeof(FinalEntitlementsDeductions), "delFD"); ChildDeleteLookup.Add(typeof(PayCode), "delPC"); ChildDeleteLookup.Add(typeof(PayrollIndemnity), "delIS"); ChildDeleteLookup.Add(typeof(PayrollIndemnityDetails), "delID"); ChildDeleteLookup.Add(typeof(PayrollIndemnityRecognition), "delIR"); ChildDeleteLookup.Add(typeof(LeavePayment), "delLP"); ChildDeleteLookup.Add(typeof(Bank), "delBA"); ChildDeleteLookup.Add(typeof(EmployeePayroll), "delEM"); ChildDeleteLookup.Add(typeof(PenaltyType), "delPT"); ChildDeleteLookup.Add(typeof(PenaltyDetail), "delPD"); ChildDeleteLookup.Add(typeof(TimeCode), "delTC"); ChildDeleteLookup.Add(typeof(PayrollBenefitSchedule), "delBS"); ChildDeleteLookup.Add(typeof(PayrollBenefit), "delBE"); ChildDeleteLookup.Add(typeof(PayrollArgument), "delAR"); ChildGetLookup.Add(typeof(GenerationHeader), "getHE"); ChildGetLookup.Add(typeof(TimeSchedule), "getTS"); ChildGetLookup.Add(typeof(SocialSecuritySchedule), "getSS"); ChildGetLookup.Add(typeof(SocialSecurityScheduleSetup), "getSC"); ChildGetLookup.Add(typeof(FinalSettlement), "getFS"); ChildGetLookup.Add(typeof(FinalEntitlementsDeductions), "getFD"); ChildGetLookup.Add(typeof(PayCode), "getPC"); ChildGetLookup.Add(typeof(PayrollIndemnity), "getIS"); ChildGetLookup.Add(typeof(PayrollIndemnityDetails), "getID"); ChildGetLookup.Add(typeof(PayrollIndemnityRecognition), "getIR"); ChildGetLookup.Add(typeof(LeavePayment), "getLP"); ChildGetLookup.Add(typeof(Bank), "getBA"); ChildGetLookup.Add(typeof(TimeCode), "getTC"); ChildGetLookup.Add(typeof(PenaltyType), "getPT"); ChildGetLookup.Add(typeof(PenaltyDetail), "getPD"); ChildGetLookup.Add(typeof(FiscalPeriod), "getPE"); //ChildGetLookup.Add(typeof(CheckExpression), "checkEX"); ChildGetLookup.Add(typeof(PayrollBenefitSchedule), "getBS"); ChildGetLookup.Add(typeof(PayrollBenefit), "getBE"); ChildGetLookup.Add(typeof(PayrollArgument), "getAR"); }
/// <summary> /// 初始化程序配置 /// </summary> private static void InitializeApplicationSetting() { IApplicationSettings applicationSettings = new AppConfigApplicationSettings(); //IocContainerFactory.GetUnityContainer().Resolve<IApplicationSettings>(); ApplicationSettingsFactory.InitializeApplicationSettingsFactory(applicationSettings); }