/// <summary>
///
/// </summary>
/// <param name="dsPhieuNguon">Là 1 DataSet phải có các cột HH_ID,SO_LUONG và DataSet này gồm
/// \n các mã hàng hóa với số lượng còn lại chưa tạo ra phiếu khác</param>
/// <param name="gridDich">Là Lưới chứa các mã hàng hóa của phiếu đích</param>
public static bool KiemTraRangBuoc(DataSet dsPhieuNguon, PLGridView gridDich)
{
// thuc hien doi mau dong vi pham rang buoc ve so luong
TaoDieuKienLoc(gridDich);
bool ViPhamRangBuoc = false;
for (int i = 0; i < gridDich.RowCount; i++)
{
for (int k = 0; k < dsPhieuNguon.Tables[0].Rows.Count; k++)
{
DataRow rowNguon= dsPhieuNguon.Tables[0].Rows[k];
DataRow rowDich=gridDich.GetDataRow(i);
if (HelpNumber.ParseInt64(rowDich["HH_ID"]) == HelpNumber.ParseInt64(rowNguon["HH_ID"]))
{
if (HelpNumber.ParseDecimal(rowDich["SO_LUONG"]) > HelpNumber.ParseDecimal(rowNguon["SO_LUONG"]))
{
gridDich.SetRowCellValue(i, gridDich.Columns["CHECK"], 0);
ViPhamRangBuoc = true;
}
else
gridDich.SetRowCellValue(i, gridDich.Columns["CHECK"], 1);
}
}
}
return ViPhamRangBuoc;
}
public static List<DataRow> GetSelectedDataRow(PLGridView gridView)
{
List<DataRow> rowList = new List<DataRow>();
if (gridView.GetSelectedRows() != null)
{
foreach (int index in gridView.GetSelectedRows())
{
if (index > -1) rowList.Add(gridView.GetDataRow(index));
}
}
return rowList;
}
public static long[] GetSelectedID(PLGridView gridView, string IDField)
{
if (gridView.GetSelectedRows() != null)
{
long[] ids = new long[gridView.GetSelectedRows().Length];
int i = 0;
foreach (int index in gridView.GetSelectedRows())
{
if (index > -1)
{
DataRow temp = gridView.GetDataRow(index);
ids[i++] = HelpNumber.ParseInt64(temp[IDField]);
}
}
return ids;
}
return null;
}
private void SetCheckAllColumnStatus(PLGridView gridView, CellValueChangedEventArgs e)
{
DataRow row = gridView.GetDataRow(e.RowHandle);
if (e.Column.FieldName == "ISFULL_BIT")
{
string bit_str = e.Value.ToString();
row["ISFULL_BIT"] = bit_str;
row["ISCREATE_BIT"] = bit_str;
row["ISREAD_BIT"] = bit_str;
row["ISUPDATE_BIT"] = bit_str;
row["ISDELETE_BIT"] = bit_str;
}
else
{
string bit_str = e.Value.ToString();
row[e.Column.FieldName] = bit_str;
row["ISFULL_BIT"] = (row["ISCREATE_BIT"].ToString() == "N"
|| row["ISREAD_BIT"].ToString() == "N"
|| row["ISUPDATE_BIT"].ToString() == "N"
|| row["ISDELETE_BIT"].ToString() == "N") ? "N" : "Y";
gridView.UpdateCurrentRow();
}
}
/// <summary>
/// Thể hiện lỗi trên Grid dựa vào DataTable chứa các dòng lỗi
/// </summary>
/// <param name="gridDich">Grid cần thể hiện lỗi</param>
/// <param name="dt_error">DataTable các dòng lỗi</param>
public static void ShowErrorOnGridExt(PLGridView gridDich, DataTable dt_error, PhieuType Des)
{
RangBuocSoLgTrLgHelp.AddFormatCond(gridDich);
for (int i = 0; i < gridDich.RowCount; i++)
{
gridDich.SetRowCellValue(i, gridDich.Columns["CHECK"], 1);
gridDich.SetRowCellValue(i, gridDich.Columns["VI_PHAM"], "");
foreach (DataRow dr_error in dt_error.Rows)
{
DataRow rowDich = gridDich.GetDataRow(i);
if ((HelpNumber.ParseInt64(rowDich["HH_ID"]) == HelpNumber.ParseInt64(dr_error["HH_ID"]))
&& (HelpNumber.ParseInt64(rowDich[Des.GetSTTField()]) == HelpNumber.ParseInt64(dr_error["TINH_TRANG"])))
{
gridDich.SetRowCellValue(i, gridDich.Columns["CHECK"], 0);
gridDich.SetRowCellValue(i, gridDich.Columns["VI_PHAM"], dr_error["VI_PHAM"]);
gridDich.UpdateCurrentRow();
gridDich.OptionsView.ShowPreview = true;
gridDich.OptionsView.AutoCalcPreviewLineCount = true;
gridDich.PreviewFieldName = "VI_PHAM";
gridDich.CustomDrawRowPreview +=
new DevExpress.XtraGrid.Views.Base.RowObjectCustomDrawEventHandler(
RangBuocSoLgTrLgHelp.gridDich_CustomDrawRowPreview);
}
}
}
}
public static void ShowErrorOnGrid(PLGridView gridDich, string Vi_Pham)
{
RangBuocSoLgTrLgHelp.AddFormatCond(gridDich);
gridDich.SetRowCellValue(0, gridDich.Columns["CHECK"], 1);
gridDich.SetRowCellValue(0, gridDich.Columns["VI_PHAM"], "");
DataRow rowDich = gridDich.GetDataRow(0);
gridDich.SetRowCellValue(0, gridDich.Columns["CHECK"], 0);
gridDich.SetRowCellValue(0, gridDich.Columns["VI_PHAM"], Vi_Pham);
gridDich.UpdateCurrentRow();
gridDich.OptionsView.ShowPreview = true;
gridDich.OptionsView.AutoCalcPreviewLineCount = true;
gridDich.PreviewFieldName = "VI_PHAM";
gridDich.CustomDrawRowPreview +=
new DevExpress.XtraGrid.Views.Base.RowObjectCustomDrawEventHandler(
gridDich_CustomDrawRowPreview);
}
public static DataTable ViPhamRangBuoc(long ID_PhieuNguon, PhieuType LoaiPhieuNguon,PLGridView gridDich)
{
DataSet dsNguon = Get_SoLuongConLai(ID_PhieuNguon, LoaiPhieuNguon);
DataTable dtViPham = new DataTable();
dtViPham.Columns.Add("HH_ID", Type.GetType("Int64"));
dtViPham.Columns.Add("VI_PHAM");
if (dsNguon == null || dsNguon.Tables[0].Rows.Count == 0)
return dtViPham;
for (int i = 0; i < gridDich.RowCount; i++)
{
DataRow rowDich = gridDich.GetDataRow(i);
DataRow rowViPham = dtViPham.NewRow();
bool exists = false;
for (int k = 0; k < dsNguon.Tables[0].Rows.Count; k++)
{
DataRow rowNguon = dsNguon.Tables[0].Rows[k];
if (HelpNumber.ParseInt64(rowDich["HH_ID"]) == HelpNumber.ParseInt64(rowNguon["HH_ID"]))
{
// HH_ID co ton tai trong phieu nguon
exists = true;
if (HelpNumber.ParseDecimal(rowDich["SO_LUONG"]) > HelpNumber.ParseDecimal(rowNguon["SO_LUONG"]))
{
rowViPham["HH_ID"] = rowDich["HH_ID"];
rowViPham["VI_PHAM"] = "Vi phạm về ràng buộc số lượng";
dtViPham.Rows.Add(rowViPham);
}
}
}
if (!exists)
{
rowViPham["HH_ID"] = rowDich["HH_ID"];
rowViPham["VI_PHAM"] = "Mã hàng này không có trong phiếu nguồn";
dtViPham.Rows.Add(rowViPham);
}
}
return dtViPham;
}