private void textBox1_TextChanged(object sender, EventArgs e)
{
textBox1.MaxLength = 13;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
string query = ("select * from employee_ru eru, opd, privilege where eru.emp_ru_idcard = opd.emp_ru_id and opd.emp_ru_id = privilege.emp_ru_idcard and eru.emp_ru_idcard = '" + textBox1.Text + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
if (textBox1.Text == cmd.Connection.Database && textBox1.MaxLength == 13)
{
foreach (DataRow item in dt.Rows)
{
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells[0].Value = item["emp_ru_idcard"].ToString();
dataGridView1.Rows[n].Cells[1].Value = item["emp_ru_name"].ToString();
dataGridView1.Rows[n].Cells[2].Value = item["emp_ru_birthday"].ToString();
dataGridView1.Rows[n].Cells[3].Value = item["emp_ru_telmobile"].ToString();
dataGridView1.Rows[n].Cells[4].Value = item["privil_status"].ToString();
}
}
else
{
clinic_approve cliapp = new clinic_approve();
cliapp.Show();
}
}
private void button1_Click(object sender, EventArgs e)
{
conn.Open();
string query = ("select eru.emp_ru_name,eru.emp_ru_idcard,eru.emp_ru_birthday,eru.emp_ru_age,eru.emp_ru_telwork,eru.emp_ru_telmobile,eru.emp_ru_telhome,eru.emp_ru_telparent,eru.emp_ru_nameparent,eru.em_ru_addressparent,eru.emp_ru_namedad,eru.emp_ru_namemom,eru.emp_ru_namehusband_and_wife,eru.emp_ru_address,workplace.workplace,position.pos_id,eru.emp_ru_id ,privilege.privil_status from employee_ru eru left join workplace on workplace.workplace_id = eru.workplace_id left join position on position.pos_id = eru.pos_id left join privilege on privilege.emp_ru_id = eru.emp_ru_id where eru.emp_ru_idcard ='" + tb1.Text + "'");
cmd = new SqlCommand(query, conn);
sdr = cmd.ExecuteReader();
if (sdr.Read())
{
string privil_status = sdr["privil_status"].ToString();
if (privil_status != "ได้รับสิทธิการรักษา")
{
string emp_ru_name = sdr["emp_ru_name"].ToString();
string emp_ru_idcard = sdr["emp_ru_idcard"].ToString();
DateTime birthday = Convert.ToDateTime(sdr["emp_ru_birthday"].ToString());
string date_birth = String.Format("{0:yyyy-MM-dd}", birthday);
string emp_ru_birthday = date_birth;
string emp_ru_age = sdr["emp_ru_age"].ToString();
string emp_ru_telwork = sdr["emp_ru_telwork"].ToString();
string emp_ru_telmobile = sdr["emp_ru_telmobile"].ToString();
string emp_ru_telhome = sdr["emp_ru_telhome"].ToString();
string emp_ru_telparent = sdr["emp_ru_telparent"].ToString();
string emp_ru_nameparent = sdr["emp_ru_nameparent"].ToString();
string em_ru_addressparent = sdr["em_ru_addressparent"].ToString();
string emp_ru_namedad = sdr["emp_ru_namedad"].ToString();
string emp_ru_namemom = sdr["emp_ru_namemom"].ToString();
string emp_ru_namehusband_and_wife = sdr["emp_ru_namehusband_and_wife"].ToString();
string emp_ru_address = sdr["emp_ru_address"].ToString();
string workplace = sdr["workplace"].ToString();
int emp_ru_id = Convert.ToInt32(sdr["emp_ru_id"].ToString());
string pos_id = sdr["pos_id"].ToString();
/* query = ("insert into opd (emp_ru_id,pos_id)" +
* "values('" + emp_ru_id + "','" + pos_id + "')");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);*/
query = ("insert into opd (opd_name,opd_idcard,opd_birthday,opd_age,opd_telwork,opd_telmobile ,opd_telhome,opd_workplace,opd_telparent,opd_nameparent,opd_addressparent,opd_namedad,opd_namemom,opd_namehusband_and_wife,opd_address,emp_ru_id,pos_id)" +
"values('" + emp_ru_name + " ','" + emp_ru_idcard + " ','" + emp_ru_birthday + "','" + emp_ru_age + " '," +
"'" + emp_ru_telwork + " ','" + emp_ru_telmobile + " ','" + emp_ru_telhome + " ','" + workplace + "','" + emp_ru_telparent + " '," +
"'" + emp_ru_nameparent + "','" + em_ru_addressparent + " ','" + emp_ru_namedad + " '" +
",'" + emp_ru_namemom + "','" + emp_ru_namehusband_and_wife + " ','" + emp_ru_address + " ','" + emp_ru_id + "','" + pos_id + "')");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
query = ("select opd_id from opd where emp_ru_id ='" + emp_ru_id + "'");
cmd = new SqlCommand(query, conn);
sdr = cmd.ExecuteReader();
if (sdr.Read())
{
int id = Convert.ToInt32(sdr["opd_id"].ToString());
query = ("select count(*) from privilege where emp_ru_id = '" + emp_ru_id + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
// sdr = cmd.ExecuteReader();
int count_par = (int)cmd.ExecuteScalar();
if (count_par == 1)
{
query = ("update privilege set privil_status = 'ได้รับสิทธิการรักษา', opd_id = '" + id + "' , date = SYSDATETIME() , time = SYSDATETIME() where emp_ru_id = '" + emp_ru_id + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
query = ("select privil_id from privilege where emp_ru_idcard = '" + emp_ru_idcard + "'");
cmd = new SqlCommand(query, conn);
sdr = cmd.ExecuteReader();
if (sdr.Read())
{
int privil_id = Convert.ToInt32(sdr["privil_id"].ToString());
query = ("update opd set privil_id = '" + privil_id + "' where opd_idcard = '" + emp_ru_idcard + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
query = ("insert into user_control (uct_user,uct_password,emp_ru_id,opd_id)values ('" + emp_ru_idcard + "','" + emp_ru_birthday + "','" + emp_ru_id + "','" + id + "');");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
string fontpath = Environment.GetEnvironmentVariable("SystemRoot") + "../fonts/THSarabun.ttf";
BaseFont basefont = BaseFont.CreateFont(fontpath, BaseFont.IDENTITY_H, true);
iTextSharp.text.Font arabicFont = new iTextSharp.text.Font(basefont, 30, iTextSharp.text.Font.NORMAL);
var el = new Chunk();
iTextSharp.text.Font f2 = new iTextSharp.text.Font(basefont, el.Font.Size,
el.Font.Style, el.Font.Color);
el.Font = f2;
Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35);
PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream("" + S2.Text + ".pdf", FileMode.Create));
doc.Open();
iTextSharp.text.pdf.PdfContentByte cb = wri.DirectContent;
iTextSharp.text.pdf.Barcode128 bc = new Barcode128();
bc.TextAlignment = Element.ALIGN_LEFT;
bc.Code = S1.Text;
bc.StartStopText = false;
bc.CodeType = iTextSharp.text.pdf.Barcode128.EAN13;
bc.Extended = true;
iTextSharp.text.Image ru = iTextSharp.text.Image.GetInstance("ru.png");
ru.ScalePercent(15f);
iTextSharp.text.Image img = bc.CreateImageWithBarcode(cb,
iTextSharp.text.BaseColor.BLACK, iTextSharp.text.BaseColor.BLACK);
cb.SetTextMatrix(100f, 150.5f);
img.ScaleToFit(150, 159);
img.SetAbsolutePosition(100f, 150f);
// doc.Add(ru);
PdfPTable headerTable = new PdfPTable(2);
headerTable.TotalWidth = 530f;
headerTable.HorizontalAlignment = 0;
headerTable.SpacingAfter = 20;
//headerTable.DefaultCell.Border = Rectangle.NO_BORDER;
float[] headerTableColWidth = new float[2];
headerTableColWidth[0] = 220f;
headerTableColWidth[1] = 310f;
headerTable.SetWidths(headerTableColWidth);
headerTable.LockedWidth = true;
PdfPCell headerTableCell_0 = new PdfPCell(ru);
headerTableCell_0.HorizontalAlignment = Element.ALIGN_LEFT;
headerTableCell_0.Border = iTextSharp.text.Rectangle.NO_BORDER;
headerTable.AddCell(headerTableCell_0);
PdfPCell head = new PdfPCell(new Phrase(70, "งานแพทย์และอนามัย มหาวิทยาลัยรามคำแหง\nบัตรประวัติผู้ป่วย", el.Font));
head.HorizontalAlignment = Element.ALIGN_LEFT;
head.VerticalAlignment = Element.ALIGN_BOTTOM;
head.Border = iTextSharp.text.Rectangle.NO_BORDER;
// headerTable.AddCell(new PdfPCell(ru));
headerTable.AddCell(head);
doc.Add(headerTable);
// Paragraph pa = new Paragraph(""+head+"");
// doc.Add(pa);
PdfPTable table = new PdfPTable(1);
// table.AddCell(new PdfPCell(ru));
table.AddCell(new PdfPCell(new Phrase(70, "ชื่อ " + S2.Text + "\nวันเดือนปีเกิด " + S3.Text + "\nอายุ" + emp_ru_age + " \nโทรศัพท์มือถือ " + S4.Text + "\n เบอร์โทรศัพท์บ้าน " + emp_ru_telhome + "\nเบอร์โทรผู้ปกครอง " + emp_ru_telparent + "\nที่อยู่ผู้ปกครอง " + em_ru_addressparent + "\nชื่อบิดา " + emp_ru_namedad + "\nชื่อมารดา " + emp_ru_namemom + "\nชื่อสามีหรือภรรยา " + emp_ru_namehusband_and_wife + "\nที่อยู่ " + emp_ru_address + "\nสังกัด " + S5.Text + "\nรหัสเข้าสู่ระบบ\nรหัสชื่อผู้ใช้ " + S1.Text + "\nรหัสผ่าน " + S3.Text + "", el.Font)));
table.AddCell(new PdfPCell(img));
// table.AddCell(new Phrase(10, "" + S2.Text + "", el.Font));
// table.AddCell(img);
// table.AddCell(new Phrase(70, "รหัสเข้าสู่ระบบ", el.Font));
// table.AddCell(new Phrase(70, "รหัสชื่อผู้ใช้ " + S1.Text + "", el.Font));
// table.AddCell(new Phrase(10, "รหัสผ่าน" + S3.Text + "", el.Font));
doc.Add(table);
doc.Close();
System.Diagnostics.Process.Start("" + S2.Text + ".pdf");
clinic_approve_step2 appr2 = new clinic_approve_step2();
appr2.Show();
clinic_approve approve = new clinic_approve();
approve.Close();
Visible = false;
}
}
else
{
query = ("insert into privilege (privil_status,emp_ru_idcard,date,time,opd_id,emp_ru_id) values('ได้รับสิทธิการรักษา','" + emp_ru_idcard + "',SYSDATETIME(), SYSDATETIME(),'" + id + "','" + emp_ru_id + "');");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
query = ("select privil_id from privilege where emp_ru_idcard = '" + emp_ru_idcard + "'");
cmd = new SqlCommand(query, conn);
sdr = cmd.ExecuteReader();
if (sdr.Read())
{
int privil_id = Convert.ToInt32(sdr["privil_id"].ToString());
query = ("update opd set privil_id = '" + privil_id + "' where opd_idcard = '" + emp_ru_idcard + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
query = ("insert into user_control (uct_user,uct_password,emp_ru_id,opd_id)values ('" + emp_ru_idcard + "','" + emp_ru_birthday + "','" + emp_ru_id + "','" + id + "');");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
string fontpath = Environment.GetEnvironmentVariable("SystemRoot") + "../fonts/THSarabun.ttf";
BaseFont basefont = BaseFont.CreateFont(fontpath, BaseFont.IDENTITY_H, true);
iTextSharp.text.Font arabicFont = new iTextSharp.text.Font(basefont, 30, iTextSharp.text.Font.NORMAL);
var el = new Chunk();
iTextSharp.text.Font f2 = new iTextSharp.text.Font(basefont, el.Font.Size,
el.Font.Style, el.Font.Color);
el.Font = f2;
Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35);
PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream("" + S2.Text + ".pdf", FileMode.Create));
doc.Open();
iTextSharp.text.pdf.PdfContentByte cb = wri.DirectContent;
iTextSharp.text.pdf.Barcode128 bc = new Barcode128();
bc.TextAlignment = Element.ALIGN_LEFT;
bc.Code = S1.Text;
bc.StartStopText = false;
bc.CodeType = iTextSharp.text.pdf.Barcode128.EAN13;
bc.Extended = true;
iTextSharp.text.Image ru = iTextSharp.text.Image.GetInstance("ru.png");
ru.ScalePercent(15f);
iTextSharp.text.Image img = bc.CreateImageWithBarcode(cb,
iTextSharp.text.BaseColor.BLACK, iTextSharp.text.BaseColor.BLACK);
cb.SetTextMatrix(100f, 150.5f);
img.ScaleToFit(150, 159);
img.SetAbsolutePosition(100f, 150f);
// doc.Add(ru);
PdfPTable headerTable = new PdfPTable(2);
headerTable.TotalWidth = 530f;
headerTable.HorizontalAlignment = 0;
headerTable.SpacingAfter = 20;
//headerTable.DefaultCell.Border = Rectangle.NO_BORDER;
float[] headerTableColWidth = new float[2];
headerTableColWidth[0] = 220f;
headerTableColWidth[1] = 310f;
headerTable.SetWidths(headerTableColWidth);
headerTable.LockedWidth = true;
PdfPCell headerTableCell_0 = new PdfPCell(ru);
headerTableCell_0.HorizontalAlignment = Element.ALIGN_LEFT;
headerTableCell_0.Border = iTextSharp.text.Rectangle.NO_BORDER;
headerTable.AddCell(headerTableCell_0);
PdfPCell head = new PdfPCell(new Phrase(70, "งานแพทย์และอนามัย มหาวิทยาลัยรามคำแหง\nบัตรประวัติผู้ป่วย", el.Font));
head.HorizontalAlignment = Element.ALIGN_LEFT;
head.VerticalAlignment = Element.ALIGN_BOTTOM;
head.Border = iTextSharp.text.Rectangle.NO_BORDER;
// headerTable.AddCell(new PdfPCell(ru));
headerTable.AddCell(head);
doc.Add(headerTable);
// Paragraph pa = new Paragraph(""+head+"");
// doc.Add(pa);
PdfPTable table = new PdfPTable(1);
// table.AddCell(new PdfPCell(ru));
table.AddCell(new PdfPCell(new Phrase(70, "ชื่อ " + S2.Text + "\nวันเดือนปีเกิด " + S3.Text + "\nอายุ" + emp_ru_age + " \nโทรศัพท์มือถือ " + S4.Text + "\n เบอร์โทรศัพท์บ้าน" + emp_ru_telhome + "\nเบอร์โทรผู้ปกครอง" + emp_ru_telparent + "\nที่อยู่ผู้ปกครอง" + em_ru_addressparent + "\nชื่อบิดา" + emp_ru_namedad + "\nชื่อมารดา" + emp_ru_namemom + "\nชื่อสามีหรือภรรยา" + emp_ru_namehusband_and_wife + "\nที่อยู่" + emp_ru_address + "\nสังกัด " + S5.Text + "\nรหัสเข้าสู่ระบบ\nรหัสชื่อผู้ใช้ " + S1.Text + "\nรหัสผ่าน " + S3.Text + "", el.Font)));
table.AddCell(new PdfPCell(img));
// table.AddCell(new Phrase(10, "" + S2.Text + "", el.Font));
// table.AddCell(img);
// table.AddCell(new Phrase(70, "รหัสเข้าสู่ระบบ", el.Font));
// table.AddCell(new Phrase(70, "รหัสชื่อผู้ใช้ " + S1.Text + "", el.Font));
// table.AddCell(new Phrase(10, "รหัสผ่าน" + S3.Text + "", el.Font));
doc.Add(table);
doc.Close();
System.Diagnostics.Process.Start("" + S2.Text + ".pdf");
clinic_approve_step2 appr2 = new clinic_approve_step2();
appr2.Show();
clinic_approve approve = new clinic_approve();
approve.Close();
Visible = false;
}
}
/*
* if (count_par == 1)
* {
*
* query = ("update privilege set privil_status = 'ได้รับสิทธิการรักษา', opd_id = '" + id + "' , date = SYSDATETIME() , time = SYSDATETIME() where emp_ru_id = '" + emp_ru_id + "'");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
* query = ("select privil_id from privilege where emp_ru_idcard = '" + emp_ru_idcard + "'");
* cmd = new SqlCommand(query, conn);
* sdr = cmd.ExecuteReader();
* if (sdr.Read())
* {
* int privil_id = Convert.ToInt32(sdr["privil_id"].ToString());
* query = ("update opd set privil_id = '" + privil_id + "' where opd_idcard = '" + emp_ru_idcard + "'");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
*
*
*
* query = ("insert into user_control (uct_user,uct_password,emp_ru_id,opd_id)values ('" + emp_ru_idcard + "','" + emp_ru_birthday + "','" + emp_ru_id + "','" + id + "');");
*
*
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
*
*
*
*
* string fontpath = Environment.GetEnvironmentVariable("SystemRoot") + "../fonts/THSarabun.ttf";
* BaseFont basefont = BaseFont.CreateFont(fontpath, BaseFont.IDENTITY_H, true);
* iTextSharp.text.Font arabicFont = new iTextSharp.text.Font(basefont, 30, iTextSharp.text.Font.NORMAL);
* var el = new Chunk();
* iTextSharp.text.Font f2 = new iTextSharp.text.Font(basefont, el.Font.Size,
* el.Font.Style, el.Font.Color);
* el.Font = f2;
*
* Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35);
*
* PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream("" + S2.Text + ".pdf", FileMode.Create));
* doc.Open();
* iTextSharp.text.pdf.PdfContentByte cb = wri.DirectContent;
* iTextSharp.text.pdf.Barcode128 bc = new Barcode128();
* bc.TextAlignment = Element.ALIGN_LEFT;
* bc.Code = S1.Text;
* bc.StartStopText = false;
* bc.CodeType = iTextSharp.text.pdf.Barcode128.EAN13;
* bc.Extended = true;
*
* iTextSharp.text.Image ru = iTextSharp.text.Image.GetInstance("ru.png");
* ru.ScalePercent(15f);
*
*
*
*
* iTextSharp.text.Image img = bc.CreateImageWithBarcode(cb,
* iTextSharp.text.BaseColor.BLACK, iTextSharp.text.BaseColor.BLACK);
*
* cb.SetTextMatrix(100f, 150.5f);
* img.ScaleToFit(150, 159);
* img.SetAbsolutePosition(100f, 150f);
* // doc.Add(ru);
* PdfPTable headerTable = new PdfPTable(2);
* headerTable.TotalWidth = 530f;
* headerTable.HorizontalAlignment = 0;
* headerTable.SpacingAfter = 20;
* //headerTable.DefaultCell.Border = Rectangle.NO_BORDER;
*
* float[] headerTableColWidth = new float[2];
* headerTableColWidth[0] = 220f;
* headerTableColWidth[1] = 310f;
*
* headerTable.SetWidths(headerTableColWidth);
* headerTable.LockedWidth = true;
*
* PdfPCell headerTableCell_0 = new PdfPCell(ru);
* headerTableCell_0.HorizontalAlignment = Element.ALIGN_LEFT;
* headerTableCell_0.Border = iTextSharp.text.Rectangle.NO_BORDER;
* headerTable.AddCell(headerTableCell_0);
*
* PdfPCell head = new PdfPCell(new Phrase(70, "งานแพทย์และอนามัย มหาวิทยาลัยรามคำแหง\nบัตรประวัติผู้ป่วย", el.Font));
*
* head.HorizontalAlignment = Element.ALIGN_LEFT;
* head.VerticalAlignment = Element.ALIGN_BOTTOM;
* head.Border = iTextSharp.text.Rectangle.NO_BORDER;
* // headerTable.AddCell(new PdfPCell(ru));
* headerTable.AddCell(head);
*
* doc.Add(headerTable);
* // Paragraph pa = new Paragraph(""+head+"");
* // doc.Add(pa);
* PdfPTable table = new PdfPTable(1);
* // table.AddCell(new PdfPCell(ru));
* table.AddCell(new PdfPCell(new Phrase(70, "ชื่อ " + S2.Text + "\nวันเดือนปีเกิด " + S3.Text + "\nอายุ" + emp_ru_age + " \nโทรศัพท์มือถือ " + S4.Text + "\n เบอร์โทรศัพท์บ้าน" + emp_ru_telhome + "\nเบอร์โทรผู้ปกครอง" + emp_ru_telparent + "\nที่อยู่ผู้ปกครอง" + em_ru_addressparent + "\nชื่อบิดา" + emp_ru_namedad + "\nชื่อมารดา" + emp_ru_namemom + "\nชื่อสามีหรือภรรยา" + emp_ru_namehusband_and_wife + "\nที่อยู่" + emp_ru_address + "\nสังกัด " + S5.Text + "\nรหัสเข้าสู่ระบบ\nรหัสชื่อผู้ใช้ " + S1.Text + "\nรหัสผ่าน " + S3.Text + "", el.Font)));
* table.AddCell(new PdfPCell(img));
* // table.AddCell(new Phrase(10, "" + S2.Text + "", el.Font));
* // table.AddCell(img);
* // table.AddCell(new Phrase(70, "รหัสเข้าสู่ระบบ", el.Font));
* // table.AddCell(new Phrase(70, "รหัสชื่อผู้ใช้ " + S1.Text + "", el.Font));
* // table.AddCell(new Phrase(10, "รหัสผ่าน" + S3.Text + "", el.Font));
* doc.Add(table);
* doc.Close();
* System.Diagnostics.Process.Start("" + S2.Text + ".pdf");
*
* clinic_approve_step2 appr2 = new clinic_approve_step2();
* appr2.Show();
* clinic_approve approve = new clinic_approve();
* approve.Close();
* Visible = false;
*
*
* }
* else
* {
*/
/*
* query = ("insert into privilege (privil_status,emp_ru_idcard,date,time,opd_id,emp_ru_id) values('ได้รับสิทธิการรักษา','" + emp_ru_idcard + "',SYSDATETIME(), SYSDATETIME(),'" + id + "','" + emp_ru_id + "');");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
* query = ("select privil_id from privilege where emp_ru_idcard = '" + emp_ru_idcard + "'");
* cmd = new SqlCommand(query, conn);
* sdr = cmd.ExecuteReader();
* if (sdr.Read())
* {
* int privil_id = Convert.ToInt32(sdr["privil_id"].ToString());
* query = ("update opd set privil_id = '" + privil_id + "' where opd_idcard = '" + emp_ru_idcard + "'");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
*
*
*
* query = ("insert into user_control (uct_user,uct_password,emp_ru_id,opd_id)values ('" + emp_ru_idcard + "','" + emp_ru_birthday + "','" + emp_ru_id + "','" + id + "');");
*
*
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
*
*
*
*
* string fontpath = Environment.GetEnvironmentVariable("SystemRoot") + "../fonts/THSarabun.ttf";
* BaseFont basefont = BaseFont.CreateFont(fontpath, BaseFont.IDENTITY_H, true);
* iTextSharp.text.Font arabicFont = new iTextSharp.text.Font(basefont, 30, iTextSharp.text.Font.NORMAL);
* var el = new Chunk();
* iTextSharp.text.Font f2 = new iTextSharp.text.Font(basefont, el.Font.Size,
* el.Font.Style, el.Font.Color);
* el.Font = f2;
*
* Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35);
*
* PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream("" + S2.Text + ".pdf", FileMode.Create));
* doc.Open();
* iTextSharp.text.pdf.PdfContentByte cb = wri.DirectContent;
* iTextSharp.text.pdf.Barcode128 bc = new Barcode128();
* bc.TextAlignment = Element.ALIGN_LEFT;
* bc.Code = S1.Text;
* bc.StartStopText = false;
* bc.CodeType = iTextSharp.text.pdf.Barcode128.EAN13;
* bc.Extended = true;
*
* iTextSharp.text.Image ru = iTextSharp.text.Image.GetInstance("ru.png");
* ru.ScalePercent(15f);
*
*
*
*
* iTextSharp.text.Image img = bc.CreateImageWithBarcode(cb,
* iTextSharp.text.BaseColor.BLACK, iTextSharp.text.BaseColor.BLACK);
*
* cb.SetTextMatrix(100f, 150.5f);
* img.ScaleToFit(150, 159);
* img.SetAbsolutePosition(100f, 150f);
* // doc.Add(ru);
* PdfPTable headerTable = new PdfPTable(2);
* headerTable.TotalWidth = 530f;
* headerTable.HorizontalAlignment = 0;
* headerTable.SpacingAfter = 20;
* //headerTable.DefaultCell.Border = Rectangle.NO_BORDER;
*
* float[] headerTableColWidth = new float[2];
* headerTableColWidth[0] = 220f;
* headerTableColWidth[1] = 310f;
*
* headerTable.SetWidths(headerTableColWidth);
* headerTable.LockedWidth = true;
*
* PdfPCell headerTableCell_0 = new PdfPCell(ru);
* headerTableCell_0.HorizontalAlignment = Element.ALIGN_LEFT;
* headerTableCell_0.Border = iTextSharp.text.Rectangle.NO_BORDER;
* headerTable.AddCell(headerTableCell_0);
*
* PdfPCell head = new PdfPCell(new Phrase(70, "งานแพทย์และอนามัย มหาวิทยาลัยรามคำแหง\nบัตรประวัติผู้ป่วย", el.Font));
*
* head.HorizontalAlignment = Element.ALIGN_LEFT;
* head.VerticalAlignment = Element.ALIGN_BOTTOM;
* head.Border = iTextSharp.text.Rectangle.NO_BORDER;
* // headerTable.AddCell(new PdfPCell(ru));
* headerTable.AddCell(head);
*
* doc.Add(headerTable);
* // Paragraph pa = new Paragraph(""+head+"");
* // doc.Add(pa);
* PdfPTable table = new PdfPTable(1);
* // table.AddCell(new PdfPCell(ru));
* table.AddCell(new PdfPCell(new Phrase(70, "ชื่อ " + S2.Text + "\nวันเดือนปีเกิด " + S3.Text + "\nอายุ" + emp_ru_age + " \nโทรศัพท์มือถือ " + S4.Text + "\n เบอร์โทรศัพท์บ้าน" + emp_ru_telhome + "\nเบอร์โทรผู้ปกครอง" + emp_ru_telparent + "\nที่อยู่ผู้ปกครอง" + em_ru_addressparent + "\nชื่อบิดา" + emp_ru_namedad + "\nชื่อมารดา" + emp_ru_namemom + "\nชื่อสามีหรือภรรยา" + emp_ru_namehusband_and_wife + "\nที่อยู่" + emp_ru_address + "\nสังกัด " + S5.Text + "\nรหัสเข้าสู่ระบบ\nรหัสชื่อผู้ใช้ " + S1.Text + "\nรหัสผ่าน " + S3.Text + "", el.Font)));
* table.AddCell(new PdfPCell(img));
* // table.AddCell(new Phrase(10, "" + S2.Text + "", el.Font));
* // table.AddCell(img);
* // table.AddCell(new Phrase(70, "รหัสเข้าสู่ระบบ", el.Font));
* // table.AddCell(new Phrase(70, "รหัสชื่อผู้ใช้ " + S1.Text + "", el.Font));
* // table.AddCell(new Phrase(10, "รหัสผ่าน" + S3.Text + "", el.Font));
* doc.Add(table);
* doc.Close();
* System.Diagnostics.Process.Start("" + S2.Text + ".pdf");
*
* clinic_approve_step2 appr2 = new clinic_approve_step2();
* appr2.Show();
* clinic_approve approve = new clinic_approve();
* approve.Close();
* Visible = false;
*
* }
*/
}
/*
* query = ("insert into opd (opd_name,opd_idcard,opd_birthday,opd_age,opd_telwork,opd_telmobile ,opd_telhome,emp_ru_telparent,emp_ru_nameparent,em_ru_addressparent,emp_ru_namedad,eru.emp_ru_namemom,emp_ru_namehusband_and_wife,emp_ru_address)"+
* "values('"+emp_ru_name+" ','"+emp_ru_idcard+" ','"+emp_ru_birthday+" ','"+emp_ru_age+" ',"+
* "'"+emp_ru_age+" ','"+emp_ru_telwork+" ','"+emp_ru_telmobile+" ','"+emp_ru_telhome+" ',"+
* "'"+emp_ru_telparent+"','"+emp_ru_nameparent+" ','"+ em_ru_addressparent + " '"+
* ",'"+ emp_ru_namedad + "','"+emp_ru_namemom+" ','"+ emp_ru_namehusband_and_wife + " ',"+
* "'"+ emp_ru_address + "')");
* cmd = new SqlCommand(query, conn);
* sda = new SqlDataAdapter(cmd);
* dt = new DataTable();
* sda.Fill(dt);
*
*/
}
}
conn.Close();
}
private void conferm_Click(object sender, EventArgs e)
{
clinic_approve cliapp = new clinic_approve();
cliapp.Show();
}
