private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { if (CurrentTender.StageId < (int)Stages.TenderingMeeting) { ErrorHandler.NotifyUser("ایجاد صورتجلسه توجیهی تا قبل از تایید نهایی درخواست مناقصه امکان پذیر نیست"); return; } var report = new RTM.Report.Report3.Report3_Main(); report.SetDatabaseLogon("ratec", "ratec"); report.SetParameterValue("IdParam", CurrentMeet.MeetingId); report.SetParameterValue("MeetNumParam", CurrentMeet.MeetingId.ToString()); report.SetParameterValue(1, DateConverter.ConvertDate((DateTime)(CurrentTender.BriefingSessionDate).Value.Date).Substring(4)); report.SetParameterValue(2, DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentsDate).Value.Date).Substring(4)); report.SetParameterValue(3, DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentDeadline).Value.Date).Substring(4)); report.SetParameterValue(4, DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionRecieveDate).Value.Date).Substring(4)); report.SetParameterValue(5, DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionOpenDate).Value.Date).Substring(4)); string GarantyType; if (CurrentTender.StockWarranty == true) { GarantyType = "اوراق مشارکت"; } else if (CurrentTender.LcWarranty == true) { GarantyType = "ضمانتنامه بانکی"; } else if (CurrentTender.DraftWarranty == true) { GarantyType = "فیش واریزی"; } else { GarantyType = ""; } report.SetParameterValue(6, GarantyType); report.SetParameterValue("LocParam", CurrentTender.Location); report.SetParameterValue("PriceParam", CurrentTender.GuarantyPrice.ToString().Split('.')[0]); if (CurrentTender.TenderingNumber != null) { report.SetParameterValue("TenderNumParam", CurrentTender.TenderingNumber); } else { report.SetParameterValue("TenderNumParam", "ندارد"); } if (CurrentMeet.MeetingDescription.Trim() == "" || CurrentMeet.MeetingDescription == null) { report.SetParameterValue("NoteParam", ""); } else { report.SetParameterValue("NoteParam", CurrentMeet.MeetingDescription); } crystalReportsViewer1.ViewerCore.ReportSource = report; }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var report = new RTM.Report.PriceEvalReport.PriceEval_Main(); report.SetDatabaseLogon("ratec", "ratec"); report.SetParameterValue("TenderId", CurrentTender.TenderingId); report.SetParameterValue("EvalId", CurrentEval.EvaluationId); report.SetParameterValue("Date", DateConverter.ConvertDate((DateTime)(CurrentEval.MeetingDate).Value.Date).Substring(4)); crystalReportsViewer1.ViewerCore.ReportSource = report; }
private CarData GetCarData(ISearchContext car) { var name = car.FindElement(LblChildCarName).Text; var price = StringUtils.CutNonDigitCharacters(car.FindElement(LblChildCarPrice).Text); var year = StringUtils.CutNonDigitCharacters(car.FindElement(LblChildCarYear).Text); var date = StringUtils.CutCharactersAfterComma(car.FindElement(LblChildCarDate).Text); var carData = new CarData(name, int.Parse(price), year, DateConverter.ConvertDate(date)); return(carData); }
private CarData GetCarData(ISearchContext car) { var name = car.FindElement(LblChildCarName).Text; var price = car.FindElement(LblChildCarPrice).Text; var year = car.FindElement(LblChildCarYear).Text; var date = GetCarDate(car); return(new CarData(name, int.Parse(price.Substring(0, price.Length - 3).Replace(" ", string.Empty)), year, DateConverter.ConvertDate(date))); }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var report = new RTM.Report.Report5.Report5_Main(); report.SetDatabaseLogon("ratec", "ratec"); report.SetParameterValue(1, DateConverter.ConvertDate((DateTime)(CurrentMeet.MeetingDate))); report.SetParameterValue(2, DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentsDate))); report.SetParameterValue(3, DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentDeadline))); report.SetParameterValue(4, DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionRecieveDate))); report.SetParameterValue(5, DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionOpenDate))); string GarantyType; string RefrenceType; if (CurrentTender.StockWarranty == true) { GarantyType = "اوراق مشارکت"; } else if (CurrentTender.LcWarranty == true) { GarantyType = "ضمانتنامه بانکی"; } else if (CurrentTender.DraftWarranty == true) { GarantyType = "فیش واریزی"; } else { GarantyType = ""; } report.SetParameterValue(6, GarantyType); if (CurrentMeet.ExtendByApplicant == true) { RefrenceType = "درخواست واحد متقاضی"; } else if (CurrentMeet.ExtendByCommittee == true) { RefrenceType = "نظر کمیسیون"; } else { RefrenceType = ""; } report.SetParameterValue(7, RefrenceType); report.SetParameterValue(8, DateConverter.ConvertDate((DateTime)(CurrentMeet.ExtendedRecieveDate))); crystalReportsViewer1.ViewerCore.ReportSource = report; }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var report = new RTM.Report.Report6.Report6_Main(); report.SetDatabaseLogon("ratec", "ratec"); if (CurrentTender.TenderingNumber != null) { report.SetParameterValue("TenderingNumParam", CurrentTender.TenderingNumber.ToString()); } else { report.SetParameterValue("TenderingNumParam", "ندارد"); } report.SetParameterValue("TenderTitleParam", CurrentTender.TenderingTitle); report.SetParameterValue("OpenDateParam", DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionOpenDate).Value.Date).Substring(4)); report.SetParameterValue("EstimateParam", CurrentReq.Estimatation); report.SetParameterValue("MeetId", CurrentMeet.MeetingId); crystalReportsViewer1.ViewerCore.ReportSource = report; }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var report = new RTM.Report.Report2.Report2_Main(); try { report.SetDatabaseLogon("ratec", "ratec"); report.SetParameterValue(0, Current.ContractorRequestId); report.SetParameterValue(1, DateConverter.ConvertDate((DateTime)(((Current.RequestDate).Value).Date)).Substring(4)); if (Current.HasCEOAccepted == true) { report.SetParameterValue(2, "موافقت"); } else { report.SetParameterValue(2, "مخالفت"); } if (Current.CeoNote != null) { report.SetParameterValue("NoteParam", Current.CeoNote); } else { report.SetParameterValue("NoteParam", " "); } if (Current.Estimatation != null) { report.SetParameterValue("EstimateParam", Current.Estimatation); } else { report.SetParameterValue("EstimateParam", "0"); } crystalReportsViewer1.ViewerCore.ReportSource = report; } catch { return; } }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var report = new RTM.Report.GenralRep.WebDocRecieve(); //report.SetDatabaseLogon("ratec", "ratec"); ConnectionInfo crConnection = new ConnectionInfo(); crConnection.ServerName = @"GIS-SERVER"; crConnection.DatabaseName = "ratec"; crConnection.UserID = "ratec"; crConnection.Password = "******"; CrystalDecisions.CrystalReports.Engine.Tables tables = report.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables) { CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo; tableLogonInfo.ConnectionInfo = crConnection; table.ApplyLogOnInfo(tableLogonInfo); } foreach (TenderingFileDownload t in MyList) { t.PersianDate = DateConverter.ConvertDate(t.date); } report.SetDataSource(MyList); crystalReportsViewer1.ViewerCore.ReportSource = report; }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var report = new RTM.Report.Report1.Report1_Main(); try { report.SetDatabaseLogon("ratec", "ratec"); report.SetParameterValue("MeetingDateParam", DateConverter.ConvertDate((DateTime)(CurrentTender.TenderingRecordDate).Value.Date).ToString().Substring(4)); report.SetParameterValue("ReqNumParam", CurrentReq.RequestNumber.ToString()); report.SetParameterValue("ReqDateParam", DateConverter.ConvertDate((DateTime)(CurrentReq.RequestDate).Value.Date).ToString().Substring(4)); report.SetParameterValue("TitleParam", CurrentReq.ProjectTitle); report.SetParameterValue("LocParam", CurrentReq.Location); report.SetParameterValue("EstimateParam", CurrentReq.Estimatation); if (CurrentReq.IsPriceList == true) { report.SetParameterValue("PriceListParam", CurrentReq.Year); } else { report.SetParameterValue("PriceListParam", "ندارد"); } report.SetParameterValue("FieldParam", CurrentReq.RequiredField); report.SetParameterValue("MinRankParam", CurrentReq.RequiredMinRank); report.SetParameterValue("TenderTypeParam", CurrentReq.TenderingType); if (CurrentTender.AdvertisingAlternationCount == null || CurrentTender.AdvertisingAlternationCount == 0) { report.SetParameterValue("AdParam", "ندارد"); } else { report.SetParameterValue("AdParam", CurrentTender.AdvertisingAlternationCount.ToString()); } string GarantyType; if (CurrentTender.StockWarranty == true) { GarantyType = "اوراق مشارکت"; } else if (CurrentTender.LcWarranty == true) { GarantyType = "ضمانتنامه بانکی"; } else if (CurrentTender.DraftWarranty == true) { GarantyType = "فیش واریزی"; } else { GarantyType = ""; } report.SetParameterValue("GarantyTypeParam", GarantyType); report.SetParameterValue("GarantyPriceParam", CurrentTender.GuarantyPrice); report.SetParameterValue("RecParam", DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentsDate).Value.Date).ToString().Substring(4)); report.SetParameterValue("RecEndParam", DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentDeadline).Value.Date).ToString().Substring(4)); report.SetParameterValue("OfferParam", DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionRecieveDate).Value.Date).ToString().Substring(4)); report.SetParameterValue("OfferEndParam", DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionOpenDate).Value.Date).ToString().Substring(4)); if (CurrentTender.IsDocForSale == true && CurrentTender.DocumentSalePrice != null) { report.SetParameterValue("SalePriceParam", CurrentTender.DocumentSalePrice); } else { report.SetParameterValue("SalePriceParam", "0"); } if (CurrentTender.HasQualityEvaluation == true) { report.SetParameterValue("QualityParam", "دارد"); } else { report.SetParameterValue("QualityParam", "ندارد"); } if (CurrentTender.HasBriefingSession == true) { report.SetParameterValue("JustiParam", "دارد"); report.SetParameterValue("JustiDateParam", DateConverter.ConvertDate((DateTime)(CurrentTender.BriefingSessionDate).Value.Date).ToString().Substring(4)); } else { report.SetParameterValue("JustiParam", "ندارد"); report.SetParameterValue("JustiDateParam", "-"); } if (CurrentTender.Description == null || CurrentTender.Description.Trim() == "") { report.SetParameterValue("NoteParam", ""); } else { report.SetParameterValue("NoteParam", CurrentTender.Description); } report.SetParameterValue("TenderId", CurrentTender.TenderingId); crystalReportsViewer1.ViewerCore.ReportSource = report; } catch { return; } }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { if (CurrentTender.StageId < (int)Stages.TenderingMeeting) { ErrorHandler.NotifyUser("ایجاد صورتجلسه توجیهی تا قبل از تایید نهایی درخواست مناقصه امکان پذیر نیست"); return; } var report = new RTM.Report.Report4.Report4_Main(); report.SetDatabaseLogon("ratec", "ratec"); report.SetParameterValue("MeetNumParam", CurrentMeet.MeetingId); report.SetParameterValue("MeetingDateParam", DateConverter.ConvertDate((DateTime)(CurrentMeet.MeetingDate).Value.Date).ToString().Substring(4)); report.SetParameterValue("RecParam", DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentsDate).Value.Date).ToString().Substring(4)); report.SetParameterValue("RecEndParam", DateConverter.ConvertDate((DateTime)(CurrentTender.RecievingDocumentDeadline).Value.Date).ToString().Substring(4)); report.SetParameterValue("OfferParam", DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionRecieveDate).Value.Date).ToString().Substring(4)); report.SetParameterValue("OfferEndParam", DateConverter.ConvertDate((DateTime)(CurrentTender.SuggestionOpenDate).Value.Date).ToString().Substring(4)); string GarantyType; if (CurrentTender.StockWarranty == true) { GarantyType = "اوراق مشارکت"; } else if (CurrentTender.LcWarranty == true) { GarantyType = "ضمانتنامه بانکی"; } else if (CurrentTender.DraftWarranty == true) { GarantyType = "فیش واریزی"; } else { GarantyType = ""; } report.SetParameterValue("GarantyTypeParam", GarantyType); report.SetParameterValue("LocParam", CurrentTender.Location); report.SetParameterValue("PriceParam", CurrentTender.GuarantyPrice.ToString().Split('.')[0]); if (CurrentTender.TenderingNumber != null) { report.SetParameterValue("TenderNumParam", CurrentTender.TenderingNumber); } else { report.SetParameterValue("TenderNumParam", "ندارد"); } if (CurrentMeet.MeetingDescription.Trim() == "" || CurrentMeet.MeetingDescription == null) { report.SetParameterValue("NoteParam", ""); } else { report.SetParameterValue("NoteParam", CurrentMeet.MeetingDescription); } string RefrenceType; if (CurrentMeet.ExtendByApplicant == true) { RefrenceType = "درخواست واحد متقاضی"; } else if (CurrentMeet.ExtendByCommittee == true) { RefrenceType = "نظر کمیسیون"; } else { RefrenceType = ""; } report.SetParameterValue("RefrenceParam", RefrenceType); report.SetParameterValue("ExtendDateParam", DateConverter.ConvertDate((DateTime)(CurrentMeet.ExtendedRecieveDate).Value.Date).ToString().Substring(4)); report.SetParameterValue("TenderId", CurrentTender.TenderingId); report.SetParameterValue("MeetId", CurrentMeet.MeetingId); string SessionType; if (CurrentMeet.MeetingType == (int)MeetingTypes.DocExtendingMeeting) { SessionType = "ارائه اسناد"; } else if (CurrentMeet.MeetingType == (int)MeetingTypes.PacketExtendingMeeting) { SessionType = "تسلیم پاکات"; } else { SessionType = ""; } report.SetParameterValue("MeetTypeParam", SessionType); crystalReportsViewer1.ViewerCore.ReportSource = report; }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var report = new RTM.Report.Report10.TenderResult(); report.SetDatabaseLogon("ratec", "ratec"); ContractorRequest z = RTM.Classes.DataManagement.RetrieveTenderingContractorRequest(Current); report.SetParameterValue("ReqID", z.ContractorRequestId); report.SetParameterValue("DateParam", DateConverter.ConvertDate((DateTime)(((z.RequestDate).Value).Date)).Substring(4)); report.SetParameterValue("DateParam1", DateConverter.ConvertDate((DateTime)(((CurrentResult.Date).Value).Date)).Substring(4)); if (CurrentResult.Renewal == true) { report.SetParameterValue("Result", "تجدید مناقصه"); report.SetParameterValue("Co1", "-----"); report.SetParameterValue("Co2", "-----"); report.SetParameterValue("Nat1", "-----"); report.SetParameterValue("Nat2", "-----"); report.SetParameterValue("Bid1", 0); report.SetParameterValue("Bid2", 0); if (CurrentResult.RenewalNote == null) { report.SetParameterValue("Note", ""); } else { report.SetParameterValue("Note", CurrentResult.RenewalNote); } } else { var Entity = new RTMEntities(); var x = (from n in Entity.Contractors where n.ContractorId == CurrentResult.FirstContractorWinnerId select n).FirstOrDefault(); var y = (from n in Entity.Contractors where n.ContractorId == CurrentResult.SecondContractorWinnerId select n).FirstOrDefault(); report.SetParameterValue("Result", "اعلام برنده"); if (x == null) { report.SetParameterValue("Co1", "----"); } else { report.SetParameterValue("Co1", x.CompanyName); } if (y == null) { report.SetParameterValue("Co2", "----"); } else { report.SetParameterValue("Co2", y.CompanyName); } if (x == null) { report.SetParameterValue("Nat1", "----"); } else { report.SetParameterValue("Nat1", x.NationalIdNumber); } if (y == null) { report.SetParameterValue("Nat2", "----"); } else { report.SetParameterValue("Nat2", y.NationalIdNumber); } if (x == null) { report.SetParameterValue("Bid1", 0); } else if (CurrentResult.FirstBid == null) { RTM.Classes.ErrorHandler.NotifyUser("قیمت ها به درستی ثبت نشده"); return; } else { report.SetParameterValue("Bid1", CurrentResult.FirstBid); } if (y == null) { report.SetParameterValue("Bid2", 0); } else if (CurrentResult.SecondBid == null) { RTM.Classes.ErrorHandler.NotifyUser("قیمت ها به درستی ثبت نشده"); return; } else { report.SetParameterValue("Bid2", CurrentResult.SecondBid); } if (CurrentResult.Notes == null) { report.SetParameterValue("Note", ""); } else { report.SetParameterValue("Note", CurrentResult.Notes); } } crystalReportsViewer1.ViewerCore.ReportSource = report; }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var Entity = new RTMEntities(); ////////Login Info ConnectionInfo crConnection = new ConnectionInfo(); crConnection.ServerName = @"Gis-Server"; crConnection.DatabaseName = "ratec"; crConnection.UserID = "ratec"; crConnection.Password = "******"; //crConnection.ServerName = @"."; //crConnection.DatabaseName = "ratec"; //crConnection.UserID = "sa"; //crConnection.Password = "******"; CrystalDecisions.CrystalReports.Engine.Tables tables = report.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables) { CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo; tableLogonInfo.ConnectionInfo = crConnection; table.ApplyLogOnInfo(tableLogonInfo); } //////// var x = (from n in Entity.OrganizationalCharts where n.ChartNodeId == CurrentContract.SupervisingUnitHigher select n).FirstOrDefault(); CalculateExtrasContract(); //report.SetDatabaseLogon("ratec", "ratec"); report.SetParameterValue("ContractId", CurrentContract.Contractid); report.SetParameterValue("DraftId", CurrentDraft.PaymentDraftId); report.SetParameterValue("Date", DateConverter.ConvertDate((DateTime)(((CurrentContract.ContractDate).Value).Date)).Substring(4)); if (Convert.ToString(CurrentDraft.PayableAmount) != string.Empty) { report.SetParameterValue("Amount", CurrentDraft.PayableAmount); } else { report.SetParameterValue("Amount", 0); } if (x != null) { report.SetParameterValue("Supervisor", x.Title); } else { report.SetParameterValue("Supervisor", "-"); } ////////////////////////////////////////////////////////////////////////// you have a problem here in your code decimal B; if (CurrentDraft.EmployerInsurancePercentage != 0 || CurrentDraft.EmployerInsurancePercentage != null) { B = ((((decimal)CurrentDraft.CurrentSituationDraft) - ((decimal)CurrentDraft.PerviousSituationDraft)) * (((decimal)(CurrentDraft.EmployerInsurancePercentage)) / 100)); } else { B = ((((decimal)CurrentDraft.CurrentSituationDraft) - ((decimal)CurrentDraft.PerviousSituationDraft))); } report.SetParameterValue("Bimeh", B); report.SetParameterValue("HaveTrans", HaveTrans); // added by naseri PNumberTString dd = new PNumberTString(); decimal Subtract = (((decimal)CurrentDraft.CurrentSituationDraft) - ((decimal)CurrentDraft.PerviousSituationDraft)); report.SetParameterValue("Subtract", Subtract); try { report.SetParameterValue("NumToWord", dd.num2str(Convert.ToString(Convert.ToInt64(CurrentDraft.PayableAmount)))); } catch (Exception) {} if (!HaveTrans) { report.SetParameterValue("User", string.Empty); } // added by naseri crystalReportsViewer1.ViewerCore.ReportSource = report; }
private void CalculateExtrasContract() { using (var en = new RTMEntities()) { var complements = ( from items in en.ContractDocFileRelations where items.ContractId == CurrentContract.Contractid && (items.ContractDocId == 1 || items.ContractDocId == 2) select items.FileId).ToList(); var lastPercentage = ( from items in en.ContractFiles where complements.Contains(items.FileId) && items.Is25Percent == true select items).ToList().LastOrDefault(); if (lastPercentage != null) { report.SetParameterValue("25Num", lastPercentage.NotificationNumber); report.SetParameterValue("25Date", DateConverter.ConvertDate((DateTime)(lastPercentage.NotificationDate).Value.Date).Substring(4)); } else { report.SetParameterValue("25Num", "-"); report.SetParameterValue("25Date", "-"); } double?SumPercentage = (double?)( from items in en.ContractFiles where complements.Contains(items.FileId) && items.Is25Percent == true select items.Percent).ToList().Sum(); SumPercentage = SumPercentage * (double?)CurrentContract.ContractBudget / 100; report.SetParameterValue("25Price", SumPercentage == null?0:SumPercentage); double?amount = (double?)( from items in en.ContractFiles where complements.Contains(items.FileId) && items.IsExtend == true select items.Amount).ToList().Sum(); report.SetParameterValue("CompletePrice", amount == null?0:amount); var lastComplement = ( from items in en.ContractFiles where complements.Contains(items.FileId) && items.IsExtend == true select items).ToList().LastOrDefault(); if (lastComplement != null) { report.SetParameterValue("CompleteNum", lastComplement.NotificationNumber); report.SetParameterValue("CompleteDate", DateConverter.ConvertDate((DateTime)(lastComplement.AttachedDate).Value.Date).Substring(4)); } else { report.SetParameterValue("CompleteNum", "-"); report.SetParameterValue("CompleteDate", "-"); } report.SetParameterValue("PrintDate", DateConverter.ConvertDate((DateTime)(CurrentDraft.Date).Value.Date).Substring(4)); if (CurrentDraft.ModelTitle == null) { report.SetParameterValue("ModelTitle", "-"); } else { report.SetParameterValue("ModelTitle", CurrentDraft.ModelTitle); } var consultant = (from n in en.Contractors where n.ContractorId == CurrentContract.ConsultantId select n).FirstOrDefault(); if (consultant == null) { report.SetParameterValue("Consultant", "-"); } else { report.SetParameterValue("Consultant", consultant.CompanyName); } if (CurrentDraft.Notes == null || CurrentDraft.Notes.Trim() == "") { report.SetParameterValue("NoteParam", "-"); } else { report.SetParameterValue("NoteParam", CurrentDraft.Notes); } if (CurrentContract.ContractTtile == null || CurrentContract.ContractTtile.Trim() == "") { report.SetParameterValue("ContractTitle", "-"); } else { report.SetParameterValue("ContractTitle", CurrentContract.ContractTtile); } report.SetParameterValue("User", "صادرکننده : " + UserData.CurrentUser.Name + " " + UserData.CurrentUser.Family); } }