public CompanyLadeAssignmentDetailReport(string FromDate, string FromTime, string ToDate, string ToTime, String LaderTypeID, String CompanyID, String GoodIDlist, String DestinationCityIDList, String PortPlaceList)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmenFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LaderTypeReportTable = new DataTable();
LadeAssignmenFactory.SelectCompanyLadeAssignmentDetail(FromDate, FromTime, ToDate, ToTime, LaderTypeID, CompanyID, GoodIDlist, DestinationCityIDList, PortPlaceList, string.Empty, ref LaderTypeReportTable);
this.DataSource = LaderTypeReportTable;
FromDatetxt.Text = FromDate;
FromTimetxt.Text = FromTime;
ToDatetxt.Text = ToDate;
ToTimetxt.Text = ToTime;
UserNametxt.Text = HPS.Common.CurrentUser.user.UserName_nvc;
Datetxt.Text = LadeAssignmenFactory.ServerJalaliDate;
Timetxt.Text = LadeAssignmenFactory.ServerTime;
Companytxt.DataField = "Company_nvc";
Goodtxt.DataField = "Good_nvc";
Addresstxt.DataField = "Address_nvc";
CarCounttxt.DataField = "CarCount_int";
LaderTypetxt.DataField = "LaderType_nvc";
PortPlacetxt.DataField = "PortPlaces_nvc";
PortageFeetxt.DataField = "PortageFee_dec";
Commenttxt.DataField = "Comment_nvc";
LadBilltxt.DataField = "LadBillCount_int";
Remaindertxt.DataField = "RemainderCount_int";
Int64?AllcountRecords = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["CarCount_int"]).Sum();
AllCounttxt.Text = AllcountRecords.HasValue ? AllcountRecords.ToString() : "0";
decimal?AllPriceRecords = (from row in LaderTypeReportTable.AsEnumerable() select(decimal) row["PortageFee_dec"]).Sum();
AllPricetxt.Text = AllPriceRecords.HasValue ? AllPriceRecords.ToString() : "0";
Int64?AllLadBillRecords = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["LadBillCount_int"]).Sum();
AllLadBilltxt.Text = AllLadBillRecords.HasValue ? AllLadBillRecords.ToString() : "0";
Int64?AllRemainderCountRecords = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["RemainderCount_int"]).Sum();
AllRemainderCounttxt.Text = AllRemainderCountRecords.HasValue ? AllRemainderCountRecords.ToString() : "0";
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
public CompanyRemainderLadeReport(string FromDate, string FromTime, string ToDate, string ToTime, String LaderTypeID, String CompanyID, string OrderColumns_nvc, bool JustRemained, String GoodIDlist, String DestinationCityIDList, String PortPlaceList)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmenFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LaderTypeReportTable = new DataTable();
LadeAssignmenFactory.SelectCompanyLadeAssignmentDetail(FromDate, FromTime, ToDate, ToTime, LaderTypeID, CompanyID, GoodIDlist, DestinationCityIDList, PortPlaceList, OrderColumns_nvc, ref LaderTypeReportTable);
LaderTypeReportTable.DefaultView.RowFilter = "RemainderCount_int <>0";
DataTable dt = null;
if (JustRemained)
{
dt = LaderTypeReportTable.DefaultView.ToTable();
}
else
{
dt = LaderTypeReportTable;
}
this.DataSource = dt;
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.##");
}
FromDatetxt.Text = FromDate;
FromTimetxt.Text = FromTime;
ToDatetxt.Text = ToDate;
ToTimetxt.Text = ToTime;
UserNametxt.Text = HPS.Common.CurrentUser.user.UserName_nvc;
Datetxt.Text = LadeAssignmenFactory.ServerJalaliDate;
Timetxt.Text = LadeAssignmenFactory.ServerTime;
Companytxt.DataField = "Company_nvc";
Goodtxt.DataField = "Good_nvc";
Addresstxt.DataField = "Address_nvc";
LaderTypetxt.DataField = "LaderType_nvc";
PortPlacetxt.DataField = "PortPlaces_nvc";
PortageFeetxt.DataField = "PortageFee_dec";
Commenttxt.DataField = "Comment_nvc";
Remaindertxt.DataField = "RemainderCount_int";
AllRequestTextBox.DataField = "CarCount_int";
LadeDatetxt.DataField = "Date_nvc";
RemainedPercenttxt.DataField = "RemainedPercent";
CanceledByCompanytxt.DataField = "CanceledByCompany";
CanceledByLadBillCanceledtxt.DataField = "CanceledByLadBillCanceled";
decimal?AllPriceRecords = (from row in dt.AsEnumerable() select(decimal) row["PortageFee_dec"]).Sum();
AllPricetxt.Text = AllPriceRecords.HasValue ? AllPriceRecords.ToString() : "0";
Int64?AllRemainderCountRecords = (from row in dt.AsEnumerable() select(Int32) row["RemainderCount_int"]).Sum();
AllRemainderCounttxt.Text = AllRemainderCountRecords.HasValue ? AllRemainderCountRecords.ToString() : "0";
Int64?AllRequestCountRecords = (from row in dt.AsEnumerable() select(Int32) row["CarCount_int"]).Sum();
AllRequesttxt.Text = AllRequestCountRecords.HasValue ? AllRequestCountRecords.ToString() : "0";
Int64?AllCanceledByCompany = (from row in dt.AsEnumerable() select(Int32) row["CanceledByCompany"]).Sum();
AllCanceledByCompanytxt.Text = AllCanceledByCompany.HasValue ? AllCanceledByCompany.ToString() : "0";
Int64?AllCanceledByLadBillCanceled = (from row in dt.AsEnumerable() select(Int32) row["CanceledByLadBillCanceled"]).Sum();
AllCanceledByLadBillCanceledtxt.Text = AllCanceledByLadBillCanceled.HasValue ? AllCanceledByLadBillCanceled.ToString() : "0";
AllPercentTxt.Text = (Convert.ToDouble(AllRemainderCounttxt.Text) * 100 / Convert.ToDouble(AllRequesttxt.Text)).ToString("0.##");
}
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);
}
}