private void ShowButton_Click(object sender, EventArgs e)
{
try
{
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
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);
}
string Condition = string.Empty;
if (WithProductionYear == true)
{
Condition = "T1.TurnDate_nvc>='" + FromDatefaDatePicker + "' AND T1.TurnDate_nvc<='" + ToDatefaDatePicker.Text + "' And T1.Area_bit=1 AND T1.ProductionYear_int IS NOT NULL";
}
else
{
Condition = "T1.TurnDate_nvc>='" + FromDatefaDatePicker.Text + "' AND T1.TurnDate_nvc<='" + ToDatefaDatePicker.Text + " And T1.Area_bit=1'";
}
if (!string.IsNullOrEmpty(AcceptedTurnNumber_binttextBox.Text))
{
Condition = string.Format(" T1.AcceptedTurnNumber_bint={0} And T1.Area_bit=1 ", AcceptedTurnNumber_binttextBox.Text);
}
if (!string.IsNullOrEmpty(TrafficNumber_binttextBox.Text))
{
Condition = string.Format(" T1.TrafficNumber_bint={0} And T1.Area_bit=1", TrafficNumber_binttextBox.Text);
}
if (!string.IsNullOrEmpty(NumberPlate_nvctextBox.Text) && !string.IsNullOrEmpty(SerialPlate_nvctextBox.Text))
{
Condition = string.Format(" T1.NumberPlate_nvc ='{0}' AND T1.SerialPlate_nvc='{1}' And T1.Area_bit=1", NumberPlate_nvctextBox.Text, SerialPlate_nvctextBox.Text);
}
if (!string.IsNullOrEmpty(LastName_nvctextBox.Text))
{
Condition = string.Format(" LastName_nvc LIKE '%{0}%' And T1.Area_bit=1", LastName_nvctextBox.Text);
}
HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
DataTable TrafficDataTable = new DataTable();
TrafficFactory.SelectAcceptedTurns(TrafficDataTable, Condition);
this.TrafficGridView.DataSource = TrafficDataTable;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
public AllAcceptedTurnReport(string FromDate, string ToDate, bool WithProductionYear)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
try
{
FromDatetxt.Text = FromDate;
ToDatetxt.Text = ToDate;
HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
string Condition = string.Empty;
if (WithProductionYear == true)
{
Condition = "[T1].[TurnAccepted_bit]='true' AND [T1].[TrafficTypeID_int]=1 AND (T1.TurnDate_nvc>='" + FromDatetxt.Text + "') AND (T1.TurnDate_nvc<='" + ToDate + "') AND T1.ProductionYear_int IS NOT NULL";
}
else
{
Condition = "[T1].[TurnAccepted_bit]='true' AND [T1].[TrafficTypeID_int]=1 AND (T1.TurnDate_nvc>='" + FromDatetxt.Text + "') AND (T1.TurnDate_nvc<='" + ToDate + "')";
}
DataTable TrafficDataTable = new DataTable();
TrafficFactory.SelectAcceptedTurns(TrafficDataTable, Condition);
this.DataSource = TrafficDataTable;
Datetxt.DataField = "Date_nvc";
Timetxt.DataField = "Time_nvc";
TurnNumbertxt.DataField = "TurnNumber_bint";
TrafficNumbertxt.DataField = "TrafficNumber_bint";
NumberPlateTextBox.DataField = "NumberPlate_nvc";
PlateCitytxt.DataField = "PlateCityID_intPlateCity_nvc";
SerialPlateTextBox.DataField = "SerialPlate_nvc";
CarCardNumbertxt.DataField = "CarCardNumber_nvc";
DriverCardNumbertxt.DataField = "DriverCardNumber_nvc";
Usertxt.DataField = "UserName_nvc";
FirstNametxt.DataField = "FirstName_nvc";
LastNametxt.DataField = "LastName_nvc";
TurnAcceptedchk.DataField = "TurnAccepted_bit";
TurnAcceptedNumbertxt.DataField = "AcceptedTurnNumber_bint";
TurnAcceptedDatetxt.DataField = "TurnDate_nvc";
TurnAcceptedTimetxt.DataField = "TurnTime_nvc";
LaderTypetxt.DataField = "LaderTypeID_intLaderType_nvc";
DateTextBox.Text = TrafficFactory.ServerJalaliDate;
TimeTextBox.Text = TrafficFactory.ServerTime;
UserNameTextBox.Text = HPS.Common.CurrentUser.user.UserName_nvc;
PivotGrouptxt.Text = "تمامی کامیون ها";
ProductionYeartxt.DataField = "ProductionYear_int";
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowwithConditionbutton_Click(object sender, EventArgs e)
{
try
{
HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
string Condition = string.Format("[T1].[TurnAccepted_bit]='true' AND [T1].[TrafficTypeID_int]=1 And T1.Area_bit=1");
if (!FromDatefaDatePicker.IsNull)
{
Condition += string.Format(" And T1.TurnDate_nvc >= '{0}'", FromDatefaDatePicker.Text);
}
if (!ToDatefaDatePicker.IsNull)
{
Condition += string.Format(" And T1.TurnDate_nvc <= '{0}'", ToDatefaDatePicker.Text);
}
if (string.IsNullOrEmpty(AcceptedTurnNumber_binttextBox.Text) == false)
{
Condition += string.Format(" And T1.AcceptedTurnNumber_bint = {0}", AcceptedTurnNumber_binttextBox.Text);
}
if (string.IsNullOrEmpty(TrafficNumber_binttextBox.Text) == false)
{
Condition += string.Format(" And T1.TrafficNumber_bint = {0}", TrafficNumber_binttextBox.Text);
}
if (string.IsNullOrEmpty(NumberPlate_nvctextBox.Text) == false)
{
Condition += string.Format(" And T1.NumberPlate_nvc =N'{0}'", NumberPlate_nvctextBox.Text);
}
if (string.IsNullOrEmpty(SerialPlate_nvctextBox.Text) == false)
{
Condition += string.Format(" And T1.SerialPlate_nvc ='{0}'", SerialPlate_nvctextBox.Text);
}
if (string.IsNullOrEmpty(LastName_nvctextBox.Text) == false)
{
Condition += string.Format(" And LastName_nvc like N'%{0}%'", LastName_nvctextBox.Text);
}
DataTable TrafficDataTable = new DataTable();
TrafficFactory.SelectAcceptedTurns(TrafficDataTable, Condition);
this.TrafficGridView.DataSource = TrafficDataTable;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
//////////////////
}
