public static int GetCounter()
{
JDataBase MyDB = new JDataBase();
try
{
MyDB.setQuery(" Select Counter From BascoolCounter ");
DataTable dt = MyDB.Query_DataTable();
int Counter;
if (dt.Rows.Count == 0)
{
if (Globals.JRegistry.Read("BascolNum").ToString() == "")
{
return(0);
}
Counter = 1000000 * JReport.GetBascoolNumber();//Globals.JRegistry.Read("BascolNum").ToString()
MyDB.setQuery(" Insert Into BascoolCounter Values( " + Counter + ")");
if (MyDB.Query_Execute() <= 0)
{
Counter = 0;
}
}
else
{
Counter = Convert.ToInt32(dt.Rows[0][0].ToString()) + 1;
}
return(Counter);
}
finally
{
MyDB.Dispose();
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
DataTable DtBase = new DataTable();
DataTable _DT = new DataTable();
try
{
DtBase.Columns.Add("StartDate");
DtBase.Columns.Add("EndDate");
DtBase.Rows.Add(txtDate.Text, txtEndDate.Text);
DtBase.TableName = "اطلاعات پایه";
_DT.TableName = "اطلاعات";
_DT = JReport.GetDataMali(Str + " And UserPostCode=" + JMainFrame.CurrentPostCode);
//JDynamicReportForm DRF = new JDynamicReportForm(JReportDesignCodes.Bascool.GetHashCode());
JDynamicReports DRF = new JDynamicReports(JReportDesignCodes.BillGoods.GetHashCode());
DRF.Add(_DT);
DRF.Add(DtBase);
//DRF.ShowDialog();
DRF.Print("توزین کاربر", true, false);
}
catch (Exception ex)
{
JSystem.Except.AddException(ex);
}
finally
{
DtBase.Dispose();
_DT.Dispose();
}
}
private void JKhalesWeightForm_Load(object sender, EventArgs e)
{
cmbBascolCode.DataSource = JReport.GetBascols(0);
cmbBascolCode.DisplayMember = "Code";
cmbBascolCode.ValueMember = "Code";
txtDate.Date = DateTime.Now;
}
private void Fill()
{
gridPlok.bind(JReport.GetPlok(), "Plok");
cmbTruck.DataSource = JTruck.GetDataTable(0);;
cmbTruck.DisplayMember = "FullName";
cmbTruck.ValueMember = "Code";
}
private void JWeightForm_Load(object sender, EventArgs e)
{
try
{
lblUserName.Text = JMainFrame.CurrentUser.Person.Name + " " + JMainFrame.CurrentUser.Person.Fam;
//if (Globals.JRegistry.Read("BascolNum") != null)
//{
lblBascolNum.Text = JReport.GetBascoolNumber().ToString(); // Globals.JRegistry.Read("BascolNum").ToString();
_Type = JReport.GetBascoolType();
//_bascoolCapacity = Convert.ToInt32(JReport.GetBascols(Convert.ToInt32(lblBascolNum.Text)).Rows[0]["Capacity"]);
//}
txtPlak1.Focus();
FillTruck();
if (this.State == JFormState.Insert)
{
//txtTime.Text = DateTime.Now.ToLongTimeString();
string Min = "";
if (DateTime.Now.Minute.ToString().Length == 1)
{
Min = "0" + DateTime.Now.Minute.ToString();
}
else
{
Min = DateTime.Now.Minute.ToString();
}
string Hour = "";
if (DateTime.Now.Hour.ToString().Length == 1)
{
Hour = "0" + DateTime.Now.Hour.ToString();
}
else
{
Hour = DateTime.Now.Hour.ToString();
}
lblTime.Text = Hour + ":" + Min;
//txtDate.Date = DateTime.Now;// Convert.ToDateTime(Globals.JRegistry.Read("DateExternalResturant"));
lblDate.Text = JDateTime.FarsiDate(DateTime.Now);
lblDay.Text = JLanguages._Text(DateTime.Now.DayOfWeek.ToString());
}
else
{
SetForm();
}
GetTaxDuty();
InitComPort();
cmbProduct.SelectedIndex = 1;
//lsTrucks.SelectedIndex = 1;
//lsTrucks.SelectedIndex = 0;
cmbPlak.SelectedIndex = 20;
txtPlak1.Focus();
}
catch (Exception ex)
{
JSystem.Except.AddException(ex);
}
}
private void JConfigBascolForm_Load(object sender, EventArgs e)
{
cmbBascol.DataSource = JReport.GetBascols(0);
cmbBascol.DisplayMember = "Code";
cmbBascol.ValueMember = "Code";
cmbBascol.SelectedValue = JReport.GetBascoolNumber();
cmbBascolType.SelectedIndex = JReport.GetBascoolType();
//if (Globals.JRegistry.Read("BascolNum") != null)
// cmbBascol.SelectedValue = Convert.ToInt32(Globals.JRegistry.Read("BascolNum"));
//if (Globals.JRegistry.Read("BascolType") != null)
// cmbBascolType.Text = Globals.JRegistry.Read("BascolType").ToString();
}
private void FillList()
{
DataTable tmpdt = JTruck.GetDataTable(0);
JKeyValue[] M = new JKeyValue[tmpdt.Rows.Count];
int count = 0;
foreach (DataRow dr in tmpdt.Rows)
{
M[count] = new JKeyValue();
M[count].Key = dr["Name"].ToString();
M[count].Value = dr["Code"];
count++;
}
chklistTrucks.Items.AddRange(M);
tmpdt = JReport.GetBascols(0);
JKeyValue[] B = new JKeyValue[tmpdt.Rows.Count];
count = 0;
foreach (DataRow dr in tmpdt.Rows)
{
B[count] = new JKeyValue();
B[count].Key = dr["Code"].ToString();
B[count].Value = dr["Code"];
count++;
}
chkListBascol.Items.AddRange(B);
tmpdt = JReport.GetUsersBascols(0);
JKeyValue[] U = new JKeyValue[tmpdt.Rows.Count];
count = 0;
foreach (DataRow dr in tmpdt.Rows)
{
U[count] = new JKeyValue();
U[count].Key = dr["Name"].ToString();
U[count].Value = dr["Code"];
count++;
}
chklistUsers.Items.AddRange(U);
listUsers.Items.AddRange(U);
tmpdt = JProductss.GetDataTable();
JKeyValue[] T = new JKeyValue[tmpdt.Rows.Count];
count = 0;
foreach (DataRow dr in tmpdt.Rows)
{
T[count] = new JKeyValue();
T[count].Key = dr["Name"].ToString();
T[count].Value = dr["Code"];
count++;
}
chklistTozin.Items.AddRange(T);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!(JPermission.CheckPermission("Bascol.JConfigBascolForm.btnSave_Click")))
{
return;
}
if (JReport.SetBascoolNumber(Convert.ToInt32(cmbBascol.SelectedValue), cmbBascolType.SelectedIndex))
{
JMessages.Information(" با موفقیت ثبت شد ", "");
}
//Globals.JRegistry.Write("BascolNum", cmbBascol.SelectedValue);
//Globals.JRegistry.Write("BascolType", cmbBascolType.Text);
}
private void btnSearch_Click(object sender, EventArgs e)
{
string Str = Where();
_dtSearch = JReport.GetDataManager(Str);
jJanusGrid1.bind(_dtSearch, "ReportManagerBascolShow");
_dtTotal = JReport.GetTotalDataManager(Str);
if (_dtTotal != null)
{
lblTotalPay.Text = JMoney.StringToMoney(_dtTotal.Rows[0]["Pay"].ToString());
lblTotalPay_h.Text = JMoney.StringToMoney(_dtTotal.Rows[0]["Pay_h"].ToString());
lblTotalTax.Text = JMoney.StringToMoney(_dtTotal.Rows[0]["Tax"].ToString());
lblTotalDuty.Text = JMoney.StringToMoney(_dtTotal.Rows[0]["Duty"].ToString());
}
}
private void btnPrint_Click(object sender, EventArgs e)
{
DataTable DtBase = new DataTable();
DtBase.Columns.Add("StartDate");
DtBase.Columns.Add("EndDate");
DtBase.Rows.Add(txtDate.Text, txtEndDate.Text);
DtBase.TableName = "اطلاعات پایه";
DataTable _DT = new DataTable();
_DT.TableName = "اطلاعات";
_DT = JReport.GetDataMali(Where());
JDynamicReportForm DRC = new JDynamicReportForm(JReportDesignCodes.Bascool.GetHashCode());
DRC.Add(_DT);
DRC.Add(DtBase);
DRC.ShowDialog();
}
public bool Transfer()
{
if (!(CreateConnectionServer()))
{
JMessages.Error(" ارتباط با بانک اصلی برقرار نمی شود ", "");
return(false);
}
if (!(ClassLibrary.JPing.Ping("192.168.3.1")))
{
JMessages.Error(" ارتباط با بانک اصلی برقرار نمی شود ", "");
return(false);
}
ClassLibrary.JDataBase MyDB = new JDataBase(_Config);
ClassLibrary.JDataBase CurrentDB = new JDataBase();
try
{
if (CurrentDB.DataBaseName == MyDB.DataBaseName)//"ERP_Sepad")
{
JMessages.Error(" بانک جاری با بانک اصلی یکی است امکان انتقال اطلاعات نیست ", "");
return(false);
}
string StrPlok = "";
//int Count = 0;
//ماشین ها پلاک
CurrentDB.setQuery(@"select distinct PlokNo,TruckCode from BascolWeights ");
foreach (DataRow dr4 in CurrentDB.Query_DataTable().Rows) //+ @"' And TruckCode = " + dr4["TruckCode"]
{
StrPlok = @"
declare @Count int
select @Count=(Select COUNT(*) From BascolPlakTruck where plokno = N'" + dr4["PlokNo"].ToString().Trim() + @"')
select @Count
if (@Count = 0)
INSERT INTO BascolPlakTruck Values('" + dr4["PlokNo"].ToString().Trim() + "'," + dr4["TruckCode"] + @")";
//Count++;
//if (Count == 10)
//{
// //MyDB.CommandTimeout = 5;
// MyDB.setQuery(StrPlok);
// MyDB.Query_Execute();
// StrPlok = "";
// Count = 0;
//}
MyDB.CommandTimeout = 2;
MyDB.setQuery(StrPlok);
MyDB.Query_Execute();
}
MyDB.beginTransaction("MainDB");
CurrentDB.beginTransaction("CurrentDB");
DataTable _DtAccess = JWeights.GetData();
JWeight tmpWeight = new JWeight();
foreach (DataRow dr in _DtAccess.Rows)
{
tmpWeight.TruckCode = Convert.ToInt32(dr["TruckCode"]);
tmpWeight.UserPostCode = Convert.ToInt32(dr["UserPostCode"]);
tmpWeight.PersonCode = Convert.ToInt32(dr["PersonCode"]);
tmpWeight.pay = Convert.ToInt32(dr["Pay"]);
tmpWeight.pay_h = Convert.ToInt32(dr["pay_h"]);
tmpWeight.BascoolCode = Convert.ToInt32(dr["BascoolCode"]);
tmpWeight.WDate = Convert.ToDateTime(dr["WDate"]);
tmpWeight.WTime = dr["WTime"].ToString();
tmpWeight.PlokNo = dr["PlokNo"].ToString();
tmpWeight.Weights = Convert.ToInt32(dr["Weights"]);
tmpWeight.Duty = Convert.ToDecimal(dr["Duty"]); //(tmpWeight.pay / (100 + _Duty + _Tax)) * _Tax;
tmpWeight.Tax = Convert.ToDecimal(dr["Tax"]); //(tmpWeight.pay / (100 + _Duty + _Tax)) * _Duty;
tmpWeight.hamrahno = Convert.ToInt32(dr["hamrahNo"]);
tmpWeight.ProductCode = Convert.ToInt32(dr["ProductCode"]);
tmpWeight.BascoolID = Convert.ToInt32(dr["BascoolID"]);
tmpWeight.FullW = Convert.ToInt32(dr["FullW"]);
tmpWeight.PrintNo = Convert.ToInt32(dr["PrintNo"]);
//tmpWeight.dele = Convert.ToBoolean(dr["dele"]);
//tmpWeight.verify = Convert.ToBoolean(dr["verify"]);
if (tmpWeight.Insert(MyDB) > 0)
{
if (!(tmpWeight.DeleteTransfer(Convert.ToInt32(dr["Code"]), CurrentDB)))
{
MyDB.Rollback("MainDB");
CurrentDB.Rollback("CurrentDB");
JMessages.Error(" خطا در همگام سازی ", "");
return(false);
}
}
else
{
MyDB.Rollback("MainDB");
CurrentDB.Rollback("CurrentDB");
JMessages.Error(" خطا در همگام سازی ", "");
return(false);
}
}
_DtAccess = JEmptyWeight.GetDataTable(-1);
JEmptyWeight tmpEmptyWeight = new JEmptyWeight();
foreach (DataRow dr in _DtAccess.Rows)
{
tmpEmptyWeight.Code = 0;
tmpEmptyWeight.BascoolNo = Convert.ToInt32(dr["BascoolNo"]);
tmpEmptyWeight.WeightID = Convert.ToInt32(dr["WeightID"]);
tmpEmptyWeight.EmptyBascoolNo = Convert.ToInt32(dr["EmptyBascoolNo"]);
tmpEmptyWeight.WeightSerial = Convert.ToInt32(dr["WeightSerial"]);
tmpEmptyWeight.DateWeight = Convert.ToDateTime(dr["DateWeight"]);
tmpEmptyWeight.EmptyWeight = Convert.ToInt32(dr["EmptyWeight"]);
tmpEmptyWeight.EmptyID = Convert.ToInt32(dr["EmptyID"]);
if (tmpEmptyWeight.Insert(MyDB) > 0)
{
tmpEmptyWeight.Code = Convert.ToInt32(dr["Code"]);
if (!(tmpEmptyWeight.Delete(CurrentDB)))
{
MyDB.Rollback("MainDB");
CurrentDB.Rollback("CurrentDB");
JMessages.Error(" خطا در همگام سازی ", "");
return(false);
}
}
else
{
MyDB.Rollback("MainDB");
CurrentDB.Rollback("CurrentDB");
JMessages.Error(" خطا در همگام سازی ", "");
return(false);
}
}
if (MyDB.Commit())
{
if (CurrentDB.Commit())
{
}
else
{
MyDB.Rollback("MainDB");
CurrentDB.Rollback("CurrentDB");
JMessages.Error(" خطا در همگام سازی ", "");
return(false);
}
}
else
{
MyDB.Rollback("MainDB");
CurrentDB.Rollback("CurrentDB");
JMessages.Error(" خطا در همگام سازی ", "");
return(false);
}
// باسکول
CurrentDB.setQuery(@" delete From Bascols ");
CurrentDB.Query_Execute();
//if (CurrentDB.Query_Execute() > 0)
{
foreach (DataRow dr1 in JReport.GetBascols(0, MyDB).Rows)
{
//MyDB.setQuery(@" Insert Into Bascols Values(" + dr1["Code"] + ",'" + dr1["Location"] + "'," + dr1["Capacity"] + ",'" + dr1["BDesc"] + "'," + dr1["Active"]+ ")");
CurrentDB.setQuery(@" Insert Into Bascols Values(" + dr1["Code"] + ",NULL," + dr1["Capacity"] + ",'" + dr1["BDesc"] + "',NULL)");
if (CurrentDB.Query_Execute() <= 0)
{
return(false);
}
}
}
// محصول
CurrentDB.setQuery(@" delete From Subdefine Where bCode=901");
CurrentDB.Query_Execute();
//if (CurrentDB.Query_Execute() > 0)
{
foreach (DataRow dr3 in JProductss.GetDataTable(MyDB).Rows)
{
CurrentDB.setQuery(@" Insert Into Subdefine Values(" + dr3["Code"] + ",901,'" + dr3["Name"] + "',0,NULL)");
if (CurrentDB.Query_Execute() <= 0)
{
return(false);
}
}
}
// ماشینها
CurrentDB.setQuery(@" delete From BascolTruck ");
CurrentDB.Query_Execute();
//if (CurrentDB.Query_Execute() > 0)
{
foreach (DataRow dr2 in JTruck.GetDataTransfer(MyDB).Rows)
{
CurrentDB.setQuery(@"INSERT INTO BascolTruck Values(" + dr2["Code"] + ",'" + dr2["Name"] + "'," + dr2["Price"] + ",'" + Convert.ToDateTime(dr2["StartDate"]).ToShortDateString() + "' ,'" + Convert.ToDateTime(dr2["EndDate"]).ToShortDateString() + "','" + dr2["Shortcut"].ToString().Trim() + "')");
if (CurrentDB.Query_Execute() <= 0)
{
return(false);
}
}
}
//ماشین ها پلاک
CurrentDB.setQuery(@" Select Max(Code) From BascolPlakTruck ");
int MaxCode = Convert.ToInt32(CurrentDB.Query_ExecutSacler());
//if (CurrentDB.Query_Execute() > 0)
//{
MyDB.setQuery(@"select Code,PlokNo,TruckCode from BascolPlakTruck Where Code > " + MaxCode);
foreach (DataRow dr4 in MyDB.Query_DataTable().Rows)
{
CurrentDB.setQuery("INSERT INTO BascolPlakTruck Values( " + dr4["Code"] + ",'" + dr4["PlokNo"] + "'," + dr4["TruckCode"] + ")");
if (CurrentDB.Query_Execute() <= 0)
{
return(false);
}
}
CurrentDB.setQuery(@"delete from BascolPlakTruck Where Code in
(select B.Code from BascolPlakTruck A inner join BascolPlakTruck B on A.PlokNo=B.PlokNo And A.Code > B.Code)");
CurrentDB.Query_Execute();
//return false;
//}
// لیست سیاه
//CurrentDB.setQuery(@" delete From BascoolBlackList ");
//if (CurrentDB.Query_Execute() > 0)
//{
// MyDB.setQuery("select * from BascoolBlackList ");
// foreach (DataRow dr5 in MyDB.Query_DataTable().Rows)
// {
// CurrentDB.setQuery(@" Insert Into BascoolBlackList Values(" + dr5["Code"] + ")");
// if (CurrentDB.Query_Execute() <= 0)
// return false;
// }
//}
//
//CurrentDB.setQuery(@" delete From BascolTaxFormula ");
//if (CurrentDB.Query_Execute() > 0)
//{
// MyDB.setQuery(@"Select top 1 Duty From BascolTaxFormula ");
// _Duty = Convert.ToDecimal(MyDB.Query_ExecutSacler());
// MyDB.setQuery(@"Select top 1 Tax From BascolTaxFormula ");
// _Tax = Convert.ToDecimal(MyDB.Query_ExecutSacler());
// CurrentDB.setQuery(@"INSERT INTO BascolTaxFormula values(" + _Duty + "," + _Tax + ")");
// if (CurrentDB.Query_Execute() <= 0)
// return false;
//}
return(true);
}
catch (Exception ex)
{
JSystem.Except.AddException(ex);
MyDB.Rollback("MainDB");
CurrentDB.Rollback("CurrentDB");
return(false);
}
finally
{
MyDB.Dispose();
CurrentDB.Dispose();
}
}
public bool TransferAccess()
{
try
{
if (CreateConnectionServer())
{
JMessages.Error(" ارتباط با بانک اصلی برقرار نمی شود ", "");
return(false);
}
ClassLibrary.JDataBase MyDB = new JDataBase(_Config);
//ClassLibrary.JOLeDbDataBase MyDB = new ClassLibrary.JOLeDbDataBase();
JWeights tmpWeights = new JWeights();
//MyDB.setQuery(@"Select * From Weight");
DataTable _DtAccess = tmpWeights.GetDataTable();
DataTable _DtSQL;
foreach (DataRow dr in _DtAccess.Rows)
{
JWeight tmpWeight = new JWeight();
tmpWeight.TruckCode = Convert.ToInt32(dr["TruckNo"]);
tmpWeight.UserPostCode = Convert.ToInt32(dr["UserPostCode"]);
tmpWeight.PersonCode = Convert.ToInt32(dr["UserNo"]);
tmpWeight.pay = Convert.ToInt32(dr["Pay"]);
tmpWeight.pay_h = Convert.ToInt32(dr["pay_h"]);
tmpWeight.BascoolCode = Convert.ToInt32(dr["BascoolCode"]);
tmpWeight.WDate = Convert.ToDateTime(dr["WDate"]);
tmpWeight.WTime = dr["WTime"].ToString();
tmpWeight.PlokNo = dr["PlokNo"].ToString();
tmpWeight.Weights = Convert.ToInt32(dr["Weights"]);
tmpWeight.Duty = Convert.ToDecimal(dr["Duty"]); //(tmpWeight.pay / (100 + _Duty + _Tax)) * _Tax;
tmpWeight.Tax = Convert.ToDecimal(dr["Tax"]); //(tmpWeight.pay / (100 + _Duty + _Tax)) * _Duty;
tmpWeight.hamrahno = Convert.ToInt32(dr["hamrahNo"]);
tmpWeight.ProductCode = Convert.ToInt32(dr["ProductNo"]);
if (tmpWeight.Insert(MyDB) > 0)
{
tmpWeight.Delete(tmpWeight.Code);
MyDB.setQuery(@"Delete From Weight Where id = " + dr["Code"]);
if (MyDB.Query_Execute() <= 0)
{
JMessages.Error(" خطا در همگام سازی ", "");
return(false);
}
}
}
MyDB.setQuery(@"SELECT ID, WeightSerial, BascoolNo, DateWeight, EmptyWeight, WeightID FROM EmptyTruck");
_DtAccess = MyDB.Query_DataTable();
foreach (DataRow dr in _DtAccess.Rows)
{
JEmptyWeight tmpEmptyWeight = new JEmptyWeight();
tmpEmptyWeight.BascoolNo = Convert.ToInt32(dr["BascoolNo"]);
tmpEmptyWeight.WeightID = Convert.ToInt32(dr["WeightID"]);
tmpEmptyWeight.EmptyBascoolNo = Convert.ToInt32(dr["EmptyBascoolNo"]);
tmpEmptyWeight.WeightSerial = Convert.ToInt32(dr["WeightSerial"]);
tmpEmptyWeight.DateWeight = Convert.ToDateTime(dr["DateWeight"]);
tmpEmptyWeight.EmptyWeight = Convert.ToInt32(dr["EmptyWeight"]);
tmpEmptyWeight.EmptyID = Convert.ToInt32(dr["EmptyID"]);
if (tmpEmptyWeight.Insert() > 0)
{
MyDB.setQuery(@"Delete From Weight Where id = " + dr["Code"]);
if (MyDB.Query_Execute() <= 0)
{
JMessages.Error(" خطا در همگام سازی ", "");
return(false);
}
}
}
// باسکول
MyDB.setQuery(@" delete From Bascools ");
if (MyDB.Query_Execute() > 0)
{
foreach (DataRow dr1 in JReport.GetBascols(0).Rows)
{
MyDB.setQuery(@" Insert Into Bascools (" + dr1["Code"] + ",'" + dr1["Location"] + "'," + dr1["Capacity"] + ",'" + dr1["BDesc"] + "'," + dr1["Active"]);
if (MyDB.Query_Execute() <= 0)
{
return(false);
}
}
}
// محصول
MyDB.setQuery(@" delete From Product ");
if (MyDB.Query_Execute() > 0)
{
foreach (DataRow dr3 in JProductss.GetDataTable().Rows)
{
MyDB.setQuery(@" Insert Into Product (" + dr3["Code"] + ",'" + dr3["Name"] + "'");
if (MyDB.Query_Execute() <= 0)
{
return(false);
}
}
}
// ماشینها
MyDB.setQuery(@" delete From Truck ");
if (MyDB.Query_Execute() > 0)
{
foreach (DataRow dr2 in JTruck.GetDataTable(0).Rows)
{
MyDB.setQuery(@"INSERT INTO Truck(TruckId,Name,wp)values(" + dr2["Code"] + ",'" + dr2["Name"] + "'," + dr2["Price"] + ")");
if (MyDB.Query_Execute() <= 0)
{
return(false);
}
}
}
//
MyDB.setQuery(@" delete From TaxFormula ");
if (MyDB.Query_Execute() > 0)
{
//GetTaxDuty();
//MyDB.setQuery(@"INSERT INTO (Duty, Tax) values(" + _Duty + "," + _Tax + ")");
if (MyDB.Query_Execute() <= 0)
{
return(false);
}
}
return(true);
}
catch (Exception ex)
{
JSystem.Except.AddException(ex);
return(false);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
txtPrice.Text = "";
if (chkBedehi.Checked)
{
jJanusGridBedehi.Visible = true;
jJanusGrid1.Visible = false;
}
else
{
jJanusGridBedehi.Visible = false;
jJanusGrid1.Visible = true;
}
Str = "";
if (!(chkAllUser.Checked))
{
if (((_PlakNo == null)) || (_PlakNo == ""))
{
if (!(chkBedehi.Checked))
{
Str = Str + " And UserPostCode=" + JMainFrame.CurrentPostCode;
}
}
}
if (chkListBascol.CheckedItems.Count > 0)
{
string CodeGH = "";
for (int i = 0; i < chkListBascol.Items.Count; i++)
{
if (chkListBascol.GetItemChecked(i))
{
CodeGH = CodeGH + "" + ((ClassLibrary.JKeyValue)(chkListBascol.Items[i])).Value.ToString() + ",";
}
}
if (CodeGH != "")
{
Str = Str + " And BascoolCode in (" + CodeGH + "0)";
}
}
if (chklistTozin.CheckedItems.Count > 0)
{
string CodeGH = "";
for (int i = 0; i < chklistTozin.Items.Count; i++)
{
if (chklistTozin.GetItemChecked(i))
{
CodeGH = CodeGH + "" + ((ClassLibrary.JKeyValue)(chklistTozin.Items[i])).Value.ToString() + ",";
}
}
if (CodeGH != "")
{
Str = Str + " And ProductCode in (" + CodeGH + "0)";
}
}
if (chklistTrucks.CheckedItems.Count > 0)
{
string CodeGH = "";
for (int i = 0; i < chklistTrucks.Items.Count; i++)
{
if (chklistTrucks.GetItemChecked(i))
{
CodeGH = CodeGH + "" + ((ClassLibrary.JKeyValue)(chklistTrucks.Items[i])).Value.ToString() + ",";
}
}
if (CodeGH != "")
{
Str = Str + " And TruckCode in (" + CodeGH + "0)";
}
}
if (txtDate.Date != DateTime.MinValue)
{
Str = Str + " And Cast(WDate as Date) >= '" + txtDate.Date.ToString("yyyy/MM/dd") + "'";
}
if (txtEndDate.Date != DateTime.MinValue)
{
Str = Str + " And Cast(WDate as Date) <= '" + txtEndDate.Date.ToString("yyyy/MM/dd") + "'";
}
if (txtplok2.Text != " -")
{
if (txtplok2.Text.Contains("ا"))
{
Str = Str + " And PlokNo=N'" + txtplok2.Text.Replace("ا", "الف") + "'";
}
else
{
Str = Str + " And PlokNo=N'" + txtplok2.Text + "'";
}
}
if (chkBedehi.Checked)
{
lblBedehkari.Text = "0";
lblBestankari.Text = "0";
DataTable tmpdt = JReport.GetDataBedehkari(Str);
jJanusGridBedehi.bind(tmpdt, "ReportBedehi");
foreach (DataRow dr in tmpdt.Rows)
{
lblBedehkari.Text = (Convert.ToDecimal(lblBedehkari.Text) + Convert.ToDecimal(dr["debit"])).ToString();
lblBestankari.Text = (Convert.ToDecimal(lblBestankari.Text) + Convert.ToDecimal(dr["crdit"])).ToString();
}
}
else if (groupBox1.Enabled == true)
{
DataTable dtManager = JReport.GetDataManager(Str);
jJanusGrid1.bind(dtManager, "ReportManagerBascolShow");
lblCount.Text = "0";
lblTotal.Text = "0";
foreach (DataRow dr in dtManager.Rows)
{
lblCount.Text = (Convert.ToDecimal(lblCount.Text) + 1).ToString();
lblTotal.Text = (Convert.ToDecimal(lblTotal.Text) + Convert.ToDecimal(dr["Pay"])).ToString();
}
}
if (groupBox1.Enabled == false)
{
jJanusGrid1.bind(JReport.GetDataTop3(Str), "ReportManagerBascolShow");
jJanusGrid1.Columns["BascoolCode"].Visible = false;
jJanusGrid1.Columns["Code"].Visible = false;
}
else if (!(chkBedehi.Checked))
{
jJanusGrid1.Columns["PrintNo"].Visible = false;
//jJanusGrid1.Columns["hamrahno"].Visible = false;
jJanusGrid1.Columns["dele"].Visible = false;
jJanusGrid1.Columns["verify"].Visible = false;
jJanusGrid1.Columns["pay"].Visible = false;
//jJanusGrid1.Columns["pay_h"].Visible = false;
jJanusGrid1.Columns["Duty"].Visible = false;
jJanusGrid1.Columns["Tax"].Visible = false;
jJanusGrid1.Columns["FirstWeight"].Visible = false;
jJanusGrid1.Columns["Khales"].Visible = false;
jJanusGrid1.Columns["PersonName"].Visible = false;
//jJanusGrid1.Columns["PostName"].Visible = false;
jJanusGrid1.Columns["UserPostCode"].Visible = false;
}
}
private void Fill()
{
jJanusGrid1.bind(JReport.GetBlackList(), "BlackList");
}
