private void UpdateHangMuc(DataTable _tblHangMuc, int _maCongTrinh, string _maHieuCT)
{
if (_tblHangMuc.Rows.Count > 0)
{
foreach (DataRow dr in _tblHangMuc.Rows)
{
BLL_HangMuc adapter = new BLL_HangMuc();
HangMuc _hangmuc = new HangMuc();
_hangmuc.MaCongTrinh = _maCongTrinh;
_hangmuc.MaHieuCT = _maHieuCT;
_hangmuc.TenHangMuc = dr["TenHangMuc"].ToString();
_hangmuc.SoLuong = string.IsNullOrEmpty(dr["SoLuong"].ToString()) ? 0 : Convert.ToInt32(dr["SoLuong"]);
_hangmuc.DonGia = string.IsNullOrEmpty(dr["DonGia"].ToString()) ? 0 : Convert.ToDecimal(dr["DonGia"]);
_hangmuc.NguoiTao = SessionUser.UserName;
int _maHangMuc = 0;
string _id = dr["ID"].ToString();
if (dr["MaHangMuc"].ToString().Equals(string.Empty))
{
_maHangMuc = adapter.Add(_hangmuc);
}
else
{
_maHangMuc = Convert.ToInt32(dr["MaHangMuc"]);
_hangmuc.MaHangMuc = _maHangMuc;
adapter.Update(_hangmuc);
}
//them chi tiet hang muc
UpdateChiTietHangMuc(adapter, _ds.Tables["ChiTietHangMuc"], _maHangMuc, _id);
}
}
}
private void UpdateChiTietHangMuc(BLL_HangMuc adapter, DataTable _tblChiTiet, int _maHangMuc, string _id)
{
if (_tblChiTiet.Rows.Count > 0)
{
foreach (DataRow dr in _tblChiTiet.Select("ParentID = '" + _id + "'"))
{
ChiTietHangMuc _chitietHM = new ChiTietHangMuc();
_chitietHM.MaHangMuc = _maHangMuc;
_chitietHM.TenChiTiet = dr["TenChiTiet"].ToString();
_chitietHM.QuyCach = dr["QuyCach"].ToString();
_chitietHM.ChieuDai = string.IsNullOrEmpty(dr["ChieuDai"].ToString()) ? 0 : Convert.ToInt32(dr["ChieuDai"]);
_chitietHM.ChieuRong = string.IsNullOrEmpty(dr["ChieuRong"].ToString()) ? 0 : Convert.ToInt32(dr["ChieuRong"]);
_chitietHM.TyTrong = string.IsNullOrEmpty(dr["TyTrong"].ToString()) ? 0 : Convert.ToDecimal(dr["TyTrong"]);
_chitietHM.SoLuong = string.IsNullOrEmpty(dr["SoLuong"].ToString()) ? 0 : Convert.ToInt32(dr["SoLuong"]);
_chitietHM.TLDonVi = string.IsNullOrEmpty(dr["TLDonVi"].ToString()) ? 0 : Convert.ToDecimal(dr["TLDonVi"]);
_chitietHM.DonGia = string.IsNullOrEmpty(dr["DonGia"].ToString()) ? 0 : Convert.ToDecimal(dr["DonGia"]);
_chitietHM.GhiChu = dr["GhiChu"].ToString();
_chitietHM.NguoiTao = SessionUser.UserName;
if (dr["MaChiTietHM"].ToString().Equals(string.Empty))
{
adapter.ChiTiet_Add(_chitietHM);
}
else
{
_chitietHM.MaChiTietHM = Convert.ToInt32(dr["MaChiTietHM"]);
adapter.ChiTiet_Update(_chitietHM);
}
}
}
}
private void InitDataSetHangMuc(int maCongTrinh)
{
_ds = new DataSet();
BLL_HangMuc adapter = new BLL_HangMuc();
List <HangMuc> _listHM = new List <HangMuc>();
List <ChiTietHangMuc> _listCTHM = new List <ChiTietHangMuc>();
if (maCongTrinh > 0)
{
_listHM = adapter.GetList(maCongTrinh, string.Empty, string.Empty);
if (_listHM != null)
{
foreach (HangMuc _hm in _listHM)
{
List <ChiTietHangMuc> _temp1 = adapter.ChiTiet_GetList(_hm.MaHangMuc, string.Empty);
if (_temp1 != null)
{
_listCTHM.AddRange(_temp1);
}
}
}
else
{
_listHM = new List <HangMuc>();
}
}
DataTable _hangmuc = Utils.ToDataTable <HangMuc>(_listHM);
DataTable _chitiethangmuc = Utils.ToDataTable <ChiTietHangMuc>(_listCTHM);
DataColumn _column = new DataColumn();
_column.ColumnName = "ID";
_column.DataType = System.Type.GetType("System.String");
_column.DefaultValue = Guid.NewGuid();
_hangmuc.Columns.Add(_column);
_hangmuc.Columns.Add("Status", Type.GetType("System.String"));
foreach (DataRow dr in _hangmuc.Rows)
{
dr["ID"] = dr["MaHangMuc"];
dr["Status"] = 1;
}
_chitiethangmuc.Columns.Add("ParentID", Type.GetType("System.String"));
foreach (DataRow dr in _chitiethangmuc.Rows)
{
dr["ParentID"] = dr["MaHangMuc"];
}
_ds.Tables.Add(_hangmuc);
_ds.Tables.Add(_chitiethangmuc);
_ds.Relations.Add("HangMuc_ChiTietHangMuc",
_ds.Tables["HangMuc"].Columns["ID"],
_ds.Tables["ChiTietHangMuc"].Columns["ParentID"]);
flexHangMuc.SetDataBinding(_ds, "HangMuc");
}
private void SearchByCongTrinh(string keySearch, DateTime dtFormDate, DateTime dtToDate, int maKhachHang, string maTinhTrang)
{
DataSet _dsCT = new DataSet();
BLL_CongTrinh adapter = new BLL_CongTrinh();
BLL_HangMuc adapterHM = new BLL_HangMuc();
List <CongTrinh> _listCT = adapter.GetList(maKhachHang, maTinhTrang, dtFormDate, dtToDate, keySearch);
List <HangMuc> _listHM = new List <HangMuc>();
List <ChiTietHangMuc> _listCTHM = new List <ChiTietHangMuc>();
if (_listCT != null)
{
foreach (CongTrinh _ct in _listCT)
{
List <HangMuc> _temp = adapterHM.GetList(_ct.MaCongTrinh, string.Empty, string.Empty);
if (_temp != null)
{
_listHM.AddRange(_temp);
}
}
foreach (HangMuc _hm in _listHM)
{
List <ChiTietHangMuc> _temp1 = adapterHM.ChiTiet_GetList(_hm.MaHangMuc, string.Empty);
if (_temp1 != null)
{
_listCTHM.AddRange(_temp1);
}
}
}
else
{
_listCT = new List <CongTrinh>();
}
DataTable _congtrinh = Utils.ToDataTable <CongTrinh>(_listCT);
DataTable _hangmuc = Utils.ToDataTable <HangMuc>(_listHM);
DataTable _chitiethangmuc = Utils.ToDataTable <ChiTietHangMuc>(_listCTHM);
_congtrinh.ExtendedProperties.Add("ShowColumns", _showColumnCT);
_hangmuc.ExtendedProperties.Add("ShowColumns", _showColumnHM);
_chitiethangmuc.ExtendedProperties.Add("ShowColumns", _showColumnCTHM);
_dsCT.Tables.Add(_congtrinh);
_dsCT.Tables.Add(_hangmuc);
_dsCT.Tables.Add(_chitiethangmuc);
_dsCT.Relations.Add("CongTrinh_HangMuc",
_dsCT.Tables["CongTrinh"].Columns["MaCongTrinh"],
_dsCT.Tables["HangMuc"].Columns["MaCongTrinh"]);
_dsCT.Relations.Add("HangMuc_ChiTietHangMuc",
_dsCT.Tables["HangMuc"].Columns["MaHangMuc"],
_dsCT.Tables["ChiTietHangMuc"].Columns["MaHangMuc"]);
flexCongTrinh.SetDataBinding(_dsCT, "CongTrinh");
}
