示例#1
0
 private void buttonOK_Click(object sender, EventArgs e)
 {
     if (textBoxID_Kho.Text != "" && textBoxTen.Text != "" && comboBoxTrangThai.SelectedIndex != -1 && comboBoxKhuVuc.SelectedIndex != -1 && textBoxDienTich.Text != "")
     {
         Kho s = new Kho
         {
             ID_Kho    = Convert.ToInt32(textBoxID_Kho.Text),
             Ten       = textBoxTen.Text,
             Dientich  = Convert.ToDouble(textBoxDienTich.Text),
             Trangthai = comboBoxTrangThai.SelectedItem.ToString(),
             ID_KhuVuc = ((CBBItem)comboBoxKhuVuc.SelectedItem).Value
         };
         if (this.ID_Kho == -1)
         {
             if (CSDL_OOP.Instance.AddKho(s))
             {
                 MessageBox.Show("Add Success!");
                 this.Close();
             }
             else
             {
                 MessageBox.Show("Add Fail!");
             }
         }
         else
         {
             CSDL_OOP.Instance.UpdateKho(s);
             MessageBox.Show("Update Success!");
             this.Close();
         }
         this.d(0, "");
     }
 }
示例#2
0
 public void AddDataRow(Kho s)
     {
         DataRow dr = DSKho.NewRow();
         dr["ID_Kho"] = s.ID_Kho;
         dr["Ten"] = s.Ten;
         dr["Dientich"] = s.Dientich;
         dr["Trangthai"] = s.Trangthai;
         dr["ID_KhuVuc"] = s.ID_KhuVuc;
         DSKho.Rows.Add(dr);
     }
示例#3
0
        private void buttonDelete_Click(object sender, EventArgs e)
        {
            DataGridViewSelectedRowCollection data = dataGridViewQLK.SelectedRows;

            if (data.Count == 1)
            {
                int ID_Kho = Convert.ToInt32(data[0].Cells["ID_Kho"].Value.ToString());
                Kho s      = CSDL_OOP.Instance.GetKhoByID_Kho(ID_Kho);
                CSDL_OOP.Instance.DeleteKho(s);
            }
            Show(0, textBoxSearch.Text);
        }
示例#4
0
 public void UpdateKho(Kho k)
 {
     foreach (DataRow r in CSDL.Instance.DSKho.Rows)
     {
         if ((int)r["ID_Kho"] == k.ID_Kho)
         {
             r["Ten"]       = k.Ten;
             r["dienTich"]  = k.Dientich;
             r["TrangThai"] = k.Trangthai;
             r["ID_KhuVuc"] = k.ID_KhuVuc;
         }
     }
 }
示例#5
0
        public Kho GetKhoByID_Kho(int ID_Kho)
        {
            Kho s = new Kho();

            foreach (Kho i in GetAllKho())
            {
                if (i.ID_Kho == ID_Kho)
                {
                    s = i;
                }
            }
            return(s);
        }
示例#6
0
        public bool AddKho(Kho k)
        {
            bool b = false;

            if (this.FindKho(k.ID_Kho) == null)
            {
                DataRow dr = CSDL.Instance.DSKho.NewRow();
                dr["ID_Kho"]    = k.ID_Kho;
                dr["Ten"]       = k.Ten;
                dr["DienTich"]  = k.Dientich;
                dr["TrangThai"] = k.Trangthai;
                dr["ID_KhuVuc"] = k.ID_KhuVuc;
                CSDL.Instance.DSKho.Rows.Add(dr);
                b = true;
            }
            return(b);
        }
示例#7
0
 public void RemoveDataRow(Kho s)
     {
         try
         {
             foreach (DataRow i in DSKho.Rows)
             {
                 //if (i["ID_Kho"].ToString() == s.ID_Kho)
                 if(Convert.ToInt32(i["ID_Kho"].ToString()) == s.ID_Kho)
                 {
                     DSKho.Rows.Remove(i);
                 }
             }
             DSKho.AcceptChanges();
         }
         catch (Exception)
         {
         }
     }
