private async void btn_save_Click(object sender, EventArgs e) { string e_lcns = Globalfunction.Encrypt(doc_lcns.Text); string e_mac = Globalfunction.Encrypt(Globalfunction.pc_lcns); var param = new List <KeyValuePair <string, string> >(); param.Add(new KeyValuePair <string, string>("mt_lcns", e_lcns)); param.Add(new KeyValuePair <string, string>("mt_mac", e_mac)); param.Add(new KeyValuePair <string, string>("mt_name", hp_doctor.Text)); HttpContent content = new FormUrlEncodedContent(param); HttpResponseMessage response = await new HttpClient().PostAsync("http://contentsbox.co.kr" + "/au/insert_info.php", content); response.EnsureSuccessStatusCode(); JsonResult result = JsonConvert.DeserializeObject <JsonResult>(await response.Content.ReadAsStringAsync()); if (result == null) { return; } else { MessageBox.Show(result.msg); save_MsDb(e_lcns, e_mac); } }
private void PInfoForm_Load(object sender, EventArgs e) { int chart; connStr = String.Format(connStr, "auxology.mdb"); OleDbConnection gConn = new OleDbConnection(connStr); DataSet myDataSet = new DataSet(); string query = @"select top 1 chart_num from p_info order by chart_num desc"; OleDbCommand cmd = new OleDbCommand(query, gConn); OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(cmd); gConn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { chart = Convert.ToInt16(dr[0].ToString()) + 1; Globalfunction.chart_num = chart.ToString(); } if (Globalfunction.chart_num == "") { Globalfunction.chart_num = "1"; } chartnum_tb.Text = Globalfunction.chart_num; dr.Close(); gConn.Close(); regday = Globalfunction.spilitDate(reg_date.Text); }
private async void btn_confirm_Click(object sender, EventArgs e) { string e_lcns = Globalfunction.Encrypt(doc_lcns.Text); string e_mac = Globalfunction.Encrypt(Globalfunction.pc_lcns); var param = new List <KeyValuePair <string, string> >(); param.Add(new KeyValuePair <string, string>("mt_lcns", e_lcns)); param.Add(new KeyValuePair <string, string>("mt_mac", e_mac)); param.Add(new KeyValuePair <string, string>("mt_name", hp_doctor.Text)); HttpContent content = new FormUrlEncodedContent(param); HttpResponseMessage response = await new HttpClient().PostAsync("http://contentsbox.co.kr" + "/au/check_lcns.php", content); response.EnsureSuccessStatusCode(); List <Pinfo> result = JsonConvert.DeserializeObject <List <Pinfo> >(await response.Content.ReadAsStringAsync()); if (result == null) { return; } else { if (result.Count == 0) { MessageBox.Show("입력하신 정보가 일치하지 않습니다."); } else { end_date.Text = result[0].mt_end; save_EndDate(Globalfunction.Encrypt(end_date.Text), e_mac); } } }
private Boolean check_lcns() { Boolean access_flag; string dt_name = ""; connStr = String.Format(connStr, "auxology.mdb"); OleDbConnection gConn = new OleDbConnection(connStr); DataSet myDataSet = new DataSet(); string e_lcns = Globalfunction.Encrypt(Globalfunction.pc_lcns); string query = @"select dt_name from d_info where dt_mac=@dt_mac"; OleDbCommand cmd = new OleDbCommand(query, gConn); cmd.Parameters.AddWithValue("@dt_mac", e_lcns); OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(cmd); gConn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { dt_name = dr[0].ToString(); } if (dt_name != "") { access_flag = true; } else { access_flag = false; } dr.Close(); gConn.Close(); return(access_flag); }
private void btn_search1_Click(object sender, EventArgs e) { ChartSearchForm csf = new ChartSearchForm(); csf.ShowDialog(); if (csf.DialogResult == DialogResult.OK) { connStr = String.Format(connStr, "auxology.mdb"); OleDbConnection gConn = new OleDbConnection(connStr); string query = "select * from P_INFO where chart_num=@chart_num"; OleDbCommand cmd = new OleDbCommand(query, gConn); cmd.Parameters.AddWithValue("@chart_num", Globalfunction.chart_num); OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(cmd); gConn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); string gr_rb = "gr_rd"; while (dr.Read()) { chartnum_tb.Text = dr[0].ToString(); dt_cb.Text = dr[1].ToString(); reg_date.Text = dr[2].ToString(); parent_tb.Text = dr[3].ToString(); parent_cb.Text = dr[4].ToString(); patient_tb.Text = dr[5].ToString(); patient_cb.Text = dr[6].ToString(); birth_date.Text = dr[7].ToString(); man_tb1.Text = dr[8].ToString(); man_tb2.Text = dr[9].ToString(); adrs_tb1.Text = dr[10].ToString(); adrs_tb2.Text = dr[11].ToString(); adrs_tb3.Text = dr[12].ToString(); gr_rb = radioBtn_Check(dr[13].ToString()); gr_tb1.Text = dr[14].ToString(); pn_tb1.Text = dr[15].ToString(); pn_tb2.Text = dr[16].ToString(); pn_tb3.Text = dr[17].ToString(); hp_tb1.Text = dr[18].ToString(); hp_tb2.Text = dr[19].ToString(); hp_tb3.Text = dr[20].ToString(); hpn_tb1.Text = dr[21].ToString(); hpn_tb2.Text = dr[22].ToString(); hpn_tb3.Text = dr[23].ToString(); h_tb.Text = dr[24].ToString(); w_tb.Text = dr[25].ToString(); bmi_tb.Text = dr[26].ToString(); ph_tb.Text = dr[27].ToString(); pw_tb.Text = dr[28].ToString(); pbmi_tb.Text = dr[29].ToString(); fname_tb.Text = dr[30].ToString(); fh_tb.Text = dr[31].ToString(); mname_tb.Text = dr[32].ToString(); mh_tb.Text = dr[33].ToString(); } regday = Globalfunction.spilitDate(reg_date.Text); birthday = Globalfunction.spilitDate(birth_date.Text); dr.Close(); gConn.Close(); } else { this.DialogResult = csf.DialogResult; } }
private void birth_date_CloseUp(object sender, EventArgs e) { birthday = Globalfunction.spilitDate(birth_date.Text); Man_Age_Cal(birthday, regday); }
private void reg_date_CloseUp(object sender, EventArgs e) { regday = Globalfunction.spilitDate(reg_date.Text); }
private void btn_search_Click(object sender, EventArgs e) { ChartSearchForm csf = new ChartSearchForm(); csf.ShowDialog(); if (csf.DialogResult == DialogResult.OK) { connStr = String.Format(connStr, "auxology.mdb"); OleDbConnection gConn = new OleDbConnection(connStr); string query = "select * from munjin1 where chart_num=@chart_num"; OleDbCommand cmd = new OleDbCommand(query, gConn); cmd.Parameters.AddWithValue("@chart_num", Globalfunction.chart_num); OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(cmd); gConn.Open(); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { chartnum_tb.Text = dr[0].ToString(); name_tb.Text = dr[1].ToString(); regday = dr[2].ToString(); cb1_1.Checked = (bool)dr[3]; cb1_2.Checked = (bool)dr[4]; tb1_1.Text = dr[5].ToString(); cb2_1.Checked = (bool)dr[6]; cb2_2.Checked = (bool)dr[7]; cb2_3.Checked = (bool)dr[8]; cb2_4.Checked = (bool)dr[9]; cb2_5.Checked = (bool)dr[10]; tb2_1.Text = dr[11].ToString(); cb3_1.Checked = (bool)dr[12]; cb3_2.Checked = (bool)dr[13]; cb3_3.Checked = (bool)dr[14]; cb3_4.Checked = (bool)dr[15]; cb4_1.Checked = (bool)dr[16]; cb4_2.Checked = (bool)dr[17]; cb4_3.Checked = (bool)dr[18]; tb4_1.Text = dr[19].ToString(); cb5_1.Checked = (bool)dr[20]; cb5_2.Checked = (bool)dr[21]; cb5_3.Checked = (bool)dr[22]; tb5_1.Text = dr[23].ToString(); cb5_4.Checked = (bool)dr[24]; tb5_2.Text = dr[25].ToString(); tb5_3.Text = dr[26].ToString(); tb5_4.Text = dr[27].ToString(); cb6_1.Checked = (bool)dr[28]; cb6_2.Checked = (bool)dr[29]; tb6_1.Text = dr[30].ToString(); cb6_3.Checked = (bool)dr[31]; cb6_4.Checked = (bool)dr[32]; cb7_1.Checked = (bool)dr[33]; cb7_2.Checked = (bool)dr[34]; cb7_3.Checked = (bool)dr[35]; cb7_4.Checked = (bool)dr[36]; cb7_5.Checked = (bool)dr[37]; cb8_1.Checked = (bool)dr[38]; cb8_2.Checked = (bool)dr[39]; cb8_3.Checked = (bool)dr[40]; cb9_1.Checked = (bool)dr[41]; cb9_2.Checked = (bool)dr[42]; cb9_3.Checked = (bool)dr[43]; cb9_4.Checked = (bool)dr[44]; cb9_5.Checked = (bool)dr[45]; cb10_1.Checked = (bool)dr[46]; cb10_2.Checked = (bool)dr[47]; cb10_3.Checked = (bool)dr[48]; cb11_1.Checked = (bool)dr[49]; cb11_2.Checked = (bool)dr[50]; cb11_3.Checked = (bool)dr[51]; cb11_4.Checked = (bool)dr[52]; cb12_1.Checked = (bool)dr[53]; cb12_2.Checked = (bool)dr[54]; cb12_3.Checked = (bool)dr[55]; cb12_4.Checked = (bool)dr[56]; cb12_5.Checked = (bool)dr[57]; cb13_1.Checked = (bool)dr[58]; tb13_1.Text = dr[59].ToString(); tb13_2.Text = dr[60].ToString(); cb13_2.Checked = (bool)dr[61]; cb14_1.Checked = (bool)dr[62]; cb14_2.Checked = (bool)dr[63]; cb14_3.Checked = (bool)dr[64]; cb14_4.Checked = (bool)dr[65]; cb14_5.Checked = (bool)dr[66]; cb14_6.Checked = (bool)dr[67]; cb15_1.Checked = (bool)dr[68]; cb15_2.Checked = (bool)dr[69]; cb15_3.Checked = (bool)dr[70]; cb15_4.Checked = (bool)dr[71]; cb15_5.Checked = (bool)dr[72]; tb16_1.Text = dr[73].ToString(); tb16_2.Text = dr[74].ToString(); tb17_1.Text = dr[75].ToString(); tb18_1.Text = dr[76].ToString(); } regday = Globalfunction.spilitDate(reg_date.Text); //birthday = Globalfunction.spilitDate(birth_date.Text); dr.Close(); gConn.Close(); } else { this.DialogResult = csf.DialogResult; } }
private void Munjin1Form_Load(object sender, EventArgs e) { chartnum_tb.Text = Globalfunction.chart_num; regday = Globalfunction.spilitDate(reg_date.Text); }