コード例 #1
0
ファイル: frmMain.cs プロジェクト: khinseakheng/HMS
        private void btSave_Click(object sender, EventArgs e)
        {
            dbConnection dbcon = new dbConnection();

            dbcon.OpenConection();
            dbcon.ExecuteQueries("INSERT INTO tbPatient" +
                                 "(PID,PName,Gender,PType,Nation,Birhtdate,PAddress,Phone,illstatus,BloodType,Occupation) VALUES " +
                                 "('" + txtID.Text + "'," +
                                 "'" + txtName.Text + "'," +
                                 "'" + cmbSex.Text + "'," +
                                 "'" + cmbType.Text + "'," +
                                 "'" + txtNation.Text + "'," +
                                 "'" + txtBD.Text + "'," +
                                 "'" + txtAddress.Text + "'," +
                                 "'" + txtPhone.Text + "'," +
                                 "'" + txtIllStatus.Text + "'," +
                                 "'" + cmbBtype.Text + "'," +
                                 "'" + txtOccupation.Text + "'" +
                                 ")");
            if (cmbType.Text == "Inpatient ")
            {
                MessageBox.Show("go to checkin");
            }
            Clear cn = new Clear();

            cn.ClearTextBoxes(this);
        }
コード例 #2
0
 private void btSave_Click(object sender, EventArgs e)
 {
     if (btclick == 1)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("INSERT INTO tbSupplier (SupplierID, SupplierName, SupplierPhone,country) " +
                              "VALUES ('" + txtSupplierID.Text + "','" + txtName.Text + "','" + txtPhone.Text + "','" + txtAdress.Text + "')");
         SupplierModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
         listViewShow lst = new listViewShow();
         lst.ShowData("Select SupplierName from tbSupplier", "SupplierName", lstView);
         btNew_Click(this, null);
     }
     if (btclick == 2)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("Update tbSupplier Set SupplierID='" + txtSupplierID.Text + "', SupplierName='" + txtName.Text + "', SupplierPhone='" + txtPhone.Text + "', Country='" + txtAdress.Text + "' Where SupplierID='" + txtSupplierID.Text + "'");
         SupplierModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
         listViewShow lst = new listViewShow();
         lst.ShowData("Select SupplierName from tbSupplier", "SupplierName", lstView);
         btNew_Click(this, null);
         MessageBox.Show("Record was Updated!!");
     }
     btSave.Enabled = false;
 }
コード例 #3
0
ファイル: RoomModule.cs プロジェクト: khinseakheng/HMS
 private void btSave_Click(object sender, EventArgs e)
 {
     if (btclick == 1)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("INSERT INTO tbRoom(RoomNo,Availablebed,Building,Rfloor,RtypeID) " +
                              "VALUES (" +
                              "'" + txtRoomNo.Text + "'," +
                              "'" + txtAvaliable.Text + "'," +
                              "'" + cmbBuiding.Text + "'," +
                              "'" + txtFloor.Text + "'," +
                              "'" + cmbRoomTID.Text + "'" +
                              ")");
         RoomModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
     }
     if (btclick == 2)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("Update tbRoom Set " +
                              " Availablebed='" + txtAvaliable.Text + "'," +
                              " Building='" + cmbBuiding.Text + "'," +
                              " Rfloor='" + txtFloor.Text + "', " +
                              " RtypeID='" + cmbRoomTID.Text + "'" +
                              " Where RoomNo  ='" + txtRoomNo.Text + "'");
         RoomModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
     }
 }
コード例 #4
0
 private void btSave_Click(object sender, EventArgs e)
 {
     if (btclick == 1)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("INSERT INTO tbRoomType" +
                              "(RTypeID,RType,NumofBed,Price) VALUES " +
                              "('" + txtRTID.Text + "'," +
                              "'" + cmbType.Text + "'," +
                              "'" + txtNumofBed.Text + "'," +
                              "'" + txtPrice.Text + "'" +
                              ")");
         RoomType_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
     }
     if (btclick == 2)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("Update tbRoomType Set " +
                              " RType='" + cmbType.Text + "'," +
                              " NumofBed='" + txtNumofBed.Text + "'," +
                              " Price='" + txtPrice.Text + "'" +
                              " Where RTypeID ='" + txtRTID.Text + "'");
         RoomType_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
     }
 }
