public ResOrderTab setDocGroupScan(ResOrderTab dgs1)
{
dgs1.ResOrderKey = "";
dgs1.OrderClass = "";
dgs1.PatientID = "";
dgs1.AccessNumber = "";
dgs1.KPatientName = "";
dgs1.EPatientName = "";
dgs1.DateOfBirth = "";
dgs1.PatientSex = "";
dgs1.PatientClass = "";
dgs1.Modality = "";
dgs1.StudyDate = "";
dgs1.SicknessName = "";
dgs1.SicknessCode = "";
dgs1.ProcDesc = "";
dgs1.ResStatus = "";
dgs1.ResStatusPolling = "";
dgs1.InsertDate = "";
dgs1.OrderDate = "";
dgs1.PhysicianID = "";
dgs1.PhysicianName = "";
dgs1.OrderDept = "";
dgs1.ModalityCode = "";
dgs1.ExamCode = "";
dgs1.ExanDescription = "";
dgs1.ReadingPriority = "";
dgs1.ReqPhysicianID = "";
dgs1.ReqPhysicianName = "";
dgs1.StationAE = "";
//dgs1.folder_ftp = "";
return(dgs1);
}
public DataTable selectResultByAccessNumber(String acc)
{
ResOrderTab cop1 = new ResOrderTab();
DataTable dt = new DataTable();
String sql = "select * " +
"From " + rpttc.table + " rpttc " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
"Where rpttc." + rpttc.AccessNumber + " ='" + acc + "' " +
" ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByPk1(String id)
{
ResOrderTab cop1 = new ResOrderTab();
DataTable dt = new DataTable();
String sql = "select * " +
"From " + reso.table + " dsc " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
"Where dsc." + reso.pkField + " ='" + id + "' " +
"Order By doc_group_id ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public String insertResOrderTab(ResOrderTab p, String userId)
{
String re = "";
if (p.ResOrderKey.Equals(""))
{
re = insert(p, "");
}
else
{
re = update(p, "");
}
return(re);
}
private void GrfReq_DoubleClick(object sender, EventArgs e)
{
//throw new NotImplementedException();
if (grfReq.Row <= 0)
{
return;
}
if (grfReq.Col <= 0)
{
return;
}
String hn = "", name = "", sex = "", dob = "", sickness = "", vn = "", hnreqyear = "", preno = "", reqno = "", xray = "";
hn = grfReq[grfReq.Row, colReqHn] != null ? grfReq[grfReq.Row, colReqHn].ToString() : "";
name = grfReq[grfReq.Row, colReqName] != null ? grfReq[grfReq.Row, colReqName].ToString() : "";
sex = grfReq[grfReq.Row, colreqsex] != null ? grfReq[grfReq.Row, colreqsex].ToString() : "";
dob = grfReq[grfReq.Row, colreqdob] != null ? grfReq[grfReq.Row, colreqdob].ToString() : "";
sickness = grfReq[grfReq.Row, colreqsickness] != null ? grfReq[grfReq.Row, colreqsickness].ToString() : "";
vn = grfReq[grfReq.Row, colReqVn] != null ? grfReq[grfReq.Row, colReqVn].ToString() : "";
hnreqyear = grfReq[grfReq.Row, colReqreqyr] != null ? grfReq[grfReq.Row, colReqreqyr].ToString() : "";
preno = grfReq[grfReq.Row, colreqpreno] != null ? grfReq[grfReq.Row, colreqpreno].ToString() : "";
reqno = grfReq[grfReq.Row, colReqreqno] != null ? grfReq[grfReq.Row, colReqreqno].ToString() : "";
xray = grfReq[grfReq.Row, colxrdesc] != null ? grfReq[grfReq.Row, colxrdesc].ToString() : "";
ResOrderTab reso = new ResOrderTab();
//MessageBox.Show("reqno " + reqno+ "\n hnreqyear "+ hnreqyear, "");
reso = bc.bcDB.resoDB.setResOrderTab(hn, name, vn, hnreqyear, preno, reqno, dob, sex, sickness, xray, "", "", "", "");
//MessageBox.Show("InsertDate " + reso.InsertDate , "");
String re = bc.bcDB.resoDB.insertResOrderTab(reso, "");
//MessageBox.Show("re " + re, "");
long chk = 0, chk1 = 0;
if (long.TryParse(re, out chk))
{
//MessageBox.Show("chk " + chk, "");
String re1 = "";
re1 = bc.bcDB.xrDB.updateStatusPACs(reqno, hnreqyear);
//MessageBox.Show("re1 " + re1, "");
if (long.TryParse(re1, out chk1))
{
setGrfReq();
}
}
}
public ResOrderTab setDocScan(DataTable dt)
{
ResOrderTab dgs1 = new ResOrderTab();
if (dt.Rows.Count > 0)
{
dgs1.ResOrderKey = dt.Rows[0][reso.ResOrderKey].ToString();
dgs1.OrderClass = dt.Rows[0][reso.OrderClass].ToString();
dgs1.PatientID = dt.Rows[0][reso.PatientID].ToString();
dgs1.AccessNumber = dt.Rows[0][reso.AccessNumber].ToString();
dgs1.KPatientName = dt.Rows[0][reso.KPatientName].ToString();
dgs1.EPatientName = dt.Rows[0][reso.EPatientName].ToString();
dgs1.DateOfBirth = dt.Rows[0][reso.DateOfBirth].ToString();
dgs1.PatientSex = dt.Rows[0][reso.PatientSex].ToString();
dgs1.PatientClass = dt.Rows[0][reso.PatientClass].ToString();
dgs1.Modality = dt.Rows[0][reso.Modality].ToString();
dgs1.StudyDate = dt.Rows[0][reso.StudyDate].ToString();
dgs1.SicknessName = dt.Rows[0][reso.SicknessName].ToString();
dgs1.SicknessCode = dt.Rows[0][reso.SicknessCode].ToString();
dgs1.ProcDesc = dt.Rows[0][reso.ProcDesc].ToString();
dgs1.ResStatus = dt.Rows[0][reso.ResStatus].ToString();
dgs1.ResStatusPolling = dt.Rows[0][reso.ResStatusPolling].ToString();
dgs1.InsertDate = dt.Rows[0][reso.InsertDate].ToString();
dgs1.OrderDate = dt.Rows[0][reso.OrderDate].ToString();
dgs1.PhysicianID = dt.Rows[0][reso.PhysicianID].ToString();
dgs1.PhysicianName = dt.Rows[0][reso.PhysicianName].ToString();
dgs1.OrderDept = dt.Rows[0][reso.OrderDept].ToString();
dgs1.ModalityCode = dt.Rows[0][reso.ModalityCode].ToString();
dgs1.ExamCode = dt.Rows[0][reso.ExamCode].ToString();
dgs1.ExanDescription = dt.Rows[0][reso.ExanDescription].ToString();
dgs1.ReadingPriority = dt.Rows[0][reso.ReadingPriority].ToString();
dgs1.ReqPhysicianID = dt.Rows[0][reso.ReqPhysicianID].ToString();
dgs1.ReqPhysicianName = dt.Rows[0][reso.ReqPhysicianName].ToString();
dgs1.StationAE = dt.Rows[0][reso.StationAE].ToString();
//dgs1.folder_ftp = dt.Rows[0][reso.folder_ftp].ToString();
}
else
{
setDocGroupScan(dgs1);
}
return(dgs1);
}
public ResOrderTab setResOrderTab(String hn, String name, String vn, String preno, String hnyear, String reqno, String dob, String sex, String sickness, String xraydesc, String xraycode, String deptname, String dtrid, String dtrname)
{
String date = "";
date = System.DateTime.Now.Year + System.DateTime.Now.ToString("MMddHHmmss");
ResOrderTab reso1 = new ResOrderTab();
reso1.ResOrderKey = "";
reso1.OrderClass = "NEW";
reso1.PatientID = hn;
reso1.AccessNumber = vn + "@" + preno + "@" + hnyear + "@" + reqno + "@" + xraycode;
reso1.KPatientName = name;
reso1.EPatientName = name;
reso1.DateOfBirth = dob.Replace("-", "");
reso1.PatientSex = sex;
reso1.PatientClass = "CR";
reso1.Modality = "CR";
reso1.StudyDate = date;
reso1.SicknessName = sickness;
reso1.SicknessCode = "100";
reso1.ProcDesc = xraydesc; // ท่า
reso1.ResStatus = "";
reso1.ResStatusPolling = "";
reso1.InsertDate = date;
reso1.OrderDate = date;
reso1.PhysicianID = dtrid;
reso1.PhysicianName = dtrname;
reso1.OrderDept = deptname;
reso1.ModalityCode = "";
//reso1.ProcDesc = "E017";
//reso1.ExanDescription = "NEck";
reso1.ExamCode = "";
reso1.ExanDescription = xraydesc;
reso1.ReadingPriority = "0";
reso1.ReqPhysicianID = "";
reso1.ReqPhysicianName = "";
reso1.StationAE = "";
reso1.HisAddedInfo1 = vn + "@" + preno + "@" + hnyear + "@" + reqno;
//reso1.HisAddedInfo1 = vn + "@" + preno + "@" + hnyear + "@" + reqno;
return(reso1);
}
private void chkNull(ResOrderTab p)
{
long chk = 0;
p.OrderClass = p.OrderClass == null ? "" : p.OrderClass;
p.PatientID = p.PatientID == null ? "" : p.PatientID;
p.AccessNumber = p.AccessNumber == null ? "" : p.AccessNumber;
p.KPatientName = p.KPatientName == null ? "" : p.KPatientName;
p.EPatientName = p.EPatientName == null ? "" : p.EPatientName;
p.DateOfBirth = p.DateOfBirth == null ? "" : p.DateOfBirth;
p.PatientSex = p.PatientSex == null ? "" : p.PatientSex;
p.PatientClass = p.PatientClass == null ? "" : p.PatientClass;
p.Modality = p.Modality == null ? "" : p.Modality;
p.StudyDate = p.StudyDate == null ? "" : p.StudyDate;
p.SicknessName = p.SicknessName == null ? "" : p.SicknessName;
p.SicknessCode = p.SicknessCode == null ? "" : p.SicknessCode;
p.ProcDesc = p.ProcDesc == null ? "" : p.ProcDesc;
p.ResStatus = p.ResStatus == null ? "" : p.ResStatus;
p.ResStatusPolling = p.ResStatusPolling == null ? "" : p.ResStatusPolling;
p.InsertDate = p.InsertDate == null ? "" : p.InsertDate;
p.OrderDate = p.OrderDate == null ? "" : p.OrderDate;
p.PhysicianID = p.PhysicianID == null ? "" : p.PhysicianID;
p.PhysicianName = p.PhysicianName == null ? "" : p.PhysicianName;
p.OrderDept = p.OrderDept == null ? "" : p.OrderDept;
p.ModalityCode = p.ModalityCode == null ? "" : p.ModalityCode;
p.ExamCode = p.ExamCode == null ? "" : p.ExamCode;
p.ExanDescription = p.ExanDescription == null ? "" : p.ExanDescription;
p.ReadingPriority = p.ReadingPriority == null ? "" : p.ReadingPriority;
p.ReqPhysicianID = p.ReqPhysicianID == null ? "" : p.ReqPhysicianID;
p.ReqPhysicianName = p.ReqPhysicianName == null ? "" : p.ReqPhysicianName;
p.StationAE = p.StationAE == null ? "" : p.StationAE;
//p.folder_ftp = p.folder_ftp == null ? "" : p.folder_ftp;
//p.folder_ftp = p.folder_ftp == null ? "" : p.folder_ftp;
//p.doc_group_id = long.TryParse(p.doc_group_id, out chk) ? chk.ToString() : "0";
//p.row_no = long.TryParse(p.row_no, out chk) ? chk.ToString() : "0";
//p.doc_group_sub_id = long.TryParse(p.doc_group_sub_id, out chk) ? chk.ToString() : "0";
//p.pre_no = int.TryParse(p.pre_no, out chk) ? chk.ToString() : "0";
//p.doctor_id = int.TryParse(p.doctor_id, out chk) ? chk.ToString() : "0";
}
public String update(ResOrderTab p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
chkNull(p);
//sql = "Update " + dsc.table + " Set " +
// " " + dsc.doc_group_id + " = '" + p.doc_group_id + "'" +
// "," + dsc.row_no + " = '" + p.row_no + "'" +
// "," + dsc.host_ftp + " = '" + p.host_ftp + "'" +
// "," + dsc.image_path + " = '" + p.image_path + "'" +
// "," + dsc.hn + " = '" + p.hn + "'" +
// "," + dsc.vn + " = '" + p.vn + "'" +
// "," + dsc.visit_date + " = '" + p.visit_date + "'" +
// "," + dsc.remark + " = '" + p.remark + "'" +
// "," + dsc.date_modi + " = convert(varchar, getdate(), 23)" +
// "," + dsc.user_modi + " = '" + userId + "'" +
// "," + dsc.an + " = '" + p.an + "'" +
// "," + dsc.doc_group_sub_id + " = '" + p.doc_group_sub_id + "'" +
// "," + dsc.pre_no + " = '" + p.pre_no + "'" +
// "," + dsc.an_date + " = '" + p.an_date + "'" +
// "," + dsc.status_ipd + " = '" + p.status_ipd + "'" +
// "," + dsc.an_cnt + " = '" + p.an_cnt + "'" +
// "," + dsc.folder_ftp + " = '" + p.folder_ftp + "'" +
// "Where " + dsc.pkField + "='" + p.doc_scan_id + "'"
// ;
try
{
//re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void initConfig()
{
reso = new ResOrderTab();
//lDgs = new List<ResOrderTab>();
reso.ResOrderKey = "ResOrderKey";
reso.OrderClass = "OrderClass";
reso.PatientID = "PatientID";
reso.AccessNumber = "AccessNumber";
reso.KPatientName = "KPatientName";
reso.EPatientName = "EPatientName";
reso.DateOfBirth = "DateOfBirth";
reso.PatientSex = "PatientSex";
reso.PatientClass = "PatientClass";
reso.Modality = "Modality";
reso.StudyDate = "StudyDate";
reso.SicknessName = "SicknessName";
reso.SicknessCode = "SicknessCode";
reso.ProcDesc = "ProcDesc";
reso.ResStatus = "ResStatus";
reso.ResStatusPolling = "ResStatusPolling";
reso.InsertDate = "InsertDate";
reso.OrderDate = "OrderDate";
reso.PhysicianID = "PhysicianID";
reso.PhysicianName = "PhysicianName";
reso.OrderDept = "OrderDept";
reso.ModalityCode = "ModalityCode";
reso.ExamCode = "ExamCode";
reso.ExanDescription = "ExanDescription";
reso.ReadingPriority = "ReadingPriority";
reso.ReqPhysicianID = "ReqPhysicianID";
reso.ReqPhysicianName = "ReqPhysicianName";
reso.StationAE = "StationAE";
reso.table = "ResOrderTab";
reso.pkField = "ResOrderKey";
}
public String insert(ResOrderTab p, String userId)
{
String re = "";
String sql = "";
DataTable dt = new DataTable();
p.Modality = "CR"; //fix code
p.OrderClass = "NEW"; //fix code
p.ResStatus = "U"; //fix code
//p.ssdata_id = "";
long chk = 0;
chkNull(p);
//sql = "Insert Into " + reso.table + " (" + reso.doc_group_id + "," + reso.active + "," + reso.row_no + "," +
// reso.host_ftp + "," + reso.image_path + "," + reso.hn + "," +
// reso.vn + "," + reso.visit_date + "," + reso.remark + "," +
// reso.date_create + "," + reso.date_modi + "," + reso.date_cancel + "," +
// reso.user_create + "," + reso.user_modi + "," + reso.user_cancel + "," +
// reso.an + "," + reso.doc_group_sub_id + "," + reso.pre_no + "," +
// reso.an_date + "," + reso.status_ipd + "," + reso.an_cnt + "," +
// reso.folder_ftp + " " +
// ") " +
// "Values ('" + p.doc_group_id + "','1','" + p.row_no + "'," +
// "'" + p.host_ftp + "','" + p.image_path + "','" + p.hn + "'," +
// "'" + p.vn + "','" + p.visit_date + "','" + p.remark + "'," +
// "convert(varchar, getdate(), 23),'" + p.date_modi + "','" + p.date_cancel + "'," +
// "'" + userId + "','" + p.user_modi + "','" + p.user_cancel + "'," +
// "'" + p.an + "','" + p.doc_group_sub_id + "','" + p.pre_no + "'," +
// "'" + p.an_date + "','" + p.status_ipd + "','" + p.an_cnt + "' " +
// "'" + p.folder_ftp + "' " +
// ")";
try
{
conn.comStore = new System.Data.SqlClient.SqlCommand();
conn.comStore.Connection = conn.connPACs;
conn.comStore.CommandText = "insert_resordertab";
conn.comStore.CommandType = CommandType.StoredProcedure;
conn.comStore.Parameters.AddWithValue("OrderClass", p.OrderClass);
conn.comStore.Parameters.AddWithValue("PatientID", p.PatientID);
conn.comStore.Parameters.AddWithValue("AccessNumber", p.AccessNumber);
conn.comStore.Parameters.AddWithValue("KPatientName", p.KPatientName);
conn.comStore.Parameters.AddWithValue("EPatientName", p.EPatientName);
conn.comStore.Parameters.AddWithValue("DateOfBirth", p.DateOfBirth);
conn.comStore.Parameters.AddWithValue("PatientSex", p.PatientSex);
conn.comStore.Parameters.AddWithValue("PatientClass", p.PatientClass);
conn.comStore.Parameters.AddWithValue("Modality", p.Modality);
conn.comStore.Parameters.AddWithValue("StudyDate", p.StudyDate);
conn.comStore.Parameters.AddWithValue("SicknessName", p.SicknessName);
conn.comStore.Parameters.AddWithValue("SicknessCode", p.SicknessCode);
conn.comStore.Parameters.AddWithValue("ProcDesc", p.ProcDesc);
conn.comStore.Parameters.AddWithValue("ResStatus", p.ResStatus);
conn.comStore.Parameters.AddWithValue("ResStatusPolling", p.ResStatusPolling);
conn.comStore.Parameters.AddWithValue("InsertDate", p.InsertDate);
conn.comStore.Parameters.AddWithValue("OrderDate", p.OrderDate);
conn.comStore.Parameters.AddWithValue("PhysicianID", p.PhysicianID);
conn.comStore.Parameters.AddWithValue("PhysicianName", p.PhysicianName);
conn.comStore.Parameters.AddWithValue("OrderDept", p.OrderDept);
conn.comStore.Parameters.AddWithValue("ModalityCode", p.ModalityCode);
conn.comStore.Parameters.AddWithValue("ExamCode", p.ExamCode);
conn.comStore.Parameters.AddWithValue("ExanDescription", p.ExanDescription);
conn.comStore.Parameters.AddWithValue("ReadingPriority", p.ReadingPriority);
conn.comStore.Parameters.AddWithValue("ReqPhysicianID", p.ReqPhysicianID);
conn.comStore.Parameters.AddWithValue("ReqPhysicianName", p.ReqPhysicianName);
conn.comStore.Parameters.AddWithValue("StationAE", p.StationAE);
conn.comStore.Parameters.AddWithValue("HisAddedInfo1", p.HisAddedInfo1);
//conn.comStore.Parameters.AddWithValue("folder_ftp", p.folder_ftp);
SqlParameter retval = conn.comStore.Parameters.Add("row_no1", SqlDbType.VarChar, 50);
retval.Value = "";
retval.Direction = ParameterDirection.Output;
conn.connPACs.Open();
conn.comStore.ExecuteNonQuery();
re = (String)conn.comStore.Parameters["row_no1"].Value;
if (long.TryParse(re, out chk))
{
}
//string retunvalue = (string)sqlcomm.Parameters["@b"].Value;
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
re = ex.Message;
}
finally
{
conn.connPACs.Close();
conn.comStore.Dispose();
}
return(re);
}
