private void FillTruck()
{
try
{
DataTable dtTrucks = JTruck.GetDataTable(0);
//lsTrucks.DataSource = dtTrucks;
//lsTrucks.DisplayMember = "FullName";
//lsTrucks.ValueMember = "Code";
_Shortcut = new string[dtTrucks.Rows.Count, 2];
for (int i = 0; i < dtTrucks.Rows.Count; i++)
{
_Shortcut[i, 0] = dtTrucks.Rows[i]["Code"].ToString();
_Shortcut[i, 1] = dtTrucks.Rows[i]["Shortcut"].ToString();
}
dtTrucks.Rows.Add(-1, " ", 0, DateTime.Now, DateTime.Now, "", " ");
cmbTruck.DataSource = dtTrucks;
cmbTruck.DisplayMember = "FullName";
cmbTruck.ValueMember = "Code";
//JProductss JCCs = new JProductss();
//JCCs.SetComboBox(cmbProduct, 1);
DataTable dtProduct = JProductss.GetDataTable();
dtProduct.Rows.Add(-1, 901, "");
dtProduct.Select("", "Code");
cmbProduct.DataSource = dtProduct;
cmbProduct.DisplayMember = "Name";
cmbProduct.ValueMember = "Code";
}
catch (Exception ex)
{
JSystem.Except.AddException(ex);
}
}
private void Fill()
{
gridPlok.bind(JReport.GetPlok(), "Plok");
cmbTruck.DataSource = JTruck.GetDataTable(0);;
cmbTruck.DisplayMember = "FullName";
cmbTruck.ValueMember = "Code";
}
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);
}
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);
}
}