コード例 #5
0
 private void btSave_Click(object sender, EventArgs e)
 {
     if (btclick == 1)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("INSERT INTO tbUser (UserID, UserName, UserPassword, AccountType, RegisterDate, StaffID) " +
                              "VALUES ('" + txtUserID.Text + "','" + txtUserName.Text + "','" + txtPassword.Text + "','" + cmbAccType.Text + "','"
                              + txtRegisterDate.Text + "','" + cmbStaff.Text + "')");
         UserModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
         listViewShow lst = new listViewShow();
         lst.ShowData("Select UserName from tbUser", "UserName", lstView);
         btNew_Click(this, null);
     }
     if (btclick == 2)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("Update tbUser Set UserID='" + txtUserID.Text + "', UserName='******', UserPassword='******', AccountType='" + cmbAccType.Text + "', RegisterDate='" + txtRegisterDate.Text + "', StaffID='" + cmbStaff.Text + "' Where UserID='" + txtUserID.Text + "'");
         UserModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
         listViewShow lst = new listViewShow();
         lst.ShowData("Select UserName from tbUser", "UserName", lstView);
     }
     btSave.Enabled = false;
     btEdit.Enabled = true;
     btNew.Enabled  = true;
 }
コード例 #6
0
ファイル: MedicineModule.cs プロジェクト: khinseakheng/HMS
 private void btSave_Click(object sender, EventArgs e)
 {
     if (btclick == 1)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("Insert Into tbMedicine(MeID,MeName,MeType,StockQty,MeCategoryID,Cost) " +
                              "VALUES (" +
                              "'" + txtMeID.Text + "'," +
                              "'" + txtName.Text + "'," +
                              "'" + cmbCategory.Text + "'," +
                              "'" + txtStockqty.Text + "'," +
                              "'" + txtCategoryID.Text + "'," +
                              "'" + txtCost.Text + "'" +
                              ")");
         MedicineModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
     }
     if (btclick == 2)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("Update tbMedicine Set " +
                              " MeName='" + txtName.Text + "'," +
                              " MeType='" + cmbCategory.Text + "'," +
                              " StockQty='" + txtStockqty.Text + "'," +
                              " Cost='" + txtCost.Text + "'," +
                              " MeCategoryID='" + txtCategoryID.Text + "'" +
                              " Where MeID  ='" + txtMeID.Text + "'");
         MedicineModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
     }
 }
コード例 #7
0
ファイル: MecCategory.cs プロジェクト: khinseakheng/HMS
 private void btSave_Click(object sender, EventArgs e)
 {
     if (btclick == 1)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("INSERT INTO tbMeCategory" +
                              "(MeCategoryID,Category,Country,Usage) VALUES " +
                              "('" + txtcategoryID.Text + "'," +
                              "'" + txtCategoryName.Text + "'," +
                              "'" + cmbCountry.Text + "'," +
                              "'" + txtUsage.Text + "'" +
                              ")");
         MecCategory_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
     }
     if (btclick == 2)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("Update tbMeCategorySet " +
                              " Category='" + txtCategoryName.Text + "'," +
                              " Country='" + cmbCountry.Text + "'," +
                              " Usage='" + txtUsage.Text + "'" +
                              " Where  MeCategoryID='" + txtcategoryID.Text + "'");
         MecCategory_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
     }
 }
