protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string strSql = "Insert Into reg_file (reg_no, p_name, birth_date, sex, id_no, area, merry, native, belief, insurance, p_type, special, pay_type, first_opd_date, last_opd_date, opd_count, miss_count, rent_man, iccard_id)" +
" Values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql);
#region 測試資料
//cmd.Parameters.Add("@reg_no", System.Data.Odbc.OdbcType.Char).Value = "Y99001";
//cmd.Parameters.Add("@p_name", System.Data.Odbc.OdbcType.Char).Value = "測試號";
//cmd.Parameters.Add("@birth_date", System.Data.Odbc.OdbcType.Date).Value = "1989/06/20";
//cmd.Parameters.Add("@sex", System.Data.Odbc.OdbcType.Char).Value = "1";
//cmd.Parameters.Add("@id_no", System.Data.Odbc.OdbcType.Char).Value = "E123456789";
//cmd.Parameters.Add("@area", System.Data.Odbc.OdbcType.Char).Value = "4301";
//cmd.Parameters.Add("@merry", System.Data.Odbc.OdbcType.Char).Value = "0";
//cmd.Parameters.Add("@native", System.Data.Odbc.OdbcType.Char).Value = "01";
//cmd.Parameters.Add("@belief", System.Data.Odbc.OdbcType.Char).Value = "0";
//cmd.Parameters.Add("@insurance", System.Data.Odbc.OdbcType.Char).Value = "01";
//cmd.Parameters.Add("@p_type", System.Data.Odbc.OdbcType.Char).Value = "00";
//cmd.Parameters.Add("@special", System.Data.Odbc.OdbcType.Char).Value = "00";
//cmd.Parameters.Add("@pay_type", System.Data.Odbc.OdbcType.Char).Value = "01";
//cmd.Parameters.Add("@first_opd_date", System.Data.Odbc.OdbcType.Date).Value = DateTime.Now.Date;
//cmd.Parameters.Add("@last_opd_date", System.Data.Odbc.OdbcType.Date).Value = DateTime.Now.Date;
//cmd.Parameters.Add("@opd_count", System.Data.Odbc.OdbcType.SmallInt).Value = "0";
//cmd.Parameters.Add("@miss_count", System.Data.Odbc.OdbcType.SmallInt).Value = "0";
//cmd.Parameters.Add("@rent_man", System.Data.Odbc.OdbcType.Char).Value = "f872";
//cmd.Parameters.Add("@iccard_id", System.Data.Odbc.OdbcType.Char).Value = "";
#endregion
cmd.Parameters.Add("@reg_no", System.Data.Odbc.OdbcType.Char).Value = txtReg_No.Text;
cmd.Parameters.Add("@p_name", System.Data.Odbc.OdbcType.Char).Value = txtName.Text;
cmd.Parameters.Add("@birth_date", System.Data.Odbc.OdbcType.Date).Value = txtBirth.Text;
cmd.Parameters.Add("@sex", System.Data.Odbc.OdbcType.Char).Value = ddlSex.SelectedValue;
cmd.Parameters.Add("@id_no", System.Data.Odbc.OdbcType.Char).Value = txtId_No.Text;
cmd.Parameters.Add("@area", System.Data.Odbc.OdbcType.Char).Value = "4301";
cmd.Parameters.Add("@merry", System.Data.Odbc.OdbcType.Char).Value = "0";
cmd.Parameters.Add("@native", System.Data.Odbc.OdbcType.Char).Value = "01";
cmd.Parameters.Add("@belief", System.Data.Odbc.OdbcType.Char).Value = "0";
cmd.Parameters.Add("@insurance", System.Data.Odbc.OdbcType.Char).Value = "01";
cmd.Parameters.Add("@p_type", System.Data.Odbc.OdbcType.Char).Value = "00";
cmd.Parameters.Add("@special", System.Data.Odbc.OdbcType.Char).Value = "00";
cmd.Parameters.Add("@pay_type", System.Data.Odbc.OdbcType.Char).Value = "01";
cmd.Parameters.Add("@first_opd_date", System.Data.Odbc.OdbcType.Date).Value = DateTime.Now.Date;
cmd.Parameters.Add("@last_opd_date", System.Data.Odbc.OdbcType.Date).Value = DateTime.Now.Date;
cmd.Parameters.Add("@opd_count", System.Data.Odbc.OdbcType.SmallInt).Value = "0";
cmd.Parameters.Add("@miss_count", System.Data.Odbc.OdbcType.SmallInt).Value = "0";
cmd.Parameters.Add("@rent_man", System.Data.Odbc.OdbcType.Char).Value = "f872";
cmd.Parameters.Add("@iccard_id", System.Data.Odbc.OdbcType.Char).Value = "";
Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection();
conn.ExecuteQuery(cmd);
hfReg_No.Value = txtReg_No.Text;
Response.Redirect(ResolveUrl(string.Format("~/AppointOnsite.aspx?ID={0}", hfReg_No.Value)));
}
catch (Exception ex)
{
PublicLib.handleError("", this.GetType().Name, ex.Message);
}
}
public string SavaPatient02(string cont_name, string cont_tel_no, string cont_rel, string cont_area, string cont_addr, string reg_no)
{
string strSql = "Update reg_file Set cont_name=?, cont_tel_no=?, cont_rel=?,cont_area=?, cont_addr=? Where reg_no=?";
System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql);
cmd.Parameters.Add("@cont_name", System.Data.Odbc.OdbcType.VarChar).Value = cont_name;
cmd.Parameters.Add("@cont_tel_no", System.Data.Odbc.OdbcType.VarChar).Value = cont_tel_no;
cmd.Parameters.Add("@cont_rel", System.Data.Odbc.OdbcType.VarChar).Value = cont_rel;
cmd.Parameters.Add("@cont_area", System.Data.Odbc.OdbcType.Char).Value = cont_area;
cmd.Parameters.Add("@cont_addr", System.Data.Odbc.OdbcType.VarChar).Value = cont_addr;
cmd.Parameters.Add("@reg_no", System.Data.Odbc.OdbcType.Char).Value = reg_no;
Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection();
return(conn.ExecuteQuery(cmd) ? "1" : "0");
}
public string SavaPatient01(string p_name, string birth_date, string sex, string merry, string native, string belief, string tel_no, string con_name, string con_tel, string area, string address, string area1, string address1, string reg_no)
{
string strSql = "Update reg_file Set p_name=?, birth_date=?, sex=?, merry=?, native=?, belief=?, tel_no=?, con_name=?, con_tel=?, area=?, address=?, area1=?, address1=? Where reg_no=?";
System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(strSql);
cmd.Parameters.Add("@p_name", System.Data.Odbc.OdbcType.Char).Value = p_name;
cmd.Parameters.Add("@birth_date", System.Data.Odbc.OdbcType.Date).Value = birth_date;
cmd.Parameters.Add("@sex", System.Data.Odbc.OdbcType.Char).Value = sex;
cmd.Parameters.Add("@merry", System.Data.Odbc.OdbcType.Char).Value = merry;
cmd.Parameters.Add("@native", System.Data.Odbc.OdbcType.Char).Value = native;
cmd.Parameters.Add("@belief", System.Data.Odbc.OdbcType.Char).Value = belief;
cmd.Parameters.Add("@tel_no", System.Data.Odbc.OdbcType.VarChar).Value = tel_no;
cmd.Parameters.Add("@con_name", System.Data.Odbc.OdbcType.VarChar).Value = con_name;
cmd.Parameters.Add("@con_tel", System.Data.Odbc.OdbcType.VarChar).Value = con_tel;
cmd.Parameters.Add("@area", System.Data.Odbc.OdbcType.Char).Value = area;
cmd.Parameters.Add("@address", System.Data.Odbc.OdbcType.Char).Value = address;
cmd.Parameters.Add("@area1", System.Data.Odbc.OdbcType.Char).Value = area1;
cmd.Parameters.Add("@address1", System.Data.Odbc.OdbcType.VarChar).Value = address1;
cmd.Parameters.Add("@reg_no", System.Data.Odbc.OdbcType.Char).Value = reg_no;
Dev.ODBCSql.MyODBCConnection conn = new Dev.ODBCSql.MyODBCConnection();
return(conn.ExecuteQuery(cmd) ? "1" : "0");
}
