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