コード例 #8
0
ファイル: ServiceModule.cs プロジェクト: khinseakheng/HMS
 private void btSave_Click(object sender, EventArgs e)
 {
     if (btclick == 1)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("INSERT INTO tbServices" +
                              "(ServiceID,ServiceName,cost,Info) VALUES " +
                              "('" + txtServiceID.Text + "'," +
                              "'" + txtName.Text + "'," +
                              "'" + txtCost.Text + "'," +
                              "'" + txtInfo.Text + "'" +
                              ")");
         ServiceModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
     }
     if (btclick == 2)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("Update tbServices Set " +
                              " ServiceName='" + txtName.Text + "'," +
                              " cost='" + txtCost.Text + "'," +
                              " Info='" + txtInfo.Text + "'" +
                              " Where ServiceID ='" + txtServiceID.Text + "'");
         ServiceModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
     }
 }
コード例 #9
0
ファイル: listViewShow.cs プロジェクト: khinseakheng/HMS
        public void ShowData(String SelectStatment, String ColumnName, ListBox listView)
        {
            listView.Items.Clear();
            dbConnection dbcon = new dbConnection();

            dbcon.OpenConection();
            SqlDataReader dr = dbcon.DataReader(SelectStatment);

            while (dr.Read())
            {
                listView.Items.Add(dr[ColumnName]);
            }
        }
コード例 #10
0
ファイル: PatientModule.cs プロジェクト: khinseakheng/HMS
        private void btSave_Click(object sender, EventArgs e)
        {
            if (btclick == 1)
            {
                dbConnection dbcon = new dbConnection();
                dbcon.OpenConection();
                dbcon.ExecuteQueries("INSERT INTO tbPatient" +
                                     "(PID,PName,Gender,PType,Nation,Birhtdate,PAddress,Phone,illstatus,BloodType,Occupation) VALUES " +
                                     "('" + txtID.Text + "'," +
                                     "'" + txtName.Text + "'," +
                                     "'" + cmbSex.Text + "'," +
                                     "'" + cmbType.Text + "'," +
                                     "'" + txtNation.Text + "'," +
                                     "'" + txtBD.Text + "'," +
                                     "'" + txtAddress.Text + "'," +
                                     "'" + txtPhone.Text + "'," +
                                     "'" + txtIllStatus.Text + "'," +
                                     "'" + cmbBtype.Text + "'," +
                                     "'" + txtOccupation.Text + "'" +
                                     ")");
                if (cmbType.Text == "Inpatient ")
                {
                    MessageBox.Show("go to checkin");
                }
                ClearControl cn = new ClearControl();
                cn.ClearTextBoxes(this);
            }
            if (btclick == 2)
            {
                dbConnection dbcon = new dbConnection();
                dbcon.OpenConection();
                dbcon.ExecuteQueries("Update tbPatient Set " +
                                     " PID='" + txtID.Text + "', " +
                                     " PName='" + txtName.Text + "'," +
                                     " Gender='" + cmbSex.Text + "'," +
                                     " PType='" + cmbType.Text + "', " +
                                     " Nation='" + txtNation.Text + "', " +
                                     " Birhtdate='" + txtBD.Text + "', " +
                                     " PAddress='" + txtAddress.Text + "', " +
                                     " Phone='" + txtPhone.Text + "', " +
                                     " illstatus='" + txtIllStatus.Text + "', " +
                                     " BloodType='" + cmbBtype.Text + "', " +
                                     " Occupation='" + txtOccupation.Text + "'" +
                                     " Where PID ='" + txtID.Text + "'");

                ClearControl cn = new ClearControl();
                cn.ClearTextBoxes(this);
                listViewShow lst = new listViewShow();
                lst.ShowData("Select PName from tbPatient", "PName", lstView);
            }
        }
