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); }