private void UpLoadMulti()
{
btn_Browser.Enabled = false;
txt_PathFolder.Enabled = false;
txt_Location.Enabled = false;
List <string> lStrBath = new List <string>();
lStrBath.AddRange(Directory.GetDirectories(txt_PathFolder.Text));
int countBatchExists = 0;
string listBatchExxists = "";
for (int i = 0; i < lStrBath.Count; i++)
{
var batchExists = (from w in Global.db.tbl_Batches where w.fBatchName == new DirectoryInfo(lStrBath[i]).Name select w.fBatchName).ToList();
if (batchExists.Count > 0)
{
countBatchExists += 1;
listBatchExxists += batchExists[0] + "\r\n";
}
}
if (countBatchExists > 0)
{
MessageBox.Show("Batch đã tồn tại :\r\n" + listBatchExxists);
btn_Browser.Enabled = true;
txt_PathFolder.Enabled = true;
txt_Location.Enabled = true;
return;
}
int n = 0;
foreach (string itemBatch in lStrBath)
{
string batchName = "", loaiPhieu = "", pathPicture = "";
int m = 0;
batchName = new DirectoryInfo(itemBatch).Name;
if (batchName.IndexOf("AEON", StringComparison.Ordinal) >= 0 || batchName.IndexOf("aeon", StringComparison.Ordinal) >= 0)
{
loaiPhieu = "AEON";
}
else if (batchName.IndexOf("ASAHI", StringComparison.Ordinal) >= 0 || batchName.IndexOf("asahi", StringComparison.Ordinal) >= 0)
{
loaiPhieu = "ASAHI";
}
else if (batchName.IndexOf("EIZEN", StringComparison.Ordinal) >= 0 || batchName.IndexOf("eizen", StringComparison.Ordinal) >= 0)
{
loaiPhieu = "EIZEN";
}
else if (batchName.IndexOf("YAMAMOTO", StringComparison.Ordinal) >= 0 || batchName.IndexOf("yamamoto", StringComparison.Ordinal) >= 0)
{
loaiPhieu = "YAMAMOTO";
}
else if (batchName.IndexOf("YASUDA", StringComparison.Ordinal) >= 0 || batchName.IndexOf("yasuda", StringComparison.Ordinal) >= 0)
{
loaiPhieu = "YASUDA";
}
else if (batchName.IndexOf("TAIYO", StringComparison.Ordinal) >= 0 || batchName.IndexOf("taiyo", StringComparison.Ordinal) >= 0)
{
loaiPhieu = "TAIYO";
}
else
{
continue;
}
n += 1;
lb_SobatchHoanThanh.Text = n + @" :";
pathPicture = itemBatch + @"\入力画像";
var fBatch = new tbl_Batch
{
fBatchName = batchName,
fUserCreate = txt_UserCreate.Text,
fDateCreated = DateTime.Now,
fPathPicture = pathPicture,
fLocation = txt_Location.Text,
fSoLuongAnh = Directory.GetFiles(pathPicture).Length.ToString(),
fLoaiPhieu = loaiPhieu
};
Global.db.tbl_Batches.InsertOnSubmit(fBatch);
Global.db.SubmitChanges();
var filters = new String[] { "jpg", "jpeg", "png", "gif", "tif", "bmp" };
string[] pathImageLocation = GetFilesFrom(pathPicture, filters, false);
string pathImageServer = Global.StrPath + "\\" + new DirectoryInfo(itemBatch).Name;
Directory.CreateDirectory(pathImageServer);
string imageJPG = "";
progressBar1.Step = 1;
progressBar1.Value = 1;
progressBar1.Maximum = pathImageLocation.Length;
progressBar1.Minimum = 0;
ModifyProgressBarColor.SetState(progressBar1, 1);
foreach (string i in pathImageLocation)
{
FileInfo fi = new FileInfo(i);
tbl_Image tempImage = new tbl_Image
{
fbatchname = batchName,
idimage = Path.GetFileName(fi.ToString()),
ReadImageDESo = 0,
CheckedDESo = 0,
Checked_QC = 0,
TienDoDESO = "Hình chưa nhập",
CheckQC = false
};
Global.db.tbl_Images.InsertOnSubmit(tempImage);
Global.db.SubmitChanges();
//tbl_TienDo tempTblTienDo = new tbl_TienDo
//{
// IDProject = "JEMS",
// fBatchName = txt_BatchName.Text,
// Idimage = Path.GetFileName(fi.ToString()),
// TienDoDeSo = "Hình chưa nhập",
// UserCheckDeSo = "",
// DateCreate = DateTime.Now
//};
//Global.db_BPO.tbl_TienDos.InsertOnSubmit(tempTblTienDo);
//Global.db_BPO.SubmitChanges();
string des = pathImageServer + @"\" + Path.GetFileName(fi.ToString());
fi.CopyTo(des);
m += 1;
lb_SoImageDaHoanThanh.Text = m + @"/" + pathImageLocation.Length;
progressBar1.PerformStep();
}
}
MessageBox.Show(@"Tạo batch mới thành công!");
txt_BatchName.Text = "";
txt_ImagePath.Text = "";
lb_SoLuongHinh.Text = "";
txt_PathFolder.Text = "";
txt_LoaiPhieu.SelectedIndex = 0;
//btn_CreateBatch.Enabled = true;
btn_Browser.Enabled = true;
txt_PathFolder.Enabled = true;
txt_Location.Enabled = true;
}
private void UpLoadSingle()
{
progressBar1.Step = 1;
progressBar1.Value = 1;
progressBar1.Maximum = _lFileNames.Length;
progressBar1.Minimum = 0;
ModifyProgressBarColor.SetState(progressBar1, 1);
var batch = (from w in Global.db.tbl_Batches.Where(w => w.fBatchName == txt_BatchName.Text) select w.fBatchName).FirstOrDefault();
if (!string.IsNullOrEmpty(txt_ImagePath.Text))
{
if (string.IsNullOrEmpty(batch))
{
var fBatch = new tbl_Batch
{
fBatchName = txt_BatchName.Text,
fUserCreate = txt_UserCreate.Text,
fDateCreated = DateTime.Now,
fPathPicture = txt_ImagePath.Text,
fLocation = txt_Location.Text,
fSoLuongAnh = soluonghinh.ToString(),
fLoaiPhieu = txt_LoaiPhieu.Text
};
Global.db.tbl_Batches.InsertOnSubmit(fBatch);
Global.db.SubmitChanges();
//DateTime timeStart = new DateTime(dateEdit_ngaybatdau.DateTime.Year,
// dateEdit_ngaybatdau.DateTime.Month,
// dateEdit_ngaybatdau.DateTime.Day,
// timeEdit_ngaybatdau.Time.Hour,
// timeEdit_ngaybatdau.Time.Minute,
// timeEdit_ngaybatdau.Time.Second);
//DateTime timeEnd = new DateTime(dateEdit_ngayketthuc.DateTime.Year,
// dateEdit_ngayketthuc.DateTime.Month,
// dateEdit_ngayketthuc.DateTime.Day,
// timeEdit_ngayketthuc.Time.Hour,
// timeEdit_ngayketthuc.Time.Minute,
// timeEdit_ngayketthuc.Time.Second);
//int timeNotificationdeadline = 0;
//if (cbb_loaithoigian.Text == "Ngày")
//{
// timeNotificationdeadline = Convert.ToInt32(nud_thoigiandeadline.Value * 24 * 60);
//}
//else if (cbb_loaithoigian.Text == "Giờ")
//{
// timeNotificationdeadline = Convert.ToInt32(nud_thoigiandeadline.Value * 60);
//}
//else if (cbb_loaithoigian.Text == "Phút")
//{
// timeNotificationdeadline = Convert.ToInt32(nud_thoigiandeadline.Value);
//}
//var fBatchEntry = new tbl_Batch_Entry()
//{
// fIDProject = Global.StrIdProject,
// fBatchName = txt_BatchName.Text,
// fUserCreate = txt_UserCreate.Text,
// fDateCreated = DateTime.Now,
// fPathPicture = txt_ImagePath.Text,
// fLocation = txt_Location.Text,
// fSoLuongAnh = soluonghinh.ToString(),
// fLoaiPhieu = txt_LoaiPhieu.Text,
// fTimeStart = timeStart,
// fTimeEnd = timeEnd,
// fDeadlineNotificationTime = timeNotificationdeadline
//};
//Global.db_BPO.tbl_Batch_Entries.InsertOnSubmit(fBatchEntry);
//Global.db.SubmitChanges();
}
else
{
MessageBox.Show("Batch đã tồn tại vui lòng điền tên batch khác!");
return;
}
}
else
{
MessageBox.Show("Bạn chưa chọn hình ảnh!");
return;
}
string temp = Global.StrPath + "\\" + txt_BatchName.Text;
if (!Directory.Exists(temp))
{
Directory.CreateDirectory(temp);
}
else
{
MessageBox.Show("Bị trùng tên batch!");
return;
}
foreach (string i in _lFileNames)
{
FileInfo fi = new FileInfo(i);
tbl_Image tempImage = new tbl_Image
{
fbatchname = txt_BatchName.Text,
idimage = Path.GetFileName(fi.ToString()),
ReadImageDESo = 0,
CheckedDESo = 0,
Checked_QC = 0,
TienDoDESO = "Hình chưa nhập",
CheckQC = false
};
Global.db.tbl_Images.InsertOnSubmit(tempImage);
Global.db.SubmitChanges();
tbl_TienDo tempTblTienDo = new tbl_TienDo
{
IDProject = "JEMS",
fBatchName = txt_BatchName.Text,
Idimage = Path.GetFileName(fi.ToString()),
TienDoDeSo = "Hình chưa nhập",
UserCheckDeSo = "",
DateCreate = DateTime.Now
};
Global.db_BPO.tbl_TienDos.InsertOnSubmit(tempTblTienDo);
Global.db_BPO.SubmitChanges();
string des = temp + @"\" + Path.GetFileName(fi.ToString());
fi.CopyTo(des);
progressBar1.PerformStep();
}
MessageBox.Show("Tạo batch mới thành công!");
txt_BatchName.Text = "";
txt_ImagePath.Text = "";
lb_SoLuongHinh.Text = "";
txt_LoaiPhieu.SelectedIndex = 0;
}