コード例 #11
0
        private void btSave_Click(object sender, EventArgs e)
        {
            if (btclick == 1)
            {
                dbConnection dbcon = new dbConnection();
                dbcon.OpenConection();
                dbcon.ExecuteQueries("INSERT INTO tbStaff (staffID, Staffname, Gender,Birthdate,Position,salary,Phone,Email,SAddress,Hireddate,Stopwork) " +
                                     "VALUES (" +
                                     "'" + txtStaffID.Text + "'," +
                                     "'" + txtName.Text + "'," +
                                     "'" + cmbSex.Text + "'," +
                                     "'" + txtBD.Text + "'," +
                                     "'" + cmbPosition.Text + "'," +
                                     "'" + txtSalary.Text + "'," +
                                     "'" + txtphone.Text + "'," +
                                     "'" + txtEmail.Text + "'," +
                                     "'" + txtAddress.Text + "'," +
                                     "'" + txtHD.Text + "'," +

                                     "'" + cmbStopWork.Text + "'" +
                                     ")");
                StaffModule_Load(this, null);
                ClearControl cn = new ClearControl();
                cn.ClearTextBoxes(this);
                listViewShow lst = new listViewShow();
                lst.ShowData("Select StaffName from tbStaff", "StaffName", lstView);
            }
            if (btclick == 2)
            {
                dbConnection dbcon = new dbConnection();
                dbcon.OpenConection();
                dbcon.ExecuteQueries("Update tbStaff Set " +
                                     " staffID='" + txtStaffID.Text + "', " +
                                     " Staffname='" + txtName.Text + "'," +
                                     " Gender='" + cmbSex.Text + "'," +
                                     " Birthdate='" + txtBD.Text + "', " +
                                     " Position='" + cmbPosition.Text + "', " +
                                     " salary='" + txtSalary.Text + "', " +
                                     " Email='" + txtEmail.Text + "', " +
                                     " SAddress='" + txtAddress.Text + "', " +
                                     " Phone='" + txtphone.Text + "', " +
                                     " Hireddate='" + txtHD.Text + "', " +
                                     " Stopwork='" + cmbStopWork.Text + "'" +
                                     " Where StaffID ='" + txtStaffID.Text + "'");
                StaffModule_Load(this, null);
                ClearControl cn = new ClearControl();
                cn.ClearTextBoxes(this);
                listViewShow lst = new listViewShow();
                lst.ShowData("Select StaffName from tbStaff", "StaffName", lstView);
            }
        }
コード例 #12
0
ファイル: listViewShow.cs プロジェクト: khinseakheng/HMS
        public void ListData(String SelectStatment, String ColumnName1, String ColumnName2, ListView listView)
        {
            listView.Items.Clear();
            dbConnection dbcon = new dbConnection();

            dbcon.OpenConection();
            SqlDataReader dr = dbcon.DataReader(SelectStatment);

            while (dr.Read())
            {
                listView.Items.Add(dr[ColumnName1].ToString());
                listView.Items.Add(dr[ColumnName2].ToString());
            }
        }
コード例 #13
0
ファイル: ServiceModule.cs プロジェクト: khinseakheng/HMS
        private void lstView_SelectedIndexChanged(object sender, EventArgs e)
        {
            int x = lstView.SelectedIndex + 1;

            txtServiceID.Text = x.ToString();
            dbConnection   conn = new dbConnection();
            SqlDataAdapter dr   = new SqlDataAdapter("select * from tbServices where ServiceID= '" + txtServiceID.Text + "'", "Database=DBHospital;Server=SEAKHENG\\KSH;Integrated Security=True;connect timeout = 30");
            DataSet        ds   = new DataSet();

            dr.Fill(ds, "tbServices");
            txtName.Text = ds.Tables["tbServices"].Rows[0].ItemArray[1].ToString();
            txtCost.Text = ds.Tables["tbServices"].Rows[0].ItemArray[2].ToString();
            txtInfo.Text = ds.Tables["tbServices"].Rows[0].ItemArray[3].ToString();
        }
