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