private void btFillter_Click(object sender, EventArgs e)
{
try
{
this.companyViewTableAdapter.FillBy_StatusAll(dtView, QT.Entities.Common.CompanyStatus.CONFIG);
}
catch (Exception)
{
}
DBComTableAdapters.CompanyTableAdapter adtCompany = new DBComTableAdapters.CompanyTableAdapter();
adtCompany.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
adtCompany.UpdateQuery_PageRankIsNull_0();
adtCompany.UpdateQuery_TotalViewMonthIsNull_0();
adtCompany.Connection.Close();
adtCompany.Dispose();
NapDictionList();
DBCom.CompanyViewDataTable dtViewTemp = new DBCom.CompanyViewDataTable();
dBCom.CompanyView.Rows.Clear();
foreach (DBCom.CompanyViewRow dr in dtView)
{
bool valid = false;
foreach (DBCom.CompanyOfTypeRow drOf in dBCom.CompanyOfType)
{
if (dr.ID == drOf.ID)
{
valid = true;
break;
}
}
if (!valid)
{
DBCom.CompanyViewRow drnew = this.dBCom.CompanyView.NewCompanyViewRow();
//drnew = dr;
drnew.ID = dr.ID;
drnew.Domain = dr.Domain;
drnew.TotalProduct = Common.Obj2Int(dr.TotalProduct);
drnew.TotalValid = Common.Obj2Int(dr.TotalValid);
drnew.TotalQueue = Common.Obj2Int(dr.TotalQueue);
drnew.TotalVisited = Common.Obj2Int(dr.TotalVisited);
drnew.PageRank = Common.Obj2Int(dr.PageRank);
drnew.TotalViewMonth = dr.TotalViewMonth;
if (listManDic.ContainsKey(dr.ID))
{
drnew.ManagerType = listManDic[dr.ID].ToString();
}
this.dBCom.CompanyView.Rows.Add(drnew);
}
dtViewTemp.AcceptChanges();
}
}
private void UpdateSauKhiCheckProduct(int count)
{
try
{
DBCom.ProductDataTable dt = new DBCom.ProductDataTable();
this.productTableAdapter.FillBy_TongValidCompany(dt, CompanyID);
DBComTableAdapters.CompanyTableAdapter adt = new DBComTableAdapters.CompanyTableAdapter();
adt.Connection.ConnectionString = Server.ConnectionString;
adt.UpdateQuery_LastCheckValid(DateTime.Now, dt.Rows.Count, CompanyID);
UpdateLog(string.Format("{0}", count));
}
catch (Exception)
{
throw;
}
}