コード例 #14
0
ファイル: DoctorModule.cs プロジェクト: khinseakheng/HMS
 private void btSave_Click(object sender, EventArgs e)
 {
     if (btclick == 1)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("INSERT INTO tbDoctor" +
                              "(DocID, Docname, Gender, Birthdate, DAddress, Specialize,Nation,Degree,salary," +
                              "Phone,Email,Contractdate,ExpiredDate,Stopwork) VALUES " +
                              "('" + txtDoctorID.Text + "','" + txtName.Text + "'," +
                              "'" + cmbSex.Text + "','" + txtBD.Text + "','" + txtEmail.Text + "'," +
                              "'" + txtSkill.Text + "','" + txtNation.Text + "','" + txtDegree.Text + "'," +
                              "'" + txtSalary.Text + "','" + txtPhone.Text + "','" + txtEmail.Text + "'," +
                              "'" + txtContractdate.Text + "','" + txtExpireDate.Text + "','" + cmbStopWork.Text + "')");
         DoctorModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
         listViewShow lst = new listViewShow();
         lst.ShowData("Select docname from tbDoctor", "docname", lstView);
         btNew_Click(this, null);
     }
     if (btclick == 2)
     {
         dbConnection dbcon = new dbConnection();
         dbcon.OpenConection();
         dbcon.ExecuteQueries("Update tbDoctor Set " +
                              " DocID='" + txtDoctorID.Text + "', " +
                              " Docname='" + txtName.Text + "'," +
                              " Gender='" + cmbSex.Text + "'," +
                              " Birthdate='" + txtBD.Text + "', " +
                              " DAddress='" + txtEmail.Text + "', " +
                              " Specialize='" + txtSkill.Text + "', " +
                              " Nation='" + txtNation.Text + "', " +
                              " Degree='" + txtDegree.Text + "', " +
                              " salary='" + txtSalary.Text + "', " +
                              " Phone='" + txtPhone.Text + "', " +
                              " Email='" + txtEmail.Text + "', " +
                              " Contractdate='" + txtContractdate.Text + "', " +
                              " ExpiredDate='" + txtExpireDate.Text + "', " +
                              " Stopwork='" + cmbStopWork.Text + "'" +
                              " Where DocID ='" + txtDoctorID.Text + "'");
         DoctorModule_Load(this, null);
         ClearControl cn = new ClearControl();
         cn.ClearTextBoxes(this);
         listViewShow lst = new listViewShow();
         lst.ShowData("Select docname from tbDoctor", "docname", lstView);
     }
 }
コード例 #15
0
ファイル: MedicineModule.cs プロジェクト: khinseakheng/HMS
        private void lstView_SelectedIndexChanged(object sender, EventArgs e)
        {
            // select* from tbMedicine Inner Join tbMeCategory on tbMedicine.MeCategoryID = tbMeCategory.MeCategoryID where tbMedicine.MeID = '" + txtMeID.Text + "'"
            int x = lstView.SelectedIndex + 1;

            txtMeID.Text = x.ToString();
            dbConnection   conn = new dbConnection();
            SqlDataAdapter dr   = new SqlDataAdapter("select * from tbMedicine where MeID = '" + txtMeID.Text + "'",
                                                     "Database=DBHospital;Server=SEAKHENG\\KSH;Integrated Security=True;connect timeout = 30");
            DataSet ds = new DataSet();

            dr.Fill(ds, "tbMedicine");
            txtName.Text       = ds.Tables["tbMedicine"].Rows[0].ItemArray[1].ToString();
            cmbCategory.Text   = ds.Tables["tbMedicine"].Rows[0].ItemArray[2].ToString();
            txtStockqty.Text   = ds.Tables["tbMedicine"].Rows[0].ItemArray[3].ToString();
            txtCategoryID.Text = ds.Tables["tbMedicine"].Rows[0].ItemArray[4].ToString();
            txtCost.Text       = ds.Tables["tbMedicine"].Rows[0].ItemArray[5].ToString();
        }
