void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn đơn hàng để gia hạn", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); //add du lieu vao danh sach foreach (DataRow dr in drs) { gvMain.AddNewRow(); gvMain.UpdateCurrentRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTDHID"], dr["DTDHID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoDH"], dr["SoDH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaKH"], dr["MaKH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["TenHang"], dr["tenhh"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["LoaiDH"], dr["Loai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Dai"], dr["Dai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Rong"], dr["Rong"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Cao"], dr["Cao"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgayNhapKho"], dr["NgayNhapKho"]); } gvMain.RefreshData(); }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn đơn hàng", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); //add du lieu vao danh sach DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; foreach (DataRow dr in drs) { if (dtDTKH.Select(string.Format("MT42ID = '{0}' and DT41ID = '{1}'", drCur["MT42ID"], dr["DT41ID"])).Length > 0) { continue; } gvMain.AddNewRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["DT41ID"], dr["DT41ID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoDH"], dr["SoCT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgayDH"], dr["NgayCT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaNL"], dr["MaNL"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DonGia"], dr["DonGia"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NoiDungCt"], dr["GhiChu"]); gvMain.UpdateCurrentRow(); } }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn hàng để nhập", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); //add du lieu vao danh sach DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; foreach (DataRow dr in drs) { gvMain.AddNewRow(); gvMain.UpdateCurrentRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaNL"], dr["MaNL"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoLuong"], dr["SL nhập"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaCuon"], dr["MaCuon"]); } gvMain.RefreshData(); }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn nguyên liệu", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); //add du lieu vao danh sach DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; string pk = _data.DrTableMaster["Pk"].ToString(); foreach (DataRow dr in drs) { if (dtDTKH.Select(string.Format(pk + " = '{0}' and MaNL = '{1}'", drCur[pk], dr["Ma"])).Length > 0) { continue; } gvMain.AddNewRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaNL"], dr["Ma"]); gvMain.UpdateCurrentRow(); } }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); frmDS.Close(); DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; string pk = _data.DrTableMaster["Pk"].ToString(); string masterId = drCur[pk].ToString(); string sophieudn = ""; foreach (DataRow dr in drs) { gvMain.AddNewRow(); gvMain.UpdateCurrentRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["MTMHID"], masterId); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoLuong"], dr["SoLuong"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DonGia"], dr["DonGia"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["ThanhTien"], dr["ThanhTien"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaPX"], dr["MaPX"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaMay"], dr["MaMay"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaVT"], dr["MaVT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["GhiChu"], dr["GhiChu"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTDNID"], dr["DTDNID"].ToString()); sophieudn += "," + dr["SoPhieu"]; } }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn lệnh sản xuất", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); DataTable dtDTNPhoi = (_data.BsMain.DataSource as DataSet).Tables[1]; using (DataTable tmp = dtDTNPhoi.Clone()) { foreach (DataRow dr in drs) { if (dtDTNPhoi.Select(string.Format("MTID = '{0}' and DTDHID = '{1}' and SoLSX='{2}'", drCur["MTID"], dr["DTDHID"], dr["SoLSX"])).Length > 0) { continue; } gvMain.AddNewRow(); gvMain.UpdateCurrentRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTDHID"], dr["DTDHID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaHH"], dr["mahh"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MTID"], drCur["MTID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTID"], Guid.NewGuid()); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoLSX"], dr["SoLSX"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoDH"], dr["Số đơn hàng"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgayDH"], dr["Ngày"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaKH"], dr["MaKH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["TenHang"], dr["TenHang"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Loai"], dr["Loai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Lop"], dr["Lop"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Dai"], dr["Dai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Rong"], dr["Rong"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Cao"], dr["Cao"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoLuongPS"], dr["SL xuất"]); //gvMain.SetFocusedRowCellValue(gvMain.Columns["SoLuong"], dr["SL tồn"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SLDangTon"], dr["SL tồn"]); } //foreach (DataRow dr in tmp.Rows) //{ // if (dtDTNPhoi.Select(string.Format("MTID = '{0}' and DTID = '{1}'", drCur["MTID"], dr["DTID"])).Length > 0) // continue; // dr["MTID"] = drCur["MTID"]; // dr["DTID"] = Guid.NewGuid(); // DataRow drNew = dtDTNPhoi.NewRow(); // drNew.ItemArray = (object[])dr.ItemArray.Clone(); // dtDTNPhoi.Rows.Add(drNew); //} } }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn lệnh sản xuất", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; using (DataTable tmp = dtDTKH.Clone()) { tmp.PrimaryKey = null; tmp.Columns["DTKHID"].AllowDBNull = true; tmp.Columns["DTKHID"].Unique = false; foreach (DataRow dr in drs) { tmp.ImportRow(dr); tmp.Rows[tmp.Rows.Count - 1]["SoLuong"] = dr["SL đặt"]; tmp.Rows[tmp.Rows.Count - 1]["KyThuat"] = dr["Kỹ thuật"]; tmp.Rows[tmp.Rows.Count - 1]["IsIn"] = dr["In"]; tmp.Rows[tmp.Rows.Count - 1]["IsChap"] = dr["Chạp"]; tmp.Rows[tmp.Rows.Count - 1]["IsDongGhim"] = dr["Đóng ghim"]; tmp.Rows[tmp.Rows.Count - 1]["IsPhu"] = dr["Độ phủ"]; tmp.Rows[tmp.Rows.Count - 1]["IsDan"] = dr["Dan"]; tmp.Rows[tmp.Rows.Count - 1]["Dao"] = dr["Cắt dọc"]; tmp.Rows[tmp.Rows.Count - 1]["IsBoi"] = dr["Bồi"]; } decimal n = gvMain.DataRowCount == 0 ? 0 : (decimal)gvMain.GetRowCellValue(gvMain.DataRowCount - 1, "Stt"); foreach (DataRow dr in tmp.Rows) { if (dtDTKH.Select(string.Format("MTKHID = '{0}' and DTLSXID = '{1}'", drCur["MTKHID"], dr["DTLSXID"])).Length > 0) { continue; } n++; dr["MTKHID"] = drCur["MTKHID"]; dr["DTKHID"] = Guid.NewGuid(); dr["HT"] = false; dr["isKho"] = false; dr["isCB"] = false; dr["Stt"] = n; DataRow drNew = dtDTKH.NewRow(); drNew.ItemArray = (object[])dr.ItemArray.Clone(); dtDTKH.Rows.Add(drNew); if (drNew["Dao"].ToString() != "" && decimal.Parse(drNew["Dao"].ToString()) != 0) { drNew["SoTam"] = decimal.Parse(drNew["SoLuong"].ToString()) / decimal.Parse(drNew["Dao"].ToString()); } if (drNew["SoTam"].ToString() != "") { drNew["SoMT"] = decimal.Parse(drNew["SoTam"].ToString()) * decimal.Parse(drNew["ChDai"].ToString()) / 100; } } } }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn đơn hàng", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; using (DataTable tmp = dtDTKH.Clone()) { tmp.PrimaryKey = null; tmp.Columns["DT22ID"].AllowDBNull = true; tmp.Columns["DT22ID"].Unique = false; foreach (DataRow dr in drs) { tmp.ImportRow(dr); tmp.Rows[tmp.Rows.Count - 1]["SoLuong"] = dr["SLHT"]; } foreach (DataRow dr in tmp.Rows) { if (dtDTKH.Select(string.Format("MT22ID = '{0}' and DTDHID = '{1}'", drCur["MT22ID"], dr["DTDHID"])).Length > 0) { continue; } gvMain.AddNewRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaHH"], dr["MaHH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["TenHang"], dr["TenHang"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoDH"], dr["SoDH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgayDH"], dr["NgayDH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DVT"], dr["DVT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["QuyCach"], dr["QuyCach"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaKH"], dr["MaKH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DonGia"], dr["DonGia"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Dai"], dr["Dai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Rong"], dr["Rong"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTDHID"], dr["DTDHID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Loai"], dr["Loai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NoiDungCt"], dr["NoiDungCt"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoLuong"], dr["SoLuong"]); //gvMain.SetFocusedRowCellValue(gvMain.Columns["MT22ID"], dr["MT22ID"]); //gvMain.SetFocusedRowCellValue(gvMain.Columns["MT22ID"], Guid.NewGuid()); gvMain.UpdateCurrentRow(); //dr["MT22ID"] = drCur["MT22ID"]; //dr["DT22ID"] = Guid.NewGuid(); //DataRow drNew = dtDTKH.NewRow(); //dtDTKH.Rows.Add(drNew); //drNew.ItemArray = (object[])dr.ItemArray.Clone(); } } }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn lệnh sản xuất", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; using (DataTable tmp = dtDTKH.Clone()) { tmp.PrimaryKey = null; tmp.Columns["DTKHID"].AllowDBNull = true; foreach (DataRow dr in drs) { tmp.ImportRow(dr); } decimal n = gvMain.DataRowCount == 0 ? 0 : (decimal)gvMain.GetRowCellValue(gvMain.DataRowCount - 1, "Stt"); foreach (DataRow dr in tmp.Rows) { if (dtDTKH.Select(string.Format("MTKHID = '{0}' and DTLSXID = '{1}'", drCur["MTKHID"], dr["DTLSXID"])).Length > 0) { continue; } n++; gvMain.AddNewRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTKHID"], Guid.NewGuid()); gvMain.SetFocusedRowCellValue(gvMain.Columns["Stt"], n); gvMain.SetFocusedRowCellValue(gvMain.Columns["TenHang"], dr["TenHang"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaKH"], dr["MaKH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["TenTat"], dr["TenTat"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoLSX"], dr["SoLSX"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgayLSX"], dr["NgayLSX"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["GhiChu"], dr["GhiChu"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Loai"], dr["Loai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["QuyCach"], dr["QuyCach"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["THS"], dr["THS"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["GHIM"], dr["Ghim"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Dan"], dr["Dan"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["HT"], false); //đưa 2 lệnh set ID này vào đây để tăng tốc xử lý gvMain.SetFocusedRowCellValue(gvMain.Columns["MTKHID"], drCur["MTKHID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTLSXID"], dr["DTLSXID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SLSX"], dr["SLSX"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoLuong"], dr["SoLuong"]); gvMain.UpdateCurrentRow(); } } }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn đơn hàng", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); //add du lieu vao danh sach hang xuat DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; foreach (DataRow dr in drs) { //kiểm tra tên hàng có dấu nháy string strTenH = ""; string[] strTenHang = dr["TenHang"].ToString().Split('\''); for (int i = 0; i < strTenHang.Length; i++) { if ((i == strTenHang.Length - 1) || strTenHang[i] == "") { strTenH += strTenHang[i]; } else { strTenH += strTenHang[i] + "''"; } } if (dtDTKH.Select(string.Format("MT32ID = '{0}' and DTDHID = '{1}' and Loi = {2} and TenHang = '{3}'" , drCur["MT32ID"], dr["DTDHID"], dr["Loi"], strTenH)).Length > 0) { continue; } addNewRow(dr, 0); } }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn phiếu để nhập hàng trả", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); //add du lieu vao danh sach DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; foreach (DataRow dr in drs) { if (dtDTKH.Select(string.Format("MT23ID = '{0}' and DT32ID = '{1}'", drCur["MT23ID"], dr["DT32ID"])).Length > 0) { continue; } gvMain.AddNewRow(); gvMain.UpdateCurrentRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTDHID"], dr["DTDHID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoPBH"], dr["SoCT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgayPBH"], dr["NgayCT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaHH"], dr["MaHH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["TenHang"], dr["TenHang"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DVT"], dr["DVT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Loi"], dr["Loi"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DonGia"], dr["DonGia"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DT32ID"], dr["DT32ID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Loai"], dr["Loai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Dai"], dr["Dai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Rong"], dr["Rong"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoLSX"], dr["SoLSX"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgaySXCD1"], dr["NgaySXCD1"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgaySXCD2"], dr["NgaySXCD2"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["CASX"], dr["CASX"]); } }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDSHV = (gvDSHV.DataSource as DataView).Table; dtDSHV.AcceptChanges(); DataRow[] drDSHV = dtDSHV.Select("Chọn = 1"); if (drDSHV.Length == 0) { XtraMessageBox.Show("Vui lòng chọn học viên đề nghị khai giảng.", Config.GetValue("PackageName").ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); return; } rpDSHV.Close(); DataTable dtDTDNKH = (data.BsMain.DataSource as DataSet).Tables[1]; DataView dv = new DataView(dtDTDNKH); drCur = (data.BsMain.Current as DataRowView).Row; dv.RowFilter = "MTKGID = '" + drCur["MTKGID"].ToString() + "'"; dtDTDNKH = dv.ToTable(); foreach (DataRow dr in drDSHV) { if (!CheckExists(dtDTDNKH, dr["ID"].ToString(), (int)dr["HVTVID"])) { continue; } gvMain.AddNewRow(); gvMain.UpdateCurrentRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTKGID"], Guid.NewGuid()); gvMain.SetFocusedRowCellValue(gvMain.Columns["MTKGID"], drCur["MTKGID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTDKID"], dr["ID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["HVTVID"], dr["HVTVID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaCD"], dr["MaCD"]); } drCur["SiSo"] = gvMain.DataRowCount; }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); if (!dtDS.Columns.Contains("SL còn")) { dtDS.Columns.Add("SL còn", typeof(Decimal), "[SL tồn] - [SL tồn cuối]"); } DataRow[] drs = dtDS.Select("Chọn = 1 and [SL còn] < 0"); if (drs.Length > 0) { XtraMessageBox.Show("Số tồn cuối không được vượt quá số tồn đầu (" + drs[0]["MaNL"].ToString() + ")", Config.GetValue("PackageName").ToString()); gvDS.FocusedRowHandle = gvDS.GetRowHandle(dtDS.Rows.IndexOf(drs[0])); return; } drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn hàng để xuất", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); //add du lieu vao danh sach DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; string pk = _data.DrTableMaster["Pk"].ToString(); string dg = tb == "MT43" ? "DonGia" : "DGNhap"; //LẤY COLUMNS GROUP string sql = string.Format(@"SELECT * FROM sysField f INNER JOIN sysTable t ON f.sysTableID = t.sysTableID where t.TableName = '{0}' AND sysPackageID = 12 AND IsGroupCol =1", tb.Replace("MT", "DT")); DataTable dtTable = data.GetDataTable(sql); //XÓA GROUP gvMain.ClearGrouping(); foreach (DataRow dr in drs) { if (dtDTKH.Select(string.Format(pk + " = '{0}' and DT42ID = '{1}'", drCur[pk], dr["DT42ID"])).Length > 0) { continue; } gvMain.AddNewRow(); gvMain.UpdateCurrentRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaNCC"], dr["MaNCC"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoPN"], dr["SoCT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgayPN"], dr["NgayCT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaNL"], dr["MaNL"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DL"], dr["DL"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SLNhap"], dr["SL nhập"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoLuong"], dr["SL còn"]); gvMain.SetFocusedRowCellValue(gvMain.Columns[dg], dr["DonGia"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DT42ID"], dr["DT42ID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaCuon"], dr["MaCuon"]); } gvMain.RefreshData(); //GROUP LẠI foreach (DataRow i in dtTable.Rows) { gvMain.Columns.ColumnByFieldName(i["FieldName"].ToString()).Group(); } gvMain.RefreshData(); }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn đơn hàng", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); //add du lieu vao danh sach hang xuat DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; foreach (DataRow dr in drs) { //kiểm tra tên hàng có dấu nháy string strTenH = ""; string[] strTenHang = dr["TenHang"].ToString().Split('\''); for (int i = 0; i < strTenHang.Length; i++) { if ((i == strTenHang.Length - 1) || strTenHang[i] == "") { strTenH += strTenHang[i]; } else { strTenH += strTenHang[i] + "''"; } } if (dtDTKH.Select(string.Format("DTDHID = '{0}' and TenHang = '{1}'" , dr["DTDHID"], strTenH)).Length > 0) { continue; } //dòng nhập gvMain.AddNewRow(); gvMain.UpdateCurrentRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoDH"], dr["SoDH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgayDH"], dr["NgayDH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["TenHang"], dr["TenHang"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DVT"], dr["DVT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["QuyCach"], dr["QuyCach"]); //gvMain.SetFocusedRowCellValue(gvMain.Columns["Loi"],dr["Loi"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DonGia"], dr["DonGia"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Dai"], dr["Dai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Rong"], dr["Rong"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Cao"], dr["Cao"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTDHID"], dr["DTDHID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Loai"], dr["Loai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaHH"], dr["MaHH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaKH"], dr["MaKH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NX"], "Xuất"); //dòng xuất gvMain.AddNewRow(); gvMain.UpdateCurrentRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoDH"], dr["SoDH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgayDH"], dr["NgayDH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["TenHang"], dr["TenHang"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DVT"], dr["DVT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["QuyCach"], dr["QuyCach"]); //gvMain.SetFocusedRowCellValue(gvMain.Columns["Loi"], dr["Loi"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DonGia"], dr["DonGia"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Dai"], dr["Dai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Rong"], dr["Rong"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Cao"], dr["Cao"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTDHID"], dr["DTDHID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Loai"], dr["Loai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaHH"], dr["MaHH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaKH"], dr["MaKH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NX"], "Nhập"); } }
void btnXuLy_Click(object sender, EventArgs e) { DataTable dtDS = (gvDS.DataSource as DataView).Table; dtDS.AcceptChanges(); DataRow[] drs = dtDS.Select("Chọn = 1"); if (drs.Length == 0) { XtraMessageBox.Show("Bạn chưa chọn đơn hàng", Config.GetValue("PackageName").ToString()); return; } frmDS.Close(); DataTable dtDTKH = (_data.BsMain.DataSource as DataSet).Tables[1]; using (DataTable tmp = dtDTKH.Clone()) { tmp.PrimaryKey = null; tmp.Columns["DT22ID"].AllowDBNull = true; foreach (DataRow dr in drs) { tmp.ImportRow(dr); tmp.Rows[tmp.Rows.Count - 1]["NoiDungCt"] = dr["GhiChu"]; tmp.Rows[tmp.Rows.Count - 1]["SLPO"] = dr["SL Đặt"]; } Database db = Database.NewDataDatabase(); foreach (DataRow dr in tmp.Rows) { if (dtDTKH.Select(string.Format("MT22ID = '{0}' and DTDHID = '{1}'" , drCur["MT22ID"], dr["DTDHID"])).Length > 0) { continue; } //Công thêm ngày 25/5/2015 kiểm tra nếu chưa có mã hàng thì insert 1 lần nữa (do code tạo mã hàng khi lập đơn hàng có vấn đề gì đó) string sql = @"if not exists (select MaHH from DMHH where MaHH = @@MaHH) insert into DMHH(MaHH, TenHH, DVT, QuyCach, GiaBan) values(@@MaHH, @@TenHH, @@DVT, @@QuyCach, @@GiaBan)"; string[] paraNames = new string[] { "@@MaHH", "@@TenHH", "@@DVT", "@@QuyCach", "@@GiaBan" }; string mahh = dr["MaKH"].ToString() + "_" + dr["QuyCach"].ToString(); object[] values = new object[] { mahh, dr["TenHang"], dr["DVT"], dr["QuyCach"], dr["DonGia"] }; db.UpdateDatabyPara(sql, paraNames, values); //them du lieu don hang vao phieu nhap thanh pham gvMain.AddNewRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaHH"], dr["MaHH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["TenHang"], dr["TenHang"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoDH"], dr["SoDH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NgayDH"], dr["NgayDH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DVT"], dr["DVT"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["QuyCach"], dr["QuyCach"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["MaKH"], dr["MaKH"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Dai"], dr["Dai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Rong"], dr["Rong"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Cao"], dr["Cao"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DTDHID"], dr["DTDHID"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Loai"], dr["Loai"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["Lop"], dr["Lop"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["NoiDungCt"], dr["NoiDungCt"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["DonGia"], dr["DonGia"]); gvMain.UpdateCurrentRow(); gvMain.SetFocusedRowCellValue(gvMain.Columns["SoLuong"], dr["SoLuong"]); gvMain.SetFocusedRowCellValue(gvMain.Columns["SLPO"], dr["SLPO"]); gvMain.UpdateCurrentRow(); } } }