/// <summary>
/// sinh ra chuoi dieu kien sau where
/// </summary>
/// <param name="list">danh sach ten column dung de so sanh</param>
/// <param name="dongBoObject">value</param>
/// <returns>chuoi dieu kien</returns>
private string GenStringDieuKien(List<string> list, DongBoObject dongBoObject)
{
var result = "";
if (list.IndexOf(ColumnKeyName.MA_DVI.ToString("G")) != -1)
result += " " + ColumnKeyName.MA_DVI.ToString("G") + " = '" + dongBoObject.MA_DVI + "'";
// cac thao tac voi bag luon can ton tai ma don vi
if (list.IndexOf(ColumnKeyName.SO_ID.ToString("G")) != -1)
result += " and " + ColumnKeyName.SO_ID.ToString("G") + " = " + dongBoObject.SO_ID;
if (list.IndexOf(ColumnKeyName.MA.ToString("G")) != -1)
result += " and " + ColumnKeyName.MA.ToString("G") + " = '" + dongBoObject.MA + "'";
if (list.IndexOf(ColumnKeyName.SO_QD.ToString("G")) != -1)
result += " and " + ColumnKeyName.SO_QD.ToString("G") + " = '" + dongBoObject.SO_QD + "'";
if (list.IndexOf(ColumnKeyName.BT.ToString("G")) != -1)
result += " and " + ColumnKeyName.BT.ToString("G") + " = " + dongBoObject.BT;
if (list.IndexOf(ColumnKeyName.HANG.ToString("G")) != -1)
result += " and " + ColumnKeyName.HANG.ToString("G") + " = " + dongBoObject.HANG;
if (list.IndexOf(ColumnKeyName.MA_HT.ToString("G")) != -1)
result += " and " + ColumnKeyName.MA_HT.ToString("G") + " = '" + dongBoObject.MA_HT + "'";
if (list.IndexOf(ColumnKeyName.NAM.ToString("G")) != -1)
result += " and " + ColumnKeyName.NAM.ToString("G") + " = " + dongBoObject.NAM;
if (list.IndexOf(ColumnKeyName.DOT.ToString("G")) != -1)
result += " and " + ColumnKeyName.DOT.ToString("G") + " = " + dongBoObject.DOT;
if (list.IndexOf(ColumnKeyName.NHA.ToString("G")) != -1)
result += " and " + ColumnKeyName.NHA.ToString("G") + " = '" + dongBoObject.NHA + "'";
return result;
}
/// <summary>
/// convert from data row to object
/// </summary>
/// <param name="listColumnId"></param>
/// <param name="dr"></param>
/// <returns></returns>
private DongBoObject GenObjectDongBo(List<string> listColumnId, DataRow dr)
{
var ob = new DongBoObject();
if (listColumnId.IndexOf(ColumnKeyName.MA_DVI.ToString("G")) != -1)
ob.MA_DVI = Convert.ToString(dr[listColumnId.IndexOf(ColumnKeyName.MA_DVI.ToString("G"))]);
if (listColumnId.IndexOf(ColumnKeyName.SO_ID.ToString("G")) != -1)
ob.SO_ID = Convert.ToInt64(dr[listColumnId.IndexOf(ColumnKeyName.SO_ID.ToString("G"))]);
if (listColumnId.IndexOf(ColumnKeyName.MA.ToString("G")) != -1)
ob.MA = Convert.ToString(dr[listColumnId.IndexOf(ColumnKeyName.MA.ToString("G"))]);
if (listColumnId.IndexOf(ColumnKeyName.SO_QD.ToString("G")) != -1)
ob.SO_QD = Convert.ToString(dr[listColumnId.IndexOf(ColumnKeyName.SO_QD.ToString("G"))]);
if (listColumnId.IndexOf(ColumnKeyName.BT.ToString("G")) != -1)
ob.BT = Convert.ToInt64(dr[listColumnId.IndexOf(ColumnKeyName.BT.ToString("G"))]);
if (listColumnId.IndexOf(ColumnKeyName.HANG.ToString("G")) != -1)
ob.HANG = Convert.ToInt64(dr[listColumnId.IndexOf(ColumnKeyName.HANG.ToString("G"))]);
if (listColumnId.IndexOf(ColumnKeyName.MA_HT.ToString("G")) != -1)
ob.MA_HT = Convert.ToString(dr[listColumnId.IndexOf(ColumnKeyName.MA_HT.ToString("G"))]);
if (listColumnId.IndexOf(ColumnKeyName.NAM.ToString("G")) != -1)
ob.NAM = Convert.ToInt64(dr[listColumnId.IndexOf(ColumnKeyName.NAM.ToString("G"))]);
if (listColumnId.IndexOf(ColumnKeyName.DOT.ToString("G")) != -1)
ob.DOT = Convert.ToInt64(dr[listColumnId.IndexOf(ColumnKeyName.DOT.ToString("G"))]);
if (listColumnId.IndexOf(ColumnKeyName.NHA.ToString("G")) != -1)
ob.NHA = Convert.ToString(dr[listColumnId.IndexOf(ColumnKeyName.NHA.ToString("G"))]);
return ob;
}