コード例 #16
0
        private void lstView_SelectedIndexChanged(object sender, EventArgs e)
        {
            int x = lstView.SelectedIndex + 1;

            txtSupplierID.Text = x.ToString();
            dbConnection   conn = new dbConnection();
            SqlDataAdapter dr   = new SqlDataAdapter("select * from tbSupplier where SupplierID= '" + txtSupplierID.Text + "'", "Database=DBHospital;Server=SEAKHENG\\KSH;Integrated Security=True;connect timeout = 30");
            DataSet        ds   = new DataSet();

            dr.Fill(ds, "tbSupplier");
            txtName.Text  = ds.Tables["tbSupplier"].Rows[0].ItemArray[1].ToString();
            txtPhone.Text = ds.Tables["tbSupplier"].Rows[0].ItemArray[2].ToString();
            // txtMail.Text = ds.Tables["tbSupplier"].Rows[0].ItemArray[3].ToString();
            txtAdress.Text = ds.Tables["tbSupplier"].Rows[0].ItemArray[3].ToString();
            btSave.Enabled = false;
            btEdit.Enabled = true;
            btNew.Enabled  = true;
        }
コード例 #17
0
ファイル: RoomModule.cs プロジェクト: khinseakheng/HMS
        private void cmbRType_SelectedIndexChanged(object sender, EventArgs e)
        {
            int Cmb = cmbRType.SelectedIndex + 1;

            cmbRoomTID.Text = Cmb.ToString();
            //txtRoomNo.Text = Cmb.ToString();
            dbConnection   conn = new dbConnection();
            SqlDataAdapter dr   = new SqlDataAdapter("select * from tbRoomType where RTypeID = '" + cmbRoomTID.Text + "'",
                                                     "Database=DBHospital;Server=SEAKHENG\\KSH;Integrated Security=True;connect timeout = 30");
            DataSet ds = new DataSet();

            dr.Fill(ds, "tbRoomType");
            txtTotalBed.Text = ds.Tables["tbRoomType"].Rows[0].ItemArray[2].ToString();
            txtprice.Text    = ds.Tables["tbRoomType"].Rows[0].ItemArray[3].ToString();
            if (btclick == 1)
            {
                txtAvaliable.Text = ds.Tables["tbRoomType"].Rows[0].ItemArray[2].ToString();
            }
        }
コード例 #18
0
ファイル: RoomModule.cs プロジェクト: khinseakheng/HMS
        private void cmbRType_MouseUp(object sender, MouseEventArgs e)
        {
            cmbRType.Items.Clear();
            dbConnection dbcon = new dbConnection();

            dbcon.OpenConection();
            SqlDataReader dr = dbcon.DataReader("select RType from tbRoomType");

            dr.Read();
            if (dr.HasRows)

            {
                cmbRType.Items.Add(dr["RType"]).ToString();
                while (dr.Read())
                {
                    cmbRType.Items.Add(dr["RType"]).ToString();
                }
            }
        }
コード例 #19
0
        private void lstView_SelectedIndexChanged(object sender, EventArgs e)
        {
            int x = lstView.SelectedIndex + 1;

            txtUserID.Text = x.ToString();
            dbConnection   conn = new dbConnection();
            SqlDataAdapter dr   = new SqlDataAdapter("select * from tbUser where UserID= '" + txtUserID.Text + "'", "Database=DBHospital;Server=SEAKHENG\\KSH;Integrated Security=True;connect timeout = 30");
            DataSet        ds   = new DataSet();

            dr.Fill(ds, "tbUser");
            txtUserName.Text     = ds.Tables["tbUser"].Rows[0].ItemArray[1].ToString();
            txtPassword.Text     = ds.Tables["tbUser"].Rows[0].ItemArray[2].ToString();
            cmbAccType.Text      = ds.Tables["tbUser"].Rows[0].ItemArray[3].ToString();
            txtConPass.Text      = ds.Tables["tbUser"].Rows[0].ItemArray[2].ToString();
            txtRegisterDate.Text = ds.Tables["tbUser"].Rows[0].ItemArray[4].ToString();
            cmbStaff.Text        = ds.Tables["tbUser"].Rows[0].ItemArray[5].ToString();
            btSave.Enabled       = true;
            btEdit.Enabled       = true;
        }
