private void DeleteButton_Click(object sender, EventArgs e)
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignment_TFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys LadeAssignmentKey = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys();
try
{
if (LadeAssignmentGridView.SelectedRows.Count > 0)
{
if (Hepsa.Core.Common.MessageBox.ConfirmDeleteMessage() == false)
{
return;
}
LadeAssignmentKey.LadeAssignmentID_bint = (Int64?)LadeAssignmentGridView.CurrentRow.Cells["colLadeAssignmentID_bint"].Value;
LadeAssignment_TFactory.Delete(LadeAssignmentKey);
DataRow[] dr = ((DataTable)this.LadeAssignmentGridView.DataSource).Select(HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T.LadeAssignment_TField.LadeAssignmentID_bint.ToString() + "='" + LadeAssignmentKey.LadeAssignmentID_bint.ToString() + "'");
if (dr.Length > 0)
{
dr[0].Delete();
}
((DataTable)this.LadeAssignmentGridView.DataSource).AcceptChanges();
}
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
string Condition = string.Empty;
Condition = "LadeAssignment_T.Date_nvc>='" + FromDatefaDatePicker.Text + "' AND LadeAssignment_T.Date_nvc<='" + ToDatefaDatePicker.Text + "'";
if (CompanyID_intComboBox.SelectedValue != null && (int)CompanyID_intComboBox.SelectedValue != 0)
{
Condition += " AND LadeAssignment_T.CompanyID_int=" + Convert.ToInt32(CompanyID_intComboBox.SelectedValue);
}
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
CompanyAllLadeAssignmentedstiReport.Dictionary.Synchronize();
CompanyAllLadeAssignmentedstiReport.Dictionary.Databases.Clear();
CompanyAllLadeAssignmentedstiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", Hepsa.Core.Common.ConnectionString.ConnectionString));
CompanyAllLadeAssignmentedstiReport.Compile();
CompanyAllLadeAssignmentedstiReport["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();
CompanyAllLadeAssignmentedstiReport["FromDate_vc"] = FromDatefaDatePicker.Text;
CompanyAllLadeAssignmentedstiReport["ToDate_vc"] = ToDatefaDatePicker.Text;
CompanyAllLadeAssignmentedstiReport["Date_vc"] = PortPlaceFactory.ServerJalaliDate + " " + PortPlaceFactory.ServerTime;;
CompanyAllLadeAssignmentedstiReport["UserName_vc"] = HPS.Common.CurrentUser.user.UserName_nvc;
CompanyAllLadeAssignmentedstiReport["@Condition"] = Condition;
CompanyAllLadeAssignmentedstiReport.Render();
this.stiViewerControl1.Report = CompanyAllLadeAssignmentedstiReport;
}
private void AcceptButton_Click(object sender, EventArgs e)
{
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T LadeAssignmentEntity = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T();
LadeAssignmentEntity = LadeAssignmentFactory.GetBy(LadeAssignmentKeys);
if (LadeAssignmentEntity == null)
{
throw new HPS.Exceptions.LadeAssignmentNotFound();
}
LadeAssignmentEntity.Accepted_bit = true;
LadeAssignmentFactory.BeginProc();
LadeAssignmentFactory.Update(LadeAssignmentEntity, LadeAssignmentKeys);
LadeAssignmentFactory.CommitProc();
if (this._DataTable != null)
{
DataRow[] dr = this._DataTable.Select("LadeAssignmentID_bint=" + this.LadeAsssignmentID.ToString());
if (dr != null && dr.Length > 0)
{
dr[0].Delete();
this._DataTable.AcceptChanges();
}
}
this.Close();
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
public LaderTypeCountWithDateReport(string FromDate, string FromTime, string ToDate, string ToTime, String LaderTypeList_nvc)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LaderTypeReportTable = new DataTable();
LadeAssignmentFactory.SelectLaderTypeCountWithDateReport(FromDate, FromTime, ToDate, ToTime, LaderTypeList_nvc, 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 = LadeAssignmentFactory.ServerJalaliDate;
Timetxt.Text = LadeAssignmentFactory.ServerTime;
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.##"); //AllLadeAssignmentGroupCountxt
}
LaderTypetxt.DataField = "LaderType_nvc";
LadeAssignmentCounttxt.DataField = "CarCount_int";
LadBillCounttxt.DataField = "LadBill";
Date_nvctxt.DataField = "LadeDate_nvc";
RemainderCounttxt.DataField = "RemainderCar_int";
RemainedCountPercenttxt.DataField = "RemainedPercent";
canceledByCompanytxt.DataField = "CanceledByCompany";
canceledByLadBillCanceledtxt.DataField = "CanceledByLadBillCanceled";
Int64?AllLadeAssignmentcount = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["CarCount_int"]).Sum();
AllLadeAssignmentCountxt.Text = AllLadeAssignmentcount.HasValue ? AllLadeAssignmentcount.ToString() : "0";
Int64?AllLadBillcountRecords = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["LadBill"]).Sum();
AllLadBillCounttxt.Text = AllLadBillcountRecords.HasValue ? AllLadBillcountRecords.ToString() : "0";
Int64?Allremaindercount = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["RemainderCar_int"]).Sum();
AllRemainderCounttxt.Text = Allremaindercount.HasValue ? Allremaindercount.ToString() : "0";
Int64?allcanceledByCompany = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["CanceledByCompany"]).Sum();
allCanceledByCompanytxt.Text = allcanceledByCompany.HasValue ? allcanceledByCompany.ToString() : "0";
Int64?allcanceledByLadBillCanceled = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["CanceledByLadBillCanceled"]).Sum();
allCanceledByLadBillCanceledtxt.Text = allcanceledByLadBillCanceled.HasValue ? allcanceledByLadBillCanceled.ToString() : "0";
AllRemainedPercenttxt.Text = ((Convert.ToDouble(AllRemainderCounttxt.Text)) * 100 / (Convert.ToDouble(AllLadeAssignmentCountxt.Text))).ToString("0.##");
}
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
public CompanyAllLadeAssignmentedReport(string FromDate, string Todate)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
FromDatetxt.Text = FromDate;
ToDatetxt.Text = Todate;
DateTextBox.Text = LadeAssignmentFactory.ServerJalaliDate;
TimeTextBox.Text = LadeAssignmentFactory.ServerTime;
UserNameTextBox.Text = HPS.Common.CurrentUser.user.UserName_nvc;
DataTable LadeAssignmentDataTable = new DataTable();
string Condition = "LadeAssignment_T.Date_nvc>='" + FromDate + "' AND LadeAssignment_T.Date_nvc<='" + Todate + "'";
LadeAssignmentFactory.GetAllByConditionReport(Condition, ref LadeAssignmentDataTable);
this.DataSource = LadeAssignmentDataTable;
Datetxt.DataField = "Date_nvc";
Timetxt.DataField = "Time_nvc";
LadingDatetxt.DataField = "LadingDate_nvc";
Companytxt.DataField = "CompanyID_intCompany_nvc";
CompanyCodetxt.DataField = "CompanyCode_nvc";
Citytxt.DataField = "CityID_intCity_nvc";
Goodtxt.DataField = "GoodID_intGood_nvc";
Boxingtxt.DataField = "BoxingID_intBoxingType_nvc";
PortageFeetxt.DataField = "PortageFee_dec";
LaderTypetxt.DataField = "LaderTypeID_intLaderType_nvc";
CarCounttxt.DataField = "CarCount_int";
CanceledCarCounttxt.DataField = "CanceledCar";
Canceledchk.DataField = "CanceledAssignment";
PortPlacetxt.DataField = "PortPlaceID_intPortPlaces_nvc";
CancelCommenttxt.DataField = "LadeCancelComment_nvc";
// AllRecordstxt.Text = Rowtxt.ToString();
//Int64? AllRecords = (from row in LadeAssignmentDataTable.AsEnumerable() select (Int32)row["CarCount_int"]).Count();
//AllRecordstxt.Text = AllRecords.HasValue ? AllRecords.ToString() : "0";
Int64?CarCount = (from row in LadeAssignmentDataTable.AsEnumerable() select(Int32) row["CarCount_int"]).Sum();
AllCartxt.Text = CarCount.HasValue ? CarCount.ToString() : "0";
Int64?CanceledCarCount = (from row in LadeAssignmentDataTable.AsEnumerable() select(Int32) row["CanceledCar"]).Sum();
AllCancelCartxt.Text = CanceledCarCount.HasValue ? CanceledCarCount.ToString() : "0";
Int64?AllPortageFee = (from row in LadeAssignmentDataTable.AsEnumerable() select Convert.ToInt64(row["PortageFee_dec"])).Sum();
AllPortagefeetxt.Text = AllPortageFee.HasValue ? AllPortageFee.ToString() : "0";
Int64?AllCanceledLadeAssignment = (from row in LadeAssignmentDataTable.AsEnumerable() where Convert.ToBoolean(row["CanceledAssignment"]) == true select row["CanceledAssignment"]).Count();
AllCanceledLadeAssignmenttxt.Text = AllCanceledLadeAssignment.HasValue ? AllCanceledLadeAssignment.ToString() : "0";
}
public UseLadBillVSLadeCountReport(string FromDate, string ToDate, string CompanyCodeList_nvc, string LaderTypeCodeList_nvc, DataView UsedLadBillDT)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
this.DataSource = UsedLadBillDT;
FromDatetxt.Text = FromDate;
ToDatetxt.Text = ToDate;
UserNameTextBox.Text = HPS.Common.CurrentUser.user.UserName_nvc;
Datetxt.Text = LadeAssignmentFactory.ServerJalaliDate;
Timetxt.Text = LadeAssignmentFactory.ServerTime;
CompanyCode_nvctxt.DataField = "CompanyCodeAndName";
LedBillCount_inttxt.DataField = "LadBillCount_int";
CarCount_inttxt.DataField = "CarCount_int";
UsedLadBillCount_inttxt.DataField = "UsedLadBill_int";
LaderType_nvctxt.DataField = "LaderType_nvc";
LadBillCountPercent_dectxt.DataField = "LadBillCountPercent_dec";
CarCountPercent_dectxt.DataField = "CarCountPercent_dec";
if (UsedLadBillDT != null && UsedLadBillDT.ToTable().Rows.Count > 0)
{
decimal?AllRequestCountRecords = (from row in UsedLadBillDT.ToTable().AsEnumerable() select(decimal) row["CarCount_int"]).Sum();
AllCarCount_inttxt.Text = AllRequestCountRecords.HasValue ? AllRequestCountRecords.ToString() : "0";
decimal?AllUsedLadBillCountRecords = (from row in UsedLadBillDT.ToTable().AsEnumerable() select(decimal) row["UsedLadBill_int"]).Sum();
AllUsedLadBillCount_inttxt.Text = AllUsedLadBillCountRecords.HasValue ? AllUsedLadBillCountRecords.ToString() : "0";
decimal?AllLadBillCountRecords = (from row in UsedLadBillDT.ToTable().AsEnumerable() select(decimal) row["LadBillCount_int"]).Sum();
AllLadBillCount_inttxt.Text = AllLadBillCountRecords.HasValue ? AllLadBillCountRecords.ToString() : "0";
decimal?AllLadBillCountPercent = (from row in UsedLadBillDT.ToTable().AsEnumerable() select(decimal) row["LadBillCountPercent_dec"]).Sum();
AllLadBillCountPercent_dectxt.Text = (AllLadBillCountPercent.Value / UsedLadBillDT.ToTable().Rows.Count).ToString("0.##");
decimal?AllCarCountPercent = (from row in UsedLadBillDT.ToTable().AsEnumerable() select(decimal) row["CarCountPercent_dec"]).Sum();
AllCarCountPercent_dectxt.Text = (AllCarCountPercent.Value / UsedLadBillDT.ToTable().Rows.Count).ToString("0.##"); //(Convert.ToDouble(AllCarCount_inttxt.Text) * 100 / Convert.ToDouble(AllUsedLadBillCount_inttxt.Text)).ToString("0.##");
}
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void LoadLadeAssignment()
{
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LadeAssignmentDataTable = new DataTable();
LadeAssignmentFactory.GetAll(ref LadeAssignmentDataTable, LadeAssignmentFactory.ServerJalaliDate, 0);
this.LadeAssignmentGridView.DataSource = LadeAssignmentDataTable;
}
catch (System.Exception ex)
{
throw ex;
}
}
protected override void Insert()
{
HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory LadeCancelAssignmentFactory = new HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory();
try
{
HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T LadeCancelAssignmentEntity = new HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T();
//LadeCancelAssignmentFactory.Delete(HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T.LadeCancelAssignment_TField.LadeAssignmentID_bint, this.LadeAssignmentKey.LadeAssignmentID_bint);
if (LadeCancelCommentID_intComboBox.SelectedIndex == 0)
{
throw new ApplicationException("موردی از توضیحات انتخاب نشده است");
}
else
{
BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable remainedLadeAssignmentTable = new DataTable();
string condition = string.Format("LadeAssignmentID_bint={0}", LadeAssignmentKey.LadeAssignmentID_bint.Value);
LadeAssignmentFactory.SelectRemainedDetailSelectByCondition(condition, remainedLadeAssignmentTable);
int remaindCount_int = 0;
if (remainedLadeAssignmentTable != null && remainedLadeAssignmentTable.Rows.Count > 0)
{
remaindCount_int = (Int32)remainedLadeAssignmentTable.Rows[remainedLadeAssignmentTable.Rows.Count - 1]["RemainderCount_int"];
}
LadeCancelAssignmentEntity.LadeAssignmentID_bint = this.LadeAssignmentKey.LadeAssignmentID_bint.Value;
LadeCancelAssignmentEntity.LadeCancelCommentID_int = (Int32)LadeCancelCommentID_intComboBox.SelectedValue;
LadeCancelAssignmentEntity.LadeCancelComment_nvc = LadeCancelCommentID_intComboBox.Text;
LadeCancelAssignmentEntity.Count_int = (Int32?)Hepsa.Core.Common.PersentationController.GetEntityValue(Count_intNumericTextBox.NumericText, TypeCode.Int32);
if (remaindCount_int - LadeCancelAssignmentEntity.Count_int < 0)
{
throw new ApplicationException(string.Format("تعداد ماشین حذفی از تعداد مانده <{0}عدد> بیشتر است", remaindCount_int));
}
if (LadeCancelAssignmentEntity.Count_int == 0)
{
throw new ApplicationException("تعداد حذفی نمیتواند برابر 0 باشد");
}
LadeCancelAssignmentEntity.Date_nvc = LadeCancelAssignmentFactory.ServerJalaliDate;
LadeCancelAssignmentEntity.Time_nvc = LadeCancelAssignmentFactory.ServerTime;
LadeCancelAssignmentEntity.UserName_nvc = HPS.Common.CurrentUser.user.UserName_nvc;
LadeCancelAssignmentFactory.BeginProc();
LadeCancelAssignmentFactory.Insert(LadeCancelAssignmentEntity);
LadeCancelAssignmentFactory.CommitProc();
}
}
catch (Exception ex)
{
LadeCancelAssignmentFactory.RollBackProc();
throw ex;
}
}
private void AllLatoolStripButton_Click(object sender, EventArgs e)
{
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LadeAssignmentDataTable = new DataTable();
Properties.Settings Setting = new HPS.Properties.Settings();
LadeAssignmentFactory.GetAll(ref LadeAssignmentDataTable, null, Setting.SaloonID_int);
this.LadeAssignmentGridView.DataSource = LadeAssignmentDataTable;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
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);
}
}
private void timer1_Tick(object sender, EventArgs e)
{
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
if (this.LadeAssignmentDataTable == null || this.StartIndex >= this.LadeAssignmentDataTable.Rows.Count || StartIndex == 0)
{
LadeAssignmentDataTable = new DataTable();
LadeAssignmentFactory.GetAllActives(ref LadeAssignmentDataTable, _LaderTypesID_nvc);
this.StartIndex = 0;
}
if (this.LadeAssignmentDataTable != null && this.LadeAssignmentDataTable.Rows.Count > 0)
{
this.dataGridView1.Rows.Clear();
for (int index = this.StartIndex; index < Math.Min(this.StartIndex + 5, this.LadeAssignmentDataTable.Rows.Count); index++)
{
this.dataGridView1.Rows.Add();
DataGridViewRow row = this.dataGridView1.Rows[this.dataGridView1.Rows.Count - 1];
//row.Cells[this.colOrder_int.Name].Value = LadeAssignmentDataTable.Rows[index]["Order_int"];
row.Cells[this.colLaderType_nvc.Name].Value = LadeAssignmentDataTable.Rows[index]["LaderType_nvc"];
row.Cells[this.colCarCount_int.Name].Value = LadeAssignmentDataTable.Rows[index]["CarCount_int"];
row.Cells[this.colCity_nvc.Name].Value = LadeAssignmentDataTable.Rows[index]["City_nvc"];
row.Cells[this.colGood_nvc.Name].Value = LadeAssignmentDataTable.Rows[index]["Good_nvc"];
//row.Cells[this.colWeight_flt.Name].Value = LadeAssignmentDataTable.Rows[index]["Weight_dec"];
row.Cells[this.colPortageFee_dec.Name].Value = LadeAssignmentDataTable.Rows[index]["PortageFee_dec"];
//row.Cells[this.colComment_nvc.Name].Value = LadeAssignmentDataTable.Rows[index]["Comment_nvc"];
row.Cells[this.colBoxingType_nvc.Name].Value = LadeAssignmentDataTable.Rows[index]["BoxingType_nvc"];
row.Cells[this.colCompany_nvc.Name].Value = LadeAssignmentDataTable.Rows[index]["Company_nvc"];
row.Cells[this.colRemainedCount_int.Name].Value = LadeAssignmentDataTable.Rows[index]["RemainedCount_int"];
row.Cells[this.colLadBillCount_int.Name].Value = LadeAssignmentDataTable.Rows[index]["LadBillCount_int"];
}
this.dataGridView1.Update();
this.StartIndex += 5;
if (StartIndex >= this.LadeAssignmentDataTable.Rows.Count)
{
this.StartIndex = 0;
}
}
else
{
this.dataGridView1.Rows.Clear();
}
}
catch (Exception ex)
{
}
}
public override bool Validate(params object[] value)
{
try
{
this.Description = string.Empty;
if (value.Length != Field.Length)
{
this.Description = Hepsa.Core.My.Resources.ValidationMessage.IncorrectDataType;
return(false);
}
Int64?LadeAssignmentID_bint = (Int64?)value[0];
int? Count_int = (int?)value[1];
if (LadeAssignmentID_bint.HasValue == false || Count_int.HasValue == false || Count_int == 0)
{
return(true);
}
HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillCreditFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory();
string condition = string.Format(" LadBillCredit_T.LadeAssignmentID_bint={0} AND Canceled_bit=0", LadeAssignmentID_bint);
List <HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_T> LadBillCreditList = LadBillCreditFactory.GetAllByCondition(condition);
int LadBillCreditCount = 0;
if (LadBillCreditList != null && LadBillCreditList.Count > 0)
{
LadBillCreditCount = LadBillCreditList.Count;
}
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys LadeAssignmentKey = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys();
LadeAssignmentKey.LadeAssignmentID_bint = LadeAssignmentID_bint;
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T LadeAssignmentEntity = LadeAssignmentFactory.GetBy(LadeAssignmentKey);
if (LadeAssignmentEntity != null)
{
if (LadeAssignmentEntity.CarCount_int - LadBillCreditCount < Count_int)
{
this.Description = string.Format(Hepsa.Core.My.Resources.ValidationMessage.ValueShouldNotGreater, "تعداد ماشین حذفی", LadeAssignmentEntity.CarCount_int - LadBillCreditCount);
return(false);
}
}
return(true);
}
catch (System.Exception ex)
{
this.Description = ex.Message;
return(false);
}
}
private void AllLatoolStripButton_Click(object sender, EventArgs e)
{
try
{
this.LoadLadeAssignmentCacelRequest();
LoadLadeAssignmentCancelRequestComment();
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LadeAssignmentDataTable = new DataTable();
LadeAssignmentFactory.GetAll(ref LadeAssignmentDataTable);
this.LadeAssignmentGridView.DataSource = LadeAssignmentDataTable;
}
catch (System.Exception ex)
{
throw ex;
}
}
private void LoadLadeAssignment()
{
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
Properties.Settings Setting = new HPS.Properties.Settings();
string Condition = string.Format("[LadeAssignment_T].[Accepted_bit]='false' AND (SaloonID_int IS NULL OR LT.SaloonID_int={0}) ", Setting.SaloonID_int != 0 ? Setting.SaloonID_int : 0);
DataTable LadeAssignmentDataTable = new DataTable();
LadeAssignmentFactory.GetForAccept(Condition, ref LadeAssignmentDataTable);
this.LadeAssignmentGridView.SetDataBinding(LadeAssignmentDataTable, "LadeAssignmentDataTable");
}
catch (System.Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void LoadLadeAssignment()
{
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LadeAssignmentDataTable = new DataTable();
Properties.Settings Setting = new HPS.Properties.Settings();
LadeAssignmentFactory.GetAll(ref LadeAssignmentDataTable, LadeAssignmentFactory.ServerJalaliDate, Setting.SaloonID_int);
this.LadeAssignmentGridView.DataSource = LadeAssignmentDataTable;
this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LadeAssignmentFactory.ServerJalaliDate);
this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LadeAssignmentFactory.ServerJalaliDate);
}
catch (System.Exception ex)
{
throw ex;
}
}
private void LoadLadeAssignment()
{
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LadeAssignmentDataTable = new DataTable();
Properties.Settings Setting = new HPS.Properties.Settings();
LadeAssignmentFactory.GetAll(ref LadeAssignmentDataTable, LadeAssignmentFactory.ServerJalaliDate, Setting.SaloonID_int);
if (HPS.Common.CurrentUser.user.CompanyID_int == null)
{
throw new ApplicationException("شما کاربر شرکت نیستید");
}
DataRow[] drSource = null;
drSource = LadeAssignmentDataTable.Select(String.Format("[CompanyID_int]={0}", HPS.Common.CurrentUser.user.CompanyID_int));
if (drSource != null && drSource.Length > 0)
{
this.LadeAssignmentGridView.DataSource = drSource.CopyToDataTable();
this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LadeAssignmentFactory.ServerJalaliDate);
this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LadeAssignmentFactory.ServerJalaliDate);
}
}
catch (System.Exception ex)
{
throw ex;
}
//try
//{
// HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
// Properties.Settings Setting = new HPS.Properties.Settings();
// DataTable LadeAssignmentDataTable = new DataTable();
// //LadeAssignmentFactory.GetAll(ref Ladeassgnm [LadeAssignment_T].[CompanyID_int], LadeAssignmentFactory.ServerJalaliDate, Setting.SaloonID_int);
// var pep = LadeAssignmentFactory.GetAllByCondition(String.Format("[LadeAssignment_T].[CompanyID_int]={0}", HPS.Common.CurrentUser.user.CompanyID_int));
// this.LadeAssignmentGridView.DataSource = pep;
// this.FromDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LadeAssignmentFactory.ServerJalaliDate);
// this.ToDatefaDatePicker.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LadeAssignmentFactory.ServerJalaliDate);
//}
//catch (System.Exception ex)
//{
// throw ex;
//}
}
private void ChooseLadeAssignmentAcceptedButton_Click(object sender, EventArgs e)
{
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T LadeAssignmentEntity = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T();
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys LadeAssignmentKeys = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys();
DataTable gridTable = new DataTable();
gridTable = LadeAssignmentDataTable.Copy();
DataRow[] dr = null;
LadeAssignmentFactory.BeginProc();
foreach (Janus.Windows.GridEX.GridEXRow itm in LadeAssignmentGridView.GetCheckedRows())
{
LadeAssignmentKeys.LadeAssignmentID_bint = (Int64)itm.Cells["LadeAssignmentID_bint"].Value;
LadeAssignmentEntity = LadeAssignmentFactory.GetBy(LadeAssignmentKeys);
LadeAssignmentEntity.Accepted_bit = true;
LadeAssignmentEntity.AcceptUserName_nvc = HPS.Common.CurrentUser.user.UserName_nvc;
LadeAssignmentEntity.AcceptDate_vc = LadeAssignmentFactory.ServerJalaliDate;
LadeAssignmentEntity.AcceptTime_vc = LadeAssignmentFactory.ServerTime;
LadeAssignmentFactory.Update(LadeAssignmentEntity, LadeAssignmentKeys);
dr = gridTable.Select(HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T.LadeAssignment_TField.LadeAssignmentID_bint.ToString() + "='" + (Int64)itm.Cells["LadeAssignmentID_bint"].Value + "'");
if (dr.Length > 0)
{
dr[0].Delete();
}
gridTable.AcceptChanges();
}
LadeAssignmentFactory.CommitProc();
LadeAssignmentGridView.DataSource = null;
LadeAssignmentGridView.SetDataBinding(gridTable, "gridTable");
LadeAssignmentDataTable = gridTable.Copy();
gridTable.Dispose();
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
public UserLadeDetailReport(string FromDate, string FromTime, string ToDate, string ToTime)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LaderTypeReportTable = new DataTable();
LadeAssignmentFactory.SelectLadeUserDetailReport(FromDate, FromTime, ToDate, ToTime, 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 = LadeAssignmentFactory.ServerJalaliDate;
Timetxt.Text = LadeAssignmentFactory.ServerTime;
UserName_nvctxt.DataField = "UserName_nvc";
LadeAssignmentCounttxt.DataField = "LadeAssignmentCount";
LadBillCounttxt.DataField = "LadBillCount";
CanceledLabillCounttxt.DataField = "LadeBillCancelCount";
Int64?AllLadeAssignmentcount = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["LadeAssignmentCount"]).Sum();
AllLadeAssignmentCountxt.Text = AllLadeAssignmentcount.HasValue ? AllLadeAssignmentcount.ToString() : "0";
Int64?AllLadBillcountRecords = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["LadBillCount"]).Sum();
AllLadBillCounttxt.Text = AllLadBillcountRecords.HasValue ? AllLadBillcountRecords.ToString() : "0";
Int64?Allremaindercount = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["LadeBillCancelCount"]).Sum();
AllCanceledLadBillCounttxt.Text = Allremaindercount.HasValue ? Allremaindercount.ToString() : "0";
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void LadeAssignmentAcceptForm_Load(object sender, EventArgs e)
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
LadeAssignmentKeys.LadeAssignmentID_bint = (Int64?)Hepsa.Core.Common.PersentationController.GetEntityValue(LadeAsssignmentID, TypeCode.Int64);
DataTable LadeAssignmentDataTable = new DataTable();
LadeAssignmentFactory.GetBy(LadeAssignmentKeys, ref LadeAssignmentDataTable);
LadingDate_nvcTextBox.Text = LadeAssignmentDataTable.Rows[0]["LadingDate_nvc"].ToString();
LadingTime_nvcTextBox.Text = LadeAssignmentDataTable.Rows[0]["LadingTime_nvc"].ToString();
City_vncTextBox.Text = LadeAssignmentDataTable.Rows[0]["CityID_intCity_nvc"].ToString();
CityCode_nvcTextBox.Text = LadeAssignmentDataTable.Rows[0]["CityCode_nvc"].ToString();
Good_nvcTextBox.Text = LadeAssignmentDataTable.Rows[0]["GoodID_intGood_nvc"].ToString();
// GoodCode_nvcTextBox.Text = LadeAssignmentDataTable.Rows[0]["GoodCode_nvc"].ToString();
Boxing_nvcTextBox.Text = LadeAssignmentDataTable.Rows[0]["BoxingID_intBoxingType_nvc"].ToString();
// BoxingCode_nvcTextBox.Text = LadeAssignmentDataTable.Rows[0]["BoxingCode_nvc"].ToString();
// LaderType_nvcTextBox.Text = LadeAssignmentDataTable.Rows[0]["LaderTypeID_intLaderType_nvc"].ToString();
// LaderTypeCode_nvcTextBox.Text = LadeAssignmentDataTable.Rows[0]["LaderTypeCode_nvc"].ToString();
CarCount_intNumericTextBox.Text = LadeAssignmentDataTable.Rows[0]["CarCount_int"].ToString();
Company_nvcTextBox.Text = LadeAssignmentDataTable.Rows[0]["CompanyID_intCompany_nvc"].ToString();
// CompanyCode_nvcTextBox.Text = LadeAssignmentDataTable.Rows[0]["CompanyCode_nvc"].ToString();
}
private void LoadLadeAssignmentWithDate()
{
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
Properties.Settings Setting = new HPS.Properties.Settings();
string Condition = string.Empty;
if (Setting.SaloonID_int != 0)
{
Condition = string.Format("[LadeAssignment_T].[Accepted_bit]='false' AND LadeAssignment_T.LadingDate_nvc='{0}' AND (LT.SaloonID_int ={1}) ", LadeAssignmentFactory.ServerJalaliDate, Setting.SaloonID_int);
}
else
{
Condition = string.Format("[LadeAssignment_T].[Accepted_bit]='false' AND LadeAssignment_T.LadingDate_nvc='{0}' ", LadeAssignmentFactory.ServerJalaliDate);
}
LadeAssignmentDataTable.Clear();
LadeAssignmentFactory.GetForAccept(Condition, ref LadeAssignmentDataTable);
LadeAssignmentGridView.DataSource = null;
this.LadeAssignmentGridView.SetDataBinding(LadeAssignmentDataTable, "LadeAssignmentDataTable");
Janus.Windows.GridEX.GridEXFormatStyle Focus = new Janus.Windows.GridEX.GridEXFormatStyle();
Focus.FontSize = 20;
Janus.Windows.GridEX.GridEXFormatStyle yellow = new Janus.Windows.GridEX.GridEXFormatStyle();
yellow.BackColor = System.Drawing.Color.FromArgb(253, 217, 142);
for (int i = 0; i < ((DataTable)LadeAssignmentGridView.DataSource).Rows.Count; i++)
{
if (LadeAssignmentGridView.GetRow(i).Cells["EditUserName_nvc"].Value != DBNull.Value && LadeAssignmentGridView.GetRow(i).Cells["AcceptUserName_nvc"].Value != DBNull.Value)
{
LadeAssignmentGridView.GetRow(i).RowStyle = yellow;
LadeAssignmentGridView.GetRow(i).Cells["EditUserName_nvc"].FormatStyle = yellow;
}
}
ChooseLadeAssignmentAcceptedButton.Select();
}
catch (System.Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ExistsLaderyTypeButton_Click(object sender, EventArgs e)
{
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LaderTypeReportTable = new DataTable();
LadeAssignmentFactory.SelectLaderTypeCountWithDateReport(FromDatefaDatePicker.Text, FromTimeTextBox.Text, ToDatefaDatePicker.Text, ToTimeTextBox.Text, string.Empty, ref LaderTypeReportTable);
DataTable dt = new DataTable();
dt = LaderTypeReportTable.DefaultView.ToTable(true, "Ladertype_nvc", "LaderTypeID_int");
this.LaderTypecheckedComboBox.DropDownDataSource = null;
this.LaderTypecheckedComboBox.DropDownDataSource = dt;
this.LaderTypecheckedComboBox.DropDownDataMember = "LaderType_T";
this.LaderTypecheckedComboBox.DropDownDisplayMember = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderType_nvc.ToString();
this.LaderTypecheckedComboBox.DropDownValueMember = HPS.BLL.LaderTypeBLL.BLLLaderType_T.LaderType_TField.LaderTypeID_int.ToString();
LaderTypecheckedComboBox.RetrieveStructure();
LaderTypecheckedComboBox.DropDownList.Columns[2].Visible = false;
LaderTypecheckedComboBox.DropDownList.Columns[1].Caption = "نوع بارگیر";
LaderTypecheckedComboBox.DropDownList.Columns[1].Width = 300;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
string Condition = string.Empty;
Properties.Settings Setting = new HPS.Properties.Settings();
Int32?SaloonID_int = null;
if (Setting.SaloonID_int != 0)
{
SaloonID_int = Setting.SaloonID_int;
}
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LadeAssignmentDataTable = new DataTable();
if (string.IsNullOrEmpty(LadeAssingmentID_binttextBox.Text))
{
if (!FromDatefaDatePicker.IsNull)
{
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);
}
else
{
DateTime MiladiCurrentDate = LadeAssignmentFactory.ServerDate.AddDays(-30);
Hepsa.Core.Common.MyDateTime OneMonthBeforeCurrentDate = new Hepsa.Core.Common.MyDateTime(MiladiCurrentDate);
if (FromDatefaDatePicker.Text.CompareTo(OneMonthBeforeCurrentDate.ConvertToPersianShortDate()) < 0)
{
throw new ApplicationException("تاریخ شروع نمی تواند کمتر از یک ماه اخیر باشد");
}
Condition = string.Format("Date_nvc >= '{0}'", FromDatefaDatePicker.Text);
}
}
if (!ToDatefaDatePicker.IsNull)
{
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);
}
else
{
Condition = string.Format(" {0} And Date_nvc <='{1}'", Condition, ToDatefaDatePicker.Text);
}
}
if (HPS.Common.CurrentUser.user.CompanyID_int != null)
{
Condition = string.Format("{0} And CompanyID_int = {1}", Condition, HPS.Common.CurrentUser.user.CompanyID_int);
}
if (this.LaderTypeID_intComboBox.SelectedIndex != -1)
{
Condition = string.Format("{0} And LaderTypeID = {1}", Condition, LaderTypeID_intComboBox.SelectedValue.ToString());
}
if (GoodID_intcomboBox.SelectedIndex != -1)
{
Condition = string.Format("{0} And GoodID_int = {1}", Condition, GoodID_intcomboBox.SelectedValue.ToString());
}
if (PortPlaceID_intcomboBox.SelectedIndex != -1)
{
Condition = string.Format("{0} And PortPlaceID_int = {1}", Condition, PortPlaceID_intcomboBox.SelectedValue.ToString());
}
if (DestinationCityID_intcomboBox.SelectedIndex != -1)
{
Condition = string.Format("{0} And CityID_int = {1} ", Condition, DestinationCityID_intcomboBox.SelectedValue.ToString());
}
if (Condition.Length > 0)
{
if (Condition.Substring(0, 4) == " And")
{
Condition = Condition.Substring(4, Condition.Length - 4);
}
}
}
else
{
DestinationCityID_intcomboBox.SelectedIndex = -1;
PortPlaceID_intcomboBox.SelectedIndex = -1;
GoodID_intcomboBox.SelectedIndex = -1;
LaderTypeID_intComboBox.SelectedIndex = -1;
this.FromDatefaDatePicker.IsNull = true;
this.ToDatefaDatePicker.IsNull = true;
if (HPS.Common.CurrentUser.user.CompanyID_int != null)
{
Condition = string.Format("CompanyID_int = {0} and ", HPS.Common.CurrentUser.user.CompanyID_int);
}
Condition += string.Format(" LadeAssignmentID_bint = {0} ", LadeAssingmentID_binttextBox.Text);
}
LadeAssignmentFactory.GetAllByCondition(Condition, SaloonID_int, ref LadeAssignmentDataTable);
this.LadeAssignmentGridView.AutoGenerateColumns = false;
this.LadeAssignmentGridView.DataSource = LadeAssignmentDataTable;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void LadeAssignmentGridView_SelectionChanged(object sender, EventArgs e)
{
try
{
if (this.LadeAssignmentGridView.CurrentRow == null)
{
return;
}
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys LadeAssignmentKey = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys();
LadeAssignmentKey.LadeAssignmentID_bint = (Int64?)this.LadeAssignmentGridView.CurrentRow.Cells["colLadeAssignmentID_bint"].Value;
HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillCreditFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory();
string condition = "LadBillCredit_T.LadeAssignmentID_bint='" + Hepsa.Core.Common.PersentationController.GetEntityValue(this.LadeAssignmentGridView.CurrentRow.Cells[colLadeAssignmentID_bint.Name].Value, TypeCode.Int64) + "' or(LadBillCredit_T.LadBillCreditID_int is not null and LadBillCredit_T.Canceled_bit=0 AND LadBillCredit_T.Turn_bit is not NULL)";
List <HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_T> LadBillCreditList = LadBillCreditFactory.GetAllByCondition(condition);
int LadBillCreditCount = 0;
int canceledLadBillCreditCount = 0;
if (LadBillCreditList != null && LadBillCreditList.Count > 0)
{
LadBillCreditCount = LadBillCreditList.Count;
canceledLadBillCreditCount = LadBillCreditList.FindAll(itm => itm.Canceled_bit.Value == true).Count;
}
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
List <HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T> LadeAssignmentList = LadeAssignmentFactory.GetAllBy(HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T.LadeAssignment_TField.LadeAssignmentID_bint, (Int64)LadeAssignmentGridView.CurrentRow.Cells[colLadeAssignmentID_bint.Name].Value);
int CarCount = (int)Hepsa.Core.Common.PersentationController.GetEntityValue(this.LadeAssignmentGridView.CurrentRow.Cells[colCarCount_int.Name].Value, TypeCode.Int32);
if (LadeAssignmentList != null && LadeAssignmentList.Count > 0)
{
HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory LadeCancelAssignmentFactory = new HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory();
DataTable LadeCancelAssignmentTable = new DataTable();
LadeCancelAssignmentFactory.GetAllBy(HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T.LadeCancelAssignment_TField.LadeAssignmentID_bint, LadeAssignmentKey.LadeAssignmentID_bint, ref LadeCancelAssignmentTable);
if (LadeCancelAssignmentTable != null && LadeCancelAssignmentTable.Rows.Count > 0)
{
Int32?Canceled = (from row in LadeCancelAssignmentTable.AsEnumerable() select(Int32) row["Count_int"]).Sum();
if (CarCount - LadBillCreditCount - Canceled >= 0)
{
LadeCancelStripButton.Enabled = true;
}
else
{
LadeCancelStripButton.Enabled = false;
}
}
else
{
if (CarCount - LadBillCreditCount - canceledLadBillCreditCount != 0)
{
LadeCancelStripButton.Enabled = true;
}
else
{
LadeCancelStripButton.Enabled = false;
}
}
}
if (int.Parse(LadeAssignmentGridView.CurrentRow.Cells["colRemainedCar"].Value.ToString()) > 0)
{
LadeCancelStripButton.Enabled = true;
}
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void LadeCancelStripButton_Click(object sender, EventArgs e)
{
try
{
BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory LadeCancelAssignmentFactory = new HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory();
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys LadeAssignmentKey = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys();
LadeAssignmentKey.LadeAssignmentID_bint = (Int64?)this.LadeAssignmentGridView.CurrentRow.Cells["colLadeAssignmentID_bint"].Value;
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T LadeAssignmentEntity = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T();
LadeAssignmentEntity = LadeAssignmentFactory.GetBy(LadeAssignmentKey);
if (LadeAssignmentEntity.Accepted_bit == true)
{
HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TFactory LadeAssignmentCacelRequestFactory = new HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TFactory();
DataTable LadeAssignmentCacelRequestDataTable = new DataTable();
LadeAssignmentCacelRequestFactory.GetAllBy(HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_T.LadeAssignmentCacelRequest_TField.LadeAssignmentID_bint, LadeAssignmentKey.LadeAssignmentID_bint, ref LadeAssignmentCacelRequestDataTable);
if (!(LadeAssignmentCacelRequestDataTable != null && LadeAssignmentCacelRequestDataTable.Rows.Count > 0 && HPS.Common.CurrentUser.user.CompanyID_int.HasValue == false))
{
throw new ApplicationException("این اطلاع سرانی بار تأیید شده است و قابل تغییر نمی باشد");
}
if (string.IsNullOrEmpty(LadeAssignmentCacelRequestDataTable.Rows[0]["AcceptedDate_nvc"].ToString()))
{
throw new ApplicationException("درخواست انصراف یا اعمال تغییرات قبول نشده است");
}
}
DataTable remainedLadeAssignmentTable = new DataTable();
string remainedCarCondition = string.Format("LadeAssignmentID_bint={0}", Hepsa.Core.Common.PersentationController.GetEntityValue(this.LadeAssignmentGridView.CurrentRow.Cells[colLadeAssignmentID_bint.Name].Value, TypeCode.Int64));
LadeAssignmentFactory.SelectRemainedDetailSelectByCondition(remainedCarCondition, remainedLadeAssignmentTable);
int remaindCount_int = 0;
if (remainedLadeAssignmentTable != null && remainedLadeAssignmentTable.Rows.Count > 0)
{
remaindCount_int = (Int32)remainedLadeAssignmentTable.Rows[remainedLadeAssignmentTable.Rows.Count - 1]["RemainderCount_int"];
}
if (remaindCount_int == 0)
{
string LadeCancelCondition = string.Format("LadeCancelAssignment_T.LadeAssignmentID_bint={0}", Hepsa.Core.Common.PersentationController.GetEntityValue(this.LadeAssignmentGridView.CurrentRow.Cells[colLadeAssignmentID_bint.Name].Value, TypeCode.Int64));
List <HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T> LadeCancelList = LadeCancelAssignmentFactory.GetAllByCondition(LadeCancelCondition);
if (LadeCancelList != null && LadeCancelList.Count > 0)
{
throw new ApplicationException("بار مورد نظر باطل شده است");
}
else
{
HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillCreditFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory();
string condition = "LadBillCredit_T.LadeAssignmentID_bint='" + Hepsa.Core.Common.PersentationController.GetEntityValue(this.LadeAssignmentGridView.CurrentRow.Cells[colLadeAssignmentID_bint.Name].Value, TypeCode.Int64) + "' and LadBillCredit_T.LadBillCreditID_int is not null and LadBillCredit_T.Canceled_bit=0 ";
List <HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_T> LadBillCreditList = new List <HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_T>();
LadBillCreditList = LadBillCreditFactory.GetAllByCondition(condition);
if (LadBillCreditList != null && LadBillCreditList.Count > 0)
{
throw new ApplicationException("بار مورد نظر مجوز گرفته است");
}
}
}
HPS.Present.LadeCancelAssignment.LadeCancelAssignmentEntityForm LadeCancelAssignment = new HPS.Present.LadeCancelAssignment.LadeCancelAssignmentEntityForm(LadeAssignmentKey);
LadeCancelAssignment.ShowDialog();
LadeAssignmentGridView_SelectionChanged(this.LadeAssignmentCommentGridView, null);
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
string Condition = string.Empty;
Properties.Settings Setting = new HPS.Properties.Settings();
Int32?SaloonID_int = null;
if (Setting.SaloonID_int != 0)
{
SaloonID_int = Setting.SaloonID_int;
}
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LadeAssignmentDataTable = new DataTable();
if (string.IsNullOrEmpty(LadeAssingmentID_binttextBox.Text))
{
if (!FromDatefaDatePicker.IsNull)
{
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);
}
else
{
Condition = string.Format("Date_nvc >= '{0}'", FromDatefaDatePicker.Text);
}
}
if (!ToDatefaDatePicker.IsNull)
{
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);
}
else
{
Condition = string.Format(" {0} And Date_nvc <='{1}'", Condition, ToDatefaDatePicker.Text);
}
}
if (this.CompanyID_intComboBox.SelectedIndex != -1)
{
Condition = string.Format("{0} And CompanyID_int = {1}", Condition, CompanyID_intComboBox.SelectedValue.ToString());
}
if (this.LaderTypeID_intComboBox.SelectedIndex != -1)
{
Condition = string.Format("{0} And LaderTypeID = {1}", Condition, LaderTypeID_intComboBox.SelectedValue.ToString());
}
if (GoodID_intcomboBox.SelectedIndex != -1)
{
Condition = string.Format("{0} And GoodID_int = {1}", Condition, GoodID_intcomboBox.SelectedValue.ToString());
}
if (PortPlaceID_intcomboBox.SelectedIndex != -1)
{
Condition = string.Format("{0} And PortPlaceID_int = {1}", Condition, PortPlaceID_intcomboBox.SelectedValue.ToString());
}
if (DestinationCityID_intcomboBox.SelectedIndex != -1)
{
Condition = string.Format("{0} And CityID_int = {1} ", Condition, DestinationCityID_intcomboBox.SelectedValue.ToString());
}
if (Condition.Length > 0)
{
if (Condition.Substring(0, 4) == " And")
{
Condition = Condition.Substring(4, Condition.Length - 4);
}
}
}
else
{
DestinationCityID_intcomboBox.SelectedIndex = -1;
PortPlaceID_intcomboBox.SelectedIndex = -1;
GoodID_intcomboBox.SelectedIndex = -1;
LaderTypeID_intComboBox.SelectedIndex = -1;
CompanyID_intComboBox.SelectedIndex = -1;
this.FromDatefaDatePicker.IsNull = true;
//.SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LadeAssignmentFactory.ServerJalaliDate);
this.ToDatefaDatePicker.IsNull = true;
//SelectedDateTime = FarsiLibrary.Utils.PersianDateConverter.ToGregorianDateTime(LadeAssignmentFactory.ServerJalaliDate);
Condition = string.Format(" LadeAssignmentID_bint = {0} ", LadeAssingmentID_binttextBox.Text);
}
LadeAssignmentFactory.GetAllByCondition(Condition, SaloonID_int, ref LadeAssignmentDataTable);
this.LadeAssignmentGridView.AutoGenerateColumns = false;
this.LadeAssignmentGridView.DataSource = LadeAssignmentDataTable;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void EditButton_Click(object sender, EventArgs e)
{
try
{
bool CanNotChangeCount = false;
BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys LadeAssignmentKey = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TKeys();
LadeAssignmentKey.LadeAssignmentID_bint = (Int64?)this.LadeAssignmentGridView.CurrentRow.Cells["colLadeAssignmentID_bint"].Value;
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T LadeAssignmentEntity = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_T();
LadeAssignmentEntity = LadeAssignmentFactory.GetBy(LadeAssignmentKey);
if (LadeAssignmentEntity.Accepted_bit == true)
{
///Select ladbillcredit
HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillCreditFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory();
string condition = "LadBillCredit_T.LadeAssignmentID_bint='" + Hepsa.Core.Common.PersentationController.GetEntityValue(this.LadeAssignmentGridView.CurrentRow.Cells[colLadeAssignmentID_bint.Name].Value, TypeCode.Int64) + "' or (LadBillCredit_T.LadBillCreditID_int is not null and LadBillCredit_T.Canceled_bit=0 AND LadBillCredit_T.Turn_bit is not NULL) order by [LadBillCredit_T].[LadBillCreditID_int] desc";
List <HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_T> LadBillCreditList = LadBillCreditFactory.GetAllByCondition(condition);
///Select canceleced
HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory LadeCancelFactory = new HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory();
List <HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T> LadeCancelList = new List <HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T>();
LadeCancelList = LadeCancelFactory.GetAllByCondition(string.Format("LadeCancelAssignment_T.LadeAssignmentID_bint={0} order by [LadeCancelAssignment_T].[LadeCancelAssignmentID_int] desc", Hepsa.Core.Common.PersentationController.GetEntityValue(this.LadeAssignmentGridView.CurrentRow.Cells[colLadeAssignmentID_bint.Name].Value, TypeCode.Int64)));
///select Remained
DataTable remainedLadeAssignmentTable = new DataTable();
string RemainedCondition = string.Format("LadeAssignmentID_bint={0}", Hepsa.Core.Common.PersentationController.GetEntityValue(this.LadeAssignmentGridView.CurrentRow.Cells[colLadeAssignmentID_bint.Name].Value, TypeCode.Int64));
LadeAssignmentFactory.SelectRemainedDetailSelectByCondition(RemainedCondition, remainedLadeAssignmentTable);
int remaindCount_int = 0;
if (remainedLadeAssignmentTable != null && remainedLadeAssignmentTable.Rows.Count > 0)
{
remaindCount_int = (Int32)remainedLadeAssignmentTable.Rows[remainedLadeAssignmentTable.Rows.Count - 1]["RemainderCount_int"];
}
if (LadeCancelList != null && LadeCancelList.Count > 0)
{
if (LadeCancelList[0].Count_int != null && remaindCount_int == 0)
{
throw new ApplicationException("این اطلاع رسانی باطل شده است و تعداد مانده ها صفر می باشد");
}
else
{
CanNotChangeCount = true;
}
}
if (remaindCount_int == 0)
{
throw new ApplicationException("بار مورد نظر مجوز گرفته است");
}
else
{
CanNotChangeCount = true;
}
HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TFactory LadeAssignmentCacelRequestFactory = new HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_TFactory();
DataTable LadeAssignmentCacelRequestDataTable = new DataTable();
LadeAssignmentCacelRequestFactory.GetAllBy(HPS.BLL.LadeAssignmentCacelRequestBLL.BLLLadeAssignmentCacelRequest_T.LadeAssignmentCacelRequest_TField.LadeAssignmentID_bint, LadeAssignmentKey.LadeAssignmentID_bint, ref LadeAssignmentCacelRequestDataTable);
if (!(LadeAssignmentCacelRequestDataTable != null && LadeAssignmentCacelRequestDataTable.Rows.Count > 0 && HPS.Common.CurrentUser.user.CompanyID_int.HasValue == false))
{
throw new ApplicationException("این اطلاع رسانی بار تأیید شده است و قابل تغییر نمی باشد");
}
if (string.IsNullOrEmpty(LadeAssignmentCacelRequestDataTable.Rows[0]["AcceptedDate_nvc"].ToString()))
{
throw new ApplicationException("درخواست انصراف یا اعمال تغییرات قبول نشده است");
}
}
LadeAssignmentInforming LadeAssignment = new LadeAssignmentInforming(BaseEntityForm1.enmState.Edit, (DataTable)this.LadeAssignmentGridView.DataSource, LadeAssignmentKey, CanNotChangeCount);
LadeAssignment.ShowDialog();
}
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 SaveButton_Click(object sender, EventArgs e)
{
HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory LadBillCreditFactory = new HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_TFactory();
HPS.BLL.LadBillCreditCancelCommentBLL.BLLLadBillCreditCancelComment_TFactory LadBillCreditCancelCommentFactory = new HPS.BLL.LadBillCreditCancelCommentBLL.BLLLadBillCreditCancelComment_TFactory();
try
{
if (LadBillCreditCancelCommentID_intCheckedListBox.CheckedItems.Count == 0)
{
throw new ApplicationException("توضیحات ابطال مجوز انتخاب نشده است");
}
HPS.BLL.LadBillCreditBLL.BLLLadBillCredit_T LadBillCreditEntity = LadBillCreditFactory.GetBy(this._Key);
HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
if (LadBillCreditEntity == null)
{
throw new HPS.Exceptions.LadBillCreditNotFound();
}
LadBillCreditEntity.Canceled_bit = true;
LadBillCreditEntity.CanceledComment_nvc = this.LadBillCreditCancelComment_nvcTextBox.Text;
LadBillCreditEntity.CanceledDate_nvc = LadBillCreditFactory.ServerJalaliDate;
LadBillCreditEntity.CanceledTime_nvc = LadBillCreditFactory.ServerTime;
LadBillCreditEntity.CanceledUserName_nvc = HPS.Common.CurrentUser.user.UserName_nvc;
if (TurnLeftRadioButton.Checked == true)
{
LadBillCreditEntity.Turn_bit = true;
}
else if (TurnCancelRadioButton.Checked == true)
{
LadBillCreditEntity.Turn_bit = false;
}
if (LadBillCreditEntity.Turn_bit.HasValue == false)
{
throw new ApplicationException("وضعیت نوبت را تعیین نمایید ");
}
if (LadeAssignmentLeftradioButton.Checked == false && LadeAssginmentCancelradioButton.Checked == false && OtherRemainedCancelRadioButton.Checked == false)
{
throw new ApplicationException("وضعیت اطلاع رسانی را تعیین نمایید ");
}
string strSelect = string.Format("TrafficID_bint='{0}'", _TrafficKey.TrafficID_bint);
DataRow[] drSelect = _dataTable.Select(strSelect);
DataTable TrafficStatusDataTable = new DataTable();
if (drSelect != null && drSelect.Length > 0)
{
LadBillCreditFactory.GetLastStatusForCancelLadBillCredit((string)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["NumberPlate_nvc"], TypeCode.String), (string)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["SerialPlate_nvc"], TypeCode.String), (string)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["CarCardNumber_nvc"], TypeCode.String), TrafficStatusDataTable);
}
if (TrafficStatusDataTable != null && TrafficStatusDataTable.Rows.Count > 0)
{
bool? HasTurn_bit = (bool?)Hepsa.Core.Common.PersentationController.GetEntityValue(TrafficStatusDataTable.Rows[0]["HasTurn_bit"], TypeCode.Boolean);
bool? TurnReturn_bit = (bool?)Hepsa.Core.Common.PersentationController.GetEntityValue(TrafficStatusDataTable.Rows[0]["TurnReturn_bit"], TypeCode.Boolean);
bool? TurnCanceled_bit = (bool?)Hepsa.Core.Common.PersentationController.GetEntityValue(TrafficStatusDataTable.Rows[0]["TurnCanceled_bit"], TypeCode.Boolean);
bool? HasLadBillCredit_bit = (bool?)Hepsa.Core.Common.PersentationController.GetEntityValue(TrafficStatusDataTable.Rows[0]["HasLadBillCredit_bit"], TypeCode.Boolean);
bool? LadBillCreditCancel_bit = (bool?)Hepsa.Core.Common.PersentationController.GetEntityValue(TrafficStatusDataTable.Rows[0]["LadBillCreditCancel_bit"], TypeCode.Boolean);
bool? LadBillCreditTurn_bit = (bool?)Hepsa.Core.Common.PersentationController.GetEntityValue(TrafficStatusDataTable.Rows[0]["LadBillCreditTurn_bit"], TypeCode.Boolean);
bool? TurnAccepted_bit = (bool?)Hepsa.Core.Common.PersentationController.GetEntityValue(TrafficStatusDataTable.Rows[0]["TurnAccepted_bit"], TypeCode.Boolean);
Int64?AcceptedTurnNumber_bint = (Int64?)Hepsa.Core.Common.PersentationController.GetEntityValue(TrafficStatusDataTable.Rows[0]["AcceptedTurnNumber_bint"], TypeCode.Int64);
// DateTime TrafficDate = DateTime.Parse((new Hepsa.Core.Common.MyDateTime(TrafficEntity.Date_nvc)).MyDate.ToString("yyyy/MM/dd") + " " + TrafficEntity.Time_nvc);
#region Conditions
if ((Int32)drSelect[0]["ServiceID_int"] == 2)
{
if (TrafficStatusDataTable != null && TrafficStatusDataTable.Rows.Count > 0)
{
if (HasTurn_bit.HasValue == false || HasTurn_bit == true)
{
if (TurnAccepted_bit.HasValue && TurnAccepted_bit == true)
{
if (TurnCanceled_bit.HasValue && TurnCanceled_bit == true)
{
throw new ApplicationException("این نوبت باطل شده است");
}
else
{
if (HasLadBillCredit_bit.HasValue && HasLadBillCredit_bit == true)
{
if (LadBillCreditCancel_bit.HasValue && LadBillCreditCancel_bit == false)
{
if (LadBillCreditTurn_bit.HasValue && LadBillCreditTurn_bit == true)
{
//محاسبه مدت مجاز سفر
DateTime NowDate = DateTime.Parse((new Hepsa.Core.Common.MyDateTime(TrafficFactory.ServerJalaliDate)).MyDate.ToString("yyyy/MM/dd") + " " + TrafficFactory.ServerTime);
DataTable TrafficDataTable = new DataTable();
if (TrafficDataTable != null && TrafficDataTable.Rows.Count > 0)
{
Int32 _CityTravelHour = 0;
if (!string.IsNullOrEmpty(TrafficDataTable.Rows[0]["TravelTime_int"].ToString()))
{
_CityTravelHour = Convert.ToInt32(TrafficDataTable.Rows[0]["TravelTime_int"].ToString());
}
///////////////
string _OutDate = TrafficDataTable.Rows[0]["Date_nvc"].ToString();
string _OutTime = TrafficDataTable.Rows[0]["Time_nvc"].ToString();
DateTime OutDate = DateTime.Parse((new Hepsa.Core.Common.MyDateTime(_OutDate)).MyDate.ToString("yyyy/MM/dd") + " " + _OutTime);
if (TrafficDataTable.Rows[0]["Out_bit"].ToString() == "False")
{
TimeSpan date = NowDate - OutDate;
if (date.TotalHours < _CityTravelHour)
{
throw new ApplicationException("مدت مجاز سفر برای این کامیون تمام نشده است و امکان ادامه عملیات ممکن نیست");
}
}
}
}
else
{
if (TurnLeftRadioButton.Checked)
{
DataTable TurnStatusDataTable = new DataTable();
//*************اگر خودرو خارج شده باشد اجازه حفظ نوبت را نداشته باشد93/06/10
List <HPS.BLL.TrafficBLL.BLLTraffic_T> TrafficList = TrafficFactory.GetAllBy(HPS.BLL.TrafficBLL.BLLTraffic_T.Traffic_TField.TrafficNumber_bint, drSelect[0]["TrafficNumber_bint"]);
if (TrafficList.Count > 0 && TrafficList != null)
{
foreach (HPS.BLL.TrafficBLL.BLLTraffic_T item in TrafficList)
{
if (item.Out_bit == true)
{
//LadBillCreditEntity.Turn_bit = false;
Hepsa.Core.Common.MessageBox.InformationMessage("این خودرو خارج شده است، امکان حفظ نوبت وجود ندارد");
return;
}
}
}
//BLL.SettingsBLL.BLLSetting_TKeys SettingKey = new BLL.SettingsBLL.BLLSetting_TKeys();
//BLL.SettingsBLL.BLLSetting_T SettingEntity = new BLL.SettingsBLL.BLLSetting_T();
//BLL.SettingsBLL.BLLSetting_TFactory SettingsFactory = new BLL.SettingsBLL.BLLSetting_TFactory();
//SettingKey.SettingID_int = 1009;
//SettingEntity = SettingsFactory.GetBy(SettingKey);
//TrafficFactory.SelectActiveTurnsForInTraffic(drSelect[0]["NumberPlate_nvc"].ToString(), drSelect[0]["SerialPlate_nvc"].ToString(), SettingEntity.Value_nvc, "00:00:00", TrafficFactory.ServerJalaliDate, "23:59:59", TurnStatusDataTable);
TrafficFactory.GetTurnStatus((string)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["NumberPlate_nvc"], TypeCode.String), (string)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["SerialPlate_nvc"], TypeCode.String), TurnStatusDataTable);
if (TurnStatusDataTable != null && TurnStatusDataTable.Rows.Count > 0)
{
if ((bool?)(Hepsa.Core.Common.PersentationController.GetEntityValue(TurnStatusDataTable.Rows[0]["Canceled_bit"], TypeCode.Boolean)) != false)
{
throw new ApplicationException(string.Format("ناوگان دارای شماره نوبت تأییدی < {0} >می باشد", TurnStatusDataTable.Rows[0]["AcceptedTurnNumber_bint"]));
}
}
DataTable LadBillCreditTrafficStatusDataTable = new DataTable();
LadBillCreditFactory.GetLadBillCreditTrafficStatus((string)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["NumberPlate_nvc"], TypeCode.String), (string)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["SerialPlate_nvc"], TypeCode.String), LadBillCreditTrafficStatusDataTable);
if (LadBillCreditTrafficStatusDataTable != null && LadBillCreditTrafficStatusDataTable.Rows.Count > 0)
{
int? LadBillCredit = (int?)Hepsa.Core.Common.PersentationController.GetEntityValue(LadBillCreditTrafficStatusDataTable.Rows[0]["LadBillCreditID_int"], TypeCode.Int32);
int? TurnCancelComment = (int?)Hepsa.Core.Common.PersentationController.GetEntityValue(LadBillCreditTrafficStatusDataTable.Rows[0]["TurnCancelCommantID_int"], TypeCode.Int32);
bool?Turnaccepted = (bool?)Hepsa.Core.Common.PersentationController.GetEntityValue(LadBillCreditTrafficStatusDataTable.Rows[0]["Turnaccepted_bit"], TypeCode.Boolean);
string strHas2LadBill = string.Format("TrafficID_bint='{0}'", drSelect[0]["TrafficID_bint"]);
string strSecondStatus = string.Format("TrafficID_bint>'{0}'", drSelect[0]["TrafficID_bint"]);
DataRow[] drHas2LadBill = LadBillCreditTrafficStatusDataTable.Select(strHas2LadBill);
DataRow[] drSecondStatus = LadBillCreditTrafficStatusDataTable.Select(strSecondStatus);
if (drHas2LadBill != null && drHas2LadBill.Length > 0)
{
if (drSecondStatus != null && drSecondStatus.Length > 0)
{
int? LadBillCreditSecond = (int?)Hepsa.Core.Common.PersentationController.GetEntityValue(drSecondStatus[0]["LadBillCreditID_int"], TypeCode.Int32);
int? TurnCancelCommentSecond = (int?)Hepsa.Core.Common.PersentationController.GetEntityValue(drSecondStatus[0]["TurnCancelCommantID_int"], TypeCode.Int32);
bool?TurnacceptedSecond = (bool?)Hepsa.Core.Common.PersentationController.GetEntityValue(drSecondStatus[0]["Turnaccepted_bit"], TypeCode.Boolean);
if (TurnacceptedSecond.HasValue && TurnacceptedSecond == true)
{
if (LadBillCreditSecond.HasValue)
{
throw new ApplicationException(string.Format("این ناوگان به شماره نوبت< {0} >و شماره قبض< {1} >مجوز گرفته است", drSecondStatus[0]["AcceptedTurnNumber_bint"], drSecondStatus[0]["TrafficNumber_bint"]));
}
else
{
if (TurnCancelCommentSecond.HasValue == false)
{
throw new ApplicationException(string.Format("این ناوگان داراي شماره نوبت تأييد شده< {0} >مي باشد", drSecondStatus[0]["AcceptedTurnNumber_bint"], drSecondStatus[0]["TrafficNumber_bint"]));
}
}
}
}
}
else
{
DataTable TurnTtatusDataTable = new DataTable();
TrafficFactory.GetTurnStatus((string)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["NumberPlate_nvc"], TypeCode.String), (string)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["SerialPlate_nvc"], TypeCode.String), TurnTtatusDataTable);
if (TurnTtatusDataTable != null && TurnTtatusDataTable.Rows.Count > 0)
{
if ((bool?)(Hepsa.Core.Common.PersentationController.GetEntityValue(TurnStatusDataTable.Rows[0]["Canceled_bit"], TypeCode.Boolean)) != false)
{
throw new ApplicationException(string.Format("ناوگان دارای شماره نوبت تأییدی < {0} >می باشد", TurnStatusDataTable.Rows[0]["AcceptedTurnNumber_bint"]));
}
}
}
}
}
else
{
if (TurnCancelRadioButton.Checked == true)
{
LadBillCreditEntity.Turn_bit = false;
//*************اگر خودرو خارج نشده باشد اجازه ابطال را نداشته باشد94/10/01
List <HPS.BLL.TrafficBLL.BLLTraffic_T> TrafficOutList = TrafficFactory.GetAllByCondition(string.Format("[Traffic_T].Out_bit=1 and [Traffic_T].TrafficNumber_bint={0}", drSelect[0]["TrafficNumber_bint"].ToString()));
if (TrafficOutList.Count == 0)
{
Hepsa.Core.Common.MessageBox.InformationMessage("این خودرو خارج نشده است، امکان ابطال وجود ندارد");
return;
}
}
//ابطال نوبت
HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory TurnManagementFactory = new HPS.BLL.TurnManagementBLL.BLLTurnManagement_TFactory();
HPS.BLL.TurnManagementBLL.BLLTurnManagement_T TurnManagementEntity = new HPS.BLL.TurnManagementBLL.BLLTurnManagement_T();
TurnManagementEntity.TurnCancelCommantID_int = 11;
TurnManagementEntity.TurnCancelCommment_nvc = "ابطال نوبت هنگام ابطال مجوز";
TurnManagementEntity.Return_bit = false;
TurnManagementEntity.Date_nvc = TurnManagementFactory.ServerJalaliDate;
TurnManagementEntity.Time_nvc = TurnManagementFactory.ServerTime;
TurnManagementEntity.UserName_nvc = HPS.Common.CurrentUser.user.UserName_nvc;
TurnManagementEntity.TrafficID_bint = (Int64?)drSelect[0]["TrafficID_bint"];
TurnManagementFactory.Insert(TurnManagementEntity);
}
}
}
else
{
DataTable TurnStatusDataTable = new DataTable();
TrafficFactory.GetTurnStatus((string)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["NumberPlate_nvc"], TypeCode.String), (string)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["SerialPlate_nvc"], TypeCode.String), TurnStatusDataTable);
if (TurnStatusDataTable != null && TurnStatusDataTable.Rows.Count > 0)
{
throw new ApplicationException(string.Format("ناوگان دارای شماره نوبت تأییدی < {0} >می باشد", TurnStatusDataTable.Rows[TurnStatusDataTable.Rows.Count - 1]["AcceptedTurnNumber_bint"]));
}
}
}
else
{
if (TurnLeftRadioButton.Checked)
{
throw new ApplicationException(string.Format("این ناوگان دارای شماره نوبت تأیید شده {0} می باشد ومجوز نگرفته است", AcceptedTurnNumber_bint));
}
}
}
}
else
{
DataTable TrafficStatusForAcceptTurnDataTable = new DataTable();
TrafficFactory.GetLastStatusForAcceptTurn((Int64)Hepsa.Core.Common.PersentationController.GetEntityValue(drSelect[0]["TrafficID_bint"], TypeCode.Int64), TrafficStatusForAcceptTurnDataTable);
if (TrafficStatusForAcceptTurnDataTable != null && TrafficStatusForAcceptTurnDataTable.Rows.Count > 0)
{
throw new ApplicationException(string.Format("این ناوگان دارای شماره نوبت تأیید شده {0} می باشد ومجوز نگرفته است", TrafficStatusForAcceptTurnDataTable.Rows[0]["AcceptedTurnNumber_bint"]));
}
}
}
}
else
{
throw new ApplicationException("نوبت معتبر ندارد");
}
}
#endregion
}
LadBillCreditFactory.BeginProc();
if (LadeAssginmentCancelradioButton.Checked)
{
//ابطال اطلاع رسانی بار
LadBillCreditFactory.Update(LadBillCreditEntity, this._Key);
HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory LadeCancelAssignmentFactory = new HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory();
HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T LadeCancelAssignmentEntity = new HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T();
LadeCancelAssignmentEntity.LadeAssignmentID_bint = _LaKey.LadeAssignmentID_bint.Value;
LadeCancelAssignmentEntity.LadeCancelCommentID_int = 6;
LadeCancelAssignmentEntity.LadeCancelComment_nvc = "ابطال اطلاع رسانی بار هنگام ابطال مجوز";
LadeCancelAssignmentEntity.Count_int = 1;
LadeCancelAssignmentEntity.Date_nvc = LadeCancelAssignmentFactory.ServerJalaliDate;
LadeCancelAssignmentEntity.Time_nvc = LadeCancelAssignmentFactory.ServerTime;
LadeCancelAssignmentEntity.UserName_nvc = HPS.Common.CurrentUser.user.UserName_nvc;
LadeCancelAssignmentFactory.Insert(LadeCancelAssignmentEntity);
}
else if (OtherRemainedCancelRadioButton.Checked)
{
//ابطال اطلاع رسانی بار و باقی مانده ها
HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory LadeCancelAssignmentFactory = new HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_TFactory();
HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T LadeCancelAssignmentEntity = new HPS.BLL.LadeCancelAssignmentBLL.BLLLadeCancelAssignment_T();
BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable remainedLadeAssignmentTable = new DataTable();
string condition = string.Format("LadeAssignmentID_bint={0}", _LaKey.LadeAssignmentID_bint.Value);
LadeAssignmentFactory.SelectRemainedDetailSelectByCondition(condition, remainedLadeAssignmentTable);
int remaindCount_int = 0;
if (remainedLadeAssignmentTable != null && remainedLadeAssignmentTable.Rows.Count > 0)
{
remaindCount_int = (Int32)remainedLadeAssignmentTable.Rows[remainedLadeAssignmentTable.Rows.Count - 1]["RemainderCount_int"];
}
LadBillCreditFactory.Update(LadBillCreditEntity, this._Key);
LadeCancelAssignmentEntity.LadeAssignmentID_bint = _LaKey.LadeAssignmentID_bint.Value;
LadeCancelAssignmentEntity.LadeCancelCommentID_int = 6;
LadeCancelAssignmentEntity.LadeCancelComment_nvc = "ابطال اطلاع رسانی بار هنگام ابطال مجوز";
LadeCancelAssignmentEntity.Count_int = remaindCount_int + 1;
LadeCancelAssignmentEntity.Date_nvc = LadeCancelAssignmentFactory.ServerJalaliDate;
LadeCancelAssignmentEntity.Time_nvc = LadeCancelAssignmentFactory.ServerTime;
LadeCancelAssignmentEntity.UserName_nvc = HPS.Common.CurrentUser.user.UserName_nvc;
LadeCancelAssignmentFactory.Insert(LadeCancelAssignmentEntity);
}
else
{
LadBillCreditFactory.Update(LadBillCreditEntity, this._Key);
}
//ابطال مجوز
for (int index = 0; index < this.LadBillCreditCancelCommentID_intCheckedListBox.CheckedItems.Count; index++)
{
HPS.BLL.LadBillCreditCancelCommentBLL.BLLLadBillCreditCancelComment_T LadBillCreditCancelCommentEntity = new HPS.BLL.LadBillCreditCancelCommentBLL.BLLLadBillCreditCancelComment_T();
LadBillCreditCancelCommentEntity.LadBillCreditID_int = this._Key.LadBillCreditID_int;
LadBillCreditCancelCommentEntity.LadBillCancelCommentID_int = ((HPS.BLL.LadBillCancelCommentBLL.BLLLadBillCancelComment_T) this.LadBillCreditCancelCommentID_intCheckedListBox.CheckedItems[index]).LadBillCancelCommentID_int;
LadBillCreditCancelCommentEntity.LadbillCancelComment_nvc = ((HPS.BLL.LadBillCancelCommentBLL.BLLLadBillCancelComment_T) this.LadBillCreditCancelCommentID_intCheckedListBox.CheckedItems[index]).LadbillCancelComment_nvc;
LadBillCreditCancelCommentFactory.Insert(LadBillCreditCancelCommentEntity);
}
LadBillCreditFactory.CommitProc();
if (this._dataTable != null)
{
DataRow[] dr = this._dataTable.Select(string.Format("LadBillCreditID_int = {0}", this._Key.LadBillCreditID_int));
if (dr != null && dr.Length > 0)
{
dr[0]["Canceled_bit"] = true;
}
this._dataTable.AcceptChanges();
}
this.Close();
}
catch (Exception ex)
{
LadBillCreditFactory.RollBackProc();
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
public LaderTypeCountChart(string FromDate, string FromTime, string ToDate, string ToTime, string LaderTypeList)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
try
{
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable LaderTypeReportTable = new DataTable();
LadeAssignmentFactory.SelectLaderTypeCountWithDateReport(FromDate, FromTime, ToDate, ToTime, LaderTypeList, 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 = LadeAssignmentFactory.ServerJalaliDate;
Timetxt.Text = LadeAssignmentFactory.ServerTime;
LaderTypetxt.DataField = "LaderType_nvc";
chartControl1.DataSource = LaderTypeReportTable;
this.chartControl1.Series[0].ValueMemberX = LaderTypeReportTable.Columns["LadeDate_nvc"].ColumnName;
this.chartControl1.Series[0].ValueMembersY = LaderTypeReportTable.Columns["CarCount_int"].ColumnName;
this.chartControl1.Series[1].ValueMembersY = LaderTypeReportTable.Columns["LadBill"].ColumnName;
this.chartControl1.Series[2].ValueMembersY = LaderTypeReportTable.Columns["RemainderCar_int"].ColumnName;
DataDynamics.ActiveReports.Chart.Graphics.Backdrop bdrop0 = new DataDynamics.ActiveReports.Chart.Graphics.Backdrop();
bdrop0.Style = BackdropStyle.Solid;
bdrop0.Color = System.Drawing.Color.FromArgb(((int)(((byte)(145)))), ((int)(((byte)(249)))), ((int)(((byte)(115)))));
bdrop0.Alpha = 255;
DataDynamics.ActiveReports.Chart.Graphics.Backdrop bdrop1 = new DataDynamics.ActiveReports.Chart.Graphics.Backdrop();
bdrop1.Style = BackdropStyle.Solid;
bdrop1.Color = System.Drawing.Color.Yellow;
bdrop1.Alpha = 255;
DataDynamics.ActiveReports.Chart.Graphics.Backdrop bdrop2 = new DataDynamics.ActiveReports.Chart.Graphics.Backdrop();
bdrop2.Style = BackdropStyle.Solid;
bdrop2.Color = System.Drawing.Color.FromArgb(((int)(((byte)(250)))), ((int)(((byte)(114)))), ((int)(((byte)(114)))));
bdrop2.Alpha = 255;
this.chartControl1.Series[0].Backdrop = bdrop0;
this.chartControl1.Series[1].Backdrop = bdrop1;
this.chartControl1.Series[2].Backdrop = bdrop2;
this.chartControl1.ChartAreas[0].Axes["AxisY"].SmartLabels = false;
this.chartControl1.ChartAreas[0].Axes["AxisY"].MajorTick.Step = 1;
this.chartControl1.ChartAreas[0].Axes["AxisY"].LabelsVisible = true;
this.chartControl1.ChartAreas[0].Axes["AxisY"].MajorTick.GridLine = new DataDynamics.ActiveReports.Chart.Graphics.Line(System.Drawing.Color.AliceBlue, 1);
this.chartControl1.ChartAreas[0].Axes["AxisY"].MajorTick.Visible = true;
this.chartControl1.ChartAreas[0].Axes[0].LabelFont.Angle = 270;
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
private void ShowButton_Click(object sender, EventArgs e)
{
try
{
LadeAssignmentInfoGridView.Visible = true;
SumPanel.Visible = true;
if (FromDatefaDatePicker.IsNull)
{
throw new ApplicationException("از تاریخ خالی است");
}
else if (ToDatefaDatePicker.IsNull)
{
throw new ApplicationException("تا تاریخ خالی است");
}
string CompanyCodeList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in companyGrid.GetCheckedRows())
{
CompanyCodeList_nvc += itm.Cells["CompanyCode_nvc"].Value.ToString() + ",";
}
if (CompanyCodeList_nvc.EndsWith(","))
{
CompanyCodeList_nvc = CompanyCodeList_nvc.Remove(CompanyCodeList_nvc.Length - 1);
}
string LaderTypeCodeList_nvc = string.Empty;
foreach (Janus.Windows.GridEX.GridEXRow itm in laderTypeGrid.GetCheckedRows())
{
LaderTypeCodeList_nvc += itm.Cells["LaderTypeCode_nvc"].Value.ToString() + ",";
}
if (LaderTypeCodeList_nvc.EndsWith(","))
{
LaderTypeCodeList_nvc = LaderTypeCodeList_nvc.Remove(LaderTypeCodeList_nvc.Length - 1);
}
HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
DataTable UsedLadBillDataTable = new DataTable();
LadeAssignmentFactory.SelectUsedLadBill(FromDatefaDatePicker.Text, ToDatefaDatePicker.Text, CompanyCodeList_nvc, LaderTypeCodeList_nvc, UsedLadBillDataTable);
LadeAssignmentInfoGridView.DataSource = UsedLadBillDataTable;
if (UsedLadBillDataTable != null && UsedLadBillDataTable.Rows.Count > 0)
{
decimal UsedLadBill_dec = (decimal)UsedLadBillDataTable.Compute("Sum(UsedLadBill_int)", "True");
AllCarCount_fltlabel.Text = "تعداد درخواستی : " + ((decimal)UsedLadBillDataTable.Compute("Sum(CarCount_int)", "True")).ToString("0.##");
AllLadBillCount_fltLabel.Text = " تعداد مجوز صادره : " + ((decimal)UsedLadBillDataTable.Compute("Sum(LadBillCount_int)", "True")).ToString("0.##");
AllUsedLadBillCount_fltLabel.Text = "تعداد بار نامه : " + ((decimal)UsedLadBillDataTable.Compute("Sum(UsedLadBill_int)", "True")).ToString("0.##");
if (UsedLadBill_dec != 0)
{
AllCarCountPercent_decLabel.Text = "درصد درخواستی به بار نامه : " + (((decimal)UsedLadBillDataTable.Compute("Sum(CarCount_int)", "True") * 100 / UsedLadBill_dec).ToString("0.##"));
//AllCarCountPercent_decLabel.Text= "درصد درخواستی به بار نامه:"+(((decimal)UsedLadBillDataTable.Compute("Sum(CarCountPercent_dec)", "True") / UsedLadBillDataTable.Rows.Count).ToString("0.##"));
AllLadBillCountPercent_decLabel.Text = "درصد مجوز صادره به بارنامه : " + (((decimal)UsedLadBillDataTable.Compute("Sum(LadBillCount_int)", "True") * 100 / UsedLadBill_dec).ToString("0.##"));
}
else
{
AllCarCountPercent_decLabel.Text = "درصد درخواستی به بار نامه :0";
AllLadBillCountPercent_decLabel.Text = "درصد مجوز صادره به بارنامه :0";
}
}
}
catch (Exception ex)
{
Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
}
}
