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