コード例 #20
0
ファイル: MedicineModule.cs プロジェクト: khinseakheng/HMS
        private void cmbCategory_MouseUp(object sender, MouseEventArgs e)
        {
            cmbCategory.Items.Clear();
            dbConnection dbcon = new dbConnection();

            dbcon.OpenConection();
            SqlDataReader dr = dbcon.DataReader("select Category from tbMeCategory");

            dr.Read();
            if (dr.HasRows)

            {
                cmbCategory.Items.Add(dr["Category"]).ToString();
                while (dr.Read())
                {
                    cmbCategory.Items.Add(dr["Category"]).ToString();
                }
            }
        }
コード例 #21
0
ファイル: PatientModule.cs プロジェクト: khinseakheng/HMS
        private void lstView_SelectedIndexChanged(object sender, EventArgs e)
        {
            int x = lstView.SelectedIndex + 1;

            txtID.Text = x.ToString();
            dbConnection   conn = new dbConnection();
            SqlDataAdapter dr   = new SqlDataAdapter("select * from tbPatient where PID= '" + txtID.Text + "'", "Database=DBHospital;Server=SEAKHENG\\KSH;Integrated Security=True;connect timeout = 30");
            DataSet        ds   = new DataSet();

            dr.Fill(ds, "tbPatient");
            txtName.Text       = ds.Tables["tbPatient"].Rows[0].ItemArray[1].ToString();
            cmbSex.Text        = ds.Tables["tbPatient"].Rows[0].ItemArray[2].ToString();
            cmbType.Text       = ds.Tables["tbPatient"].Rows[0].ItemArray[3].ToString();
            txtNation.Text     = ds.Tables["tbPatient"].Rows[0].ItemArray[4].ToString();
            txtBD.Text         = ds.Tables["tbPatient"].Rows[0].ItemArray[5].ToString();
            txtAddress.Text    = ds.Tables["tbPatient"].Rows[0].ItemArray[6].ToString();
            txtPhone.Text      = ds.Tables["tbPatient"].Rows[0].ItemArray[7].ToString();
            txtIllStatus.Text  = ds.Tables["tbPatient"].Rows[0].ItemArray[8].ToString();
            cmbBtype.Text      = ds.Tables["tbPatient"].Rows[0].ItemArray[9].ToString();
            txtOccupation.Text = ds.Tables["tbPatient"].Rows[0].ItemArray[10].ToString();
        }
コード例 #22
0
        private void lstView_SelectedIndexChanged(object sender, EventArgs e)
        {
            int x = lstView.SelectedIndex + 1;

            txtStaffID.Text = x.ToString();
            dbConnection   conn = new dbConnection();
            SqlDataAdapter dr   = new SqlDataAdapter("select * from tbStaff where StaffID= '" + txtStaffID.Text + "'", "Database=DBHospital;Server=SEAKHENG\\KSH;Integrated Security=True;connect timeout = 30");
            DataSet        ds   = new DataSet();

            dr.Fill(ds, "tbStaff");
            txtName.Text     = ds.Tables["tbStaff"].Rows[0].ItemArray[1].ToString();
            cmbSex.Text      = ds.Tables["tbStaff"].Rows[0].ItemArray[2].ToString();
            cmbPosition.Text = ds.Tables["tbStaff"].Rows[0].ItemArray[4].ToString();
            txtAddress.Text  = ds.Tables["tbStaff"].Rows[0].ItemArray[8].ToString();
            txtphone.Text    = ds.Tables["tbStaff"].Rows[0].ItemArray[6].ToString();
            txtEmail.Text    = ds.Tables["tbStaff"].Rows[0].ItemArray[7].ToString();
            txtSalary.Text   = ds.Tables["tbStaff"].Rows[0].ItemArray[5].ToString();
            txtBD.Text       = ds.Tables["tbStaff"].Rows[0].ItemArray[3].ToString();
            txtHD.Text       = ds.Tables["tbStaff"].Rows[0].ItemArray[9].ToString();
            cmbStopWork.Text = ds.Tables["tbStaff"].Rows[0].ItemArray[11].ToString();
        }
