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 Print() { try { DataTable dt = JWeights.GetDataTableAll(_Code, false); dt.Columns.Add("State"); dt.Columns.Add("StateHamrah"); if (Convert.ToInt32(dt.Rows[0]["PrintNo"]) >= 2) { dt.Rows[0]["State"] = "این برگه المثنی" + " قبض شماره " + dt.Rows[0]["BascoolID"].ToString() + " مورخ " + dt.Rows[0]["WDate"].ToString() + "ساعت" + dt.Rows[0]["WTime"].ToString().Trim() + "می باشد"; } else { dt.Rows[0]["State"] = ""; } if (Convert.ToInt32(dt.Rows[0]["HamrahNO"]) != 0) { dt.Rows[0]["StateHamrah"] = dt.Rows[0]["HamrahNO"] + " تعداد همراه "; } else { dt.Rows[0]["StateHamrah"] = ""; } if (JMainFrame.BaseCurrentPostCode == 1) { JDynamicReportForm DRF = new JDynamicReportForm(JReportDesignCodes.Bascool.GetHashCode()); DRF.Add(dt); DRF.ShowDialog(); } else { JDynamicReports DRF = new JDynamicReports(JReportDesignCodes.BillGoods.GetHashCode()); DRF.Add(dt); DRF.Print("چاپ قبض", false, false); } } catch (Exception ex) { JSystem.Except.AddException(ex); JMessages.Error(" خطا در چاپ ", ""); } }
//dele,verify,pay,Duty,Tax, private void btnPrint2_Click(object sender, EventArgs e) { if (jJanusGrid1.DataSource == null) { JMessages.Error(" ابتدا دکمه جستجو را بزنید ", ""); return; } if (jJanusGrid1.SelectedRow == null) { JMessages.Error(" لطفا سطری را انتخاب کنید ", ""); return; } _Code = Convert.ToInt32(jJanusGrid1.SelectedRow.Row["Code"].ToString()); DataTable dt = JWeights.GetDataTableAll(_Code, true); string State = "این برگه المثنی" + " قبض شماره " + dt.Rows[0]["BascoolID"].ToString() + " مورخ " + dt.Rows[0]["WDate"].ToString() + "ساعت" + dt.Rows[0]["WTime"].ToString().Trim() + "می باشد"; JWeight tmpWeight = new JWeight(); tmpWeight.TruckCode = Convert.ToInt32(dt.Rows[0]["TruckCode"].ToString()); tmpWeight.UserPostCode = JMainFrame.CurrentPostCode; tmpWeight.PersonCode = JMainFrame.CurrentPersonCode; tmpWeight.pay = Convert.ToInt32(dt.Rows[0]["pay"].ToString()); tmpWeight.pay_h = Convert.ToInt32(dt.Rows[0]["pay"].ToString()); tmpWeight.BascoolCode = Convert.ToInt32(dt.Rows[0]["BascoolCode"].ToString()); tmpWeight.PlokNo = dt.Rows[0]["P1"].ToString() + dt.Rows[0]["P2"].ToString() + dt.Rows[0]["P3"].ToString() + dt.Rows[0]["P4"].ToString(); tmpWeight.Weights = Convert.ToInt32(dt.Rows[0]["Weights"].ToString()); //tmpWeight.Duty = Convert.ToDecimal(dt.Rows[0]["Duty"].ToString()); //tmpWeight.Tax = Convert.ToDecimal(dt.Rows[0]["Tax"].ToString()); JTransferData tmpT = new JTransferData(); tmpT.GetTaxDuty(); tmpWeight.Duty = (tmpWeight.pay / (100 + tmpT._Duty + tmpT._Tax)) * tmpT._Duty; tmpWeight.Tax = (tmpWeight.pay / (100 + tmpT._Duty + tmpT._Tax)) * tmpT._Tax; tmpWeight.hamrahno = Convert.ToInt32(dt.Rows[0]["hamrahno"].ToString()); tmpWeight.ProductCode = Convert.ToInt32(dt.Rows[0]["ProductCode"].ToString()); tmpWeight.PrintNo = 2; 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(); } tmpWeight.WTime = Hour + ":" + Min; tmpWeight.BascoolID = JWeights.GetCounter(); tmpWeight.WDate = DateTime.Now; JTransferData tmpJTransferData = new JTransferData(); JDataBase dbMain = tmpJTransferData.CreateConMainServer(false); if (tmpWeight.Insert() > 0)//dbMain { dt = JWeights.GetDataTableAll(tmpWeight.Code, false); } dt.Columns.Add("State"); dt.Columns.Add("StateHamrah"); dt.Rows[0]["State"] = State; if (Convert.ToInt32(dt.Rows[0]["HamrahNO"]) != 0) { dt.Rows[0]["StateHamrah"] = dt.Rows[0]["HamrahNO"] + " تعداد همراه "; } else { dt.Rows[0]["StateHamrah"] = ""; } if (dt != null) { //JDynamicReportForm DRF = new JDynamicReportForm(JReportDesignCodes.Bascool.GetHashCode()); JDynamicReports DRF = new JDynamicReports(JReportDesignCodes.BillGoods.GetHashCode()); DRF.Add(dt); //DRF.ShowDialog(); DRF.Print("چاپ قبض", false, false); } try { dbMain.setQuery("Update BascolWeights set PrintNo=PrintNo+1 Where Code=" + _Code); dbMain.Query_Execute(); } catch (Exception ex) { JSystem.Except.AddException(ex); } finally { dbMain.Dispose(); } }