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