public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { repPOS rpt = new repPOS(); rpt.Site = this.Site; return(rpt); }
private void PrintPOS() //พิมพ์ใบเสร็จ { DropTmpTable(); //ลบข้อมูลตารางชั่วคราว try { tr = Conn.BeginTransaction(); sb = new StringBuilder(); sb.Append(" SELECT A.PosID,A.PosDate,A.PosTotal,A.PosDisc,A.PosNet,B.ProID,C.ProName,D.PtDetail,E.UnDetail,B.PostPrice,B.PostNum,B.PostTotal"); sb.Append(" INTO _repPOS" + DBConnString.pUsID);//ใส่ในตารางที่สร้างขึ้นใหม่ sb.Append(" FROM tblPos A"); sb.Append(" INNER JOIN tblPosTrn B ON A.PosID=B.PosID"); sb.Append(" LEFT JOIN tblProduct C ON C.ProID=B.ProID"); sb.Append(" LEFT JOIN tblSetProductType D ON D.PtID=C.PtID"); sb.Append(" LEFT JOIN tblSetUnit E ON E.UnID=C.UnID"); sb.Append(" WHERE A.PosID=@PosID"); 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("@PosID", SqlDbType.NVarChar).Value = lblPosID.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 " + "_repPOS" + DBConnString.pUsID; SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn); repPOS_DATA ds = new repPOS_DATA(); dscmd.Fill(ds, "repPOS"); cnn.Close(); MoneyExt mne = new MoneyExt(); string xThaiBath = ""; xThaiBath = "(-" + mne.NumberToThaiWord(Convert.ToDouble(lblNet.Text)) + "-)"; repPOS objRpt = new repPOS(); 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 + "'"; objRpt.DataDefinition.FormulaFields["xUsFullName"].Text = "'('+'" + DBConnString.pUsFullName + "'+')'"; 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; } }