private void BtnRotate_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
String dgs = "", id = "";
try
{
filename = filename.Substring(filename.IndexOf('*') + 1);
//Image img=null;
//img.Save(stream, ImageFormat.Jpeg);
//resizedImage = bc.RotateImage(img);
img1 = bc.RotateImage(img1);
//img.Dispose();
//if (File.Exists(filename))
//{
// File.Delete(filename);
//}
//img1.Save(filename);
//Bitmap bmp;
//bmp = (Bitmap)img1;
//bmp.Save(filename, System.Drawing.Imaging.ImageFormat.Jpeg);
//Image img2 = Image.FromFile(filename);
pic1.Image = img1;
//pnImg.Width = img1.
}
catch (Exception ex)
{
dgs = ex.Message;
}
}
private void BtnSaveRotate_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
Stream stream = new MemoryStream();
pic1.Image.Save(stream, ImageFormat.Jpeg);
DocScan dsc = new DocScan();
dsc = bc.bcDB.dscDB.castDocScan(dgs);
dsc.doc_scan_id = "";
string ext = Path.GetExtension(dgs.image_path);
String re = bc.bcDB.dscDB.insertDocScan(dsc, "");
dsc.image_path = txtHn.Text.Replace("/", "-") + "//" + txtHn.Text.Replace("/", "-") + "-" + vn.Replace("/", "_").Replace("(", "_").Replace(")", "") + "//" + txtHn.Text.Replace("/", "-") + "-" + vn.Replace("/", "_").Replace("(", "_").Replace(")", "") + "-" + re + ext; //+1
int chk = 0;
if (int.TryParse(re, out chk))
{
String re1 = bc.bcDB.dscDB.updateImagepath(dsc.image_path, re);
FtpClient ftp = new FtpClient(bc.iniC.hostFTP, bc.iniC.userFTP, bc.iniC.passFTP, bc.ftpUsePassive);
stream.Seek(0, SeekOrigin.Begin);
//MessageBox.Show(bc.iniC.folderFTP + "//" + dsc.image_path, "");
Boolean chk1 = ftp.upload(bc.iniC.folderFTP + "//" + dsc.image_path, stream);
bc.bcDB.dscDB.voidDocScan(dgs.doc_scan_id, "");
MessageBox.Show("save file Rotate to seerver success", "");
}
}
private void chkNull(DocScan p)
{
long chk = 0;
p.date_modi = p.date_modi == null ? "" : p.date_modi;
p.date_cancel = p.date_cancel == null ? "" : p.date_cancel;
p.user_create = p.user_create == null ? "" : p.user_create;
p.user_modi = p.user_modi == null ? "" : p.user_modi;
p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
p.host_ftp = p.host_ftp == null ? "" : p.host_ftp;
p.image_path = p.image_path == null ? "" : p.image_path;
p.hn = p.hn == null ? "" : p.hn;
p.vn = p.vn == null ? "" : p.vn;
p.visit_date = p.visit_date == null ? "" : p.visit_date;
p.remark = p.remark == null ? "" : p.remark;
p.an = p.an == null ? "" : p.an;
p.pre_no = p.pre_no == null ? "" : p.pre_no;
p.an_date = p.an_date == null ? "" : p.an_date;
p.status_ipd = p.status_ipd == null ? "" : p.status_ipd;
p.an_cnt = p.an_cnt == null ? "" : p.an_cnt;
p.folder_ftp = p.folder_ftp == null ? "" : p.folder_ftp;
p.status_record = p.status_record == null ? "0" : p.status_record;
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";
}
private void initConfig()
{
dsc = new DocScan();
lDgs = new List <DocScan>();
dsc.doc_scan_id = "doc_scan_id";
dsc.doc_group_id = "doc_group_id";
dsc.row_no = "row_no";
dsc.host_ftp = "host_ftp";
dsc.image_path = "image_path";
dsc.hn = "hn";
dsc.vn = "vn";
dsc.visit_date = "visit_date";
dsc.active = "active";
dsc.remark = "remark";
dsc.date_create = "date_create";
dsc.date_modi = "date_modi";
dsc.date_cancel = "date_cancel";
dsc.user_create = "user_create";
dsc.user_modi = "user_modi";
dsc.user_cancel = "user_cancel";
dsc.an = "an";
dsc.doc_group_sub_id = "doc_group_sub_id";
dsc.pre_no = "pre_no";
dsc.an_date = "an_date";
dsc.status_ipd = "status_ipd";
dsc.an_cnt = "an_cnt";
dsc.folder_ftp = "folder_ftp";
dsc.status_record = "status_record";
dsc.table = "t_doc_scan";
dsc.pkField = "doc_scan_id";
}
private void BtnGenSort_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
DataTable dataTable1 = new DataTable();
DataTable dataTable2 = this.bc.bcDB.dscDB.selectByAnSortID(((Control)this.txtHn).Text, ((Control)this.txtAn).Text);
if (dataTable2.Rows.Count <= 0)
{
return;
}
long result1 = 0;
if (long.TryParse(dataTable2.Rows[0][this.bc.bcDB.dscDB.dsc.sort1].ToString(), out result1))
{
int num = 0;
foreach (DataRow row in (InternalDataCollectionBase)dataTable2.Rows)
{
++num;
int result2 = 0;
if (!int.TryParse(this.bc.bcDB.dscDB.updateSort(row[this.bc.bcDB.dscDB.dsc.doc_scan_id].ToString(), num.ToString()), out result2))
{
;
}
}
DocScan docScan1 = new DocScan();
DocScan docScan2 = this.bc.bcDB.dscDB.selectByPk(((Control)this.txtID).Text);
txtSort.Value = docScan2.sort1;
txtSort.Value = docScan2.sort1;
}
}
public DocScan setDocGroupScan(DocScan dgs1)
{
dgs1.doc_scan_id = "";
dgs1.doc_group_id = "";
dgs1.row_no = "";
dgs1.host_ftp = "";
dgs1.image_path = "";
dgs1.hn = "";
dgs1.vn = "";
dgs1.visit_date = "";
dgs1.active = "";
dgs1.remark = "";
dgs1.date_create = "";
dgs1.date_modi = "";
dgs1.date_cancel = "";
dgs1.user_create = "";
dgs1.user_modi = "";
dgs1.user_cancel = "";
dgs1.an = "";
dgs1.doc_group_sub_id = "";
dgs1.pre_no = "";
dgs1.an_date = "";
dgs1.status_ipd = "";
dgs1.an_cnt = "";
dgs1.folder_ftp = "";
dgs1.status_record = "";
return(dgs1);
}
private static void RecognizeWithFCProcessor(string pathFolderWork, string pathFlderTmplates, string[] manyImages, bool loadInproc = true)
{
var outProcRecognizing = new DocScan();
try
{
if (loadInproc)
{
outProcRecognizing.SetInprocLoading();
}
if (!outProcRecognizing.LoadEngine())
{
PrintConsole(outProcRecognizing.GetErrorText());
}
// отображение версий шаблонов
outProcRecognizing.SetTemplatesDirectory(pathFlderTmplates);
// установить режим предобработки изображений
outProcRecognizing.SetImagePreproccesingMode(_modePreprocessingImage);
Console.WriteLine("Версия компоненты распознавания:");
Console.WriteLine(outProcRecognizing.GetComponentVersion());
Console.WriteLine("Версии шаблонов распознавания: ");
string nameTmplte = outProcRecognizing.GetTemplateVersion();
Console.WriteLine(nameTmplte);
while (!String.IsNullOrEmpty(nameTmplte))
{
nameTmplte = outProcRecognizing.GetTemplateVersion();
Console.WriteLine(nameTmplte);
}
foreach (string image in manyImages)
{
outProcRecognizing.AddImage(image);
}
try
{
Console.WriteLine("Идет распознавание...");
outProcRecognizing.RecognizeFiles(pathFolderWork, pathFlderTmplates);
} catch (Exception ex)
{
string tt = ex.Message + Environment.NewLine + ex.StackTrace + Environment.NewLine + outProcRecognizing.GetErrorText();
PrintConsole(tt);
}
outProcRecognizing.UnloadEngine();
}
catch (Exception ex)
{
_errorText = "Сбой распознавания: " + ex.Message;
_errorText += Environment.NewLine + outProcRecognizing.GetErrorText();
_errorText += Environment.NewLine + ex.StackTrace;
_errorText += Environment.NewLine + "Images:" + String.Join(" ", manyImages);
PrintConsole(_errorText);
}
}
public DataTable selectByVn(String hn, String an)
{
DocScan cop1 = new DocScan();
DataTable dt = new DataTable();
String sql = "select * " +
"From " + dsc.table + " dsc " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
"Where dsc." + dsc.hn + " ='" + hn + "' and dsc." + dsc.vn + "='" + an + "' and dsc." + dsc.active + "='1'" +
"Order By doc_group_id ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public DataTable selectByPk1(String id)
{
DocScan cop1 = new DocScan();
DataTable dt = new DataTable();
String sql = "select * " +
"From " + dsc.table + " dsc " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
"Where dsc." + dsc.pkField + " ='" + id + "' " +
"Order By doc_group_id ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public String insertDocScan(DocScan p, String userId)
{
String re = "";
if (p.doc_scan_id.Equals(""))
{
re = insert(p, userId);
}
else
{
re = update(p, userId);
}
return(re);
}
private void ContextMenu_grfImg_Download(object sender, System.EventArgs e)
{
String id = "", datetick = "", dsc_id = "";
if (grfImg.Col <= 0)
{
return;
}
if (grfImg.Row < 0)
{
return;
}
if (grfImg.Col == 1)
{
id = grfImg[grfImg.Row, colPic2].ToString();
}
else
{
id = grfImg[grfImg.Row, colPic4].ToString();
}
dsc_id = id;
DocScan dsc = new DocScan();
dsc = bc.bcDB.dscDB.selectByPk(dsc_id);
Stream streamDownload = null;
MemoryStream strm = null;
foreach (listStream lstrmm in lStream)
{
if (lstrmm.id.Equals(id))
{
strm = lstrmm.stream;
streamDownload = lstrmm.stream;
break;
}
}
if (!Directory.Exists(bc.iniC.pathDownloadFile))
{
Directory.CreateDirectory(bc.iniC.pathDownloadFile);
}
datetick = DateTime.Now.Ticks.ToString();
Image img = Image.FromStream(streamDownload);
img.Save(bc.iniC.pathDownloadFile + "\\" + dsc.hn + "_" + datetick + ".jpg", System.Drawing.Imaging.ImageFormat.Jpeg);
bc.ExploreFile(bc.iniC.pathDownloadFile + "\\" + dsc.hn + "_" + datetick + ".jpg");
}
private void setControl()
{
string str = "";
try
{
str = "00";
dgs = bc.bcDB.dscDB.selectByPk(dscid);
bc.bcDB.dgssDB.setCboDGSS(cboDgss, "");
bc.bcDB.dgsDB.setCboDgs(cboDgs, "");
str = "01";
txtID.Value = dgs.doc_scan_id;
txtHn.Value = hn;
txtVN.Value = dgs.vn;
txtAn.Value = dgs.an;
txtPttName.Value = name;
txtVisitDate.Value = visitDate;
txtSort.Value = dgs.sort1;
txtFmCode.Value = dgs.ml_fm;
//bc.setC1Combo(cboDgs, dgs);
txtSortMax.Value = dgs.row_cnt;
//txtSortMax.Value = dgs.row_cnt;
DocGroupFM docGroupFm1 = new DocGroupFM();
DocGroupFM docGroupFm2 = bc.bcDB.dfmDB.selectByFMCode(this.dgs.ml_fm);
if (docGroupFm2.fm_id.Length > 0)
{
bc.setC1Combo(cboDgs, docGroupFm2.doc_group_id);
bc.bcDB.dgssDB.setCboDGSS(cboDgs, docGroupFm2.doc_group_id, "");
bc.setC1Combo(cboDgss, docGroupFm2.doc_group_sub_id);
}
str = "02";
pic1.Image = img1;
btnSaveFmCode.Hide();
btnVoid.Hide();
}
catch (Exception ex)
{
LogWriter logWriter = new LogWriter("e", "FrmScanViewEdit setControl err " + str + " " + ex.Message);
}
}
public String update(DocScan 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 + " = now()" +
"," + 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);
}
public String selectRowNoByHnVn(String hn, String vn, String docgid)
{
String re = "0", re1 = "";
int chk = 0;
DocScan cop1 = new DocScan();
DataTable dt = new DataTable();
String sql = "select max(" + dsc.row_no + ") as " + dsc.row_no + " " +
"From " + dsc.table + " dsc " +
//"Left Join f_patient_prefix pfx On stf.prefix_id = pfx.f_patient_prefix_id " +
"Where dsc." + dsc.hn + " ='" + hn + "' and dsc." + dsc.doc_group_id + "='" + docgid + "' and dsc." + dsc.vn + "='" + vn + "' " +
" ";
dt = conn.selectData(conn.conn, sql);
if (dt.Rows.Count > 0)
{
re1 = dt.Rows[0][dsc.row_no].ToString();
int.TryParse(re1, out chk);
chk++;
re = chk.ToString();
}
return(re);
}
public void getlBsp()
{
//lDept = new List<Position>();
lDgs.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
DocScan itm1 = new DocScan();
itm1.doc_scan_id = row[dsc.doc_scan_id].ToString();
itm1.doc_group_id = row[dsc.doc_group_id].ToString();
itm1.row_no = row[dsc.row_no].ToString();
itm1.host_ftp = row[dsc.host_ftp].ToString();
itm1.image_path = row[dsc.image_path].ToString();
itm1.hn = row[dsc.hn].ToString();
itm1.vn = row[dsc.vn].ToString();
itm1.visit_date = row[dsc.visit_date].ToString();
itm1.active = row[dsc.active].ToString();
itm1.remark = row[dsc.remark].ToString();
itm1.date_create = row[dsc.date_create].ToString();
itm1.date_modi = row[dsc.date_modi].ToString();
itm1.date_cancel = row[dsc.date_cancel].ToString();
itm1.user_create = row[dsc.user_create].ToString();
itm1.user_modi = row[dsc.user_modi].ToString();
itm1.user_cancel = row[dsc.user_cancel].ToString();
itm1.an = row[dsc.an].ToString();
itm1.doc_group_sub_id = row[dsc.doc_group_sub_id].ToString();
itm1.pre_no = row[dsc.pre_no].ToString();
itm1.an_date = row[dsc.an_date].ToString();
itm1.status_ipd = row[dsc.status_ipd].ToString();
itm1.an_cnt = row[dsc.an_cnt].ToString();
itm1.folder_ftp = row[dsc.folder_ftp].ToString();
itm1.status_record = row[dsc.status_record].ToString();
lDgs.Add(itm1);
}
}
private void loadDoctorDiag()
{
String mlfm = "";
DocScan docCC = new DocScan();
//DocScan docME = new DocScan();
//DocScan docDiag = new DocScan();
if (status.Equals("cc"))
{
mlfm = "FM-MED-900";
}
else if (title.Equals("me"))
{
mlfm = "FM-MED-901";
}
else if (title.Equals("diag"))
{
mlfm = "FM-MED-902";
}
docCC = bc.bcDB.dscDB.selectByStatusMedicalExamination(hn, mlfm, bc.vsdate, bc.preno);
//docME = bc.bcDB.dscDB.selectByStatusMedicalExamination(hn, "FM-MED-901", vsdate, preno);
//docDiag = bc.bcDB.dscDB.selectByStatusMedicalExamination(hn, "FM-MED-902", vsdate, preno);
MemoryStream streamCC, streamME, streamDiag;
FtpClient ftp = new FtpClient(bc.iniC.hostFTP, bc.iniC.userFTP, bc.iniC.passFTP, bc.ftpUsePassive);
streamCC = ftp.download(bc.iniC.folderFTP + "//" + docCC.image_path);
Thread.Sleep(200);
//streamME = ftp.download(bc.iniC.folderFTP + "//" + docME.image_path);
//Thread.Sleep(200);
//streamDiag = ftp.download(bc.iniC.folderFTP + "//" + docDiag.image_path);
//Thread.Sleep(200);
richTextBox1.Text = "";
streamCC.Position = 0;
if (streamCC.Length > 0)
{
richTextBox1.LoadFile(streamCC, RichTextBoxStreamType.RichText);
}
}
public DocScan setDocScan(DataTable dt)
{
DocScan dgs1 = new DocScan();
if (dt.Rows.Count > 0)
{
dgs1.doc_scan_id = dt.Rows[0][dsc.doc_scan_id].ToString();
dgs1.doc_group_id = dt.Rows[0][dsc.doc_group_id].ToString();
dgs1.row_no = dt.Rows[0][dsc.row_no].ToString();
dgs1.host_ftp = dt.Rows[0][dsc.host_ftp].ToString();
dgs1.image_path = dt.Rows[0][dsc.image_path].ToString();
dgs1.hn = dt.Rows[0][dsc.hn].ToString();
dgs1.vn = dt.Rows[0][dsc.vn].ToString();
dgs1.visit_date = dt.Rows[0][dsc.visit_date].ToString();
dgs1.active = dt.Rows[0][dsc.active].ToString();
dgs1.remark = dt.Rows[0][dsc.remark].ToString();
dgs1.date_create = dt.Rows[0][dsc.date_create].ToString();
dgs1.date_modi = dt.Rows[0][dsc.date_modi].ToString();
dgs1.date_cancel = dt.Rows[0][dsc.date_cancel].ToString();
dgs1.user_create = dt.Rows[0][dsc.user_create].ToString();
dgs1.user_modi = dt.Rows[0][dsc.user_modi].ToString();
dgs1.user_cancel = dt.Rows[0][dsc.user_cancel].ToString();
dgs1.an = dt.Rows[0][dsc.an].ToString();
dgs1.doc_group_sub_id = dt.Rows[0][dsc.doc_group_sub_id].ToString();
dgs1.pre_no = dt.Rows[0][dsc.pre_no].ToString();
dgs1.an_date = dt.Rows[0][dsc.an_date].ToString();
dgs1.status_ipd = dt.Rows[0][dsc.status_ipd].ToString();
dgs1.an_cnt = dt.Rows[0][dsc.an_cnt].ToString();
dgs1.folder_ftp = dt.Rows[0][dsc.an_cnt].ToString();
dgs1.status_record = dt.Rows[0][dsc.status_record].ToString();
}
else
{
setDocGroupScan(dgs1);
}
return(dgs1);
}
public String insert(DocScan p, String userId)
{
String re = "";
String sql = "";
//DataTable dt = new DataTable();
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
sql = "Insert Into " + dsc.table + " set " +
"" + dsc.doc_group_id + "= '" + p.doc_group_id + "'" +
"," + dsc.active + "= '" + p.active + "'" +
"," + 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_create + "= now()" +
"," + dsc.date_modi + "= ''" +
"," + dsc.date_cancel + "= ''" +
"," + dsc.user_create + "= '" + userId + "@" + conn._IPAddress + "'" +
"," + dsc.user_modi + "= ''" +
"," + dsc.user_cancel + "= ''" +
"," + 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 + "'" +
"," + dsc.status_record + " " + "= '" + p.status_record + "'" +
"";
try
{
// conn.comStore = new System.Data.SqlClient.SqlCommand();
// conn.comStore.Connection = conn.conn;
// conn.comStore.CommandText = "insert_doc_scan";
// conn.comStore.CommandType = CommandType.StoredProcedure;
// conn.comStore.Parameters.AddWithValue("doc_group_id", p.doc_group_id);
// conn.comStore.Parameters.AddWithValue("host_ftp", p.host_ftp);
// conn.comStore.Parameters.AddWithValue("hn", p.hn);
// conn.comStore.Parameters.AddWithValue("vn", p.vn);
// conn.comStore.Parameters.AddWithValue("remark", p.remark);
// conn.comStore.Parameters.AddWithValue("user_create", userId);
// conn.comStore.Parameters.AddWithValue("an", p.an);
// conn.comStore.Parameters.AddWithValue("doc_group_sub_id", p.doc_group_sub_id);
// conn.comStore.Parameters.AddWithValue("pre_no", p.pre_no);
// conn.comStore.Parameters.AddWithValue("an_date", p.an_date);
// conn.comStore.Parameters.AddWithValue("status_ipd", p.status_ipd);
// conn.comStore.Parameters.AddWithValue("ext", p.image_path);
// conn.comStore.Parameters.AddWithValue("visit_date", p.visit_date);
// SqlParameter retval = conn.comStore.Parameters.Add("row_no1", SqlDbType.VarChar, 50);
// retval.Value = "";
// retval.Direction = ParameterDirection.Output;
re = conn.ExecuteNonQuery(conn.conn, sql);
//conn.Open();
// conn.comStore.ExecuteNonQuery();
// re = (String)conn.comStore.Parameters["row_no1"].Value;
// //string retunvalue = (string)sqlcomm.Parameters["@b"].Value;
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
finally
{
conn.conn.Close();
//conn.comStore.Dispose();
}
return(re);
}
private void BtnUpload_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
//name = filename.Replace("*", "");
String dgssid = cboDgs.SelectedItem == null ? "" : ((ComboBoxItem)cboDgs.SelectedItem).Value;
if (dgssid.Length <= 0)
{
MessageBox.Show("ไม่ได้เลือก กลุ่มเอกสาร", "");
return;
}
picWait.Show();
string ext = Path.GetExtension(filename);
String dgssname = "", vn = "", an = "";
//dgssid = bc.bcDB.dgssDB.getIdDgss("Document Other");
DocGroupSubScan dgss = new DocGroupSubScan();
dgss = bc.bcDB.dgssDB.selectByPk(dgssid);
DocScan dsc = new DocScan();
//new LogWriter("d", "BtnUpload_Click dsc.vn " + dsc.vn + " dsc.an " + dsc.an);
dsc.active = "1";
dsc.doc_scan_id = "";
dsc.doc_group_id = cboDgs.SelectedItem == null ? "" : ((ComboBoxItem)cboDgs.SelectedItem).Value;
dsc.hn = txtHn.Text;
if (lbVn.Text.Trim().Equals("VN :"))
{
dsc.an = "";
dsc.vn = txtVn.Text.Trim();
}
else
{
dsc.vn = "";
dsc.an = txtVn.Text.Trim();
}
dsc.visit_date = "";
dsc.host_ftp = bc.iniC.hostFTP;
//dsc.image_path = txtHn.Text + "//" + txtHn.Text + "_" + dgssid + "_" + dsc.row_no + "." + ext[ext.Length - 1];
dsc.image_path = "";
dsc.doc_group_sub_id = dgssid;
dsc.pre_no = "";
dsc.an_date = "";
dsc.folder_ftp = bc.iniC.folderFTP;
dsc.status_ipd = "O";
dsc.row_no = "1";
dsc.row_cnt = "1";
dsc.status_ml = "2";
dsc.ml_fm = txtFM.Text.Trim();
String re = bc.bcDB.dscDB.insertScreenCapture(dsc, bc.userId);
sB11.Text = " filename " + filename + " bc.iniC.folderFTP " + bc.iniC.folderFTP + "//" + dsc.image_path;
long chk = 0;
if (long.TryParse(re, out chk))
{
//dsc.image_path = txtHn.Text.Replace("/", "-") + "//" + txtHn.Text.Replace("/", "-") + "-" + vn + "//" + txtHn.Text.Replace("/", "-") + "-" + vn + "-" + re + ext; //+1
dsc.image_path = txtHn.Text.Replace("/", "-") + "//" + txtHn.Text.Replace("/", "-") + "-" + re + ext;
String re1 = bc.bcDB.dscDB.updateImagepath(dsc.image_path, re);
//MessageBox.Show("filename" + filename + "\n bc.iniC.folderFTP " + bc.iniC.folderFTP + "//" + dsc.image_path, "");
//FtpClient ftp = new FtpClient(bc.iniC.hostFTP, bc.iniC.userFTP, bc.iniC.passFTP);
FtpClient ftp = new FtpClient(bc.iniC.hostFTP, bc.iniC.userFTP, bc.iniC.passFTP, bc.ftpUsePassive, bc.iniC.ProxyProxyType, bc.iniC.ProxyHost, bc.iniC.ProxyPort);
//MessageBox.Show("HN "+ txtHn.Text.Replace("/", "-"), "");
//ftp.createDirectory(txtHn.Text);
ftp.createDirectory(bc.iniC.folderFTP + "//" + txtHn.Text.Replace("/", "-"));
//MessageBox.Show("222", "");
ftp.delete(bc.iniC.folderFTP + "//" + dsc.image_path);
//MessageBox.Show("333", "");
ftp.upload(bc.iniC.folderFTP + "//" + dsc.image_path, filename);
File.Delete(filename);
System.Threading.Thread.Sleep(1000);
this.Dispose();
}
}
private void BtnDel_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
if (Directory.Exists(ic.iniC.pathImageScan))
{
if (MessageBox.Show("ต้องการ Upload ข้อมูล รูป scan ", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK)
{
//DirectoryInfo dir = new DirectoryInfo(ic.iniC.pathImageScan);
//foreach (FileInfo fi in dir.GetFiles())
//{
// fi.Delete();
//}
int i = 0;
String dgs = "", name = "";
Boolean chk = false;
txtVN.Hide();
btnVn.Hide();
//label3.Hide();
//txtAN.Hide();
//txtAnCnt.Hide();
//chkIPD.Hide();
label6.Hide();
txtVisitDate.Hide();
//txtAnDate.Hide();
//txtPreNo.Hide();
setVisible(false);
ProgressBar pB1 = new ProgressBar();
pB1.Location = new System.Drawing.Point(15, 15);
pB1.Name = "pB1";
pB1.Size = new System.Drawing.Size(862, 23);
//pB1.Left = txtVN.Left;
pB1.Show();
pB1.Value = 0;
pB1.Minimum = 0;
pB1.Maximum = array1.Count;
groupBox1.Controls.Add(pB1);
Application.DoEvents();
foreach (String aa in array1)
{
i++;
pB1.Value++;
String[] aaa = aa.Split(',');
if (aaa.Length == 3)
{
name = aaa[2].Replace("*", "");
string ext = Path.GetExtension(name);
String dgssname = "", dgssid = "", vn = "", an = "";
dgssid = ic.ivfDB.dgssDB.getIdDgss("Document Other");
DocGroupSubScan dgss = new DocGroupSubScan();
dgss = ic.ivfDB.dgssDB.selectByPk(dgssid);
DocScan dsc = new DocScan();
dsc.active = "1";
dsc.doc_scan_id = "";
dsc.doc_group_id = dgss.doc_group_id;
//dsc.hn = txtHn.Text; //-0021
//dsc.hn = txtHn.Text.Trim().Replace(ic.hnspareyear, "").Replace(txtPttYear.Text.Trim(), ""); //+0021
int index = txtHn.Text.IndexOf(ic.hnspareyear);
if (index >= 6)
{
dsc.hn = txtHn.Text.Substring(0, index);
}
dsc.vn = txtVN.Text;
dsc.an = "";
dsc.visit_date = ic.datetoDB(txtVisitDate.Text);
dsc.host_ftp = ic.iniC.hostFTP;
//dsc.image_path = txtHn.Text + "//" + txtHn.Text + "_" + dgssid + "_" + dsc.row_no + "." + ext[ext.Length - 1];
dsc.image_path = "";
dsc.doc_group_sub_id = dgssid;
dsc.pre_no = "";
dsc.an = "";
DateTime dt = new DateTime();
//dsc.an_date = (DateTime.TryParse(txtAnDate.Text, out dt)) ? ic.datetoDB(txtAnDate.Text) : "";
//if (dsc.an_date.Equals("1-01-01"))
//{
dsc.an_date = "";
//}
dsc.folder_ftp = ic.iniC.folderFTP;
dsc.status_ipd = "O";
String re = ic.ivfDB.dscDB.insertDocScan(dsc, ic.userId);
//dsc.image_path = txtHn.Text + "//" + txtHn.Text + "_" + re + ext;
//if (chkIPD.Checked)
//{
// vn = txtAN.Text.Replace("/", "_").Replace("(", "_").Replace(")", "");
//}
//else
//{
vn = txtVN.Text.Replace("/", "_").Replace("(", "_").Replace(")", "");
//}
dsc.image_path = txtHn.Text.Replace("-", "").Replace("/", "") + "_" + vn + "//" + txtHn.Text.Replace("-", "").Replace("/", "") + "_" + vn + "_" + re + ext;
String re1 = ic.ivfDB.dscDB.updateImagepath(dsc.image_path, re);
FtpClient ftp = new FtpClient(ic.iniC.hostFTP, ic.iniC.userFTP, ic.iniC.passFTP, ic.ftpUsePassive, ic.iniC.pathChar);
//MessageBox.Show("111", "");
//ftp.createDirectory(txtHn.Text);
ftp.createDirectory(ic.iniC.folderFTP + "//" + txtHn.Text.Replace("-", "").Replace("/", "") + "_" + vn);
//MessageBox.Show("222", "");
ftp.delete(ic.iniC.folderFTP + "//" + dsc.image_path);
//MessageBox.Show("333", "");
ftp.upload(ic.iniC.folderFTP + "//" + dsc.image_path, name);
//break;
//Application.DoEvents();
}
}
pB1.Dispose();
txtVN.Show();
btnVn.Show();
//label3.Show();
//txtAN.Show();
//txtAnCnt.Show();
//chkIPD.Show();
label6.Show();
delFile();
grf.Dispose();
initGrf();
setGrf();
setImage1(true);
setVisible(true);
MessageBox.Show("Upload รูป เวชระเบียน เรียบร้อย", "");
}
}
}
private void uploadFiletoServerRIA()
{
timer.Stop();
listBox2.Items.Clear(); //listBox3
Application.DoEvents();
Thread.Sleep(1000);
if (!Directory.Exists(bc.iniC.pathLabOutBackupRIAZipExtract))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupRIAZipExtract);
}
if (!Directory.Exists(bc.iniC.pathLabOutBackupRIA))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupRIA);
}
FtpClient ftp = new FtpClient(bc.iniC.hostFTP, bc.iniC.userFTP, bc.iniC.passFTP, bc.ftpUsePassive);
//String[] filePaths = Directory.GetFiles(bc.iniC.pathLabOutReceive, "*.*", SearchOption.TopDirectoryOnly);
List <String> filePaths = new List <String>();
DirectoryInfo dir = new DirectoryInfo(bc.iniC.pathLabOutReceiveRIA);
FileInfo[] Files = dir.GetFiles("*.zip"); //Getting Text files
foreach (FileInfo file in Files)
{
//Console.WriteLine("The number of files in {0} is {1}", diNext, diNext.GetFiles().Length);
string str = "";
filePaths.Add(file.FullName);
}
String dgssid = "";
dgssid = bc.bcDB.dgssDB.getIdDgss("Document Other");
DocGroupSubScan dgss = new DocGroupSubScan();
dgss = bc.bcDB.dgssDB.selectByPk(dgssid);
foreach (String zipFilename in filePaths)
{
listBox2.Items.Add("พบ file " + zipFilename);
Application.DoEvents();
int year2 = 0;
String yy = "", mm = "", dd = "", reqid = "", vn = "", datetick1 = "", pathbackup = "", year1 = "", ext = "", pathname = "", tmp = "", filename2 = "", hn = "", filenamePDF = "";
var fileStreamJson = new MemoryStream();
var fileStreamPDF = new MemoryStream();
//Json
datetick1 = DateTime.Now.Ticks.ToString();
pathbackup = bc.iniC.pathLabOutBackupRIA + "\\" + datetick1;
if (!Directory.Exists(pathbackup))
{
Directory.CreateDirectory(pathbackup);
}
//using (var zip = ZipFile.Read(filename))
//{
// foreach (var entry in zip)
// {
// ext = Path.GetExtension(entry.FileName);
// if (ext.ToLower().Equals(".json"))
// {
// entry.Extract(fileStreamJson);
// fileStreamJson.Seek(0, SeekOrigin.Begin);
// StreamReader reader = new StreamReader(fileStreamJson, System.Text.Encoding.UTF8, true);
// using (JsonTextReader readerJson = new JsonTextReader(reader))
// {
// //JObject o2 = (JObject)JToken.ReadFrom(readerJson);
// //RIA_Patient account = JsonConvert.DeserializeObject<RIA_Patient>(readerJson);
// string jsonData1 = @"{'idcard': '', 'hn': '', title:'', fname:'', lname:'', sex:'', dob:''}";
// JsonSerializer serializer = new JsonSerializer();
// var movie2 = serializer.Deserialize(readerJson);
// JObject o2 = (JObject)JToken.ReadFrom(readerJson);
// dynamic obj = o2["patient"];
// //dynamic obj = JsonConvert.DeserializeObject(movie2.ToString());
// //var jsonData = JObject.Parse(movie2.ToString());
// //RIA_Patient account = (RIA_Patient)jsonData[0]["hn"].ToString();
// //RIA_Patient rptt = new RIA_Patient();
// //rptt = (RIA_Patient)movie2[0];
// }
// }
// else if (ext.ToLower().Equals(".pdf"))
// {
// entry.Extract(fileStreamPDF);
// fileStreamPDF.Seek(0, SeekOrigin.Begin);
// }
// }
//}
RIA_Patient aaa = new RIA_Patient();
ZipFile zf = new ZipFile(zipFilename);
zf.ExtractAll(pathbackup);
DirectoryInfo dZip = new DirectoryInfo(pathbackup);
FileInfo[] filesZip = dZip.GetFiles("*.*");
foreach (FileInfo file in filesZip)
{
ext = Path.GetExtension(file.FullName);
if (ext.ToLower().Equals(".json"))
{
using (StreamReader file1 = File.OpenText(file.FullName))
using (JsonTextReader reader = new JsonTextReader(file1))
{
JObject o2 = (JObject)JToken.ReadFrom(reader);
dynamic objPtt = o2["patient"];
dynamic objOrd = o2["orderdetail"];
aaa.hn = objPtt.hn;
aaa.idcard = objPtt.idcard;
aaa.fname = objPtt.fname;
aaa.lname = objPtt.lname;
aaa.ref_no = objOrd.ref_no;
aaa.order_number = objOrd.order_number;
aaa.ln = objOrd.ln;
aaa.hn_customer = objOrd.hn_customer;
aaa.status = objOrd.status;
aaa.comment_order = objOrd.comment_order;
aaa.comment_patient = objOrd.comment_patient;
aaa.ward_customer = objOrd.ward_customer;
aaa.doctor = objOrd.doctor;
aaa.time_register = objOrd.time_register;
aaa.ward_customer = objOrd.ward_customer;
filename2 = aaa.ref_no;
//aaa = (RIA_Patient)o2["patient"];
//IList<JToken> results = o2["patient"]["fname"].Children().ToList();
}
}
else if (ext.ToLower().Equals(".pdf"))
{
filenamePDF = file.FullName;
}
}
filesZip = null;
if (filename2.Length <= 0)
{
MessageBox.Show("aaaaaa", "");
return;
}
dZip = null;
zf.Dispose();
reqid = filename2.Substring(filename2.Length - 3);
yy = filename2.Substring(filename2.Length - 5, 2);
mm = filename2.Substring(filename2.Length - 7, 2);
dd = filename2.Substring(filename2.Length - 9, 2);
year1 = "20" + yy;
DataTable dt = new DataTable();
dt = bc.bcDB.vsDB.SelectHnLabOut(reqid, year1 + "-" + mm + "-" + dd);
if (dt.Rows.Count <= 0)
{
listBox2.Items.Add("Filename ไม่พบข้อมูล HIS " + zipFilename);
Application.DoEvents();
String datetick = "";
new LogWriter("e", "Filename ไม่พบข้อมูล HIS");
//MessageBox.Show("Filename ไม่พบข้อมูล HIS", "");
datetick = DateTime.Now.Ticks.ToString();
if (!Directory.Exists(bc.iniC.pathLabOutBackupRIA))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupRIA);
}
if (pathname.Length > 0)
{
if (!Directory.Exists(bc.iniC.pathLabOutBackupRIA + "\\" + pathname))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupRIA + "\\" + pathname);
}
}
Thread.Sleep(200);
if (pathname.Length > 0)
{
File.Move(zipFilename, bc.iniC.pathLabOutBackupRIA + "\\" + pathname + "\\err_" + filename2 + "_" + datetick + ext);
}
else
{
File.Move(zipFilename, bc.iniC.pathLabOutBackupRIA + "\\err_" + filename2 + "_" + datetick + ext);
}
Thread.Sleep(1000);
continue;
}
listBox2.Items.Add("พบข้อมูล HIS " + dt.Rows[0]["mnc_hn_no"].ToString());
Application.DoEvents();
if (!dt.Rows[0]["mnc_hn_no"].ToString().Equals(aaa.hn_customer))
{
MessageBox.Show("aaaaaa", "");
}
DocScan dsc = new DocScan();
dsc.active = "1";
dsc.doc_scan_id = "";
dsc.doc_group_id = dgss.doc_group_id;
dsc.hn = dt.Rows[0]["mnc_hn_no"].ToString();
dsc.vn = dt.Rows[0]["MNC_VN_NO"].ToString() + "/" + dt.Rows[0]["MNC_VN_SEQ"].ToString() + "(" + dt.Rows[0]["MNC_VN_SUM"].ToString() + ")";
dsc.an = dt.Rows[0]["MNC_AN_NO"].ToString() + "/" + dt.Rows[0]["MNC_AN_YR"].ToString();
if (dsc.an.Equals("/"))
{
dsc.an = "";
}
dsc.visit_date = "";
dsc.host_ftp = bc.iniC.hostFTP;
//dsc.image_path = txtHn.Text + "//" + txtHn.Text + "_" + dgssid + "_" + dsc.row_no + "." + ext[ext.Length - 1];
dsc.image_path = "";
dsc.doc_group_sub_id = dgssid;
dsc.pre_no = dt.Rows[0]["mnc_pre_no"].ToString();
//dsc.an = "";
//DateTime dt = new DateTime();
// dsc.an_date = (DateTime.TryParse(txtAnDate.Text, out dt)) ? bc.datetoDB(txtAnDate.Text) : "";
// if (dsc.an_date.Equals("1-01-01"))
// {
// dsc.an_date = "";
// }
dsc.folder_ftp = bc.iniC.folderFTP;
// dsc.status_ipd = chkIPD.Checked ? "I" : "O";
dsc.row_no = "1";
dsc.row_cnt = "1";
dsc.status_version = "2";
dsc.req_id = dt.Rows[0]["mnc_req_no"].ToString();
DateTime dtt = new DateTime();
if (DateTime.TryParse(dt.Rows[0]["mnc_req_dat"].ToString(), out dtt))
{
dsc.date_req = dtt.Year.ToString() + "-" + dtt.ToString("MM-dd");
}
else
{
dsc.date_req = "";
}
if (dsc.an.Length > 0)
{
dsc.status_ipd = "1";
}
else
{
dsc.status_ipd = "0";
}
//dsc.ml_fm = "FM-LAB-999";
dsc.ml_fm = "FM-LAB-996"; //RIA
dsc.patient_fullname = dt.Rows[0]["mnc_patname"].ToString();
dsc.status_record = "2";
String re = bc.bcDB.dscDB.insertLabOut(dsc, bc.userId);
if (re.Length <= 0)
{
listBox2.Items.Add("ไม่ได้เลขที่ " + zipFilename);
Application.DoEvents();
String datetick = "";
new LogWriter("e", "ไม่ได้เลขที่ " + zipFilename);
//MessageBox.Show("Filename ไม่พบข้อมูล HIS", "");
datetick = DateTime.Now.Ticks.ToString();
Thread.Sleep(200);
if (pathname.Length > 0)
{
File.Move(zipFilename, pathbackup + "\\err_" + filename2 + "_" + datetick + ext);
}
else
{
File.Move(zipFilename, pathbackup + "\\err_" + filename2 + "_" + datetick + ext);
}
Thread.Sleep(1000);
continue;
}
listBox2.Items.Add("ได้เลขที่ " + re);
Application.DoEvents();
dsc.image_path = dt.Rows[0]["mnc_hn_no"].ToString() + "//" + dt.Rows[0]["mnc_hn_no"].ToString() + "_" + re + ext;
// if (chkIPD.Checked)
// {
// vn = txtAN.Text.Replace("/", "_").Replace("(", "_").Replace(")", "");
// }
// else
// {
vn = dsc.vn.Replace("/", "_").Replace("(", "_").Replace(")", "");
dsc.ml_fm = "FM-LAB-996"; //RIA
// }
// //dsc.image_path = txtHn.Text.Replace("/", "-") + "-" + vn + "//" + txtHn.Text.Replace("/", "-") + "-" + vn + "-" + re + ext; //-1
dsc.image_path = dt.Rows[0]["mnc_hn_no"].ToString().Replace("/", "-") + "//" + dt.Rows[0]["mnc_hn_no"].ToString().Replace("/", "-") + "-" + vn + "-" + re + ext; //+1
String re1 = bc.bcDB.dscDB.updateImagepath(dsc.image_path, re);
listBox2.Items.Add("updateImagepath " + dsc.image_path);
Application.DoEvents();
// //MessageBox.Show("111", "");
ftp.createDirectory(bc.iniC.folderFTP + "//" + dt.Rows[0]["mnc_hn_no"].ToString().Replace("/", "-")); // สร้าง Folder HN
// ftp.createDirectory(bc.iniC.folderFTP + "//" + txtHn.Text.Replace("/", "-") + "//" + txtHn.Text.Replace("/", "-") + "-" + vn);
// //MessageBox.Show("222", "");
Thread.Sleep(200);
ftp.delete(bc.iniC.folderFTP + "//" + dsc.image_path);
// //MessageBox.Show("333", "");
Thread.Sleep(200);
if (ftp.upload(bc.iniC.folderFTP + "//" + dsc.image_path, zipFilename))
{
Thread.Sleep(200);
if (ftp.upload(bc.iniC.folderFTP + "//" + dsc.image_path, filenamePDF))
{
listBox2.Items.Add("FTP upload success ");
Application.DoEvents();
Thread.Sleep(1000);
String datetick = "";
datetick = DateTime.Now.Ticks.ToString();
//if (!Directory.Exists(bc.iniC.pathLabOutBackupRIA))
//{
// Directory.CreateDirectory(bc.iniC.pathLabOutBackupRIA);
//}
//if (pathname.Length > 0)
//{
// if (!Directory.Exists(bc.iniC.pathLabOutBackupRIA + "\\" + pathname))
// {
// Directory.CreateDirectory(bc.iniC.pathLabOutBackupRIA + "\\" + pathname);
// }
//}
Thread.Sleep(1000);
if (File.Exists(zipFilename))
{
//dZip.MoveTo("");
try
{
File.Move(zipFilename, pathbackup + "\\" + filename2 + "_" + datetick + ".zip");
}
catch (Exception ex)
{
String aaaa = "";
}
}
}
//else
//{
// File.Move(zipFilename, pathbackup + "\\" + filename2 + "_" + datetick + ".zip");
//}
listBox1.BeginUpdate(); //listBox2
listBox1.Items.Add(zipFilename + " -> " + bc.iniC.hostFTP + "//" + bc.iniC.folderFTP + "//" + dsc.image_path); //listBox2
listBox1.EndUpdate(); //listBox2
Application.DoEvents();
Thread.Sleep(1000 * 60);
}
else
{
listBox2.Items.Add("FTP upload success ");
Application.DoEvents();
new LogWriter("e", "FTP upload no success");
}
}
timer.Start();
}
private void ContextMenu_upload(object sender, System.EventArgs e)
{
String dgs = "", filename = "", id = "";
filename = searchInArray();
if (txtHn.Text.Equals(""))
{
MessageBox.Show("กรุณาป้อน HN", "");
return;
}
try
{
filename = filename.Substring(filename.IndexOf('*') + 1);
//String[] ext = filename.Split('.');
string ext = Path.GetExtension(filename);
String dgssname = "", dgssid = "";
dgssname = ((MenuItem)sender).Text;
dgssid = ic.ivfDB.dgssDB.getIdDgss(dgssname);
DocGroupSubScan dgss = new DocGroupSubScan();
dgss = ic.ivfDB.dgssDB.selectByPk(dgssid);
if (!dgss.doc_group_sub_id.Equals(""))
{
//dgs = cboDgs.SelectedItem == null ? "" : ((ComboBoxItem)cboDgs.SelectedItem).Value;
int row = 0, col = 0;
row = grf.Row;
col = grf.Col;
DocScan dsc = new DocScan();
dsc.active = "1";
dsc.doc_scan_id = "";
dsc.doc_group_id = dgss.doc_group_id;
dsc.hn = txtHn.Text;
dsc.vn = txtVN.Text;
dsc.an = "";
dsc.visit_date = ic.datetoDB(txtVisitDate.Text);
//if (!txtVN.Text.Equals(""))
//{
// dsc.row_no = bc.ivfDB.dscDB.selectRowNoByHnVn(txtHn.Text, txtVN.Text, dgs);
//}
//else
//{
// dsc.row_no = bc.ivfDB.dscDB.selectRowNoByHn(txtHn.Text, dgs);
//}
dsc.host_ftp = ic.iniC.hostFTP;
//dsc.image_path = txtHn.Text + "//" + txtHn.Text + "_" + dgssid + "_" + dsc.row_no + "." + ext[ext.Length - 1];
dsc.image_path = "";
dsc.doc_group_sub_id = dgssid;
dsc.pre_no = "";
dsc.an = "";
DateTime dt = new DateTime();
dsc.an_date = "";
//if (dsc.an_date.Equals("1-01-01"))
//{
// dsc.an_date = "";
//}
dsc.status_ipd = "O";
dsc.folder_ftp = ic.iniC.folderFTP;
String re = ic.ivfDB.dscDB.insertDocScan(dsc, ic.userId);
dsc.image_path = txtVN.Text + "//" + txtHn.Text.Replace("/", "-") + "_" + txtVN.Text + "_" + re + ext;
String re1 = ic.ivfDB.dscDB.updateImagepath(dsc.image_path, re);
FtpClient ftp = new FtpClient(ic.iniC.hostFTP, ic.iniC.userFTP, ic.iniC.passFTP, ic.ftpUsePassive, ic.iniC.pathChar);
//MessageBox.Show("111", "");
ftp.createDirectory(ic.iniC.folderFTP + "//" + txtVN.Text);
//MessageBox.Show("222", "");
ftp.delete(dsc.image_path);
//MessageBox.Show("333", "");
ftp.upload(ic.iniC.folderFTP + "//" + dsc.image_path, filename);
Boolean findTrue = false;
foreach (Control con in this.Controls)
{
if (findTrue)
{
break;
}
if (con is Panel)
{
foreach (Control conp in con.Controls)
{
if (findTrue)
{
break;
}
if (conp is C1DockingTab)
{
foreach (Control cond in conp.Controls)
{
if (findTrue)
{
break;
}
if (cond is C1DockingTabPage)
{
foreach (Control cong in cond.Controls)
{
if (findTrue)
{
break;
}
if (cong is C1DockingTab)
{
foreach (Control congd in cong.Controls)
{
if (findTrue)
{
break;
}
if (congd is C1DockingTabPage)
{
foreach (Control congd1 in congd.Controls)
{
if (findTrue)
{
break;
}
if (congd1 is C1FlexGrid)
{
if (congd1.Name.Equals(dsc.doc_group_sub_id))
{
String aa = "";
C1FlexGrid grf1;
grf1 = (C1FlexGrid)congd1;
Row rowg = grf1.Rows.Add();
Image loadedImage, resizedImage;
loadedImage = Image.FromFile(filename);
int originalWidth = 0;
originalWidth = loadedImage.Width;
int newWidth = 280;
resizedImage = loadedImage.GetThumbnailImage(newWidth, (newWidth * loadedImage.Height) / originalWidth, null, IntPtr.Zero);
//
rowg[colPic1] = resizedImage;
rowg[colPic2] = filename;
//grf[grf.Row, grf.Col] = dsc.doc_group_sub_id;
grf1.AutoSizeRows();
Application.DoEvents();
addInArrayImg(filename, dsc.doc_group_sub_id);
grf.SetData(grf.Row, grf.Col, dgssname);
grf.AutoSizeRows(grf.Row, grf.Col, grf.Row, grf.Col, 20, AutoSizeFlags.SameSize);
findTrue = true;
break;
}
}
}
}
}
}
}
}
}
}
}
}
}
//grf.AutoSizeRows();
//grf.AutoSizeCols();
//CellRange cr = grf.GetCellRange(grf.Row, grf.Col);
CellStyle cs = grf.Styles.Add("CellNeWStyle");
cs.BackColor = Color.Green;
cs.Border.Color = Color.FromArgb(196, 228, 223);
cs.Border.Color = Color.Black;
//cr.Style = cs;
grf.SetCellStyle(grf.Row, grf.Col, cs);
grf.Styles.Normal.ImageAlign = C1.Win.C1FlexGrid.ImageAlignEnum.CenterTop;
grf.Styles.Normal.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterBottom;
grf.SetData(grf.Row, grf.Col, dgssname);
}
}
catch (Exception ex)
{
}
}
private void RbnSave_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
bc.cStf.staff_id = "";
FrmPasswordConfirm frm = new FrmPasswordConfirm(bc);
frm.ShowDialog(this);
if (!bc.cStf.staff_id.Equals(""))
{
String filename = "", ext = "";
if (!Directory.Exists("medical"))
{
Directory.CreateDirectory("medical");
}
filename = "medical\\" + hn + "_" + bc.vsdate + "_" + bc.preno + "_" + status + ".rtf";
SaveDocumentMedicalExamination(filename);
Application.DoEvents();
Thread.Sleep(200);
if (File.Exists(filename))
{
ext = Path.GetExtension(filename);
FtpClient ftp = new FtpClient(bc.iniC.hostFTP, bc.iniC.userFTP, bc.iniC.passFTP, bc.ftpUsePassive);
DocScan dsc = new DocScan();
dsc.active = "1";
dsc.doc_scan_id = "";
dsc.doc_group_id = "";
dsc.hn = bc.hn;
//dsc.vn = dt.Rows[0]["MNC_VN_NO"].ToString() + "/" + dt.Rows[0]["MNC_VN_SEQ"].ToString() + "(" + dt.Rows[0]["MNC_VN_SUM"].ToString() + ")";
dsc.an = "";
dsc.visit_date = bc.vsdate;
dsc.host_ftp = bc.iniC.hostFTP;
//dsc.image_path = txtHn.Text + "//" + txtHn.Text + "_" + dgssid + "_" + dsc.row_no + "." + ext[ext.Length - 1];
dsc.image_path = "";
dsc.doc_group_sub_id = "";
dsc.pre_no = bc.preno;
dsc.folder_ftp = bc.iniC.folderFTP;
// dsc.status_ipd = chkIPD.Checked ? "I" : "O";
dsc.row_no = "1";
dsc.row_cnt = "1";
dsc.status_version = "2";
dsc.req_id = "";
dsc.date_req = "";
dsc.status_ipd = "0";
//dsc.ml_fm = "FM-LAB-999";
if (status.Equals("cc"))
{
dsc.ml_fm = "FM-MED-900"; //
}
else if (status.Equals("me"))
{
dsc.ml_fm = "FM-MED-901"; //
}
else if (status.Equals("diag"))
{
dsc.ml_fm = "FM-MED-902"; //
}
bc.bcDB.dscDB.voidDocScanByStatusMedicalExamination(hn, dsc.ml_fm, bc.vsdate, bc.preno, bc.cStf.staff_id);
dsc.patient_fullname = ptt.Name;
dsc.status_record = "5"; // status medical diagnose
dsc.comp_labout_id = "";
String re = bc.bcDB.dscDB.insertMedicalExamination(dsc, bc.userId);
dsc.image_path = hn + "//" + status + "_" + bc.hn + "_" + bc.vsdate + "_" + bc.preno + "_" + re + ext;
String re1 = bc.bcDB.dscDB.updateImagepath(dsc.image_path, re);
ftp.createDirectory(bc.iniC.folderFTP + "//" + hn.Replace("/", "-")); // สร้าง Folder HN
ftp.delete(bc.iniC.folderFTP + "//" + dsc.image_path);
Thread.Sleep(200);
if (ftp.upload(bc.iniC.folderFTP + "//" + dsc.image_path, filename))
{
}
}
}
}
private void GrfHn_DoubleClick(object sender, EventArgs e)
{
//throw new NotImplementedException();
String dscid = "";
if (grfHn.Row <= 0)
{
return;
}
if (grfHn.Col <= 0)
{
return;
}
dscid = grfHn[grfHn.Row, colId].ToString();
DocScan dsc = new DocScan();
dsc = bc.bcDB.dscDB.selectByPk(dscid);
if (!dsc.doc_scan_id.Equals(""))
{
if (!Directory.Exists("report"))
{
Directory.CreateDirectory("report");
}
MemoryStream stream;
int bufferSize = 2048;
Stream ftpStream = null;
String dgssid = "", filename = "", ftphost = "", id = "", folderftp = "", datetick = "";
datetick = DateTime.Now.Ticks.ToString();
stream = new MemoryStream();
FtpWebRequest ftpRequest = null;
FtpWebResponse ftpResponse = null;
FtpClient ftpc = new FtpClient(dsc.host_ftp, bc.iniC.userFTP, bc.iniC.passFTP, bc.ftpUsePassive);
stream = ftpc.download(dsc.folder_ftp + "/" + dsc.image_path);
if (stream == null)
{
return;
}
if (stream.Length == 0)
{
return;
}
stream.Seek(0, SeekOrigin.Begin);
var fileStream = new FileStream("report\\" + datetick + ".pdf", FileMode.Create, FileAccess.Write);
stream.CopyTo(fileStream);
fileStream.Flush();
fileStream.Dispose();
Application.DoEvents();
Thread.Sleep(200);
Form frm = new Form();
frm.Size = new Size(600, 800);
frm.StartPosition = FormStartPosition.CenterScreen;
Panel pn = new Panel();
pn.Dock = DockStyle.Fill;
frm.Controls.Add(pn);
string currentDirectory = Directory.GetCurrentDirectory();
WebBrowser webb = new WebBrowser();
webb.Dock = DockStyle.Fill;
webb.Name = "webBrowser1";
pn.Controls.Add(webb);
webb.Navigate(currentDirectory + "\\report\\" + datetick + ".pdf");
frm.ShowDialog(this);
}
}
private void uploadFiletoServerInnoTech()
{
timer.Stop();
listBox2.Items.Clear(); //listBox3
Application.DoEvents();
Thread.Sleep(1000);
FtpClient ftp = new FtpClient(bc.iniC.hostFTP, bc.iniC.userFTP, bc.iniC.passFTP, bc.ftpUsePassive);
//String[] filePaths = Directory.GetFiles(bc.iniC.pathLabOutReceive, "*.*", SearchOption.TopDirectoryOnly);
List <String> filePaths = new List <String>();
DirectoryInfo d = new DirectoryInfo(bc.iniC.pathLabOutReceiveInnoTech);//Assuming Test is your Folder
DirectoryInfo[] dirs = d.GetDirectories();
foreach (DirectoryInfo diNext in dirs)
{
Console.WriteLine("The number of files in {0} is {1}", diNext, diNext.GetFiles().Length);
FileInfo[] Files = diNext.GetFiles("*.*"); //Getting Text files
string str = "";
foreach (FileInfo file in Files)
{
filePaths.Add(file.FullName);
}
}
String dgssid = "";
dgssid = bc.bcDB.dgssDB.getIdDgss("Document Other");
DocGroupSubScan dgss = new DocGroupSubScan();
dgss = bc.bcDB.dgssDB.selectByPk(dgssid);
foreach (String filename in filePaths)
{
listBox2.Items.Add("พบ file " + filename);
Application.DoEvents();
int year2 = 0;
String yy = "", mm = "", dd = "", reqid = "", vn = "", filename1 = "", filename2 = "", year1 = "", ext = "";
String pathname = "", tmp = "";
tmp = bc.iniC.pathLabOutReceiveInnoTech.Replace("\\\\", "\\");
filename1 = Path.GetFileName(filename);
pathname = filename.Replace(filename1, "").Replace(tmp, "").Replace("\\", "");
pathname = pathname.Replace("\\", "");
String[] txt = filename1.Split('_');
if (txt.Length > 1)
{
filename2 = txt[0];
}
else
{
filename2 = filename1.Replace(".pdf", "");
}
ext = Path.GetExtension(filename1);
if (filename2.Replace(".pdf", "").Length < 10)
{
String datetick = "";
new LogWriter("e", "Filename ไม่ถูก FORMAT");
listBox2.Items.Add("Filename ไม่ถูก FORMAT " + filename);
//MessageBox.Show("Filename ไม่ถูก FORMAT", "");
datetick = DateTime.Now.Ticks.ToString();
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech);
}
if (pathname.Length > 0)
{
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname);
}
}
Thread.Sleep(200);
if (pathname.Length > 0)
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname + "\\err_" + filename2 + "_" + datetick + ext);
}
else
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\err_" + filename2 + "_" + datetick + ext);
}
Thread.Sleep(1000);
continue;
}
if (filename2.Length <= 10)
{
String datetick = "";
new LogWriter("e", "Filename ชื่อ File สั้นไป " + filename);
listBox2.Items.Add("Filename ชื่อ File สั้นไป " + filename);
//MessageBox.Show("Filename ไม่ถูก FORMAT", "");
datetick = DateTime.Now.Ticks.ToString();
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech);
}
if (pathname.Length > 0)
{
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname);
}
}
Thread.Sleep(200);
if (pathname.Length > 0)
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname + "\\err_" + filename2 + "_" + datetick + ext);
}
else
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\err_" + filename2 + "_" + datetick + ext);
}
Thread.Sleep(1000);
continue;
}
DateTime dtt1 = new DateTime();
int.TryParse(year1, out year2);
yy = filename2.Substring(filename2.Length - 5, 2);
mm = filename2.Substring(filename2.Length - 7, 2);
dd = filename2.Substring(filename2.Length - 9, 2);
year1 = "20" + yy;
if (!DateTime.TryParse(year1 + "-" + mm + "-" + dd, out dtt1))
{
String datetick = "";
new LogWriter("e", "Filename ชื่อ File ไม่สามารถหา date ได้ " + filename);
listBox2.Items.Add("Filename ชื่อ File ไม่สามารถหา date ได้ " + filename);
//MessageBox.Show("Filename ไม่ถูก FORMAT", "");
datetick = DateTime.Now.Ticks.ToString();
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech);
}
if (pathname.Length > 0)
{
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname);
}
}
Thread.Sleep(200);
if (pathname.Length > 0)
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname + "\\err_" + filename2 + "_" + datetick + ext);
}
else
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\err_" + filename2 + "_" + datetick + ext);
}
Thread.Sleep(1000);
continue;
}
reqid = filename2.Substring(filename2.Length - 3);
DataTable dt = new DataTable();
dt = bc.bcDB.vsDB.SelectHnLabOut(reqid, year1 + "-" + mm + "-" + dd);
if (dt.Rows.Count <= 0)
{
listBox2.Items.Add("Filename ไม่พบข้อมูล HIS " + filename);
Application.DoEvents();
String datetick = "";
new LogWriter("e", "Filename ไม่พบข้อมูล HIS");
//MessageBox.Show("Filename ไม่พบข้อมูล HIS", "");
datetick = DateTime.Now.Ticks.ToString();
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech);
}
if (pathname.Length > 0)
{
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname);
}
}
Thread.Sleep(200);
if (pathname.Length > 0)
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname + "\\err_" + filename2 + "_" + datetick + ext);
}
else
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\err_" + filename2 + "_" + datetick + ext);
}
Thread.Sleep(1000);
continue;
}
listBox2.Items.Add("พบข้อมูล HIS " + dt.Rows[0]["mnc_hn_no"].ToString());
Application.DoEvents();
DocScan dsc = new DocScan();
dsc.active = "1";
dsc.doc_scan_id = "";
dsc.doc_group_id = dgss.doc_group_id;
dsc.hn = dt.Rows[0]["mnc_hn_no"].ToString();
dsc.vn = dt.Rows[0]["MNC_VN_NO"].ToString() + "/" + dt.Rows[0]["MNC_VN_SEQ"].ToString() + "(" + dt.Rows[0]["MNC_VN_SUM"].ToString() + ")";
dsc.an = dt.Rows[0]["MNC_AN_NO"].ToString() + "/" + dt.Rows[0]["MNC_AN_YR"].ToString();
if (dsc.an.Equals("/"))
{
dsc.an = "";
}
dsc.visit_date = "";
dsc.host_ftp = bc.iniC.hostFTP;
//dsc.image_path = txtHn.Text + "//" + txtHn.Text + "_" + dgssid + "_" + dsc.row_no + "." + ext[ext.Length - 1];
dsc.image_path = "";
dsc.doc_group_sub_id = dgssid;
dsc.pre_no = dt.Rows[0]["mnc_pre_no"].ToString();
//dsc.an = "";
//DateTime dt = new DateTime();
// dsc.an_date = (DateTime.TryParse(txtAnDate.Text, out dt)) ? bc.datetoDB(txtAnDate.Text) : "";
// if (dsc.an_date.Equals("1-01-01"))
// {
// dsc.an_date = "";
// }
dsc.folder_ftp = bc.iniC.folderFTP;
// dsc.status_ipd = chkIPD.Checked ? "I" : "O";
dsc.row_no = "1";
dsc.row_cnt = "1";
dsc.status_version = "2";
dsc.req_id = dt.Rows[0]["mnc_req_no"].ToString();
DateTime dtt = new DateTime();
if (DateTime.TryParse(dt.Rows[0]["mnc_req_dat"].ToString(), out dtt))
{
dsc.date_req = dtt.Year.ToString() + "-" + dtt.ToString("MM-dd");
}
else
{
dsc.date_req = "";
}
if (dsc.an.Length > 0)
{
dsc.status_ipd = "1";
}
else
{
dsc.status_ipd = "0";
}
//dsc.ml_fm = "FM-LAB-999";
if (pathname.Equals("ClinicalReport"))
{
dsc.ml_fm = "FM-LAB-998";
}
else
{
dsc.ml_fm = "FM-LAB-997"; //PathoReport
}
dsc.patient_fullname = dt.Rows[0]["mnc_patname"].ToString();
dsc.status_record = "2";
String re = bc.bcDB.dscDB.insertLabOut(dsc, bc.userId);
if (re.Length <= 0)
{
listBox2.Items.Add("ไม่ได้เลขที่ " + filename);
Application.DoEvents();
String datetick = "";
new LogWriter("e", "ไม่ได้เลขที่ " + filename);
//MessageBox.Show("Filename ไม่พบข้อมูล HIS", "");
datetick = DateTime.Now.Ticks.ToString();
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech);
}
if (pathname.Length > 0)
{
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname);
}
}
Thread.Sleep(200);
if (pathname.Length > 0)
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname + "\\err_" + filename2 + "_" + datetick + ext);
}
else
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\err_" + filename2 + "_" + datetick + ext);
}
Thread.Sleep(1000);
continue;
}
listBox2.Items.Add("ได้เลขที่ " + re);
Application.DoEvents();
dsc.image_path = dt.Rows[0]["mnc_hn_no"].ToString() + "//" + dt.Rows[0]["mnc_hn_no"].ToString() + "_" + re + ext;
// if (chkIPD.Checked)
// {
// vn = txtAN.Text.Replace("/", "_").Replace("(", "_").Replace(")", "");
// }
// else
// {
vn = dsc.vn.Replace("/", "_").Replace("(", "_").Replace(")", "");
if (pathname.Equals("ClinicalReport"))
{
dsc.ml_fm = "FM-LAB-998";
}
else
{
dsc.ml_fm = "FM-LAB-997"; //PathoReport
}
// }
// //dsc.image_path = txtHn.Text.Replace("/", "-") + "-" + vn + "//" + txtHn.Text.Replace("/", "-") + "-" + vn + "-" + re + ext; //-1
dsc.image_path = dt.Rows[0]["mnc_hn_no"].ToString().Replace("/", "-") + "//" + dt.Rows[0]["mnc_hn_no"].ToString().Replace("/", "-") + "-" + vn + "-" + re + ext; //+1
String re1 = bc.bcDB.dscDB.updateImagepath(dsc.image_path, re);
listBox2.Items.Add("updateImagepath " + dsc.image_path);
Application.DoEvents();
// //MessageBox.Show("111", "");
ftp.createDirectory(bc.iniC.folderFTP + "//" + dt.Rows[0]["mnc_hn_no"].ToString().Replace("/", "-")); // สร้าง Folder HN
// ftp.createDirectory(bc.iniC.folderFTP + "//" + txtHn.Text.Replace("/", "-") + "//" + txtHn.Text.Replace("/", "-") + "-" + vn);
// //MessageBox.Show("222", "");
ftp.delete(bc.iniC.folderFTP + "//" + dsc.image_path);
// //MessageBox.Show("333", "");
Thread.Sleep(200);
if (ftp.upload(bc.iniC.folderFTP + "//" + dsc.image_path, filename))
{
listBox2.Items.Add("FTP upload success ");
Application.DoEvents();
Thread.Sleep(1000);
String datetick = "";
datetick = DateTime.Now.Ticks.ToString();
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech);
}
if (pathname.Length > 0)
{
if (!Directory.Exists(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname))
{
Directory.CreateDirectory(bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname);
}
}
Thread.Sleep(1000);
if (pathname.Length > 0)
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\" + pathname + "\\" + filename2 + "_" + datetick + ext);
}
else
{
File.Move(filename, bc.iniC.pathLabOutBackupInnoTech + "\\" + filename2 + "_" + datetick + ext);
}
listBox1.BeginUpdate(); //listBox2
listBox1.Items.Add(filename + " -> " + bc.iniC.hostFTP + "//" + bc.iniC.folderFTP + "//" + dsc.image_path); //listBox2
listBox1.EndUpdate(); //listBox2
Application.DoEvents();
Thread.Sleep(1000 * 60);
}
else
{
listBox2.Items.Add("FTP upload success ");
Application.DoEvents();
new LogWriter("e", "FTP upload no success");
}
}
timer.Start();
}
