private void khoiTao()
{
dictionaryDataSource = new Dictionary <string, Dictionary <string, HangHoaDataSource> >();
listLayoutHangHoa = new List <FlowLayoutPanel>();
listDictionaryHangHoa = new List <Dictionary <int, List <FoodLayout> > >();
TongCong = 0;
loaiHienTai = 1;
giamGia = 0.0f;
//txtGiamGia.Text = giamGia.ToString() + "%";
listFoodLayout = new List <FoodLayout>();
hashMaHangHoa = new HashSet <string>();
dGVHoaDon.AllowUserToAddRows = false;
bindingSource.Add(new HangHoaDataSource());
dGVHoaDon.DataSource = bindingSource;
bindingSource.RemoveAt(0);
dGVHoaDon.Columns["Ten"].HeaderText = "Tên";
dGVHoaDon.Columns["Gia"].HeaderText = "Giá";
dGVHoaDon.Columns["Soluong"].HeaderText = "Số lượng";
dGVHoaDon.Columns["Thanhtien"].HeaderText = "Thành tiền";
dGVHoaDon.Columns["DonViTinh"].HeaderText = "Đơn vị tính";
dGVHoaDon.Columns["Ma"].Visible = false;
dGVHoaDon.Columns["Loai"].Visible = false;
dGVHoaDon.Columns["IndexDict"].Visible = false;
dGVHoaDon.Columns["MaLoaiHangHoa"].Visible = false;
dGVHoaDon.Columns["TenLoaiHangHoa"].Visible = false;
dGVHoaDon.Columns["IndexList"].Visible = false;
dGVHoaDon.Columns["Gia"].ReadOnly = true;
dGVHoaDon.Columns["Ten"].ReadOnly = true;
dGVHoaDon.Columns["Thanhtien"].ReadOnly = true;
var grouper = new Subro.Controls.DataGridViewGrouper(dGVHoaDon);
grouper.SetGroupOn("MaLoaiHangHoa");
//grouper.Options.GroupSortOrder = SortOrder.None;
grouper.DisplayGroup += grouper_DisplayGroup;
//lấy danh sách loại sản phẩm đưa vào tabcontrol lớn
List <LoaiHangHoa> listLoaiHangHoa = BUS.HangHoaBUS.XemLoaiMon(1);
if (listLoaiHangHoa != null)
{
//tabControl.TabPages.Clear();
for (int i = 0; i < listLoaiHangHoa.Count; i++)
{
FlowLayoutPanel flowFoodLayout = new FlowLayoutPanel();
flowFoodLayout.Dock = DockStyle.Fill;
listLayoutHangHoa.Add(flowFoodLayout);
Dictionary <int, List <FoodLayout> > dictionary = new Dictionary <int, List <FoodLayout> >();
TabPage tabPage = new TabPage(listLoaiHangHoa[i].Ten);
tabPage.Controls.Add(flowFoodLayout);
tabPage.Name = listLoaiHangHoa[i].Ma;
tabControl.TabPages.Add(tabPage);
listDictionaryHangHoa.Add(dictionary);
}
}
listTenGroup = new List <LoaiHangHoa>();
listTenGroup.AddRange(BUS.HangHoaBUS.XemLoaiMon(2));
if (listTenGroup != null)
{
for (int i = 0; i < listTenGroup.Count; i++)
{
dictionaryDataSource.Add(listTenGroup[i].Ten, new Dictionary <string, HangHoaDataSource>());
}
}
List <HangHoaDataSource> temp = BUS.SanPhamBUS.XemChiTietPhieuNhapSanPham(phieuNhapHang.SoPhieu);
if (temp != null)
{
uint tongCong = 0;
for (int i = 0; i < temp.Count; i++)
{
hashMaHangHoa.Add(temp[i].Ma);
dictionaryDataSource[temp[i].TenLoaiHangHoa].Add(temp[i].Ma, temp[i]);
bindingSource.Add(temp[i]);
tongCong += uint.Parse(temp[i].Thanhtien);
}
TongCong = tongCong;
}
thayDoiLoai();
}
public override void Delete()
{
if (bdsDoiTuongNh.Position < 0)
{
return;
}
DataRow drCurrent = ((DataRowView)bdsDoiTuongNh.Current).Row;
if (!Common.MsgYes_No(Languages.GetLanguage("SURE_DELETE")))
{
return;
}
if (DataTool.SQLCheckExist("LIDOITUONGNH", "Ma_Nh_Dt_Cha", drCurrent["Ma_Nh_Dt"]))
{
string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ?
"Nhóm đối tượng: {" + drCurrent["Ten_Nh_Dt"].ToString() + "} đang có nhóm con" :
"Object group: {" + drCurrent["Ten_Nh_Dt"].ToString() + "} have child object group";
Common.MsgCancel(strMsg);
return;
}
if (DataTool.SQLCheckExist("LIDOITUONG", "Ma_Nh_Dt", drCurrent["Ma_Nh_Dt"]))
{
string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ?
"Nhóm đối tượng: {" + drCurrent["Ten_Nh_Dt"].ToString() + "} đang có đối tượng" :
"Object group : {" + drCurrent["Ten_Nh_Dt"].ToString() + "} have object";
Common.MsgCancel(strMsg);
return;
}
if (DataTool.SQLDelete("LIDOITUONGNH", drCurrent))
{
////Sync Delete----------
//string Is_Sync = Convert.ToString(SQLExec.ExecuteReturnValue("SELECT Parameter_Value FROM SYSPARAMETER WHERE Parameter_ID = 'SYNC_BEGIN'"));
//if (Is_Sync == "1")
//{
// SqlConnection sqlCon = SQLExecSync1.GetNewSQLConnectionSync1();
// if (sqlCon.State != ConnectionState.Open)
// {
// SQLExec.Execute("UPDATE SYSPARAMETER SET Parameter_Value = 0 WHERE Parameter_ID = 'SYNC_BEGIN'");
// string strMsg = Element.sysLanguage == enuLanguageType.Vietnamese ? "Quá trình đồng bộ đang bị gián đoạn. Vui lòng chờ trong ít phút !" : "The synchronization process is interrupted. Please wait a few minutes !";
// Common.MsgCancel(strMsg);
// }
// else
// {
// DataToolSync1.SQLDelete("LIDOITUONGNH", drCurrent);
// }
//}
////-----------------------
//Cập nhật History
htHistory["CODE"] = drCurrent[strCode];
htHistory["NAME"] = drCurrent[strName];
htHistory["UPDATE_TYPE"] = "D";
UpdateHistory();
bdsDoiTuongNh.RemoveAt(bdsDoiTuongNh.Position);
dtDoiTuongNh.AcceptChanges();
}
}
private void btnHuyMuc_Click(object sender, EventArgs e)
{
binding.RemoveAt(grv_TraDia.GetSelectedRows()[0]);
}
private void khoiTao()
{
enableControls(false);
cmbLoaiMon.DataSource = BUS.MonAnBUS.XemLoaiMon();
cmbLoaiMon.DisplayMember = "Ten";
cmbLoaiMonTK.DataSource = BUS.MonAnBUS.XemLoaiMon();
cmbLoaiMonTK.DisplayMember = "Ten";
dtNguyenLieu = new DataTable();
dGVMonAn.DataSource = dtNguyenLieu;
pageNumber = 1;
txtPageNumber.Text = "1";
totalPage = BUS.MonAnBUS.DemMonAn("", "");
totalPage = Utility.TinhKichThuocTrang(totalPage, pageSize);
txtTotalPage.Text = totalPage.ToString();
bindingSourceMonAn.DataSource = BUS.MonAnBUS.XemMonAnDataSource("", 0, pageNumber, pageSize);
dGVMonAn.DataSource = bindingSourceMonAn;
AddGridTableStyle();
dGVMonAn.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dGVMonAn.Columns["Ten"].HeaderText = "Tên";
dGVMonAn.Columns["Gia"].HeaderText = "Giá";
dGVMonAn.Columns["TenLoaiHangHoa"].HeaderText = "Loại hàng hóa";
dGVMonAn.Columns["Ma"].Visible = false;
dGVMonAn.Columns["MaLoaiHangHoa"].Visible = false;
dGVMonAn.Columns["AnhMinhHoa"].Visible = false;
// dGVMonAn.Columns["LoaiHangHoa"].
bindingSource.Add(new NguyenLieuMADataSource());
dGVNguyenLieu.DataSource = bindingSource;
bindingSource.RemoveAt(0);
dGVNguyenLieu.Columns["Ten"].HeaderText = "Tên";
dGVNguyenLieu.Columns["Gia"].HeaderText = "Giá";
dGVNguyenLieu.Columns["Soluong"].HeaderText = "Số lượng";
// dGVNguyenLieu.Columns["Thanhtien"].HeaderText = "Thành tiền";
dGVNguyenLieu.Columns["DonViTinh"].HeaderText = "Đơn vị tính";
dGVNguyenLieu.Columns["Ma"].Visible = false;
// dGVNguyenLieu.Columns["Loai"].Visible = false;
// dGVNguyenLieu.Columns["AnhMinhHoa"].Visible = false;
// dGVNguyenLieu.Columns["Thanhtien"].Visible = false;
dGVNguyenLieu.Columns["Gia"].ReadOnly = true;
dGVNguyenLieu.Columns["Ten"].ReadOnly = true;
// dGVNguyenLieu.Columns["Thanhtien"].ReadOnly = true;
bSua = false;
bThem = false;
}
private void khoiTao()
{
dictionaryDataSource = new Dictionary <string, Dictionary <string, HangHoaDataSource> >();
TongCong = 0;
giamGia = 0.0f;
//txtGiamGia.Text = giamGia.ToString() + "%";
hashMaHangHoa = new HashSet <string>();
dGVHoaDon.AllowUserToAddRows = false;
bindingSource.Add(new PhieuNhapHangDataSource());
dGVHoaDon.DataSource = bindingSource;
bindingSource.RemoveAt(0);
dGVHoaDon.Columns["Ten"].HeaderText = "Tên";
dGVHoaDon.Columns["Gia"].HeaderText = "Giá";
dGVHoaDon.Columns["Soluong"].HeaderText = "Số lượng";
dGVHoaDon.Columns["Thanhtien"].HeaderText = "Thành tiền";
dGVHoaDon.Columns["DonViTinh"].HeaderText = "Đơn vị tính";
dGVHoaDon.Columns["Ma"].Visible = false;
dGVHoaDon.Columns["Loai"].Visible = false;
dGVHoaDon.Columns["Gia"].ReadOnly = true;
dGVHoaDon.Columns["Ten"].ReadOnly = true;
dGVHoaDon.Columns["Thanhtien"].ReadOnly = true;
// var grouper = new Subro.Controls.DataGridViewGrouper(dGVHoaDon);
// grouper.SetGroupOn("MaLoaiHangHoa");
//grouper.Options.GroupSortOrder = SortOrder.None;
// grouper.DisplayGroup += grouper_DisplayGroup;
nguyenLieuSource.Add(BUS.NguyenLieuBUS.TimKiemDanhSachNguyenLieu("", nhaCungCap.MaNCC, false, 1, pageSize));
// nguyenLieuSource.da
bindingListNguyenLieu = new BindingList <DTO.NguyenLieu>(BUS.NguyenLieuBUS.TimKiemDanhSachNguyenLieu("", nhaCungCap.MaNCC, false, 1, pageSize));
dGVNguyenLieu.DataSource = bindingListNguyenLieu;
dGVNguyenLieu.Columns["Ten"].HeaderText = "Tên";
dGVNguyenLieu.Columns["Ma"].HeaderText = "Mã";
dGVNguyenLieu.Columns["Loai"].HeaderText = "Loại";
dGVNguyenLieu.Columns["NhaCungCap"].HeaderText = "Nhà cung cấp";
dGVNguyenLieu.Columns["DonViTinh"].HeaderText = "Đơn vị tinh";
dGVNguyenLieu.Columns["Dongia"].HeaderText = "Đơn giá";
dGVNguyenLieu.Columns["SoLuongTon"].HeaderText = "Số lượng tồn";
dGVNguyenLieu.Columns["SoLuongToiThieu"].Visible = false;
List <PhieuNhapHangDataSource> temp = BUS.NguyenLieuBUS.XemChiTietPhieuNhapNguyenlieu(phieuNhapHang.SoPhieu);
if (temp != null)
{
uint tongCong = 0;
for (int i = 0; i < temp.Count; i++)
{
hashMaHangHoa.Add(temp[i].Ma);
bindingSource.Add(temp[i]);
tongCong += uint.Parse(temp[i].Thanhtien);
}
TongCong = tongCong;
}
//listTenGroup = new List<LoaiHangHoa>();
//listTenGroup.AddRange(BUS.HangHoaBUS.XemLoaiMon(2));
//if (listTenGroup != null)
//{
// for (int i = 0; i < listTenGroup.Count; i++)
// {
// dictionaryDataSource.Add(listTenGroup[i].Ten, new Dictionary<string, HangHoaDataSource>());
// }
//}
//if (soHoaDon != "")
//{
// List<HangHoaDataSource> temp = BUS.HoaDonBUS.XemChiTietHoaDonGoiMon(soHoaDon);
// if (temp != null)
// {
// uint tongCong = 0;
// for (int i = 0; i < temp.Count; i++)
// {
// hashMaHangHoa.Add(temp[i].Ma);
// dictionaryDataSource[temp[i].TenLoaiHangHoa].Add(temp[i].Ma, temp[i]);
// bindingSource.Add(temp[i]);
// tongCong += uint.Parse(temp[i].Thanhtien);
// }
// TongCong = tongCong;
// }
//}
// thayDoiLoai();
}
private void CountMoney(BindingSource bs, DataGridView dg)
{
int haveHere = bs.Find("仓库", "总计");
if (haveHere > -1)
{
bs.RemoveAt(haveHere);
}
if (null == dg.CurrentRow)
{
return;
}
decimal sum_storemoney = 0;
decimal in_storemoney = 0;
decimal out_storemoney = 0;
decimal planout_money = 0;
decimal plan_storemoney = 0;
//decimal sum_accrual = 0;
//decimal sum_compensate_accrual = 0;
//decimal sum_left_accrual = 0;
foreach (DataGridViewRow dr in dg.Rows)
{
//if (System.DBNull.Value == dr.Cells["数量"].Value)
// sum_qty = sum_qty + 0;
//else
// sum_qty = sum_qty + decimal.Parse(dr.Cells["数量"].Value.ToString());
if ("总计" == dr.Cells["仓库"].Value.ToString())
{
dg.Rows.Remove(dr);
}
else
{
if (System.DBNull.Value == dr.Cells["库存金额"].Value)
{
sum_storemoney = sum_storemoney + 0;
}
else
{
sum_storemoney = sum_storemoney + decimal.Parse(dr.Cells["库存金额"].Value.ToString());
}
if (System.DBNull.Value == dr.Cells["入库金额"].Value)
{
in_storemoney = in_storemoney + 0;
}
else
{
in_storemoney = in_storemoney + decimal.Parse(dr.Cells["入库金额"].Value.ToString());
}
if (System.DBNull.Value == dr.Cells["出库金额"].Value)
{
out_storemoney = out_storemoney + 0;
}
else
{
out_storemoney = out_storemoney + decimal.Parse(dr.Cells["出库金额"].Value.ToString());
}
//////////////////////////////
if (System.DBNull.Value == dr.Cells["计划出库金额"].Value)
{
planout_money = planout_money + 0;
}
else
{
planout_money = planout_money + decimal.Parse(dr.Cells["计划出库金额"].Value.ToString());
}
if (System.DBNull.Value == dr.Cells["计划库存金额"].Value)
{
plan_storemoney = plan_storemoney + 0;
}
else
{
plan_storemoney = plan_storemoney + decimal.Parse(dr.Cells["计划库存金额"].Value.ToString());
}
}
//if (System.DBNull.Value == dr.Cells["采购金额"].Value)
// sum_buymoney = sum_buymoney + 0;
//else
// sum_buymoney = sum_buymoney + decimal.Parse(dr.Cells["采购金额"].Value.ToString());
//if (System.DBNull.Value == dr.Cells["利息"].Value)
// sum_accrual = sum_accrual + 0;
//else
// sum_accrual = sum_accrual + decimal.Parse(dr.Cells["利息"].Value.ToString());
//if (System.DBNull.Value == dr.Cells["还息"].Value)
// sum_compensate_accrual = sum_compensate_accrual + 0;
//else
// sum_compensate_accrual = sum_compensate_accrual + decimal.Parse(dr.Cells["还息"].Value.ToString());
//if (System.DBNull.Value == dr.Cells["欠息"].Value)
// sum_left_accrual = sum_left_accrual + 0;
//else
// sum_left_accrual = sum_left_accrual + decimal.Parse(dr.Cells["欠息"].Value.ToString());
}
bs.AddNew();
dg.CurrentRow.Cells["仓库"].Value = "总计";
dg.CurrentRow.Cells["库存金额"].Value = sum_storemoney;
dg.CurrentRow.Cells["入库金额"].Value = in_storemoney;
dg.CurrentRow.Cells["出库金额"].Value = out_storemoney;
dg.CurrentRow.Cells["计划出库金额"].Value = planout_money;
dg.CurrentRow.Cells["计划库存金额"].Value = plan_storemoney;
dg.CurrentRow.Cells["物资编号"].Value = "---";
dg.CurrentRow.Cells["库存底线"].Value = -1;
dg.CurrentRow.Cells["库存警戒"].Value = 0;
//dg.CurrentRow.Cells["欠息"].Value = sum_left_accrual;
bs.EndEdit();
bs.Position = 0;
}
private void AddSummationRow_New(BindingSource bs, DataGridView dgv)
{
//InitializeApp();
//return;
DataRow sumdr = (((DataSet)bs.DataSource).Tables[bs.DataMember]).NewRow();
if (-1 != bs.Find("合同编号", "_合计"))
{
bs.RemoveAt(bs.Find("合同编号", "_合计"));
}
foreach (DataGridViewRow dgvRow in dgv.Rows)
{
foreach (DataGridViewCell dgvCell in dgvRow.Cells)
{
//foreach (DataGridViewColumn dgvColumn in dgv.Columns)
//{
if (dgvCell.Value != null && !(dgvCell.Value is DBNull))
{
if (IsInteger(dgvCell.Value))
{
if ("年份" != dgvCell.OwningColumn.HeaderText && "月份" != dgvCell.OwningColumn.HeaderText)
{
if (sumdr[dgvCell.OwningColumn.DataPropertyName] == null || (sumdr[dgvCell.OwningColumn.DataPropertyName] is DBNull))
{
sumdr[dgvCell.OwningColumn.DataPropertyName] = 0;
}
sumdr[dgvCell.OwningColumn.DataPropertyName] = Convert.ToInt64(sumdr[dgvCell.OwningColumn.DataPropertyName]) + Convert.ToInt64(dgvCell.Value);
}
}
else if (IsDecimal(dgvCell.Value))
{
if ("年份" != dgvCell.OwningColumn.HeaderText && "月份" != dgvCell.OwningColumn.HeaderText)
{
if (sumdr[dgvCell.OwningColumn.DataPropertyName] == null || (sumdr[dgvCell.OwningColumn.DataPropertyName] is DBNull))
{
sumdr[dgvCell.OwningColumn.DataPropertyName] = 0;
}
//dgvCell .OwningColumn.Name dgvCell.ColumnIndex
sumdr[dgvCell.OwningColumn.DataPropertyName] = Convert.ToDecimal(sumdr[dgvCell.OwningColumn.DataPropertyName]) + Convert.ToDecimal(dgvCell.Value);
}
}
//sumBox.Text = string.Format("{0}", sumBox.Tag);
//sumBox.Invalidate();
}
//}
}
}
//sumdr["sumorder"] = "02";
sumdr["合同编号"] = "_合计";
sumdr["id"] = -999;
//sumdr["税务"] = "";
((DataSet)bs.DataSource).Tables[bs.DataMember].Rows.Add(sumdr);
bs.ResetBindings(true);
}