private void convertPtt()
{
ConnectDB connS;
pB1.Show();
pB1.Minimum = 0;
connS = new ConnectDB(ic.iniC);
connS.conn.ConnectionString = "Server=" + txtShost.Text + ";Database=" + txtSdatabase.Text + ";Uid=" + txtSuser.Text + ";Pwd=" + txtSpassword.Text +
";port = " + txtSport.Text + "; Connection Timeout = 300;default command timeout=0; CharSet=utf8;SslMode=none;";
DataTable dtS = new DataTable();
String sql = "";
sql = "Select row_id, regisdate, idcard, hn, yot, name, surname, dbirth, age, phone, sex, status" +
", lastupdate, officer, blood, beActive, pg, tcname, agen, hnmale, namemale, hnfemale, namefemale, doctor, pttype " +
", namefemale " +
"From opcard " +
"Where status_convert = '0' " +
"Order By regisdate ";
dtS = connS.selectData(connS.conn, sql);
if (dtS.Rows.Count > 0)
{
pB1.Maximum = dtS.Rows.Count + 1;
//sql = "Delete From t_patient Where status_convert = '1' ";
//connS.ExecuteNonQuery(ic.conn.conn, sql);
foreach (DataRow row in dtS.Rows)
{
Patient ptt = new Patient();
ptt.t_patient_id = "";
ptt.patient_hn = row["hn"].ToString();
ptt.patient_firstname_e = row["name"].ToString();
ptt.patient_lastname_e = row["surname"].ToString();
ptt.patient_birthday = row["dbirth"].ToString();
ptt.mobile1 = row["phone"].ToString();
ptt.f_sex_id = row["sex"].ToString().Equals("M") ? "2100000001" : "2100000002";
ptt.agent = row["agen"].ToString();
ptt.patient_type = row["pttype"].ToString();
ptt.patient_group = row["pg"].ToString();
ptt.patient_private_doctor = row["doctor"].ToString();
ptt.status_convert = "1";
ptt.remark = row["tcname"].ToString();
ptt.pid = row["idcard"].ToString();
ptt.f_patient_prefix_id = ic.getC1Combo(cboPrefix, row["yot"].ToString());
ic.ivfDB.pttDB.insertPatient(ptt, "");
sql = "Update opcard Set status_convert = '1' Where row_id = '" + row["row_id"].ToString() + "'";
connS.ExecuteNonQuery(connS.conn, sql);
pB1.Value++;
}
}
pB1.Hide();
}
