public void ResetForCompany(long companyID, string Domain, Entities.Data.SqlDb sqlDb) { DataTable proTable = sqlDb.GetTblData(@"Select ID, Instock, Valid, Price, Name, IsNews, ImageUrls, IsDeal, ClassificationID From Product Where Company = @CompanyID and Valid = 1", CommandType.Text, new System.Data.SqlClient.SqlParameter[] { SqlDb.CreateParamteterSQL("CompanyID", companyID, SqlDbType.BigInt) }); this.RemoveDuplicate(companyID); if (proTable != null && proTable.Rows.Count > 0) { for (int j = 0; j < proTable.Rows.Count; j++) { long ProductID = QT.Entities.Common.Obj2Int64(proTable.Rows[j]["ID"].ToString()); int InStock = QT.Entities.Common.Obj2Int(proTable.Rows[j]["InStock"].ToString()); bool Valid = QT.Entities.Common.Obj2Bool(proTable.Rows[j]["Valid"].ToString()); long Price = QT.Entities.Common.Obj2Int64(proTable.Rows[j]["Price"].ToString()); string Name = QT.Entities.Common.Obj2String(proTable.Rows[j]["Name"].ToString()); bool IsNew = QT.Entities.Common.Obj2Bool(proTable.Rows[j]["IsNews"]); string ImageUrl = QT.Entities.Common.Obj2String(proTable.Rows[j]["ImageUrls"]); bool IsDeal = QT.Entities.Common.Obj2Bool(proTable.Rows[j]["IsDeal"].ToString()); long CategoryID = QT.Entities.Common.Obj2Int64(proTable.Rows[j]["ClassificationID"].ToString()); SetCheckDuplicate(companyID, ProductID, Domain, Price, Name, ImageUrl, Valid); } } }
public void ResetForCompany(long CompanyID, Entities.Data.SqlDb sqlDb) { this.RemoveAllLstProduct(CompanyID); DataTable tbl = sqlDb.GetTblData("select id from product where company = @CompanyID", CommandType.Text, new System.Data.SqlClient.SqlParameter[] { SqlDb.CreateParamteterSQL("@CompanyID", CompanyID, SqlDbType.BigInt) }); List <long> productIDs = new List <long>(); foreach (DataRow rowInfo in tbl.Rows) { productIDs.Add(Convert.ToInt64(rowInfo["id"])); } this.UpdateBathLastUpdateProduct(CompanyID, productIDs, new DateTime(1990, 1, 1, 0, 0, 0)); }