예제 #1
0
        public void Edit_STATE(int USER_ID)
        {
            SqlParameter[] pr = new SqlParameter[1];
            pr[0] = new SqlParameter("USER_ID", USER_ID);

            DAL.conopen();
            DAL.Excute("SP_UPDATELOGIN", pr);
            DAL.conclose();
        }
예제 #2
0
 //INSERT Data Treatments
 public void Insert_PAT_INFO(string PAT_NAME, int PAT_AGE, string PAT_TYPE)
 {
     SqlParameter[] pr = new SqlParameter[3];
     pr[0] = new SqlParameter("PAT_NAME", PAT_NAME);
     pr[1] = new SqlParameter("PAT_AGE", PAT_AGE);
     pr[2] = new SqlParameter("PAT_TYPE", PAT_TYPE);
     DAL.conopen();
     DAL.Excute("SP_INSERTPATINFO", pr);
     DAL.conclose();
 }
예제 #3
0
 //INSERT Data Treatments
 public void Insert_Treat(string Treat_Name)
 {
     SqlParameter[] pr = new SqlParameter[1];
     pr[0] = new SqlParameter("TREAT_NAME", Treat_Name);
     DAL.conopen();
     DAL.Excute("SP_INSERTTREAT", pr);
     DAL.conclose();
 }