private void saveFMCode()
{
DocGroupFM fm = new DocGroupFM();
DocGroupFM tmp = new DocGroupFM();
tmp = bc.bcDB.dfmDB.selectByFMCode(txtMlFmCodeNew.Text.Trim());
if (tmp.fm_id.Length <= 0)
{
fm.fm_id = "";
}
else
{
fm.fm_id = tmp.fm_id;
}
fm.fm_code = txtMlFmCodeNew.Text.Trim();
fm.fm_name = "";
fm.remark = "";
fm.status_doc_adminsion = "0";
fm.status_doc_medical = "0";
fm.status_doc_nurse = "0";
fm.status_doc_office = "0";
fm.doc_group_sub_id = "";
fm.doc_group_id = "";
fm.active = "";
bc.bcDB.dfmDB.insertDocGroupFMCode(fm, "");
}
public String updateCode(DocGroupFM p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
chkNull(p);
sql = "Update " + dfm.table + " Set " +
" " + dfm.fm_code + " = '" + p.fm_code.Replace("'", "''") + "'" +
//", " + dfm.fm_name + " = '" + p.fm_name.Replace("'", "''") + "'" +
//", " + dfm.doc_group_sub_id + " = '" + p.doc_group_sub_id + "'" +
//", " + dfm.status_doc_adminsion + " = '" + p.status_doc_adminsion + "'" +
//", " + dfm.status_doc_medical + " = '" + p.status_doc_medical + "'" +
//", " + dfm.status_doc_nurse + " = '" + p.status_doc_nurse + "'" +
//", " + dfm.status_doc_office + " = '" + p.status_doc_office + "'" +
"Where " + dfm.pkField + "='" + p.fm_id + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void initConfig()
{
pageLoad = true;
dgss = new DocGroupSubScan();
dfm = new DocGroupFM();
fEdit = new Font(bc.iniC.grdViewFontName, bc.grdViewFontSize, FontStyle.Regular);
fEditB = new Font(bc.iniC.grdViewFontName, bc.grdViewFontSize, FontStyle.Bold);
C1ThemeController.ApplicationTheme = bc.iniC.themeApplication;
theme1.Theme = C1ThemeController.ApplicationTheme;
theme1.SetTheme(sB, "BeigeOne");
bg = txtFmCode.BackColor;
fc = txtFmCode.ForeColor;
ff = txtFmCode.Font;
bc.bcDB.dgssDB.setCboDGSS(cboDocGroupSubName, "");
bc.bcDB.dgsDB.setCboDgs(cboDocGroupName, "");
sB.Text = "";
btnVoid.Hide();
txtPasswordVoid.Hide();
stt = new C1SuperTooltip();
sep = new C1SuperErrorProvider();
btnNew.Click += BtnNew_Click;
btnEdit.Click += BtnEdit_Click;
btnSave.Click += BtnSave_Click;
txtPasswordVoid.KeyUp += TxtPasswordVoid_KeyUp;
cboDocGroupName.SelectedIndexChanged += CboDocGroupName_SelectedIndexChanged;
initGrfFMCode();
setGrfFMCode();
setControlEnable(false);
setFocusColor();
pageLoad = false;
}
public String insert(DocGroupFM p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
sql = "Insert Into " + dfm.table + " (" + dfm.fm_code + "," + dfm.active + "," + dfm.fm_name + "," + dfm.doc_group_sub_id + "" +
"," + dfm.status_doc_adminsion + "," + dfm.status_doc_medical + "," + dfm.status_doc_nurse + "," + dfm.status_doc_office + "" +
") " +
"Values ('" + p.fm_code.Replace("'", "''") + "','1','" + p.fm_name.Replace("'", "''") + "','" + p.doc_group_sub_id + "' " +
",'" + p.status_doc_adminsion + "','" + p.status_doc_medical + "','" + p.status_doc_nurse + "','" + p.status_doc_office + "' " +
")";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void setControl(String posiId)
{
dfm = bc.bcDB.dfmDB.selectByPk(posiId);
bc.setC1Combo(cboDocGroupName, dfm.doc_group_id);
bc.setC1Combo(cboDocGroupSubName, dfm.doc_group_sub_id);
txtID.Value = dfm.fm_id;
txtFmCode.Value = dfm.fm_code;
txtFmName.Value = dfm.fm_name;
chkStatusDocMedical.Checked = dfm.status_doc_medical.Equals("1") ? true : false;
ChkStatusDocNurse.Checked = dfm.status_doc_nurse.Equals("1") ? true : false;
ChkStatusDocAdmision.Checked = dfm.status_doc_adminsion.Equals("1") ? true : false;
chkStatusDocOffice.Checked = dfm.status_doc_office.Equals("1") ? true : false;
}
public DocGroupFM setDocGroupFM(DocGroupFM dgs1)
{
dgs1.active = "";
dgs1.remark = "";
dgs1.fm_id = "";
dgs1.doc_group_sub_id = "";
dgs1.fm_code = "";
dgs1.fm_name = "";
dgs1.status_doc_adminsion = "";
dgs1.status_doc_medical = "";
dgs1.status_doc_nurse = "";
dgs1.status_doc_office = "";
return(dgs1);
}
public DataTable selectByPk1(String id)
{
DocGroupFM cop1 = new DocGroupFM();
DataTable dt = new DataTable();
String sql = "select dfm.*, dgss.doc_group_id " +
"From " + dfm.table + " dfm " +
"Left Join doc_group_sub_scan dgss On dfm.doc_group_sub_id = dgss.doc_group_sub_id " +
"Where dfm." + dfm.pkField + " ='" + id + "' " +
"Order By dfm.fm_id ";
dt = conn.selectData(conn.conn, sql);
return(dt);
}
public String insertDocGroupFMCode(DocGroupFM p, String userId)
{
String re = "";
if (p.fm_id.Equals(""))
{
re = insert(p, "");
}
else
{
re = updateCode(p, "");
}
return(re);
}
private void initConfig()
{
dfm = new DocGroupFM();
dfm.active = "active";
dfm.fm_code = "fm_code";
dfm.fm_id = "fm_id";
dfm.fm_name = "fm_name";
dfm.doc_group_sub_id = "doc_group_sub_id";
dfm.doc_group_id = "doc_group_id";
dfm.status_doc_adminsion = "status_doc_adminsion";
dfm.status_doc_medical = "status_doc_medical";
dfm.status_doc_nurse = "status_doc_nurse";
dfm.status_doc_office = "status_doc_office";
dfm.table = "doc_group_fm";
dfm.pkField = "fm_id";
}
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);
}
}
private void TxtFmCode_KeyUp(object sender, KeyEventArgs e)
{
//throw new NotImplementedException();
if (e.KeyCode == Keys.Enter)
{
pageLoad = false;
DocGroupFM dfm = new DocGroupFM();
dfm = bc.bcDB.dfmDB.selectByFMCode(txtFmCode.Text.Trim());
if ((dfm.doc_group_id != null) && (dfm.doc_group_id.Length > 0))
{
bc.setC1Combo(cboDgs, dfm.doc_group_id);
bc.bcDB.dgssDB.setCboDGSS(cboDgs, dfm.doc_group_id, "");
bc.setC1Combo(cboDgss, dfm.doc_group_sub_id);
btnSaveFmCode.Show();
}
pageLoad = true;
}
else
{
btnSaveFmCode.Hide();
}
}
private void chkNull(DocGroupFM p)
{
long chk = 0;
int chk1 = 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.fm_code = p.fm_code == null ? "" : p.fm_code;
p.fm_name = p.fm_name == null ? "" : p.fm_name;
p.active = p.active == null ? "" : p.active;
p.status_doc_adminsion = p.status_doc_adminsion == null ? "" : p.status_doc_adminsion;
p.status_doc_medical = p.status_doc_medical == null ? "" : p.status_doc_medical;
p.status_doc_nurse = p.status_doc_nurse == null ? "" : p.status_doc_nurse;
p.status_doc_office = p.status_doc_office == null ? "0" : p.status_doc_office;
p.doc_group_sub_id = long.TryParse(p.doc_group_sub_id, out chk) ? chk.ToString() : "0";
//p.pre_no = long.TryParse(p.pre_no, out chk) ? chk.ToString() : "0";
}
public DocGroupFM setDocFM(DataTable dt)
{
DocGroupFM dfm = new DocGroupFM();
if (dt.Rows.Count > 0)
{
dfm.fm_id = dt.Rows[0][this.dfm.fm_id].ToString();
dfm.doc_group_sub_id = dt.Rows[0][this.dfm.doc_group_sub_id].ToString();
dfm.fm_code = dt.Rows[0][this.dfm.fm_code].ToString();
dfm.fm_name = dt.Rows[0][this.dfm.fm_name].ToString();
dfm.active = dt.Rows[0][this.dfm.active].ToString();
dfm.doc_group_id = dt.Rows[0][this.dfm.doc_group_id].ToString();
dfm.status_doc_adminsion = dt.Rows[0][this.dfm.status_doc_adminsion].ToString();
dfm.status_doc_medical = dt.Rows[0][this.dfm.status_doc_medical].ToString();
dfm.status_doc_nurse = dt.Rows[0][this.dfm.status_doc_nurse].ToString();
dfm.status_doc_office = dt.Rows[0][this.dfm.status_doc_office].ToString();
}
else
{
setDocGroupFM(dfm);
}
return(dfm);
}
public void getlBsp()
{
//lDept = new List<Position>();
lDgss.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
DocGroupFM itm1 = new DocGroupFM();
itm1.fm_id = row[dfm.fm_id].ToString();
itm1.doc_group_sub_id = row[dfm.doc_group_sub_id].ToString();
itm1.fm_code = row[dfm.fm_code].ToString();
itm1.fm_name = row[dfm.fm_name].ToString();
itm1.active = row[dfm.active].ToString();
itm1.status_doc_adminsion = row[dfm.status_doc_adminsion].ToString();
itm1.status_doc_medical = row[dfm.status_doc_medical].ToString();
itm1.status_doc_nurse = row[dfm.status_doc_nurse].ToString();
itm1.status_doc_office = row[dfm.status_doc_office].ToString();
lDgss.Add(itm1);
}
}