示例#8
0
        public List <Kho> SortKho(int idkho, string ten, MyCompare cmp)
        {
            List <Kho> data = GetListKho(idkho, ten);

            for (int i = 0; i < data.Count - 1; ++i)
            {
                for (int j = i + 1; j < data.Count; ++j)
                {
                    if (cmp(data[i], data[j]))
                    {
                        Kho temp = data[i];
                        data[i] = data[j];
                        data[j] = temp;
                    }
                }
            }
            return(data);
        }
示例#9
0
        private void buttonEdit_Click(object sender, EventArgs e)
        {
            //DataGridViewSelectedRowCollection data = dataGridViewQLK.SelectedRows;
            //if (data.Count == 1)
            //{
            //    int ID_Kho = Convert.ToInt32(data[0].Cells["ID_Kho"].Value.ToString());
            //    Form2 EDIT = new Form2(ID_Kho);
            //    EDIT.ShowDialog();
            //    Show(0, textBoxSearch.Text);

            if (dataGridViewQLK.SelectedRows.Count == 1)
            {
                int   k   = (int)dataGridViewQLK.SelectedRows[0].Cells["ID_Kho"].Value;
                Kho   kho = CSDL_OOP.Instance.FindKho(k);
                Form2 f2  = new Form2(kho.ID_Kho);
                f2.d = new Form2.mydelegate(Show);
                f2.Show();
            }
        }
示例#10
0
        public void ExecuteDB(Kho s)
        {
            bool check = false;

            foreach (Kho i in GetAllKho())
            {
                if (s.ID_Kho == i.ID_Kho)
                {
                    check = true;
                }
            }
            if (check)
            {
                CSDL.Instance.EditDataRow(s);
            }
            else
            {
                CSDL.Instance.AddDataRow(s);
            }
        }
示例#11
0
        public void EditDataRow(Kho s)
            {
                try
                {
                    foreach (DataRow i in DSKho.Rows)
                    {
                        if (Convert.ToInt32(i["ID_Kho"].ToString()) == s.ID_Kho)
                        {
                            i["Ten"] = s.Ten;
                            i["Dientich"] = s.Dientich;
                            i["Trangthai"] = s.Trangthai;
                            i["ID_KhuVuc"] = s.ID_KhuVuc;

                        }
                    }
                }
                catch (Exception)
                {
                }

            }
示例#12
0
        public void ADDANDEDIT()
        {
            Kho s = CSDL_OOP.Instance.FindKho(this.ID_Kho);

            if (s != null)
            {
                this.textBoxID_Kho.Text = s.ID_Kho.ToString();
                this.textBoxTen.Text    = s.Ten;
                foreach (KhuVuc K in CSDL_OOP.Instance.GetAllKhuVuc())
                {
                    comboBoxKhuVuc.Items.Add(new CBBItem {
                        Value = K.ID_KV, Text = K.Diachi
                    });
                    if (s.ID_KhuVuc == K.ID_KV)
                    {
                        comboBoxKhuVuc.SelectedItem = comboBoxKhuVuc.Items[comboBoxKhuVuc.Items.Count - 1];
                    }
                }
                this.textBoxDienTich.Text = s.Dientich.ToString();
                this.comboBoxTrangThai.Items.Add("Full");
                this.comboBoxTrangThai.Items.Add("Not Full");
                this.comboBoxTrangThai.Items.Add("KHD");
                this.comboBoxTrangThai.Text = s.Trangthai;
                this.textBoxID_Kho.Enabled  = false;
            }
            else
            {
                foreach (KhuVuc K in CSDL_OOP.Instance.GetAllKhuVuc())
                {
                    comboBoxKhuVuc.Items.Add(new CBBItem {
                        Value = K.ID_KV, Text = K.Diachi
                    });
                }
                this.comboBoxTrangThai.Items.Add("Full");
                this.comboBoxTrangThai.Items.Add("Not Full");
                this.comboBoxTrangThai.Items.Add("KHD");
            }
        }
示例#13
0
 public void DeleteKho(Kho ID_Kho)
 {
     CSDL.Instance.RemoveDataRow(ID_Kho);
 }