コード例 #23
0
ファイル: RoomModule.cs プロジェクト: khinseakheng/HMS
        private void lstView_SelectedIndexChanged(object sender, EventArgs e)
        {
            int x = lstView.SelectedIndex + 1;

            txtRoomNo.Text = x.ToString();
            dbConnection   conn = new dbConnection();
            SqlDataAdapter dr   = new SqlDataAdapter("select tbRoom.RoomNo,tbRoom.Availablebed,tbRoom.Building," +
                                                     "tbRoom.Rfloor,tbRoom.RtypeID,tbRoomType.RType,tbRoomType.NumofBed,tbRoomType.Price,tbRoomType.RTypeID" +
                                                     " from tbRoom Inner Join tbRoomType on tbRoom.RtypeID = tbRoomType.RTypeID where tbRoom.RoomNo = '" + txtRoomNo.Text + "'",
                                                     "Database=DBHospital;Server=SEAKHENG\\KSH;Integrated Security=True;connect timeout = 30");
            DataSet ds = new DataSet();

            dr.Fill(ds, "tbRoom");
            txtAvaliable.Text = ds.Tables["tbRoom"].Rows[0].ItemArray[1].ToString();
            txtFloor.Text     = ds.Tables["tbRoom"].Rows[0].ItemArray[3].ToString();;
            txtprice.Text     = ds.Tables["tbRoom"].Rows[0].ItemArray[7].ToString();;
            txtTotalBed.Text  = ds.Tables["tbRoom"].Rows[0].ItemArray[6].ToString();;
            cmbBuiding.Text   = ds.Tables["tbRoom"].Rows[0].ItemArray[2].ToString();;
            cmbRoomTID.Text   = ds.Tables["tbRoom"].Rows[0].ItemArray[4].ToString();;
            cmbRType.Text     = ds.Tables["tbRoom"].Rows[0].ItemArray[5].ToString();;
        }
コード例 #24
0
ファイル: RoomModule.cs プロジェクト: khinseakheng/HMS
        public void RoomModule_Load(object sender, EventArgs e)
        {
            listViewShow lst = new listViewShow();

            lst.ShowData("select RoomNo from tbRoom", "RoomNo", lstView);

            dbConnection dbcon = new dbConnection();

            dbcon.OpenConection();
            SqlDataReader dr = dbcon.DataReader("select RType from tbRoomType");

            dr.Read();
            if (dr.HasRows)

            {
                cmbRType.Items.Add(dr["RType"]).ToString();
                while (dr.Read())
                {
                    cmbRType.Items.Add(dr["RType"]).ToString();
                }
            }
        }
コード例 #25
0
ファイル: AutoID.cs プロジェクト: khinseakheng/HMS
        public int getID(string Selectstatment, string ColumName)
        {
            dbConnection dbcon = new dbConnection();

            dbcon.OpenConection();
            SqlDataReader dr = dbcon.DataReader(Selectstatment);

            dr.Read();
            string ID = null;

            if (dr.HasRows)
            {
                ID = dr[ColumName].ToString();
                if (ID == null)
                {
                    int y = 1;
                    return(y);
                }

                while (dr.Read())
                {
                    ID = dr[ColumName].ToString();
                }
                if (ID == null)
                {
                    int y = 2;
                    return(y);
                }
                if (ID != null)
                {
                    int y = Int32.Parse(ID) + 1;
                    return(y);
                }
            }

            return(1);
        }
コード例 #26
0
        private void RoomType_Load(object sender, EventArgs e)
        {
            dbConnection dbcon = new dbConnection();

            dbcon.DataAdapter("select * from tbRoomType", dataView);
        }