public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { repOrder rpt = new repOrder(); rpt.Site = this.Site; return(rpt); }
private void PrintOrder() { DropTmpTable();//ลบข้อมูลตารางชั่วคราว try { tr = Conn.BeginTransaction(); sb = new StringBuilder(); sb.Append(" SELECT A.OrdID,A.OrdDate,E.CpID,E.CpName,E.CpAddress,E.CpTel,E.CpContact,E.CpContactTel,A.UsID,"); sb.Append(" G.TiDetail,F.UsFirstName,F.UsLastName,B.ProID,C.ProName,D.UnDetail,B.OrtPrice,B.OrtNum,B.OrtTotal,"); sb.Append(" A.OrdStatus,A.OrdTotal,A.OrdDisc,A.OrdNet"); sb.Append(" INTO _repOrder" + DBConnString.pUsID);//ใส่ในตารางที่สร้างขึ้นใหม่ sb.Append(" FROM tblOrder A INNER JOIN tblOrderTrn B ON A.OrdID=B.OrdID"); sb.Append(" LEFT JOIN tblProduct C ON B.ProID=C.ProID"); sb.Append(" LEFT JOIN tblSetUnit D ON C.UnID=D.UnID"); sb.Append(" LEFT JOIN tblSetCompany E ON E.CpID=A.CpID"); sb.Append(" LEFT JOIN tblSetUser F ON F.UsID=A.UsID"); sb.Append(" LEFT JOIN tblSetTitle G ON G.TiID=F.TiID"); sb.Append(" WHERE A.OrdID=@OrdID"); SqlText = sb.ToString(); com = new SqlCommand(); com.CommandText = SqlText; com.CommandType = CommandType.Text; com.Connection = Conn; com.Transaction = tr; com.Parameters.Clear(); com.Parameters.Add("@OrdID", SqlDbType.NVarChar).Value = txtOrdID.Text.Trim(); com.ExecuteNonQuery(); tr.Commit(); SqlConnection cnn; string connectionString = null; string sql = null; connectionString = DBConnString.strConn; cnn = new SqlConnection(connectionString); cnn.Open(); sql = "SELECT * FROM " + "_repOrder" + DBConnString.pUsID; SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn); repOrder_DATA ds = new repOrder_DATA(); dscmd.Fill(ds, "repOrder"); cnn.Close(); MoneyExt mne = new MoneyExt(); string xThaiBath = ""; xThaiBath = "(-" + mne.NumberToThaiWord(Convert.ToDouble(txtNet.Text)) + "-)"; repOrder objRpt = new repOrder(); objRpt.SetDataSource(ds.Tables[1]); objRpt.DataDefinition.FormulaFields["xSuName"].Text = "'" + PublicVariable.pSuName + "'"; objRpt.DataDefinition.FormulaFields["xSuAddress"].Text = "'" + PublicVariable.pSuAddress + "'"; objRpt.DataDefinition.FormulaFields["xThaiBath"].Text = "'" + xThaiBath + "'"; crvRep.Visible = true; crvRep.Dock = DockStyle.Fill; crvRep.ReportSource = objRpt; objRpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4; crvRep.Refresh(); DropTmpTable();//ลบข้อมูลตารางชั่วคราว } catch (Exception Err) { MessageBox.Show("เกิดข้อผิดพลาด : " + Err.Message, DBConnString.xMessage, MessageBoxButtons.OK, MessageBoxIcon.Warning); tr.Rollback(); return; } }