private void btGhiNhanDonHang_LinkClicked(object sender, NavBarLinkEventArgs e)
{
if (!CTLQuanLyForm.formName.Contains(frmDonDatHang.Name))
{
if (frmDonDatHang != null)
{
frmDonDatHang = new FrmDonDatHang.FrmDonDatHang(this);
xtraTabbedMdiManager.MdiParent = this;
CTLQuanLyForm.formName.Add(frmDonDatHang.Name);
frmDonDatHang.Text = "Ghi nhận đơn đặt hàng";
frmDonDatHang.MdiParent = this;
if (Config._tableDMSKU == null)
{
WaitingMsg waitingMsg = new WaitingMsg("Đang load dữ liệu......", "Vui lòng chờ trong giây lát");
Config.LoadDanhMucSKU();
waitingMsg.Finish();
}
frmDonDatHang.Show();
}
else
{
frmDonDatHang = new FrmDonDatHang.FrmDonDatHang(this);
xtraTabbedMdiManager.MdiParent = this;
CTLQuanLyForm.formName.Add(frmDonDatHang.Name);
frmDonDatHang.Text = "Ghi nhận đơn đặt hàng";
frmDonDatHang.MdiParent = this;
if (Config._tableDMSKU == null)
{
WaitingMsg waitingMsg = new WaitingMsg("Đang load dữ liệu......", "Vui lòng chờ trong giây lát");
Config.LoadDanhMucSKU();
waitingMsg.Finish();
}
frmDonDatHang.Show();
}
}
else
{
if (frmDonDatHang == null)
{
frmDonDatHang = new FrmDonDatHang.FrmDonDatHang(this);
frmDonDatHang.MdiParent = this;
frmDonDatHang.Activate();
frmDonDatHang.BringToFront();
}
else
{
frmDonDatHang.MdiParent = this;
frmDonDatHang.Activate();
frmDonDatHang.BringToFront();
}
}
}
/// <summary>Thực hiện hành động trong action và hiện thông điệp chờ.
/// Chú ý: Khi dùng các hành động trong action ko có phần MessageBox.
/// </summary>
public static void showMsgForm(XtraForm parent, DelegationLib.CallFunction_MulIn_NoOut action)
{
WaitingMsg msg = new WaitingMsg(parent);
try
{
action(new List<object>());
}
catch { }
finally
{
msg.Finish();
}
}
private void BTLoadDS_Click(object sender, EventArgs e)
{
WaitingMsg waitingMsg = new WaitingMsg("Chương trình đang load dữ liệu!", "Please Waiting .......");
try
{
if (CopyFileINVMST())
{
if (_PathFileINVMST == string.Empty)
{
InfoMessage.HienThi("Thong bao",
"Không lấy đữ liệu được ! Vui lòng kiểm tra lại H:\\ hoặc Server 21",
"Lay du lieu khong thanh cong", HinhAnhThongBao.THONGTIN, NutThongBao.DONGY);
return;
}
//_PathFileINVMST = @"C:\WINDOWS\Temp\INVMST.tps";
TPSDataAccess access = new TPSDataAccess(_PathFileINVMST);
string strsql = string.Format(@"Select SKU,Description,Disc_Flag,0 as Check from INVMST where Disc_Flag='N'");
DataTable dt = new DataTable();
dt = access.GetDataTable(strsql);
GrDSPriceSKU.DataSource = null;
if (dt != null && dt.Rows.Count > 0)
{
GrDSPriceSKU.DataSource = dt;
repositoryItemCheckEdit2.ValueChecked = 1;
repositoryItemCheckEdit2.ValueUnchecked = 0;
}
}
else
{
InfoMessage.HienThi("Thong bao",
"Không lấy đữ liệu được ! Vui lòng kiểm tra lại H:\\ hoặc Server 21",
"Lay du lieu khong thanh cong", HinhAnhThongBao.THONGTIN, NutThongBao.DONGY);
return;
}
waitingMsg.Finish();
}
catch (Exception exception)
{
CTLError.WriteError("btLoadData ", exception.Message);
waitingMsg.Finish();
return;
}
}
private void gridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
webBrowser1.AllowNavigation = true;
DataRow r = gridView1.GetDataRow(gridView1.FocusedRowHandle);
string url = r["LINK"].ToString();
string ID = r["ID"].ToString();
WaitingMsg m = new WaitingMsg();
string strWeb = RSS_new_old(ID, url);
if (strWeb == "")
webBrowser1.DocumentText = "Chưa có dữ liệu và tin mới cho mục này";
else
{
webBrowser1.DocumentText = strWeb;
Home = strWeb;
}
m.Finish();
}
private void gridControlTaiLieu_Click(object sender, EventArgs e)
{
DataRow r = layoutView1.GetDataRow(layoutView1.FocusedRowHandle);
if (r != null)
{
LayoutViewHitInfo gHitInfo = layoutView1.CalcHitInfo(layoutView1.GridControl.PointToClient(Control.MousePosition));
if (gHitInfo.Column == null) return;
if (gHitInfo.Column.FieldName == "TEN_FILE")//Nếu cell được click thuộc _columnField
{
WaitingMsg m = new WaitingMsg();
frmSaveOpen frm = new frmSaveOpen(DALuuTruTapTin.Instance.Load(HelpNumber.ParseInt64(layoutView1.GetDataRow(layoutView1.FocusedRowHandle)["ID"])).NOI_DUNG, layoutView1.GetDataRow(layoutView1.FocusedRowHandle)["TEN_FILE"].ToString());
m.Finish();
ProtocolForm.ShowModalDialog(this, frm);
}
}
}
private void repositoryItemButtonEdit2_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
DataRow row = layoutView1.GetDataRow(layoutView1.FocusedRowHandle);
DOLuuTruTapTin do_tt = DALuuTruTapTin.Instance.Load(HelpNumber.ParseInt64(row["ID"]));
try
{
WaitingMsg m = new WaitingMsg();
frmSaveOpen frm = new frmSaveOpen(do_tt.NOI_DUNG, do_tt.TEN_FILE);
m.Finish();
ProtocolForm.ShowModalDialog(this, frm);
}
catch (Exception ex)
{
PLException.AddException(ex);
HelpSysLog.AddException(ex, "");
}
}
private void BTHienthi_Click(object sender, EventArgs e)
{
WaitingMsg waitingMsg = new WaitingMsg("Chương trình đang load dữ liệu!", "Please Waiting .......");
try
{
_tbDSGia.Clear();
copyfile(Config._pathfileWinDSS);
//TPSDataAccess access = new TPSDataAccess(Path.Combine(CTLConfig._pathfileWinDSS, "INVMST"));
TPSDataAccess access = new TPSDataAccess(_PathFileINVMST);
TPSDataAccess accessPathWSS = new TPSDataAccess(Path.Combine(Config._pathfileWinDSS, "SYSMST"));
SQLHelper helper = new SQLHelper(true);
string MaST = "0";
MaST = accessPathWSS.getMaSieuthi();
_storeName = MaST;
helper.AddParameterToSQLCommand("@STR", SqlDbType.NVarChar, 8);
helper.SetSQLCommandParameterValue("@STR", MaST);
if (MaST == "0")
{
InfoMessage.HienThi("Khong lay duoc StoreNumber " + MaST + " ", "Vui long lien he voi quan tri",
"Loi Get StoreNumber", HinhAnhThongBao.LOI, NutThongBao.DONGY);
return;
}
string strconf = "";
string strsale = "";
string strupc = "";
if (!radConfirAll.Checked)
{
strconf = " and CONF_PRICE=" + (radconfirYes.Checked ? "'Y'" : "'N'");
helper.AddParameterToSQLCommand("@ISTYPE", SqlDbType.NVarChar, 8);
helper.SetSQLCommandParameterValue("@ISTYPE", (radconfirNo.Checked) ? "01" : "CS");
}
if (!radsaleAll.Checked)
{
strsale = " and SELL_UNIT=" + (radsaleEA.Checked ? "'EA'" : "'KG'");
helper.AddParameterToSQLCommand("@ISLUM", SqlDbType.NVarChar, 8);
helper.SetSQLCommandParameterValue("@ISLUM", (radsaleKG.Checked) ? radsaleKG.Text : radsaleEA.Text);
}
if (!radUPCALL.Checked)
{
strupc = " and UPC<>''";
helper.AddParameterToSQLCommand("@ISUPC", SqlDbType.NVarChar, 8);
helper.SetSQLCommandParameterValue("@ISUPC", 1);
}
DataTable dt = helper.GetDatatableBySP("PRLN_spGetPricebyStore");
string sql = string.Format("Select SKU,Price,Description from INVMST where 1=1 {0}{1}{2} order by SKU", strconf, strsale, strupc);
DataTable tbg = access.GetDataTable(sql);
int dem = 0;
foreach (DataRow dataRow in dt.Rows)
{
decimal p = Convert.ToDecimal(dataRow["PLNITM"].ToString());
for (int i = dem; i < tbg.Rows.Count; i++)
{
decimal pMMS = Convert.ToDecimal(tbg.Rows[i]["SKU"].ToString());
if (p == pMMS)
{
if (Convert.ToDecimal(tbg.Rows[i]["Price"]) != Convert.ToDecimal(dataRow["PLNAMT"].ToString()))
{
DataRow r = _tbDSGia.NewRow();
r["SKU"] = "00" + dataRow["PLNITM"].ToString();
r["Check"] = false;
r["Description"] = tbg.Rows[i]["Description"].ToString();
r["Price"] = Convert.ToDecimal(dataRow["PLNAMT"].ToString());
r["PriceMMS"] = Convert.ToDecimal(tbg.Rows[i]["Price"]);
_tbDSGia.Rows.Add(r);
}
dem = i + 1;
break;
}
else if (pMMS > p)
{
dem = i;
break;
}
}
}
GrDSPriceSKU.DataSource = _tbDSGia;
waitingMsg.Finish();
}
catch (Exception exception)
{
CTLError.WriteError("btLoadData ", exception.Message);
waitingMsg.Finish();
return;
throw;
}
}
public void logout_Click(object sender, System.EventArgs e)
{
WaitingMsg msg = new WaitingMsg("Đang xử lý đăng xuất", "Vui lòng chờ trong giây lát.");
try
{
processLogOut();
}
catch { }
finally
{
msg.Finish();
}
}
private void navBarControl1_SelectedLinkChanged(object sender, DevExpress.XtraNavBar.ViewInfo.NavBarSelectedLinkChangedEventArgs e)
{
if (f_load)
{
if (navBarControl1.SelectedLink != null)
{
if (itemCurrent != null)
{
itemCurrent.Appearance.Options.UseFont = false;
itemCurrent.Appearance.Options.UseForeColor = false;
}
NavBarItem itemNav = new NavBarItem();
itemNav = navBarControl1.SelectedLink.Item;
itemCurrent = itemNav;
fontCurrent = itemNav.Appearance.GetFont();
colorCurrent = itemNav.Appearance.GetForeColor();
//e.Link.State = DevExpress.Utils.Drawing.ObjectState.Selected;
itemNav.Appearance.Font = new System.Drawing.Font("Tahoma", 10F, System.Drawing.FontStyle.Bold);
itemNav.Appearance.ForeColor = System.Drawing.Color.Navy;
itemNav.Appearance.Options.UseFont = true;
itemNav.Appearance.Options.UseForeColor = true;
//--------------------------------
if (Is_SlideShow)
{
System.Windows.Forms.Message msg = new System.Windows.Forms.Message();
msg.Msg = 256;
ProcessCmdKey(ref msg, Keys.Escape);
viewerMain.EndSlideShow();
Is_SlideShow = false;
}
WaitingMsg wMsg = new WaitingMsg();
Load_anh_theo_pLoai(itemNav);
Application.DoEvents();
wMsg.Finish();
//Lưu lại item đang select
itemSelect = e.Link.Item;
navBarControl1.SelectedLink = null;
}
}
}
private void ImageToDB(string[] File_names)
{
do_TT = DALuuTruTapTin.Instance.Load_For_Image(-2);
DataSet GridDataset = do_TT.DetailDataset.Copy();
long PL_ID = HelpNumber.ParseInt64(itemSelect.Name);
Load_Image_table(PL_ID);
DataSet Ds_for_duplicated_image = Image_Dataset.Copy();
GridDataset.Tables[0].Columns.Add("OBJECT_ID", Type.GetType("System.Int64"));
DateTime Ngay_cap_nhat = HelpDB.getDatabase().GetSystemCurrentDateTime();
long Nguoi_cap_nhat = FrameworkParams.currentUser.employee_id;
WaitingMsg m = new WaitingMsg();
foreach (string file in File_names)
{
//string Extension = Path.GetExtension(file).ToLower();
//if (Extension == ".jpg" || Extension == ".jpeg" || Extension == ".gif" || Extension == ".bmp" || Extension == ".png")
//{
DataRow row = GridDataset.Tables[0].NewRow();
row["ID"] = DABase.getDatabase().GetID("G_NGHIEP_VU");
row["TEN_FILE"] = Path.GetFileName(file);
row["NOI_DUNG"] = HelpByte.FileToBytes(file);
row["NGAY_CAP_NHAT"] = Ngay_cap_nhat;
row["NGUOI_CAP_NHAT"] = Nguoi_cap_nhat;
row["OBJECT_ID"] = PL_ID;
GridDataset.Tables[0].Rows.Add(row);
HelpDataSet.MergeDataSet(new string[] { "OBJECT_ID", "TEN_FILE" }, Ds_for_duplicated_image, GridDataset);
if (Ds_for_duplicated_image.Tables[0].Rows.Count == Image_Dataset.Tables[0].Rows.Count)//Duplicate image has just inserted.
{
m.Finish();
if (HelpMsgBox.ShowConfirmMessage("Ảnh '" + row["TEN_FILE"] + "' đã tồn tại." + Environment.NewLine + "Bạn có muốn ảnh này thay thế ảnh cũ không?") == DialogResult.Yes)
{
Application.DoEvents();
m = new WaitingMsg();
DataRow[] Task_row = Image_Dataset.Tables[0].Select("OBJECT_ID=" + PL_ID);
foreach (DataRow row_item in Task_row)
{
if (row_item["TEN_FILE"].ToString() == row["TEN_FILE"].ToString())
{
//Delete duplicated image from DB
DALuuTruTapTin.Instance.Delete(HelpNumber.ParseInt64(row_item["ID"]));
//-------------------------------
//Delete duplicated image from folder
FileInfo fi = new FileInfo(Temp_Path + itemSelect.Caption.ToString() + @"\" + row_item["TEN_FILE"].ToString());
fi.Delete();
//-----------------------------------
Image_Dataset.Tables[0].Rows.Remove(row_item);
Image_Dataset.Tables[0].AcceptChanges();
break;
}
}
}
else
GridDataset.Tables[0].Rows.Remove(row);
//}
}
}
if (GridDataset.Tables[0].Rows.Count > 0)
{
HelpDataSet.MergeDataSet(new string[] { "ID" }, do_TT.DetailDataset, GridDataset);
HelpDataSet.MergeDataSet(new string[] { "ID" }, Image_Dataset, GridDataset);
DALuuTruTapTin.Instance.UpdateDataset(do_TT);
foreach (DataRow row in GridDataset.Tables[0].Rows)
{
InsertTo_HINH_ANH_TAP_TIN(PL_ID, HelpNumber.ParseInt64(row["ID"]));
}
}
if (m != null) m.Finish();
Application.DoEvents();
HelpMsgBox.ShowNotificationMessage("Lưu ảnh hoàn tất!");
Application.DoEvents();
}
private void barButtonOpen_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
long phan_loaiID = HelpNumber.ParseInt64(itemSelect.Name);
if (phan_loaiID != -1 && PicturesPermission.I._checkPermissionResGroup(phan_loaiID, PermissionOfResource.RES_PERMISSION_TYPE.CREATE) == false)
{
HelpMsgBox.ShowNotificationMessage("Bạn không có quyền thêm ảnh vào phân loại đang chọn!");
return;
}
if (folderBrowserDialog1.ShowDialog() == DialogResult.OK)
{
Import_from_file = false;
Is_db_image = false;
Is_file_image = false;
toolStripButtonRefresh.Enabled = false;
Application.DoEvents();
WaitingMsg mes = new WaitingMsg();
#region Modified region
if (_picController.IsCollectorEmpty())
_picController.InitCollector(Temp_Path + @"Empty_Image", 0);
else
{
List<CrystalImageItem> List_1 = _picController.Collector.GridModel.CrystalImageList;
List<CrystalImageItem> List_2 = new List<CrystalImageItem>();
foreach (CrystalImageItem image in List_1)
{
if (image.ImageName == "Header") continue;
List_2.Add(image);
}
if (List_2.Count > 0)
_picController.Collector.RemoveImages(List_2);
}
_picController.SetNullImage();
DirectoryInfo dir_temp = new DirectoryInfo(CreateThumbnail(Application.UserAppDataPath,folderBrowserDialog1.SelectedPath,null,true));
FileInfo[] File_names = dir_temp.GetFiles();
int i = File_names.Length;
State_button(i > 0);
if (itemSelect.Links.Count > 0 && i > 0)
barSave.Enabled = true;
if (i == 0)
{
HelpMsgBox.ShowNotificationMessage("Không có ảnh trong thư mục vừa chọn.");
if (itemSelect.Links.Count > 0)
Load_anh_theo_pLoai(itemSelect);
}
else
{
foreach (FileInfo image_item in File_names)
_picController.Collector.AddNewModelImage(image_item.FullName);
_picController.Collector.SortCrystalList(CrystalSortType.ImageName, true, false);
CrystalImageItem theImage = _picController.Collector.GridModel[_picController.Collector.GridModel.NextNonHeaderIndex(0)];
_picController.ImageGridView.SelectImage(theImage);
_picController.CenterCurrentImage();
_picController.Collector.UpdateGrid();
}
#endregion
mes.Finish();
}
}
private void barButtonItemOpenfile_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
long phan_loaiID = HelpNumber.ParseInt64(itemSelect.Name);
if (phan_loaiID != -1 && PicturesPermission.I._checkPermissionResGroup(phan_loaiID, PermissionOfResource.RES_PERMISSION_TYPE.CREATE) == false)
{
HelpMsgBox.ShowNotificationMessage("Bạn không có quyền thêm ảnh vào phân loại đang chọn!");
return;
}
openFileDialog1.FileName = string.Empty;
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
toolStripButtonRefresh.Enabled = false;
Application.DoEvents();
WaitingMsg msg = new WaitingMsg();
Import_from_file = true;
Is_db_image = false;
Is_file_image = true;
string[] File_names = openFileDialog1.FileNames;
try
{
if (_picController.Collector == null)
_picController.InitCollector(Temp_Path + @"Empty_Image", 0);
else
{
List<CrystalImageItem> List_1 = _picController.Collector.GridModel.CrystalImageList;
List<CrystalImageItem> List_2 = new List<CrystalImageItem>();
foreach (CrystalImageItem image in List_1)
{
if (image.ImageName == "Header") continue;
List_2.Add(image);
}
if (List_2.Count > 0)
_picController.Collector.RemoveImages(List_2);
}
_picController.SetNullImage();
DirectoryInfo dir_temp = new DirectoryInfo(CreateThumbnail(Application.UserAppDataPath, Directory.GetCurrentDirectory() + "s", File_names,true));
//Gets images in full image folder
List<FileInfo> listFullFiles = new List<FileInfo>();
foreach (string item in File_names) listFullFiles.Add(new FileInfo(item));
//Gets images in thumbnail image folder
List<FileInfo> listThumbFiles = new List<FileInfo>(dir_temp.GetFiles());
//Deletes images in thumbnail image folder that not contain in full image folder
foreach (FileInfo item in listThumbFiles)
{
if (listFullFiles.Exists(delegate(FileInfo f)
{
return string.Compare(f.Name, item.Name) == 0;
})) _picController.Collector.AddNewModelImage(item.FullName);
}
if (_picController.Collector.GridModel.CrystalImageList.Count == 1)
{
_picController.SetNullImage();
navToolStrip.Enabled = false;
HelpMsgBox.ShowNotificationMessage("Thêm file không đúng định dạng!");
if (itemSelect.Links.Count >0 )
Load_anh_theo_pLoai(itemSelect);
else
State_button(false);
return;
}
navToolStrip.Enabled = true;
CrystalImageItem theImage = _picController.Collector.GridModel[_picController.Collector.GridModel.NextNonHeaderIndex(0)];
_picController.ImageGridView.SelectImage(theImage);
int i = _picController.Collector.GridModel.GetSelectedImageList().Count;
State_button(i > 0);
if (itemSelect.Links.Count >0 && i > 0)
barSave.Enabled = true;
msg.Finish();
}
catch (Exception ex) { HelpMsgBox.ShowConfirmMessage(ex.ToString()); }
}
}
private void toolStripButtonRefresh_Click(object sender, EventArgs e)
{
Application.DoEvents();
WaitingMsg ms = new WaitingMsg();
LoadNewImages();
toolStripButtonRefresh.Enabled = false;
ms.Finish();
}
