public static void BindingKetCau(System.Windows.Forms.TreeView treeViewKetCau)
{
treeViewKetCau.Nodes.Clear();
BLL_KetCau obj = new BLL_KetCau();
List <NhomKetCau> dsNhom = obj.NhomKetCau_GetList(string.Empty);
if (dsNhom != null)
{
var listNhom = (from nhom in dsNhom
orderby nhom.SapXep
select nhom);
foreach (NhomKetCau n in listNhom)
{
System.Windows.Forms.TreeNode root = treeViewKetCau.Nodes.Add(n.MaNhomKetCau.ToString(), n.TenNhomKetCau);
List <KetCau> dsKetCau = obj.GetList(n.MaNhomKetCau, string.Empty);
if (dsKetCau != null)
{
foreach (KetCau kc in dsKetCau)
{
root.Nodes.Add(kc.MaKetCau.ToString(), kc.TenKetCau);
}
}
}
treeViewKetCau.ExpandAll();
}
}
private void ToolStripMenuItem_Edit_Click(object sender, EventArgs e)
{
ResetFormKC();
TreeNode node = treeViewKetCau.SelectedNode;
if (node == null)
{
return;
}
//chỉ edit khi node là Kết cấu
if (node.Level == 0)
{
return;
}
string s = node.Name;
if (int.Parse(s) > 0)
{
BLL_KetCau adapter = new BLL_KetCau();
KetCau _ketcau = adapter.GetByID(int.Parse(s));
txtTenKetCau.Text = _ketcau.TenKetCau;
txtMoTa.Text = _ketcau.MoTa;
cboNhomKetCau.SelectedValue = _ketcau.MaNhomKetCau;
lblMaKetCau.Text = _ketcau.MaKetCau.ToString();
}
}
private void BindingChiTietKetCau(int maKetCau)
{
dgvChiTietKetCau.DataSource = null;
BLL_KetCau adapter = new BLL_KetCau();
List <ChiTietKetCau> _list = adapter.ChiTiet_GetListByKetCauID(maKetCau);
if (_list != null)
{
dgvChiTietKetCau.DataSource = _list;
}
}
public static void BindingKetCau(System.Windows.Forms.ComboBox cboKetCau, int maNhomKetCau)
{
cboKetCau.Items.Clear();
BLL_KetCau obj = new BLL_KetCau();
List <KetCau> list = obj.GetList(maNhomKetCau, string.Empty);
if (list != null)
{
KetCau item = new KetCau();
item.MaKetCau = -1;
item.TenKetCau = "Kết cấu - chọn -";
list.Insert(0, item);
cboKetCau.DataSource = list;
cboKetCau.ValueMember = "MaKetCau";
cboKetCau.DisplayMember = "TenKetCau";
}
}
public static void BindingNhomKetCau(System.Windows.Forms.ComboBox cboNhomKetCau)
{
cboNhomKetCau.Items.Clear();
BLL_KetCau obj = new BLL_KetCau();
List <NhomKetCau> list = obj.NhomKetCau_GetList(string.Empty);
if (list != null)
{
NhomKetCau item = new NhomKetCau();
item.MaNhomKetCau = -1;
item.TenNhomKetCau = "Nhóm kết cấu - chọn nhóm";
list.Insert(0, item);
cboNhomKetCau.DataSource = list;
cboNhomKetCau.ValueMember = "MaNhomKetCau";
cboNhomKetCau.DisplayMember = "TenNhomKetCau";
}
}
private void BindingNhomKetCau()
{
BLL_KetCau adapter = new BLL_KetCau();
List <NhomKetCau> _list = adapter.NhomKetCau_GetList(string.Empty);
if (_list != null)
{
treeViewNhomKC.Nodes.Clear();
System.Windows.Forms.TreeNode root = treeViewNhomKC.Nodes.Add("-1", "Nhóm kết cấu - tất cả");
var list = (from item in _list
orderby item.SapXep
select item);
foreach (NhomKetCau o in list)
{
root.Nodes.Add(o.MaNhomKetCau.ToString(), o.TenNhomKetCau);
}
treeViewNhomKC.ExpandAll();
}
}
private void ToolStripMenuItem_Edit_Click(object sender, EventArgs e)
{
ResetFormNhomKC();
TreeNode node = treeViewNhomKC.SelectedNode;
if (node == null)
{
return;
}
string s = node.Name;
if (int.Parse(s) > 0)
{
BLL_KetCau adapter = new BLL_KetCau();
NhomKetCau _nhomketcau = adapter.NhomKetCau_GetByID(int.Parse(s));
txtTenNhomKetCau.Text = _nhomketcau.TenNhomKetCau;
txtSapXep.Text = _nhomketcau.SapXep.ToString();
txtMaNhomKetCau.Text = _nhomketcau.MaNhomKetCau.ToString();
}
}
private void btnAccept_Click(object sender, EventArgs e)
{
ChiTietKetCau chitiet = new ChiTietKetCau();
chitiet.TenChiTietKetCau = txtTenChiTiet.Text;
chitiet.MaKetCau = Convert.ToInt32(cboKetCau.SelectedValue);
chitiet.QuyCach = txtQuyCach.Text;
chitiet.ChieuDai = Convert.ToInt32(txtChieuDai.Text);
chitiet.ChieuRong = Convert.ToInt32(txtChieuRong.Text);
chitiet.TyTrong = Convert.ToDecimal(txtTyTrong.Text);
chitiet.Gia = Convert.ToDecimal(txtGia.Text);
chitiet.NguoiTao = SessionUser.UserName;
BLL_KetCau adapter = new BLL_KetCau();
int result = -1;
if (txtMaChiTiet.Text == string.Empty)
{
result = adapter.ChiTiet_Add(chitiet);
}
else
{
chitiet.MaChiTietKetCau = int.Parse(txtMaChiTiet.Text);
result = adapter.ChiTiet_Update(chitiet);
}
if (result >= 0)
{
ResetFormChiTietKC();
BindingChiTietKetCau(_ketcauId);
tabControl1.SelectedIndex = 0;
}
else
{
MessageBox.Show("Lỗi khi cập nhật chi tiết kết cấu", "Thông báo");
}
}
private void btnKetCau_Accept_Click(object sender, EventArgs e)
{
KetCau _ketcau = new KetCau();
_ketcau.TenKetCau = txtTenKetCau.Text;
_ketcau.MoTa = txtMoTa.Text;
_ketcau.NguoiTao = SessionUser.UserName;
_ketcau.MaNhomKetCau = Convert.ToInt32(cboNhomKetCau.SelectedValue);
BLL_KetCau adapter = new BLL_KetCau();
if (lblMaKetCau.Text == string.Empty)
{
adapter.Add(_ketcau);
}
else
{
_ketcau.MaKetCau = int.Parse(lblMaKetCau.Text);
adapter.Update(_ketcau);
}
ResetFormKC();
BindingData.BindingKetCau(treeViewKetCau);
}
private void btnAccept_Click(object sender, EventArgs e)
{
NhomKetCau _nhomketcau = new NhomKetCau();
_nhomketcau.TenNhomKetCau = txtTenNhomKetCau.Text;
_nhomketcau.SapXep = Convert.ToInt32(txtSapXep.Text);
_nhomketcau.NguoiTao = SessionUser.UserName;
BLL_KetCau apdater = new BLL_KetCau();
if (txtMaNhomKetCau.Text != "")
{
_nhomketcau.MaNhomKetCau = Convert.ToInt32(txtMaNhomKetCau.Text);
apdater.NhomKetCau_Update(_nhomketcau);
}
else
{
apdater.NhomKetCau_Add(_nhomketcau);
}
ResetFormNhomKC();
BindingNhomKetCau();
// refresh treeView
}
