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