private void ShowButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
DataTable CanceledTurnsTable = new DataTable();
HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new BLL.TrafficBLL.BLLTraffic_TFactory();
TrafficFactory.SelectCanceledTurns(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, FromTimeTextBox.Text, ToTimeTextBox.Text, CanceledTurnsTable);
CanceledTurnsGridView.DataSource = CanceledTurnsTable;
//AllCanceledTurnstiReport.Show();
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
//HPS.Reports.ReportDoc.ServicesCountPriceReprt rpt = new HPS.Reports.ReportDoc.ServicesCountPriceReprt(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text);
//rpt.Document.Printer.PrinterName = string.Empty;
//viewer1.Document = rpt.Document;
//rpt.Run();
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
HPS.BLL.TrafficBLL.BLLTraffic_TFactory plateNumberFatory = new BLL.TrafficBLL.BLLTraffic_TFactory();
DataTable trafficPicturesTable = new DataTable();
plateNumberFatory.SelectTypeandLasteIn(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, FromTimeTextBox.Text, ToTimeTextBox.Text, trafficPicturesTable);
TypeandLastInGrid.DataSource = trafficPicturesTable;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
LoadOnlineCardChecking();
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
//HPS.Reports.ReportDoc.AllLaderTypeTurnReport rpt = new HPS.Reports.ReportDoc.AllLaderTypeTurnReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text);
//rpt.Document.Printer.PrinterName = string.Empty;
//viewer1.Document = rpt.Document;
//rpt.Run();
HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
AllLaderTypeTurnstiReport.Dictionary.Synchronize();
AllLaderTypeTurnstiReport.Dictionary.Databases.Clear();
AllLaderTypeTurnstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
AllLaderTypeTurnstiReport.Compile();
AllLaderTypeTurnstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory();
AllLaderTypeTurnstiReport["@FromDate_nvc"] = FromDatefaDatePicker.Text;
AllLaderTypeTurnstiReport["@FromTime_nvc"] = FromTimeTextBox.Text;
AllLaderTypeTurnstiReport["@ToDate_nvc"] = ToDatefaDatePicker.Text;
AllLaderTypeTurnstiReport["@ToTime_nvc"] = ToTimeTextBox.Text;
AllLaderTypeTurnstiReport["fromdate_vc"] = FromDatefaDatePicker.Text;
AllLaderTypeTurnstiReport["todate_vc"] = ToDatefaDatePicker.Text;
AllLaderTypeTurnstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;;
AllLaderTypeTurnstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc;
AllLaderTypeTurnstiReport["FromTime_vc"] = FromTimeTextBox.Text;
AllLaderTypeTurnstiReport["ToTime_vc"] = ToTimeTextBox.Text;
AllLaderTypeTurnstiReport.Render();
this.stiViewerControl1.Report = AllLaderTypeTurnstiReport;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ChartShowButton_Click(object sender, EventArgs e)
{
try
{
ExistsLaderTypeGridView.Visible = false;
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
object[] LaderTypeList = new object[100];
string LaderTypeList_nvc = string.Empty;
int index = 0;
LaderTypeList = LaderTypecheckedComboBox.CheckedValues;
if (LaderTypeList != null)
{
foreach (object obj in LaderTypeList)
{
LaderTypeList_nvc = string.Format("{0},{1}", LaderTypeList_nvc, LaderTypeList[index].ToString());
index += 1;
}
LaderTypeList_nvc = LaderTypeList_nvc.Substring(1, LaderTypeList_nvc.Length - 1);
}
if (string.IsNullOrEmpty(LaderTypeList_nvc))
{
throw new ApplicationException("نوع بارگیر انتخاب نشده است");
}
if (LaderTypecheckedComboBox.CheckedValues.Length > 1)
{
throw new ApplicationException("یک بارگیر را انتخاب کنید");
}
//HPS.Reports.ReportDoc.LaderTypeCountChart rpt = new HPS.Reports.ReportDoc.LaderTypeCountChart(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, LaderTypeList_nvc);
//rpt.Document.Printer.PrinterName = string.Empty;
//viewer1.Document = rpt.Document;
//rpt.Run();
LaderTypeCountChartstiReport.Dictionary.Synchronize();
LaderTypeCountChartstiReport.Dictionary.Databases.Clear();
LaderTypeCountChartstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
LaderTypeCountChartstiReport.Compile();
LaderTypeCountChartstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory();
LaderTypeCountChartstiReport["fromDate_nvc"] = FromDatefaDatePicker.Text;
LaderTypeCountChartstiReport["toDate_nvc"] = ToDatefaDatePicker.Text;
LaderTypeCountChartstiReport["fromTime_nvc"] = FromTimeTextBox.Text;
LaderTypeCountChartstiReport["toTime_nvc"] = ToTimeTextBox.Text;
LaderTypeCountChartstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;;
LaderTypeCountChartstiReport["userName_nvc"] = HPS.Common.CurrentUser.user.UserName_nvc;
LaderTypeCountChartstiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text;
LaderTypeCountChartstiReport["@todate_nvc"] = ToDatefaDatePicker.Text;
LaderTypeCountChartstiReport["@fromtime_nvc"] = FromTimeTextBox.Text;
LaderTypeCountChartstiReport["@totime_nvc"] = ToTimeTextBox.Text;
LaderTypeCountChartstiReport["@LaderTypeList"] = LaderTypeList_nvc;
LaderTypeCountChartstiReport.Render();
//this.stiViewerControl1.Report = LaderTypeCountChartstiReport;
LaderTypeCountChartstiReport.Show();
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
ExistsLaderTypeGridView.Visible = false;
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
object[] LaderTypeList = new object[100];
string LaderTypeList_nvc = string.Empty;
int index = 0;
LaderTypeList = LaderTypecheckedComboBox.CheckedValues;
if (LaderTypeList != null)
{
foreach (object obj in LaderTypeList)
{
LaderTypeList_nvc = string.Format("{0},{1}", LaderTypeList_nvc, LaderTypeList[index].ToString());
index += 1;
}
LaderTypeList_nvc = LaderTypeList_nvc.Substring(1, LaderTypeList_nvc.Length - 1);
}
//HPS.Reports.ReportDoc.LaderTypeCountReport rpt = new HPS.Reports.ReportDoc.LaderTypeCountReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, LaderTypeList_nvc);
//rpt.Document.Printer.PrinterName = string.Empty;
//viewer1.Document = rpt.Document;
//rpt.Run();
//پر کردن دیتا تیبل
//HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
//DataTable LaderTypeReportTable = new DataTable();
//DataSet LaderTypeDataSet = new DataSet();
//LadeAssignmentFactory.SelectLaderTypeCountReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox .Text, LaderTypeList_nvc, ref LaderTypeReportTable);
////اضافه کردن ستون جدید به جدول
//if (LaderTypeReportTable != null && LaderTypeReportTable.Rows.Count > 0)
//{
// LaderTypeReportTable.Columns.Add("RemainedPercent");
// foreach (DataRow row in LaderTypeReportTable.Rows)
// {
// double RemainedPercent = (Convert.ToDouble(row["RemainderCar_int"]) * 100) / Convert.ToDouble(row["CarCount_int"]);
// row["RemainedPercent"] = RemainedPercent.ToString("0.##");
// }
//}
//Int64? AllLadeAssignmentcount = (from row in LaderTypeReportTable.AsEnumerable() select (Int32)row["CarCount_int"]).Sum();
//Int64? AllLadBillcountRecords = (from row in LaderTypeReportTable.AsEnumerable() select (Int32)row["LadBill"]).Sum();
//Int64? allcanceledByCompany = (from row in LaderTypeReportTable.AsEnumerable() select (Int32)row["CanceledByCompany"]).Sum();
//Int64? allcanceledByLadBillCanceled = (from row in LaderTypeReportTable.AsEnumerable() select (Int32)row["CanceledByLadBillCanceled"]).Sum();
////AllRemainderCounttxt.Text = (Convert.ToInt64(AllLadeAssignmentcount) - Convert.ToInt64(AllLadBillcountRecords) - Convert.ToInt64(allcanceledByCompany) - Convert.ToInt64(allcanceledByLadBillCanceled)).ToString(); //Allremaindercount.HasValue ? Allremaindercount.ToString() : "0";
//AllRemainedPercenttxt.Text = ((Convert.ToDouble(AllRemainderCounttxt.Text)) * 100 / (Convert.ToDouble(AllLadeAssignmentCountxt.Text))).ToString("0.##");
//اضافه کردن دیتاتیبل به دیتا ست
//LaderTypeDataSet.Tables.Add(LaderTypeReportTable.Copy());
//کدهای استیمیول
LederTypeCountReportstiReport.Dictionary.Synchronize();
LederTypeCountReportstiReport.Dictionary.Databases.Clear();
LederTypeCountReportstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
LederTypeCountReportstiReport.Compile();
LederTypeCountReportstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory();
//مقدار دهی متغیرها
LederTypeCountReportstiReport["fromDate_nvc"] = FromDatefaDatePicker.Text;
LederTypeCountReportstiReport["fromTime_nvc"] = FromTimeTextBox.Text;
LederTypeCountReportstiReport["toTime_nvc"] = ToTimeTextBox.Text;
LederTypeCountReportstiReport["toDate_nvc"] = ToDatefaDatePicker.Text;
LederTypeCountReportstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;;
LederTypeCountReportstiReport["userName_nvc"] = HPS.Common.CurrentUser.user.UserName_nvc;
LederTypeCountReportstiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text;
LederTypeCountReportstiReport["@fromtime_nvc"] = FromTimeTextBox.Text;
LederTypeCountReportstiReport["@totime_nvc"] = ToTimeTextBox.Text;
LederTypeCountReportstiReport["@todate_nvc"] = ToDatefaDatePicker.Text;
if (!(LaderTypeList_nvc == ""))
{
LederTypeCountReportstiReport["@LaderTypeList"] = LaderTypeList_nvc;
}
//LederTypeCountReportstiReport["@CompanyID_int"] = FromDatefaDatePicker.Text;
//LederTypeCountReportstiReport["@GoodIDList_nvc"] = FromTimeTextBox.Text;
//LederTypeCountReportstiReport["@DestinationCityIDList_nvc"] = ToTimeTextBox.Text;
//LederTypeCountReportstiReport["@PortPlaceIDList_nvc"] = ToDatefaDatePicker.Text;
//LederTypeCountReportstiReport["@OrderColumns_nvc"] = LaderTypeList_nvc;
LederTypeCountReportstiReport.Render();
//LederTypeCountReportstiReport.Show();
stiViewerControl1.Report = LederTypeCountReportstiReport;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
string CompanyList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in companyGrid.GetCheckedRows())
{
CompanyList_nvc += itm.Cells["CompanyID_int"].Value.ToString() + ",";
}
if (CompanyList_nvc.EndsWith(","))
{
CompanyList_nvc = CompanyList_nvc.Remove(CompanyList_nvc.Length - 1);
}
companyGrid.UnCheckAllRecords();
string LaderTypeList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in laderTypeGrid.GetCheckedRows())
{
LaderTypeList_nvc += itm.Cells["LaderTypeID_int"].Value.ToString() + ",";
}
if (LaderTypeList_nvc.EndsWith(","))
{
LaderTypeList_nvc = LaderTypeList_nvc.Remove(LaderTypeList_nvc.Length - 1);
}
laderTypeGrid.UnCheckAllRecords();
string GoodList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in goodGrid.GetCheckedRows())
{
GoodList_nvc += itm.Cells["GoodID_int"].Value.ToString() + ",";
}
if (GoodList_nvc.EndsWith(","))
{
GoodList_nvc = GoodList_nvc.Remove(GoodList_nvc.Length - 1);
}
goodGrid.UnCheckAllRecords();
string PortPlaceList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in portPlaceGrid.GetCheckedRows())
{
PortPlaceList_nvc += itm.Cells["PortPlacesID_int"].Value.ToString() + ",";
}
if (PortPlaceList_nvc.EndsWith(","))
{
PortPlaceList_nvc = PortPlaceList_nvc.Remove(PortPlaceList_nvc.Length - 1);
}
portPlaceGrid.UnCheckAllRecords();
string DestinationCityList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in destinationCityGrid.GetCheckedRows())
{
DestinationCityList_nvc += itm.Cells["CityID_int"].Value.ToString() + ",";
}
if (DestinationCityList_nvc.EndsWith(","))
{
DestinationCityList_nvc = DestinationCityList_nvc.Remove(DestinationCityList_nvc.Length - 1);
}
destinationCityGrid.UnCheckAllRecords();
//HPS.Reports.ReportDoc.CompanyLadeAssignmentDetailReport rpt = new HPS.Reports.ReportDoc.CompanyLadeAssignmentDetailReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, LaderTypeList_nvc, CompanyList_nvc, GoodList_nvc, DestinationCityList_nvc, PortPlaceList_nvc);
//viewer1.Document = rpt.Document;
//rpt.Document.Printer.PrinterName = string.Empty;
//rpt.Run();
CompanyLadeAssignmentDetailReportstiReport.Dictionary.Synchronize();
CompanyLadeAssignmentDetailReportstiReport.Dictionary.Databases.Clear();
CompanyLadeAssignmentDetailReportstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
CompanyLadeAssignmentDetailReportstiReport.Compile();
HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory();
CompanyLadeAssignmentDetailReportstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
CompanyLadeAssignmentDetailReportstiReport["FromDate_vc"] = FromDatefaDatePicker.Text;
CompanyLadeAssignmentDetailReportstiReport["ToDate_vc"] = ToDatefaDatePicker.Text;
CompanyLadeAssignmentDetailReportstiReport["FromTime_vc"] = FromTimeTextBox.Text;
CompanyLadeAssignmentDetailReportstiReport["ToTime_vc"] = ToTimeTextBox.Text;
CompanyLadeAssignmentDetailReportstiReport["Date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;;
CompanyLadeAssignmentDetailReportstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc;
CompanyLadeAssignmentDetailReportstiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text;
CompanyLadeAssignmentDetailReportstiReport["@todate_nvc"] = ToDatefaDatePicker.Text;
CompanyLadeAssignmentDetailReportstiReport["@fromtime_nvc"] = FromTimeTextBox.Text;
CompanyLadeAssignmentDetailReportstiReport["@totime_nvc"] = ToTimeTextBox.Text;
if (string.IsNullOrEmpty(LaderTypeList_nvc))
{
CompanyLadeAssignmentDetailReportstiReport["@LaderTypeID_int"] = DBNull.Value;
}
else
{
CompanyLadeAssignmentDetailReportstiReport["@LaderTypeID_int"] = LaderTypeList_nvc;
}
if (string.IsNullOrEmpty(CompanyList_nvc))
{
CompanyLadeAssignmentDetailReportstiReport["@CompanyID_int"] = DBNull.Value;
}
else
{
CompanyLadeAssignmentDetailReportstiReport["@CompanyID_int"] = CompanyList_nvc;
}
if (string.IsNullOrEmpty(GoodList_nvc))
{
CompanyLadeAssignmentDetailReportstiReport["@GoodIDList_nvc"] = DBNull.Value;
}
else
{
CompanyLadeAssignmentDetailReportstiReport["@GoodIDList_nvc"] = GoodList_nvc;
}
if (string.IsNullOrEmpty(DestinationCityList_nvc))
{
CompanyLadeAssignmentDetailReportstiReport["@DestinationCityIDList_nvc"] = DBNull.Value;
}
else
{
CompanyLadeAssignmentDetailReportstiReport["@DestinationCityIDList_nvc"] = DestinationCityList_nvc;
}
if (string.IsNullOrEmpty(PortPlaceList_nvc))
{
CompanyLadeAssignmentDetailReportstiReport["@PortPlaceIDList_nvc"] = DBNull.Value;
}
else
{
CompanyLadeAssignmentDetailReportstiReport["@PortPlaceIDList_nvc"] = PortPlaceList_nvc;
}
CompanyLadeAssignmentDetailReportstiReport["@OrderColumns_nvc"] = DBNull.Value;
CompanyLadeAssignmentDetailReportstiReport.Render();
this.stiViewerControl1.Report = CompanyLadeAssignmentDetailReportstiReport;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
Hepsa.Core.BLL.BLLAction_TFactory ActionFactory = new Hepsa.Core.BLL.BLLAction_TFactory();
try
{
//ExistsLaderTypeGridView.Visible = false;
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
InCountstiReport.Dictionary.Synchronize();
InCountstiReport.Dictionary.Databases.Clear();
InCountstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
InCountstiReport.Compile();
InCountstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
InCountstiReport["fromdate"] = FromDatefaDatePicker.Text;
InCountstiReport["todate"] = ToDatefaDatePicker.Text;
InCountstiReport["fromtime_nvc"] = FromTimeTextBox.Text;
InCountstiReport["totime_nvc"] = ToTimeTextBox.Text;
InCountstiReport["date"] = ActionFactory.ServerJalaliDate;
InCountstiReport["UserName"] = HPS.Common.CurrentUser.user.UserName_nvc;
InCountstiReport["@FromDate_nvc"] = FromDatefaDatePicker.Text;
InCountstiReport["@ToDate_nvc"] = ToDatefaDatePicker.Text;
InCountstiReport["@fromtime_nvc"] = FromTimeTextBox.Text;
InCountstiReport["@totime_nvc"] = ToTimeTextBox.Text;
InCountstiReport.Render();
InCountstiViewerControl.Report = InCountstiReport;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
BLL.TrafficBLL.BLLTraffic_TFactory factory = new BLL.TrafficBLL.BLLTraffic_TFactory();
DT.DataTable dt;
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
if (_TrafficType == 1)
{
string Turn = string.Empty;
if (TurnAcceptedradioButton.Checked == true)
{
Turn = "Traffic_T.TurnAccepted_bit=1 ";
}
else if (AllTurnradioButton.Checked == true)
{
Turn = "Traffic_T.TurnAccepted_bit IS NULL";
}
if (!string.IsNullOrEmpty(Turn))
{
Turn += " AND ";
}
Turn += " Traffic_T.TrafficNumber_bint NOT IN (SELECT trafficNumber_bint FROM Traffic_T WHERE Traffic_T.Out_bit = 1 AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc >= '" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "') AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc <='" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "') ) AND Traffic_T.TrafficNumber_bint NOT IN (SELECT trafficNumber_bint FROM Traffic_T WHERE Traffic_T.TemporaryOut_bit = 1 AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc >= '" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "') AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc <='" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "')) AND ";
//HPS.Reports.ReportDoc.IranianInTrafficReport rpt = new HPS.Reports.ReportDoc.IranianInTrafficReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, "1", FromTimeTextBox.Text, ToTimeTextBox.Text, FromTrafficNumbertxt.Text, ToTrafficNumbertxt.Text,
// Convert.ToString(LaderPivotGroupID_intComboBox.SelectedValue), Convert.ToString(LaderTypeID_intComboBox.SelectedValue), Convert.ToString(ServicescomboBox.SelectedValue), Turn);
//rpt.Document.Printer.PrinterName = string.Empty;
//viewer1.Document = rpt.Document;
//rpt.Run();
IranianInTrafficstiReport.Dictionary.Synchronize();
IranianInTrafficstiReport.Dictionary.Databases.Clear();
IranianInTrafficstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
IranianInTrafficstiReport.Compile();
IranianInTrafficstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory();
IranianInTrafficstiReport["fromdate_vc"] = FromDatefaDatePicker.Text;
IranianInTrafficstiReport["todate_vc"] = ToDatefaDatePicker.Text;
IranianInTrafficstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;;
IranianInTrafficstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc;
IranianInTrafficstiReport["fromTrafficNumber"] = FromTrafficNumbertxt.Text;
IranianInTrafficstiReport["toTrafficNumber"] = ToTrafficNumbertxt.Text;
IranianInTrafficstiReport["FromTime_vc"] = FromTimeTextBox.Text;
IranianInTrafficstiReport["ToTime_vc"] = ToTimeTextBox.Text;
if (string.IsNullOrEmpty(FromDatefaDatePicker.Text))
{
IranianInTrafficstiReport["@FromDateTime_nvc"] = DBNull.Value;
}
else
{
IranianInTrafficstiReport["@FromDateTime_nvc"] = FromDatefaDatePicker.Text + ' ' + FromTimeTextBox.Text;
}
if (string.IsNullOrEmpty(ToDatefaDatePicker.Text))
{
IranianInTrafficstiReport["@ToDateTime_nvc"] = DBNull.Value;
}
else
{
IranianInTrafficstiReport["@ToDateTime_nvc"] = ToDatefaDatePicker.Text + ' ' + ToTimeTextBox.Text;
}
if (string.IsNullOrEmpty(FromTrafficNumbertxt.Text))
{
IranianInTrafficstiReport["@FromTrafficNumber_nvc"] = DBNull.Value;
}
else
{
IranianInTrafficstiReport["@FromTrafficNumber_nvc"] = FromTrafficNumbertxt.Text;
}
if (string.IsNullOrEmpty(ToTrafficNumbertxt.Text))
{
IranianInTrafficstiReport["@ToTrafficNumber_nvc"] = DBNull.Value;
}
else
{
IranianInTrafficstiReport["@ToTrafficNumber_nvc"] = ToTrafficNumbertxt.Text;
}
if (LaderPivotGroupID_intComboBox.SelectedValue == null)
{
IranianInTrafficstiReport["@LaderPivotGroupID_nvc"] = DBNull.Value;
}
else
{
IranianInTrafficstiReport["@LaderPivotGroupID_nvc"] = LaderPivotGroupID_intComboBox.SelectedValue;
}
//@LaderTypeID_nvc
if (LaderTypeID_intComboBox.SelectedValue == null)
{
IranianInTrafficstiReport["@LaderTypeID_nvc"] = DBNull.Value;
}
else
{
IranianInTrafficstiReport["@LaderTypeID_nvc"] = LaderTypeID_intComboBox.SelectedValue;
}
//@ServiceID_nvc
if (ServicescomboBox.SelectedValue == null)
{
IranianInTrafficstiReport["@ServiceID_nvc"] = DBNull.Value;
}
else
{
IranianInTrafficstiReport["@ServiceID_nvc"] = ServicescomboBox.SelectedValue;
}
// @TrafficTypeID_nvc ,
IranianInTrafficstiReport["@TrafficTypeID_nvc"] = 1;
IranianInTrafficstiReport["@TrafficInbit_nvc"] = 1;
IranianInTrafficstiReport["@TrafficOutbit_nvc"] = DBNull.Value;
IranianInTrafficstiReport["@TurnAccepted_nvc"] = Turn;
if (LaderPivotGroupID_intComboBox.SelectedValue != null)
{
if (Convert.ToInt32(LaderPivotGroupID_intComboBox.SelectedValue) == 1)
{
IranianInTrafficstiReport["PivotGrouptxt"] = "(دو محور)";
}
else if (Convert.ToInt32(LaderPivotGroupID_intComboBox.SelectedValue) == 2)
{
IranianInTrafficstiReport["PivotGrouptxt"] = "(سه محور به بالا)";
}
}
else
{
IranianInTrafficstiReport["PivotGrouptxt"] = "(تمامی کامیون ها)";
}
if (LaderTypeID_intComboBox.SelectedValue != null)
{
IranianInTrafficstiReport["PivotGrouptxt"] = (string)Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(this.LaderTypeID_intComboBox);
}
IranianInTrafficstiReport.Render();
stiViewerControl1.Report = IranianInTrafficstiReport;
dt = new DT.DataTable();
ExportExcelDt = new System.Data.DataTable();
factory.ReportSelectByFieds(
IranianInTrafficstiReport["@FromDateTime_nvc"],
IranianInTrafficstiReport["@ToDateTime_nvc"],
IranianInTrafficstiReport["@FromTrafficNumber_nvc"],
IranianInTrafficstiReport["@ToTrafficNumber_nvc"],
IranianInTrafficstiReport["@LaderPivotGroupID_nvc"],
IranianInTrafficstiReport["@LaderTypeID_nvc"],
IranianInTrafficstiReport["@TrafficTypeID_nvc"],
IranianInTrafficstiReport["@TrafficInbit_nvc"],
IranianInTrafficstiReport["@TrafficOutbit_nvc"],
IranianInTrafficstiReport["@ServiceID_nvc"],
Turn, ref dt);
Dictionary <string, string> Columns = new Dictionary <string, string>();
Columns.Add("TrafficNumber_bint", "شماره قبض");
Columns.Add("TurnNumber_bint", "شماره نوبت");
Columns.Add("DriverCardNumber_nvc", "شماره کارت راننده ");
Columns.Add("carCardNumber_nvc", "شماره کارت ناوگان");
Columns.Add("FirstName_nvc", "نام راننده");
Columns.Add("LastName_nvc", "نام خانوادگی راننده");
Columns.Add("NumberPlate_nvc", "شماره پلاک");
Columns.Add("UserName_nvc", "کاربر");
Columns.Add("Date_nvc", "تاریخ ورود");
Columns.Add("Time_nvc", "زمان ورود");
Columns.Add("EditUserName_nvc", "کاربر تایید کننده");
Columns.Add("TurnDate_nvc", "ترایخ نوبت");
Columns.Add("TurnTime_nvc", "زمان نوبت");
Columns.Add("PriceNoTax_dec", "مبلغ");
Columns.Add("PriceTax_dec", "ارزش افزوده");
Columns.Add("Price_dec", "مبلغ دریافتی");
Columns.Add("WithLade_bit", "با بار");
Columns.Add("ServiceID_intServiceType_nvc", "مراجعه به");
foreach (var col in Columns)
{
ExportExcelDt.Columns.Add(col.Value, col.Key.EndsWith("_bit") ? typeof(bool) : typeof(string));
}
DataRow dr;
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
dr = ExportExcelDt.NewRow();
for (int j = 0; j < Columns.Count; j++)
{
dr[j] = dt.Rows[i][Columns.Keys.ElementAt(j)];
}
ExportExcelDt.Rows.Add(dr);
}
//gridControl1.DataSource = dt;
//gridView1.Columns.Clear();
////gridView1.PopulateColumns();
//GridColumn column;
//int x = 0;
//foreach (DataColumn i in dt.Columns)
//{
// x++;
// if (x == 6)
// break;
// column = new GridColumn() { FieldName = i.ColumnName,Width = 200,MinWidth = 200,MaxWidth = 200};
// Columns.Add();
//}
//gridView1.PopulateColumns(Columns);
//gridView1.RefreshData();
//foreach (GridColumn clm in gridView1.Columns)
//{
// clm.Width = clm.MinWidth = clm.MaxWidth = 200;
//}
}
if (_TrafficType == 2)
{
//HPS.Reports.ReportDoc.ForeignInTrafficReport rpt = new HPS.Reports.ReportDoc.ForeignInTrafficReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, 2, FromTimeTextBox.Text, ToTimeTextBox.Text, FromTrafficNumbertxt.Text, ToTrafficNumbertxt.Text);
//rpt.Document.Printer.PrinterName = string.Empty;
//viewer1.Document = rpt.Document;
//rpt.Run();
HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
DT.DataTable TrafficDataTable = new DT.DataTable();
string Condition = string.Empty;
string FromTime = FromTimeTextBox.Text;
string ToTime = ToTimeTextBox.Text;
string FromTrafficNumber = FromTrafficNumbertxt.Text;
string ToTrafficNumber = ToTrafficNumbertxt.Text;
string FromDate = FromDatefaDatePicker.Text;
string ToDate = ToDatefaDatePicker.Text;
if (!(string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)) && (string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime)))
{
Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc>='" + FromDate + "') AND (T.Date_nvc<='" + ToDate + "') AND (T.TrafficNumber_bint>='" + FromTrafficNumber + "') AND (T.TrafficNumber_bint<='" + ToTrafficNumber + "')";
}
else if (string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime) && (string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)))
{
Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc>='" + FromDate + "') AND (T.Date_nvc<='" + ToDate + "')";
}
else if (!(string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime)) && string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber))
{
Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc+ ' ' +T.Time_nvc>='" + FromDate + ' ' + FromTime + "' ) AND (T.Date_nvc + ' ' + T.Time_nvc<='" + ToDate + ' ' + ToTime + "')";
}
else if (!((string.IsNullOrEmpty(FromTime) && string.IsNullOrEmpty(ToTime)) && string.IsNullOrEmpty(FromTrafficNumber) && string.IsNullOrEmpty(ToTrafficNumber)))
{
Condition = "(T.In_bit='True') AND (T.TrafficTypeID_int='2') AND (T.Date_nvc + ' ' + T.Time_nvc>='" + FromDate + ' ' + FromTime + "' ) AND (T.Date_nvc + ' ' + T.Time_nvc<='" + ToDate + ' ' + ToTime + "') AND (T.TrafficNumber_bint>='" + FromTrafficNumber + "') AND (T.TrafficNumber_bint<='" + ToTrafficNumber + "')";
}
dt = new DT.DataTable();
ExportExcelDt = new System.Data.DataTable();
ForeignInTrafficReportStiReport.Dictionary.Synchronize();
ForeignInTrafficReportStiReport.Dictionary.Databases.Clear();
ForeignInTrafficReportStiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
ForeignInTrafficReportStiReport.Compile();
ForeignInTrafficReportStiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory();
ForeignInTrafficReportStiReport["@Condition"] = Condition;
ForeignInTrafficReportStiReport["fromdate_vc"] = FromDatefaDatePicker.Text;
ForeignInTrafficReportStiReport["todate_vc"] = ToDatefaDatePicker.Text;
ForeignInTrafficReportStiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;;
ForeignInTrafficReportStiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc;
ForeignInTrafficReportStiReport["fromTrafficNumber"] = FromTrafficNumbertxt.Text;
ForeignInTrafficReportStiReport["toTrafficNumber"] = ToTrafficNumbertxt.Text;
ForeignInTrafficReportStiReport["FromTime_vc"] = FromTimeTextBox.Text;
ForeignInTrafficReportStiReport["ToTime_vc"] = ToTimeTextBox.Text;
ForeignInTrafficReportStiReport.Render();
stiViewerControl1.Report = ForeignInTrafficReportStiReport;
factory.GetAllByConditionAllTraffic(Condition, ref dt);
Dictionary <string, string> Columns = new Dictionary <string, string>();
Columns.Add("TrafficNumber_bint", "شماره قبض");
//Columns.Add("TurnNumber_bint", "شماره نوبت");
//Columns.Add("DriverCardNumber_nvc", "شماره کارت راننده ");
//Columns.Add("carCardNumber_nvc", "شماره کارت ناوگان");
Columns.Add("FirstName_nvc", "نام راننده");
Columns.Add("LastName_nvc", "نام خانوادگی راننده");
Columns.Add("NumberPlate_nvc", "شماره پلاک");
Columns.Add("UserName_nvc", "کاربر");
Columns.Add("Date_nvc", "تاریخ ورود");
Columns.Add("Time_nvc", "زمان ورود");
Columns.Add("EditUserName_nvc", "کاربر تایید کننده");
//Columns.Add("TurnDate_nvc", "تاریخ نوبت");
//Columns.Add("TurnTime_nvc", "زمان نوبت");
Columns.Add("PriceNoTax_dec", "مبلغ");
Columns.Add("PriceTax_dec", "ارزش افزوده");
Columns.Add("Price_dec", "مبلغ دریافتی");
Columns.Add("WithLade_bit", "با بار");
Columns.Add("ServiceID_intServiceType_nvc", "مراجعه به");
foreach (var col in Columns)
{
ExportExcelDt.Columns.Add(col.Value, col.Key.EndsWith("_bit") ? typeof(bool) : typeof(string));
}
DataRow dr;
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
dr = ExportExcelDt.NewRow();
for (int j = 0; j < Columns.Count; j++)
{
dr[j] = dt.Rows[i][Columns.Keys.ElementAt(j)];
}
ExportExcelDt.Rows.Add(dr);
}
}
if (_TrafficType == 0)
{
string turn = string.Empty;
turn = " Traffic_T.TrafficNumber_bint NOT IN (SELECT trafficNumber_bint FROM Traffic_T WHERE Traffic_T.Out_bit = 1 AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc >= '" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "') AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc <='" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "')) AND Traffic_T.TrafficNumber_bint NOT IN (SELECT trafficNumber_bint FROM Traffic_T WHERE Traffic_T.TemporaryOut_bit = 1 AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc >= '" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "') AND (Traffic_T.Date_nvc + ' ' + Traffic_T.Time_nvc <='" + FromDatefaDatePicker.Text + " " + ToDatefaDatePicker.Text + "')) AND ";
//HPS.Reports.ReportDoc.OtherInReport rpt = new HPS.Reports.ReportDoc.OtherInReport(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, FromTimeTextBox.Text,
// ToTimeTextBox.Text, FromTrafficNumbertxt.Text, ToTrafficNumbertxt.Text, Convert.ToString(TrafficTypeID_intComboBox.SelectedValue), Convert.ToString(ServicescomboBox.SelectedValue), turn);
//rpt.Document.Printer.PrinterName = string.Empty;
//viewer1.Document = rpt.Document;
//rpt.Run();
OtherInTrafficStiReport.Dictionary.Synchronize();
OtherInTrafficStiReport.Dictionary.Databases.Clear();
OtherInTrafficStiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
OtherInTrafficStiReport.Compile();
OtherInTrafficStiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory();
OtherInTrafficStiReport["@FromDateTime_nvc"] = FromDatefaDatePicker.Text + ' ' + FromTimeTextBox.Text;
OtherInTrafficStiReport["@ToDateTime_nvc"] = ToDatefaDatePicker.Text + ' ' + ToTimeTextBox.Text;
if (string.IsNullOrEmpty(FromTrafficNumbertxt.Text))
{
OtherInTrafficStiReport["@FromTrafficNumber_nvc"] = DBNull.Value;
}
else
{
OtherInTrafficStiReport["@FromTrafficNumber_nvc"] = FromTrafficNumbertxt.Text;
}
if (string.IsNullOrEmpty(ToTrafficNumbertxt.Text))
{
OtherInTrafficStiReport["@ToTrafficNumber_nvc"] = DBNull.Value;
}
else
{
OtherInTrafficStiReport["@ToTrafficNumber_nvc"] = ToTrafficNumbertxt.Text;
}
OtherInTrafficStiReport["@LaderPivotGroupID_nvc"] = DBNull.Value;
OtherInTrafficStiReport["@LaderTypeID_nvc"] = DBNull.Value;
OtherInTrafficStiReport["@TrafficTypeID_nvc"] = Convert.ToString(TrafficTypeID_intComboBox.SelectedValue);
OtherInTrafficStiReport["@TrafficInbit_nvc"] = "1";
OtherInTrafficStiReport["@TrafficOutbit_nvc"] = DBNull.Value;
if (string.IsNullOrEmpty(Convert.ToString(ServicescomboBox.SelectedValue)))
{
OtherInTrafficStiReport["@ServiceID_nvc"] = DBNull.Value;
}
else
{
OtherInTrafficStiReport["@ServiceID_nvc"] = Convert.ToString(ServicescomboBox.SelectedValue);
}
OtherInTrafficStiReport["@TurnAccepted_nvc"] = turn;
OtherInTrafficStiReport["fromdate_vc"] = FromDatefaDatePicker.Text;
OtherInTrafficStiReport["todate_vc"] = ToDatefaDatePicker.Text;
OtherInTrafficStiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;;
OtherInTrafficStiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc;
OtherInTrafficStiReport["FromTime_vc"] = FromTimeTextBox.Text;
OtherInTrafficStiReport["ToTime_vc"] = ToTimeTextBox.Text;
OtherInTrafficStiReport.Render();
stiViewerControl1.Report = OtherInTrafficStiReport;
dt = new DT.DataTable();
ExportExcelDt = new System.Data.DataTable();
factory.ReportSelectByFieds(
OtherInTrafficStiReport["@FromDateTime_nvc"],
OtherInTrafficStiReport["@ToDateTime_nvc"],
OtherInTrafficStiReport["@FromTrafficNumber_nvc"],
OtherInTrafficStiReport["@ToTrafficNumber_nvc"],
OtherInTrafficStiReport["@LaderPivotGroupID_nvc"],
OtherInTrafficStiReport["@LaderTypeID_nvc"],
OtherInTrafficStiReport["@TrafficTypeID_nvc"],
OtherInTrafficStiReport["@TrafficInbit_nvc"],
OtherInTrafficStiReport["@TrafficOutbit_nvc"],
OtherInTrafficStiReport["@ServiceID_nvc"],
"", ref dt);
Dictionary <string, string> Columns = new Dictionary <string, string>();
Columns.Add("TrafficNumber_bint", "شماره قبض");
//Columns.Add("TurnNumber_bint", "شماره نوبت");
//Columns.Add("DriverCardNumber_nvc", "شماره کارت راننده ");
//Columns.Add("carCardNumber_nvc", "شماره کارت ناوگان");
Columns.Add("FirstName_nvc", "نام راننده");
Columns.Add("LastName_nvc", "نام خانوادگی راننده");
Columns.Add("NumberPlate_nvc", "شماره پلاک");
Columns.Add("UserName_nvc", "کاربر");
Columns.Add("Date_nvc", "تاریخ ورود");
Columns.Add("Time_nvc", "زمان ورود");
// Columns.Add("EditUserName_nvc", "کاربر تایید کننده");
//Columns.Add("TurnDate_nvc", "تاریخ نوبت");
//Columns.Add("TurnTime_nvc", "زمان نوبت");
Columns.Add("PriceNoTax_dec", "مبلغ");
Columns.Add("PriceTax_dec", "ارزش افزوده");
Columns.Add("Price_dec", "مبلغ دریافتی");
// Columns.Add("WithLade_bit", "با بار");
Columns.Add("ServiceID_intServiceType_nvc", "مراجعه به");
foreach (var col in Columns)
{
ExportExcelDt.Columns.Add(col.Value, col.Key.EndsWith("_bit") ? typeof(bool) : typeof(string));
}
DataRow dr;
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
dr = ExportExcelDt.NewRow();
for (int j = 0; j < Columns.Count; j++)
{
dr[j] = dt.Rows[i][Columns.Keys.ElementAt(j)];
}
ExportExcelDt.Rows.Add(dr);
}
}
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void uiButton1_Click(object sender, EventArgs e)
{
try
{
if ((FromDatefaDatePicker.IsNull) && (string.IsNullOrEmpty(FromTrafficNumbertxt.Text) || string.IsNullOrEmpty(ToTrafficNumbertxt.Text)))
{
throw new ApplicationException("از تاریخ خالی است");
}
else if ((ToDatefaDatePicker.IsNull && (string.IsNullOrEmpty(FromTrafficNumbertxt.Text) || string.IsNullOrEmpty(ToTrafficNumbertxt.Text))))
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
object[] LaderTypeList = new object[100];
string LaderTypeList_nvc = string.Empty;
int index = 0;
LaderTypeList = LaderTypecheckedComboBox.CheckedValues;
if (LaderTypeList != null)
{
foreach (object obj in LaderTypeList)
{
LaderTypeList_nvc = string.Format("{0},{1}", LaderTypeList_nvc, LaderTypeList[index].ToString());
index += 1;
}
LaderTypeList_nvc = LaderTypeList_nvc.Substring(1, LaderTypeList_nvc.Length - 1);
}
object[] ServiceList = new object[100];
string ServiceList_nvc = string.Empty;
int Serviceindex = 0;
ServiceList = this.ServicescheckedComboBox.CheckedValues;
if (ServiceList != null)
{
foreach (object obj in ServiceList)
{
ServiceList_nvc = string.Format("{0},{1}", ServiceList_nvc, ServiceList[Serviceindex].ToString());
Serviceindex += 1;
}
ServiceList_nvc = ServiceList_nvc.Substring(1, ServiceList_nvc.Length - 1);
}
GroupTrafficstiReport.Dictionary.Synchronize();
GroupTrafficstiReport.Dictionary.Databases.Clear();
GroupTrafficstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
GroupTrafficstiReport.Compile();
GroupTrafficstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory();
GroupTrafficstiReport["fromdate_vc"] = FromDatefaDatePicker.Text;
GroupTrafficstiReport["todate_vc"] = ToDatefaDatePicker.Text;
GroupTrafficstiReport["fromtime_nvc"] = FromTimeTextBox.Text;
GroupTrafficstiReport["totime_nvc"] = ToTimeTextBox.Text;
GroupTrafficstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate;
GroupTrafficstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc;
GroupTrafficstiReport["fromTrafficNumber"] = FromTrafficNumbertxt.Text;
GroupTrafficstiReport["toTrafficNumber"] = ToTrafficNumbertxt.Text;
if (string.IsNullOrEmpty(FromDatefaDatePicker.Text))
{
GroupTrafficstiReport["@FromDateTime_nvc"] = DBNull.Value;
}
else
{
GroupTrafficstiReport["@FromDateTime_nvc"] = FromDatefaDatePicker.Text + ' ' + FromTimeTextBox.Text;
}
if (string.IsNullOrEmpty(ToDatefaDatePicker.Text))
{
GroupTrafficstiReport["@ToDateTime_nvc"] = DBNull.Value;
}
else
{
GroupTrafficstiReport["@ToDateTime_nvc"] = ToDatefaDatePicker.Text + ' ' + ToTimeTextBox.Text;
}
if (string.IsNullOrEmpty(LaderTypeList_nvc))
{
GroupTrafficstiReport["@LaderTypeID_nvc"] = DBNull.Value;
}
else
{
GroupTrafficstiReport["@LaderTypeID_nvc"] = Convert.ToString(LaderTypeList_nvc);
}
if (InTrafficradioButton.Checked)
{
GroupTrafficstiReport["@TrafficInbit_nvc"] = 1;
GroupTrafficstiReport["@TrafficOutbit_nvc"] = DBNull.Value;
GroupTrafficstiReport["TrafficType"] = "ورودی";
}
else if (OutTrafficradioButton.Checked)
{
GroupTrafficstiReport["@TrafficInbit_nvc"] = DBNull.Value;
GroupTrafficstiReport["@TrafficOutbit_nvc"] = 1;
GroupTrafficstiReport["TrafficType"] = "خروجی";
}
else
{
MessageBox.Show("نوع تردد ورودی یا خروجی بایستی انتخاب شود");
}
if (string.IsNullOrEmpty(ServiceList_nvc))
{
GroupTrafficstiReport["@ServiceID_nvc"] = DBNull.Value;
}
else
{
GroupTrafficstiReport["@ServiceID_nvc"] = Convert.ToString(ServiceList_nvc);
}
if (string.IsNullOrEmpty(FromTrafficNumbertxt.Text))
{
GroupTrafficstiReport["@FromTrafficNumber_nvc"] = DBNull.Value;
}
else
{
GroupTrafficstiReport["@FromTrafficNumber_nvc"] = FromTrafficNumbertxt.Text;
}
if (string.IsNullOrEmpty(ToTrafficNumbertxt.Text))
{
GroupTrafficstiReport["@ToTrafficNumber_nvc"] = DBNull.Value;
}
else
{
GroupTrafficstiReport["@ToTrafficNumber_nvc"] = ToTrafficNumbertxt.Text;
}
GroupTrafficstiReport.Render();
stiViewerControl1.Report = GroupTrafficstiReport;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
object[] LaderTypeList = new object[100];
string LaderTypeList_nvc = string.Empty;
int index = 0;
LaderTypeList = LaderTypecheckedComboBox.CheckedValues;
if (LaderTypeList != null)
{
foreach (object obj in LaderTypeList)
{
LaderTypeList_nvc = string.Format("{0},{1}", LaderTypeList_nvc, LaderTypeList[index].ToString());
index += 1;
}
LaderTypeList_nvc = LaderTypeList_nvc.Substring(1, LaderTypeList_nvc.Length - 1);
}
HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
CarLadeBillstiReport.Dictionary.Synchronize();
CarLadeBillstiReport.Dictionary.Databases.Clear();
CarLadeBillstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
CarLadeBillstiReport.Compile();
CarLadeBillstiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
CarLadeBillstiReport["date_vc"] = TrafficFactory.ServerJalaliDate + " " + TrafficFactory.ServerTime;
CarLadeBillstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc;
CarLadeBillstiReport["fromdate_vc"] = FromDatefaDatePicker.Text;
CarLadeBillstiReport["todate_vc"] = ToDatefaDatePicker.Text;
CarLadeBillstiReport["fromTime_vc"] = FromTimeTextBox.Text;
CarLadeBillstiReport["toTime_vc"] = ToTimeTextBox.Text;
CarLadeBillstiReport["@FromDate_nvc"] = FromDatefaDatePicker.Text;
CarLadeBillstiReport["@ToDate_nvc"] = ToDatefaDatePicker.Text;
CarLadeBillstiReport["@FromTime_nvc"] = FromTimeTextBox.Text;
CarLadeBillstiReport["@ToTime_nvc"] = ToTimeTextBox.Text;
if (string.IsNullOrEmpty(LaderTypeList_nvc))
{
CarLadeBillstiReport["@LaderTypeID_nvc"] = DBNull.Value;
}
else
{
CarLadeBillstiReport["@LaderTypeID_nvc"] = Convert.ToString(LaderTypeList_nvc);
}
if (string.IsNullOrEmpty(CarSerialnumbertextBox.Text))
{
CarLadeBillstiReport["@SerialPlate_nvc"] = DBNull.Value;
}
else
{
CarLadeBillstiReport["@SerialPlate_nvc"] = CarSerialnumbertextBox.Text;
}
if (string.IsNullOrEmpty(NumberPlate_nvctextBox.Text))
{
CarLadeBillstiReport["@NumberPlate_nvc"] = DBNull.Value;
}
else
{
CarLadeBillstiReport["@NumberPlate_nvc"] = NumberPlate_nvctextBox.Text;
}
//@CarCardNumber_nvc
if (string.IsNullOrEmpty(CarCardNumber_nvctextBox.Text))
{
CarLadeBillstiReport["@CarCardNumber_nvc"] = DBNull.Value;
}
else
{
CarLadeBillstiReport["@CarCardNumber_nvc"] = CarCardNumber_nvctextBox.Text;
}
CarLadeBillstiReport.Render();
stiViewerControl1.Report = CarLadeBillstiReport;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowWithChartButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
if (LaderTypeID_intComboBox.SelectedIndex != -1)
{
//HPS.Reports.ReportDoc.AllInInfoByDateChartReport rpt = new HPS.Reports.ReportDoc.AllInInfoByDateChartReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, Convert.ToInt32(LaderTypeID_intComboBox.SelectedValue), LaderTypeID_intComboBox.Text);
//rpt.Document.Printer.PrinterName = string.Empty;
//viewer1.Document = rpt.Document;
//rpt.Run();
AllInInfoByDateChartReportstiReport.Dictionary.Synchronize();
AllInInfoByDateChartReportstiReport.Dictionary.Databases.Clear();
AllInInfoByDateChartReportstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
AllInInfoByDateChartReportstiReport.Compile();
HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory();
AllInInfoByDateChartReportstiReport["fromDate_nvc"] = FromDatefaDatePicker.Text;
AllInInfoByDateChartReportstiReport["toDate_nvc"] = ToDatefaDatePicker.Text;
AllInInfoByDateChartReportstiReport["fromTime_nvc"] = FromTimeTextBox.Text;
AllInInfoByDateChartReportstiReport["toTime_nvc"] = ToTimeTextBox.Text;
AllInInfoByDateChartReportstiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;
AllInInfoByDateChartReportstiReport["userName_nvc"] = HPS.Common.CurrentUser.user.UserName_nvc;
AllInInfoByDateChartReportstiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text;
AllInInfoByDateChartReportstiReport["@todate_nvc"] = ToDatefaDatePicker.Text;
AllInInfoByDateChartReportstiReport["@fromtime_nvc"] = FromTimeTextBox.Text;
AllInInfoByDateChartReportstiReport["@totime_nvc"] = ToTimeTextBox.Text;
AllInInfoByDateChartReportstiReport["@LaderTypeList"] = Convert.ToInt32(LaderTypeID_intComboBox.SelectedValue);
AllInInfoByDateChartReportstiReport["@FromDate_nvc"] = FromDatefaDatePicker.Text;
AllInInfoByDateChartReportstiReport["@ToDate_nvc"] = ToDatefaDatePicker.Text;
AllInInfoByDateChartReportstiReport["@FromTime_nvc"] = FromTimeTextBox.Text;
AllInInfoByDateChartReportstiReport["@ToTime_nvc"] = ToTimeTextBox.Text;
AllInInfoByDateChartReportstiReport["@LaderTypeID_int"] = Convert.ToInt32(LaderTypeID_intComboBox.SelectedValue);
AllInInfoByDateChartReportstiReport.Render();
AllInInfoByDateChartReportstiReport.Show();
}
else
{
throw new ApplicationException("نوع بارگیر را انتخاب نمایید");
}
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
////
HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
DataTable AllDataTable = new DataTable();
DataTable LadeAssignmentTable = new DataTable();
TrafficFactory.TurnAndLadeAssignmentInfoByLaderTypeReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, null, ref AllDataTable);
TrafficFactory.LadeAssignmentInfoByLaderType(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, null, ref LadeAssignmentTable);
DataRow[] dr = null;
foreach (DataRow row in AllDataTable.Rows)
{
dr = LadeAssignmentTable.Select(string.Format(" LaderTypeID_int={0} ", row["LaderTypeID_int"]));
if (dr != null && dr.Length > 0)
{
row["Canceled_int"] = dr[0][2];
row["CarCount_int"] = dr[0][3];
row["ladBillCount_int"] = dr[0][4];
row["LadeRemainedCount_int"] = dr[0][5];
row["RemainedPercent_flt"] = dr[0][6];
}
else
{
var ladeset = new HashSet <int>(AllDataTable.AsEnumerable().Select(p => Convert.ToInt32(p["LaderTypeID_int"])));
var ladeResult = LadeAssignmentTable.AsEnumerable().Where(i => !ladeset.Contains(Convert.ToInt32(i["LaderTypeID_int"]))).ToList();
for (int i = 0; i < ladeResult.Count; i++)
{
row["LaderTypeID_int"] = ladeResult[i]["LaderTypeID_int"];
row["LaderType_nvc"] = ladeResult[i]["LaderType_nvc"];
row["CarCount_int"] = ladeResult[i]["CarCount_int"];
row["ladBillCount_int"] = ladeResult[i]["ladBillCount_int"];
row["LadeRemainedCount_int"] = ladeResult[i]["LadeRemainedCount_int"];
row["RemainedPercent_flt"] = ladeResult[i]["RemainedPercent_flt"];
row["TurnRemainedCount_int"] = 0;
AllDataTable.Rows.Add(row);
}
}
}
Int64? AllRemainedCountRecords = (from row in AllDataTable.AsEnumerable() select Convert.ToInt32(row["LadeRemainedCount_int"])).Sum();
string AllLadeRemaindedCounttxt = AllRemainedCountRecords.HasValue ? AllRemainedCountRecords.ToString() : "0";
Int64? AllRequestCountRecords = (from row in AllDataTable.AsEnumerable() select Convert.ToInt32(row["CarCount_int"])).Sum();
string AllRequesttxt = AllRequestCountRecords.HasValue ? AllRequestCountRecords.ToString() : "0";
Int64? AllLadBillCountRecords = (from row in AllDataTable.AsEnumerable() select Convert.ToInt32(row["LadBillCount_int"])).Sum();
string AllLadBillxt = AllLadBillCountRecords.HasValue ? AllLadBillCountRecords.ToString() : "0";
string AllRemainedPercentTxt = "";
if (Convert.ToInt32(AllRequesttxt) != 0)
{
AllRemainedPercentTxt = (Convert.ToDouble(AllLadeRemaindedCounttxt) * 100 / Convert.ToDouble(AllRequesttxt)).ToString("0.##");
}
else
{
AllRemainedPercentTxt = "0";
}
DataSet MyDataset = new DataSet();
MyDataset.Tables.Add(AllDataTable);
AllInfoByDatestiReport.Dictionary.Synchronize();
AllInfoByDatestiReport.Dictionary.Databases.Clear();
AllInfoByDatestiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
AllInfoByDatestiReport.RegData(MyDataset);
AllInfoByDatestiReport.Compile();
AllInfoByDatestiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
AllInfoByDatestiReport["date_vc"] = TrafficFactory.ServerJalaliDate + " " + TrafficFactory.ServerTime;
AllInfoByDatestiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc;
AllInfoByDatestiReport["AllRemainedPercentTxt"] = AllRemainedPercentTxt;
AllInfoByDatestiReport["fromdate_vc"] = FromDatefaDatePicker.Text;
AllInfoByDatestiReport["todate_vc"] = ToDatefaDatePicker.Text;
AllInfoByDatestiReport["fromTime_vc"] = FromTimeTextBox.Text;
AllInfoByDatestiReport["toTime_vc"] = ToTimeTextBox.Text;
AllInfoByDatestiReport.Render();
stiViewerControl1.Report = AllInfoByDatestiReport;
////
//HPS.Reports.ReportDoc.AllInfoByDateReport rpt = new HPS.Reports.ReportDoc.AllInfoByDateReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text);
//rpt.Document.Printer.PrinterName = string.Empty;
//viewer1.Document = rpt.Document;
//rpt.Run();
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
object[] PortPlaceList = new object[100];
string PortPlaceList_nvc = string.Empty;
int index = 0;
PortPlaceList = portPlacecheckedComboBox.CheckedValues;
if (PortPlaceList != null)
{
foreach (object obj in PortPlaceList)
{
PortPlaceList_nvc = string.Format("{0},{1}", PortPlaceList_nvc, PortPlaceList[index].ToString());
index += 1;
}
PortPlaceList_nvc = PortPlaceList_nvc.Substring(1, PortPlaceList_nvc.Length - 1);
}
PortPlacestiReport.Dictionary.Synchronize();
PortPlacestiReport.Dictionary.Databases.Clear();
PortPlacestiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
PortPlacestiReport.Compile();
PortPlacestiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory();
PortPlacestiReport["fromdate_vc"] = FromDatefaDatePicker.Text;
PortPlacestiReport["todate_vc"] = ToDatefaDatePicker.Text;
PortPlacestiReport["fromtime_nvc"] = FromTimeTextBox.Text;
PortPlacestiReport["totime_nvc"] = ToTimeTextBox.Text;
PortPlacestiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate;
PortPlacestiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc;
PortPlacestiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text;
PortPlacestiReport["@fromtime_nvc"] = FromTimeTextBox.Text;
PortPlacestiReport["@todate_nvc"] = ToDatefaDatePicker.Text;
PortPlacestiReport["@totime_nvc"] = ToTimeTextBox.Text;
if (PortPlaceList_nvc == string.Empty)
{
PortPlacestiReport["@PortPlaceList"] = DBNull.Value;
}
else
{
PortPlacestiReport["@PortPlaceList"] = PortPlaceList_nvc;
}
PortPlacestiReport.Render();
stiViewerControl1.Report = PortPlacestiReport;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)))
{
throw new ApplicationException("از ساعت خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
else if (string.IsNullOrEmpty(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)))
{
throw new ApplicationException("تا ساعت خالی است");
}
Hepsa.Core.Validation.DateRule <string> FromDateValidator = new Hepsa.Core.Validation.DateRule <string>("FromDate", "از تاریخ", null, null);
if (FromDateValidator.Validate(FromDatefaDatePicker.Text) == false)
{
throw new ApplicationException(FromDateValidator.Description);
}
Hepsa.Core.Validation.DateRule <string> ToDateValidator = new Hepsa.Core.Validation.DateRule <string>("ToDate", "تا تاریخ", null, null);
if (ToDateValidator.Validate(ToDatefaDatePicker.Text) == false)
{
throw new ApplicationException(ToDateValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> FromTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("FromTime", "از ساعت", null, null);
if (FromTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(FromTimeTextBox)) == false)
{
throw new ApplicationException(FromTimeValidator.Description);
}
Hepsa.Core.Validation.TimeRule <string> ToTimeValidator = new Hepsa.Core.Validation.TimeRule <string>("ToTime", "تا ساعت", null, null);
if (ToTimeValidator.Validate(Hepsa.Core.Common.PersentationController.GetMaskedTextBoxValue(ToTimeTextBox)) == false)
{
throw new ApplicationException(ToTimeValidator.Description);
}
string CompanyList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in companyGrid.GetCheckedRows())
{
CompanyList_nvc += itm.Cells["CompanyID_int"].Value.ToString() + ",";
}
if (CompanyList_nvc.EndsWith(","))
{
CompanyList_nvc = CompanyList_nvc.Remove(CompanyList_nvc.Length - 1);
}
companyGrid.UnCheckAllRecords();
string LaderTypeList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in laderTypeGrid.GetCheckedRows())
{
LaderTypeList_nvc += itm.Cells["LaderTypeID_int"].Value.ToString() + ",";
}
if (LaderTypeList_nvc.EndsWith(","))
{
LaderTypeList_nvc = LaderTypeList_nvc.Remove(LaderTypeList_nvc.Length - 1);
}
laderTypeGrid.UnCheckAllRecords();
//////create Order list
string OrderColumns_nvc = string.Empty;
OrderColumns_nvc = " T1.LadeDate_nvc ";
bool justRemained = false;
if (JustRemainedCheckBox.Checked)
{
justRemained = true;
}
string GoodList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in goodGrid.GetCheckedRows())
{
GoodList_nvc += itm.Cells["GoodID_int"].Value.ToString() + ",";
}
if (GoodList_nvc.EndsWith(","))
{
GoodList_nvc = GoodList_nvc.Remove(GoodList_nvc.Length - 1);
}
goodGrid.UnCheckAllRecords();
string PortPlaceList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in portPlaceGrid.GetCheckedRows())
{
PortPlaceList_nvc += itm.Cells["PortPlacesID_int"].Value.ToString() + ",";
}
if (PortPlaceList_nvc.EndsWith(","))
{
PortPlaceList_nvc = PortPlaceList_nvc.Remove(PortPlaceList_nvc.Length - 1);
}
portPlaceGrid.UnCheckAllRecords();
string DestinationCityList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in destinationCityGrid.GetCheckedRows())
{
DestinationCityList_nvc += itm.Cells["CityID_int"].Value.ToString() + ",";
}
if (DestinationCityList_nvc.EndsWith(","))
{
DestinationCityList_nvc = DestinationCityList_nvc.Remove(DestinationCityList_nvc.Length - 1);
}
destinationCityGrid.UnCheckAllRecords();
////////////////////////////////////////
//HPS.Reports.ReportDoc.CompanyRemanedLadBillWithDateReport rpt = new HPS.Reports.ReportDoc.CompanyRemanedLadBillWithDateReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, LaderTypeList_nvc, CompanyList_nvc, OrderColumns_nvc, justRemained, GoodList_nvc, DestinationCityList_nvc, PortPlaceList_nvc);
//viewer1.Document = rpt.Document;
//rpt.Document.Printer.PrinterName = string.Empty;
//rpt.Run();
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmenFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LaderTypeReportTable = new DataTable();
DataSet LaderTypeDataset = new DataSet();
LadeAssignmenFactory.SelectCompanyLadeAssignmentDetail(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, LaderTypeList_nvc, CompanyList_nvc, GoodList_nvc, DestinationCityList_nvc, PortPlaceList_nvc, OrderColumns_nvc, ref LaderTypeReportTable);
DataTable dt = null;
if (JustRemainedCheckBox.Checked)
{
LaderTypeReportTable.DefaultView.RowFilter = "RemainderCount_int <>0";
dt = LaderTypeReportTable.DefaultView.ToTable();
}
else if (JustCanceledCheckBox.Checked)
{
LaderTypeReportTable.DefaultView.RowFilter = "CanceledByCompany <>0 OR CanceledByLadBillCanceled<>0";
dt = LaderTypeReportTable.DefaultView.ToTable();
}
else
{
dt = LaderTypeReportTable;
}
dt.Columns.Add("RemainedPercent");
foreach (DataRow row in dt.Rows)
{
double RemainedPercent = (Convert.ToDouble(row["RemainderCount_int"]) * 100) / (Convert.ToDouble(row["CarCount_int"]));
row["RemainedPercent"] = RemainedPercent.ToString("0.##");
}
LaderTypeDataset.Tables.Add(dt.Copy());
CompanyRemanedLadBillStiReport.Dictionary.Synchronize();
CompanyRemanedLadBillStiReport.Dictionary.Databases.Clear();
CompanyRemanedLadBillStiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
CompanyRemanedLadBillStiReport.RegData(LaderTypeDataset);
CompanyRemanedLadBillStiReport.Compile();
CompanyRemanedLadBillStiReport["organ"] = new HPS.BLL.SettingsBLL.BLLSetting_TFactory().GetBy(new BLL.SettingsBLL.BLLSetting_TKeys()
{
SettingID_int = 1029
}).Value_nvc.ToString();
HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory PortPlaceFactory = new HPS.BLL.PortPlacesBLL.BLLPortPlaces_TFactory();
CompanyRemanedLadBillStiReport["fromDate_nvc"] = FromDatefaDatePicker.Text;
CompanyRemanedLadBillStiReport["fromTime_nvc"] = FromTimeTextBox.Text;
CompanyRemanedLadBillStiReport["toTime_nvc"] = ToTimeTextBox.Text;
CompanyRemanedLadBillStiReport["toDate_nvc"] = ToDatefaDatePicker.Text;
CompanyRemanedLadBillStiReport["date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;;
CompanyRemanedLadBillStiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc;
if (JustRemainedCheckBox.Checked)
{
CompanyRemanedLadBillStiReport["title_nvc"] = "بارهای جامانده شرکت های حمل و نقل";
}
else if (JustCanceledCheckBox.Checked)
{
CompanyRemanedLadBillStiReport["title_nvc"] = "بارهای ابطالی شرکت های حمل و نقل";
}
else
{
CompanyRemanedLadBillStiReport["title_nvc"] = "بارهای درخواستی و جامانده شرکت های حمل و نقل";
}
//
//CompanyRemanedLadBillStiReport["@fromdate_nvc"] = FromDatefaDatePicker.Text;
//CompanyRemanedLadBillStiReport["@fromtime_nvc"] = FromTimeTextBox.Text;
//CompanyRemanedLadBillStiReport["@totime_nvc"] = ToTimeTextBox.Text;
//CompanyRemanedLadBillStiReport["@todate_nvc"] = ToDatefaDatePicker.Text;
//if (string.IsNullOrEmpty(LaderTypeList_nvc))
// CompanyRemanedLadBillStiReport["@LaderTypeID_int"] = DBNull.Value;
//else
// CompanyRemanedLadBillStiReport["@LaderTypeID_int"] = LaderTypeList_nvc;
//if (string.IsNullOrEmpty(CompanyList_nvc))
// CompanyRemanedLadBillStiReport["@CompanyID_int"] = DBNull.Value;
//else
// CompanyRemanedLadBillStiReport["@CompanyID_int"] = CompanyList_nvc;
//if (string.IsNullOrEmpty(GoodList_nvc))
// CompanyRemanedLadBillStiReport["@GoodIDList_nvc"] = DBNull.Value;
//else
// CompanyRemanedLadBillStiReport["@GoodIDList_nvc"] = GoodList_nvc;
//if (string.IsNullOrEmpty(DestinationCityList_nvc))
// CompanyRemanedLadBillStiReport["@DestinationCityIDList_nvc"] = DBNull.Value;
//else
// CompanyRemanedLadBillStiReport["@DestinationCityIDList_nvc"] = DestinationCityList_nvc;
//if (string.IsNullOrEmpty(PortPlaceList_nvc))
// CompanyRemanedLadBillStiReport["@PortPlaceIDList_nvc"] = DBNull.Value;
//else
// CompanyRemanedLadBillStiReport["@PortPlaceIDList_nvc"] = PortPlaceList_nvc;
//if (string.IsNullOrEmpty(OrderColumns_nvc))
// CompanyRemanedLadBillStiReport["@OrderColumns_nvc"] = DBNull.Value;
//else
// CompanyRemanedLadBillStiReport["@OrderColumns_nvc"] = OrderColumns_nvc;
CompanyRemanedLadBillStiReport.Render();
stiViewerControl1.Report = CompanyRemanedLadBillStiReport;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
