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); } ////////////////// }