private void btDownloadImg_Click(object sender, EventArgs e) { DBToolTableAdapters.View_SanPhamImageTableAdapter adt = new DBToolTableAdapters.View_SanPhamImageTableAdapter(); DBTool.View_SanPhamImageDataTable dt = new DBTool.View_SanPhamImageDataTable(); adt.Connection.ConnectionString = QT.Entities.Server.ConnectionString; if (adt.Connection.State == ConnectionState.Closed) { adt.Connection.Open(); } adt.FillByAll_Da_TaiImage(dt); DowloadImageV2(dt); dt.Dispose(); adt.Dispose(); }
private void btDownloadImageChuaTai_Click(object sender, EventArgs e) { /// Download lại toàn bộ ảnh của những sản phẩm chưa được kiểm tra /// DBToolTableAdapters.View_SanPhamImageTableAdapter adt = new DBToolTableAdapters.View_SanPhamImageTableAdapter(); DBTool.View_SanPhamImageDataTable dt = new DBTool.View_SanPhamImageDataTable(); adt.Connection.ConnectionString = QT.Entities.Server.ConnectionString; if (adt.Connection.State == ConnectionState.Closed) { adt.Connection.Open(); } adt.FillBy_SanPhamChuaKiemTra(dt); DowloadImageV2(dt); dt.Dispose(); adt.Dispose(); }
void doDowload(Object id) { DBToolTableAdapters.View_SanPhamImageTableAdapter adt = new DBToolTableAdapters.View_SanPhamImageTableAdapter(); DBTool.View_SanPhamImageDataTable dt = new DBTool.View_SanPhamImageDataTable(); adt.Connection.ConnectionString = QT.Entities.Server.ConnectionString; if (adt.Connection.State == ConnectionState.Closed) { adt.Connection.Open(); } long idCompany = 0; bool isdownloadImageNhap = false; this.Invoke((MethodInvoker) delegate { this.laMess1.Text = String.Format("Start download data"); idCompany = QT.Entities.Common.Obj2Int64(id); isdownloadImageNhap = chkImageAdmin.Checked; }); switch (cboCommand.SelectedIndex) { case 0: //Current Not Valid adt.FillBy_ChuaKiemTraTheoCongTy(dt, idCompany); break; case 1: //Current All adt.FillBy_AllByCompany(dt, idCompany); break; case 2: //All Check not valid adt.FillBy_ChuaKiemTraTheoCongTy(dt, idCompany); //DBTool.View_SanPhamImageDataTable dt1 = new DBTool.View_SanPhamImageDataTable(); //foreach (DBTool.CompanyRow dr in this.dBTool.Company) //{ // if (dr.CheckD == true) // { // this.Invoke((MethodInvoker)delegate // { // this.laMess1.Text = String.Format("start download {0}", dr.Domain); // }); // adt.FillBy_ChuaKiemTraTheoCongTy(dt1, dr.ID); // dt.Merge(dt1); // } //} //dt.AcceptChanges(); break; case 3: //All Check adt.FillBy_AllByCompany(dt, idCompany); //DBTool.View_SanPhamImageDataTable dt2 = new DBTool.View_SanPhamImageDataTable(); //foreach (DBTool.CompanyRow dr in this.dBTool.Company) //{ // if (dr.CheckD == true) // { // this.Invoke((MethodInvoker)delegate // { // this.laMess1.Text = String.Format("start download {0}", dr.Domain); // }); // adt.FillBy_AllByCompany(dt2, dr.ID); // dt.Merge(dt2); // } //} //dt.AcceptChanges(); break; case 4: //Config ananytic DBTool.View_SanPhamImageDataTable dt3 = new DBTool.View_SanPhamImageDataTable(); this.Invoke((MethodInvoker) delegate { this.laMess1.Text = String.Format("start download {0}", "quangtrung.vn"); }); if (isdownloadImageNhap) { // Update ảnh ở bảng ProductImage sang adt.FillBy_SanPhamGocCoAnhNhap(dt3, QT.Entities.Common.GetIDCompany("quangtrung.vn")); } else { adt.FillBy_SPConfigAnanytic(dt3, QT.Entities.Common.GetIDCompany("quangtrung.vn")); } dt.Merge(dt3); dt.AcceptChanges(); break; } this.Invoke((MethodInvoker) delegate { this.laMess1.Text = String.Format("download finish"); }); String path = ""; path = "D:\\Beta\\img\\"; path = QT.Entities.Common.FolderImage; DBToolTableAdapters.ProductImagePathTableAdapter adtPro = new DBToolTableAdapters.ProductImagePathTableAdapter(); adtPro.Connection.ConnectionString = QT.Entities.Server.ConnectionString; if (adtPro.Connection.State == ConnectionState.Closed) { adtPro.Connection.Open(); } int count = 0; for (int i = 0; i < dt.Rows.Count; i++) { try { String url = dt.Rows[i]["DetailUrl"].ToString(); Uri root = new Uri(url); String namepath = root.DnsSafeHost.Replace("www.", "").Replace('.', '_'); //namepath = Common.UnicodeToKoDauAndGach(namepath.Replace(" ", " ").Replace(" ", " ").Trim()); if (cboCommand.SelectedIndex == 4) { namepath = "images"; } string ss = namepath + "\\"; string filename = QT.Entities.Common.UnicodeToKoDauAndGach(dt.Rows[i]["Name"].ToString()); string tempf = filename.Replace("-", ""); string s3 = tempf.Substring(0, 3); if (s3 == "bin") { s3 = "bin1"; } ss += s3 + "\\"; if (filename.Length > 100) { filename = filename.Substring(0, 99); } String fullfile = path + ss + filename + ".jpg"; if (chkRedownload.Checked == true) { //Bitmap thumbBitmap = null; //try //{ // thumbBitmap = new Bitmap(fullfile); // string pathsave = ss + filename + ".jpg"; // pathsave = "Store/" + pathsave.Replace('\\', '/'); // adtPro.UpdateQuery(pathsave, thumbBitmap.Width, thumbBitmap.Height, QT.Entities.Common.Obj2Int64(dt.Rows[i]["ID"].ToString())); //} //catch (Exception ex) //{ // this.Invoke((MethodInvoker)delegate // { // this.laMess1.Text = String.Format("Error {0}/{1}{2}", i, dt.Rows.Count, ex); // }); //} } else { if (!File.Exists(fullfile)) { /// chưa có file --> tải lại dữ liệu int w = 0, h = 0; string fileSave = QT.Entities.Common.SaveFile(dt.Rows[i]["ImageUrls"].ToString(), path + ss, filename + ".jpg", out w, out h, false); count++; if (fileSave != "") { string pathsave = ss + filename.Replace('\\', '/') + ".jpg"; pathsave = "Store/" + pathsave.Replace('\\', '/'); adtPro.UpdateQuery(pathsave, w, h, QT.Entities.Common.Obj2Int64(dt.Rows[i]["ID"].ToString())); count++; } } else { if (dt.Rows[i]["ImagePath"].ToString() == "") { Bitmap thumbBitmap = null; try { thumbBitmap = new Bitmap(fullfile); string pathsave = ss + filename + ".jpg"; pathsave = "Store/" + pathsave.Replace('\\', '/'); adtPro.UpdateQuery(pathsave, thumbBitmap.Width, thumbBitmap.Height, QT.Entities.Common.Obj2Int64(dt.Rows[i]["ID"].ToString())); } catch (Exception ex) { this.Invoke((MethodInvoker) delegate { this.laMess1.Text = String.Format("Error {0}/{1}{2}", i, dt.Rows.Count, ex); }); } } } } this.Invoke((MethodInvoker) delegate { this.laMess1.Text = String.Format("{0}/{1} download:{2} - {3}\n{4}", i, dt.Rows.Count, count, dt.Rows[i]["Name"].ToString(), dt.Rows[i]["DetailUrl"].ToString()); }); } catch (Exception ex) { this.Invoke((MethodInvoker) delegate { this.laMess1.Text = String.Format("{0}/{1} download:{2} - {3}\n{4}\n{5}", i, dt.Rows.Count, count, dt.Rows[i]["Name"].ToString(), dt.Rows[i]["DetailUrl"].ToString(), ex.ToString()); Thread.Sleep(5000); }); } } adtPro.Dispose(); dt.Clear(); dt.Dispose(); adt.Dispose(); }