public List <ZVendor> ConvertDataTableToZVendors(DataTable data)
{
List <ZVendor> zVendors = new List <ZVendor>();
foreach (DataRow dataRow in data.Rows)
{
ZVendor zVendor = new ZVendor();
zVendor.Article = dataRow[this.articleColumn].ToString();
zVendor.Vendor = dataRow[this.vendorColumn].ToString();
zVendor.MC = dataRow[this.mcColumn].ToString();
zVendor.SoLuongDatHang = string.IsNullOrEmpty(dataRow[this.soLuongDatHangColumn].ToString()) ? 0 : float.Parse(dataRow[this.soLuongDatHangColumn].ToString());
zVendor.SoLuongGiaoHang = string.IsNullOrEmpty(dataRow[this.soLuongGiaoHangColumn].ToString()) ? 0 : float.Parse(dataRow[this.soLuongGiaoHangColumn].ToString());
zVendors.Add(zVendor);
}
return(zVendors);
}
public int TinhDungSai(ZVendor zVendor)
{
int result;
float chenhLech, chenhLechPT;
string query;
query = _dungSaiNCCHelper.GetQuery(zVendor.Vendor, zVendor.MC);
chenhLech = zVendor.SoLuongGiaoHang - zVendor.SoLuongDatHang;
chenhLechPT = chenhLech / zVendor.SoLuongDatHang * 100;
string[] names = new string[] { "@article", "@vendor", "@mc", "@sldh", "@slgh", "@cl", "@clpt" };
object[] values = new object[] { zVendor.Article, zVendor.Vendor, zVendor.MC, zVendor.SoLuongDatHang, zVendor.SoLuongGiaoHang, chenhLech, chenhLechPT };
DataTable data = _sQLiteProvider.ExecuteQuery(query, names, values);
result = data.Rows.Count > 0 ? int.Parse(data.Rows[0][0].ToString()) : -2;
return(result);
}