private void barBtnXuatBaoCao_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (Object.Equals(objPhong, null))
{
XtraMessageBox.Show("Chưa chọn phòng!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (Object.Equals(objPhong.id, Guid.Empty))
{
XtraMessageBox.Show("Chưa chọn phòng!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
String strViTri = "[Không Rõ]";
if (!Object.Equals(objPhong.vitri, null))
strViTri = objPhong.vitri.coso != null ? objPhong.vitri.coso.ten + (objPhong.vitri.day != null ? " - " + objPhong.vitri.day.ten + (objPhong.vitri.tang != null ? " - " + objPhong.vitri.tang.ten : "") : "") : "";
if (Object.Equals(listCTThietBis, null))
{
XtraMessageBox.Show(String.Format("Phòng {0} ({1}) chưa có thiết bị!", objPhong.ten, strViTri), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
if (listCTThietBis.Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::PTB_GUI.WaitForm1), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReport_Template _XtraReport_Template = new XtraReport_Template(SHARED.Libraries.ReportHelper.FillDatasetFromGrid(gridViewCTThietBi), gridViewCTThietBi, barCheckItemLandscape.Checked);
_XtraReport_Template.SetTitleText(String.Format("Danh Sách Thiết Bị Tại Phòng: {0} ({1})", objPhong.ten, strViTri));
if (barCheckItemThietKe.Checked)
{
ReportDesignTool designTool = new ReportDesignTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
designTool.ShowDesignerDialog();
ReportPrintTool printTool = new ReportPrintTool(designTool.Report);
printTool.ShowPreviewDialog();
}
else
{
ReportPrintTool printTool = new ReportPrintTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show(String.Format("Phòng {0} ({1}) chưa có thiết bị!", objPhong.ten, strViTri), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
splashScreenManager1.ShowWaitForm();
try
{
if (_ischanginglogin)
{
ChangeLogin();
MessageBox.Show("Логин был изменен");
}
else
{
ChangePassword();
MessageBox.Show("Пароль был изменен");
}
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(String.Format(ex.Message), "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
splashScreenManager1.CloseWaitForm();
}
}
private void barBtnXuatBaoCao_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (Object.Equals(_ViTriHienTai, null))
{
XtraMessageBox.Show("Chưa chọn vị trí!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (Object.Equals(listPhong, null))
{
XtraMessageBox.Show("Không có phòng!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
String strViTri = _ViTriHienTai.coso != null ? _ViTriHienTai.coso.ten + (_ViTriHienTai.day != null ? " - " + _ViTriHienTai.day.ten + (_ViTriHienTai.tang != null ? " - " + _ViTriHienTai.tang.ten : "") : "") : "";
if (listPhong.Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::PTB_GUI.WaitForm1), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReport_Template _XtraReport_Template = new XtraReport_Template(SHARED.Libraries.ReportHelper.FillDatasetFromGrid(gridViewPhong), gridViewPhong, barCheckItemLandscape.Checked);
_XtraReport_Template.SetTitleText("Danh Sách Phòng Tại: " + strViTri);
if (barCheckItemThietKe.Checked)
{
ReportDesignTool designTool = new ReportDesignTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
designTool.ShowDesignerDialog();
ReportPrintTool printTool = new ReportPrintTool(designTool.Report);
printTool.ShowPreviewDialog();
}
else
{
ReportPrintTool printTool = new ReportPrintTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
strViTri = "[" + strViTri + "]";
XtraMessageBox.Show(strViTri + " không có phòng!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public static void iWaitForm(this DevExpress.XtraSplashScreen.SplashScreenManager spmg)
{
if (spmg.IsSplashFormVisible)
{
spmg.CloseWaitForm();
}
else
{
spmg.ShowWaitForm();
}
}
private void OpenSplashScreen(Type screenType, Form frm)
{
bgWorker = new BackgroundWorker();
if (bgWorker.IsBusy != true)
{
SplashScreenManager = new DevExpress.XtraSplashScreen.SplashScreenManager(frm, screenType, true, true);
if (!SplashScreenManager.IsSplashFormVisible)
{
SplashScreenManager.ShowWaitForm();
}
}
}
public void ShowWaitForm()
{
try
{
if (!SplashManager.IsSplashFormVisible)
{
SplashManager.ShowWaitForm();
}
}
catch (Exception ex)
{
if (CDS.Shared.Exception.UserInterfaceExceptionHandler.HandleException(ref ex))
{
throw ex;
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
splashScreenManager1.ShowWaitForm();
try
{
ImportOrder();
MessageBox.Show("Заявка была импортирована");
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(String.Format(ex.Message), "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
splashScreenManager1.CloseWaitForm();
}
}
private void barBtnXuatBaoCao_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (Object.Equals(NhanVienPTs, null))
{
XtraMessageBox.Show("Chưa có nhân viên phụ trách", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (NhanVienPTs.Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::PTB_GUI.WaitForm1), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReport_Template _XtraReport_Template = new XtraReport_Template(SHARED.Libraries.ReportHelper.FillDatasetFromGrid(gridViewNhanVien), gridViewNhanVien, barCheckItemLandscape.Checked, false);
_XtraReport_Template.SetTitleText("Danh Sách Nhân Viên Phụ Trách");
if (barCheckItemThietKe.Checked)
{
ReportDesignTool designTool = new ReportDesignTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
designTool.ShowDesignerDialog();
ReportPrintTool printTool = new ReportPrintTool(designTool.Report);
printTool.ShowPreviewDialog();
}
else
{
ReportPrintTool printTool = new ReportPrintTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có nhân viên phụ trách", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
var agencyReportRequest = new AgencyReportRequest();
agencyReportRequest.ServiceType = "flights";
agencyReportRequest.OrganizationCode = _orgcode;
agencyReportRequest.BeginDate = calFrom.DateTime;
agencyReportRequest.EndDate = calTo.DateTime;
splashScreenManager1.ShowWaitForm();
try
{
DataProcessor.CreateReport(null, cbFormat.EditValue.ToString(), null, "agentreport", agencyReportRequest);
}
finally
{
splashScreenManager1.CloseWaitForm();
}
this.DialogResult = DialogResult.OK;
}
private void wizardControl1_SelectedPageChanged(object sender, WizardPageChangedEventArgs e)
{
if (e.Page == pageCreateDatabase)
{
Splash = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(Waiting.Wait), true, true);
Splash.WaitForSplashFormClose();
if (!Splash.IsSplashFormVisible)
{
Splash.ShowWaitForm();
}
do_SQLSettings();
if (DataBaseControl)
{
e.Page.AllowNext = true;
do_CreateTable();
if (Splash.IsSplashFormVisible)
{
Splash.CloseWaitForm();
}
}
else
{
e.Page.AllowNext = false;
do_CreateDatabese();
if (Splash.IsSplashFormVisible)
{
Splash.CloseWaitForm();
}
}
}
if (e.Page == pageLisansDemo)
{
dt_RecordDate.EditValue = DateTime.Now;
}
}
private void barBtnXuatBaoCao_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (Object.Equals(NhanVienPTs, null))
{
XtraMessageBox.Show("Chưa có nhân viên phụ trách", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (NhanVienPTs.Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::PTB_GUI.WaitForm1), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReport_Template _XtraReport_Template = new XtraReport_Template(SHARED.Libraries.ReportHelper.FillDatasetFromGrid(gridViewNhanVien), gridViewNhanVien, barCheckItemLandscape.Checked, false);
_XtraReport_Template.SetTitleText("Danh Sách Nhân Viên Phụ Trách");
if (barCheckItemThietKe.Checked)
{
ReportDesignTool designTool = new ReportDesignTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
designTool.ShowDesignerDialog();
ReportPrintTool printTool = new ReportPrintTool(designTool.Report);
printTool.ShowPreviewDialog();
}
else
{
ReportPrintTool printTool = new ReportPrintTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có nhân viên phụ trách", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void barButtonItemXuatThongKe_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (current.Equals(_ucTKPhong))
{
if (Object.Equals(_ucTKPhong.gridControlPhong.DataSource, null))
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (((List <Phong_ThongKe>)_ucTKPhong.gridControlPhong.DataSource).Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::TSCD_GUI.WaitFormLoad), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReportTSCD_Grid _XtraReportTSCD_Grid = new XtraReportTSCD_Grid(_ucTKPhong.gridControlPhong, false);
_XtraReportTSCD_Grid.SetTextTitle("Thống Kê Phòng");
_XtraReportTSCD_Grid.SetTextTitle_TopRight("");
ReportPrintTool printTool = new ReportPrintTool(_XtraReportTSCD_Grid);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (current.Equals(_ucTKTaiSan))
{
if (Object.Equals(_ucTKTaiSan.gridControlTaiSan.DataSource, null))
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (((List <TaiSan_ThongKe>)_ucTKTaiSan.gridControlTaiSan.DataSource).Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::TSCD_GUI.WaitFormLoad), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReportTSCD_Grid _XtraReportTSCD_Grid = new XtraReportTSCD_Grid(_ucTKTaiSan.gridControlTaiSan, false);
_XtraReportTSCD_Grid.SetTextTitle("Thống Kê Tài Sản");
_XtraReportTSCD_Grid.SetTextTitle_TopRight("");
ReportPrintTool printTool = new ReportPrintTool(_XtraReportTSCD_Grid);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (current.Equals(_ucTKHaoMon))
{
if (Object.Equals(_ucTKHaoMon.gridControlHaoMon.DataSource, null))
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (((List <TaiSanHienThi>)_ucTKHaoMon.gridControlHaoMon.DataSource).Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::TSCD_GUI.WaitFormLoad), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReportTSCD_Grid _XtraReportTSCD_Grid = new XtraReportTSCD_Grid(_ucTKHaoMon.gridControlHaoMon, false);
_XtraReportTSCD_Grid.SetTextTitle("Thống Kê Hao Mòn");
_XtraReportTSCD_Grid.SetTextTitle_TopRight("");
ReportPrintTool printTool = new ReportPrintTool(_XtraReportTSCD_Grid);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (current.Equals(_ucTKTHPhong))
{
if (Object.Equals(_ucTKTHPhong.gridControlPhong.DataSource, null))
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (((List <Phong_ThongKe>)_ucTKTHPhong.gridControlPhong.DataSource).Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::TSCD_GUI.WaitFormLoad), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReportTSCD_Grid _XtraReportTSCD_Grid = new XtraReportTSCD_Grid(_ucTKTHPhong.gridControlPhong, false);
_XtraReportTSCD_Grid.SetTextTitle("Thống Kê Tổng Hợp Phòng");
_XtraReportTSCD_Grid.SetTextTitle_TopRight("");
ReportPrintTool printTool = new ReportPrintTool(_XtraReportTSCD_Grid);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (current.Equals(_ucTKTHTaiSan))
{
if (Object.Equals(_ucTKTHTaiSan.gridControlTaiSan.DataSource, null))
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (((List <TaiSanHienThi>)_ucTKTHTaiSan.gridControlTaiSan.DataSource).Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::TSCD_GUI.WaitFormLoad), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReportTSCD_Grid _XtraReportTSCD_Grid = new XtraReportTSCD_Grid(_ucTKTHTaiSan.gridControlTaiSan, false);
_XtraReportTSCD_Grid.SetTextTitle("Thống Kê Tổng Hợp Tài Sản");
_XtraReportTSCD_Grid.SetTextTitle_TopRight("");
ReportPrintTool printTool = new ReportPrintTool(_XtraReportTSCD_Grid);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void do_FirstRecord()
{
if (Convert.ToString(txtKullaniciAdi.EditValue) == "")
{
XtraMessageBox.Show("Kullanıcı Adı Giriniz.");
return;
}
if (Convert.ToString(txtUserParola.EditValue) == "")
{
XtraMessageBox.Show("Parola Giriniz.");
return;
}
if (Convert.ToString(txtSirketAdi.EditValue) == "")
{
XtraMessageBox.Show("Şirket Adı Giriniz.");
return;
}
if (Convert.ToString(txtDepotAdi.EditValue) == "")
{
XtraMessageBox.Show("Depo Adı Giriniz.");
return;
}
try
{
Splash = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(Waiting.Wait), true, true);
Splash.WaitForSplashFormClose();
if (!Splash.IsSplashFormVisible)
{
Splash.ShowWaitForm();
}
SqlCommand sCommand = SqlCreateCommandFront(SqlConnectionString);
sCommand.CommandText = "SELECT [TableName] = so.name FROM sysobjects so WHERE so.xtype = 'U' GROUP BY so.name ";
DataTable tblTableList = ExecuteSelectCommand(sCommand);
DataColumn[] KeysTableList = new DataColumn[1];
KeysTableList[0] = tblTableList.Columns["TableName"];
tblTableList.PrimaryKey = KeysTableList;
#region Users
if (tblTableList.Rows.Contains("Users") == false)
{
sCommand.CommandText = "CREATE TABLE [dbo].[Users]( "
+ " [id][int] IDENTITY(1, 1) NOT NULL, "
+ " [username] [nvarchar] (50) NOT NULL, "
+ " [password] [nvarchar] (50) NULL, "
+ " [note] [text] NULL, "
+ " [date] [datetime] NULL, "
+ " [Active] [bit] NULL, "
+ " [HaspPassword] [nvarchar] (50) NULL, "
+ " [Email] [nvarchar] (50) NULL, "
+ " [DefaultTheme] "
+ " [nvarchar] "
+ " (max) NULL, "
+ " [DefaultTheme2] [nvarchar] "
+ " (max) NULL, "
+ " [AdminAuthority] [bit] NULL, "
+ " [ReportPrint][bit] NULL, "
+ " [ExportExcelPdf] [bit] NULL, "
+ " [DailyEndOperation] [bit] NULL, "
+ " [EnvanterEntry] [bit] NULL, "
+ " [VeresiyeDefterClosed] [bit] NULL, "
+ " CONSTRAINT[PK_users] PRIMARY KEY CLUSTERED "
+ " ( "
+ " [username] ASC "
+ " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] "
+ " ) ON[PRIMARY] TEXTIMAGE_ON[PRIMARY]";
ExecuteNonQuery(sCommand);
}
sCommand.CommandText = "INSERT INTO [dbo].[Users] "
+ " ([username] "
+ " ,[password] "
+ " ,[date] "
+ " ,[Active] "
+ " ,[HaspPassword]) "
+ " VALUES "
+ " ('Admin' "
+ " ,@Password "
+ " ,@date "
+ " ,'True' "
+ " ,@HashPassword)";
sCommand.Parameters.Clear();
sCommand.Parameters.Add("Password", SqlDbType.NVarChar).Value = SecurityExtension.Sifrele("c4e128b141aFb");
sCommand.Parameters.Add("date", SqlDbType.DateTime).Value = DateTime.Now;
sCommand.Parameters.Add("HashPassword", SqlDbType.NVarChar).Value = SecurityExtension.ConvertStringToMD5("c4e128b141aFb");
ExecuteNonQuery(sCommand);
sCommand.CommandText = "INSERT INTO [dbo].[Users] "
+ " ([username] "
+ " ,[password] "
+ " ,[date] "
+ " ,[Active] "
+ " ,[HaspPassword]) "
+ " VALUES "
+ " (@userName "
+ " ,@Password "
+ " ,@date "
+ " ,'True' "
+ " ,@HashPassword)";
sCommand.Parameters.Clear();
sCommand.Parameters.Add("userName", SqlDbType.NVarChar).Value = txtKullaniciAdi.EditValue;
sCommand.Parameters.Add("Password", SqlDbType.NVarChar).Value = SecurityExtension.Sifrele(txtUserParola.EditValue.ToString());
sCommand.Parameters.Add("date", SqlDbType.DateTime).Value = DateTime.Now;
sCommand.Parameters.Add("HashPassword", SqlDbType.NVarChar).Value = SecurityExtension.ConvertStringToMD5(txtUserParola.EditValue.ToString());
ExecuteNonQuery(sCommand);
#endregion
#region Company
if (tblTableList.Rows.Contains("Company") == false)
{
sCommand.CommandText = "CREATE TABLE [dbo].[Company]( "
+ " [RecId][int] IDENTITY(1, 1) NOT NULL, "
+ " [CompanyCode] [nvarchar] (50) NULL, "
+ " [CompanyName] [nvarchar] (50) NULL, "
+ " [Logo] [image] NULL, "
+ " [Adress1] [nvarchar] (50) NULL, "
+ " [Adress2] [nvarchar] (50) NULL, "
+ " [BulvarCadde] [nvarchar] (50) NULL, "
+ " [TelNo] [int] NULL, "
+ " [BinaAdi] [nvarchar] (50) NULL, "
+ " [BinaNo] [nvarchar] (50) NULL, "
+ " [MahalleSemt] [nvarchar] (50) NULL, "
+ " [Sehir] [nvarchar] (50) NULL, "
+ " [PostaKodu] [int] NULL, "
+ " [Ulke] [nvarchar] (50) NULL, "
+ " CONSTRAINT[PK_Company] PRIMARY KEY CLUSTERED "
+ " ( "
+ " [RecId] ASC "
+ " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] "
+ " ) ON[PRIMARY] TEXTIMAGE_ON[PRIMARY]";
ExecuteNonQuery(sCommand);
}
sCommand.CommandText = "INSERT INTO [dbo].[Company] ([CompanyCode], [CompanyName]) VALUES ('001', @companyName);SELECT SCOPE_IDENTITY();";
sCommand.Parameters.Clear();
sCommand.Parameters.Add("companyName", SqlDbType.NVarChar).Value = txtSirketAdi.EditValue;
int CompanyRecId = Convert.ToInt32(ExecuteScalar(sCommand));
//ExecuteNonQuery(sCommand);
#endregion
#region Depo
if (tblTableList.Rows.Contains("Depot") == false)
{
sCommand.CommandText = "CREATE TABLE [dbo].[Depot]( "
+ " [DID][int] IDENTITY(1, 1) NOT NULL, "
+ " [DepName] [nvarchar] (50) NULL, "
+ " [DepAddress] [nvarchar] (50) NULL, "
+ " [DepDistrict] [nvarchar] (50) NULL, "
+ " [DepCity] [nvarchar] (50) NULL, "
+ " [DepAuthPerson] [nvarchar] (50) NULL, "
+ " [DepPhoneOne] [nvarchar] (50) NULL, "
+ " [DepPhoneTwo] [nvarchar] (50) NULL, "
+ " [DepTaxAdministration] [nvarchar] (50) NULL, "
+ " [DepTaxNo] [nvarchar] (50) NULL, "
+ " [DepActive] [bit] NULL, "
+ " [DepDate] [datetime] NULL, "
+ " [CompanyRecId] [int] NULL, "
+ " CONSTRAINT[PK_Depot] PRIMARY KEY CLUSTERED "
+ " ( "
+ " [DID] ASC "
+ " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] "
+ " ) ON[PRIMARY]";
ExecuteNonQuery(sCommand);
}
sCommand.CommandText = "INSERT INTO [dbo].[Depot] ([DepName],[CompanyRecId]) VALUES (@DepName, @CompanyRecId)";
sCommand.Parameters.Clear();
sCommand.Parameters.Add("DepName", SqlDbType.NVarChar).Value = txtDepotAdi.EditValue;
sCommand.Parameters.Add("CompanyRecId", SqlDbType.Int).Value = CompanyRecId;
ExecuteNonQuery(sCommand);
#endregion
#region ApplicatonServer
if (tblTableList.Rows.Contains("ApplicationServer") == false)
{
sCommand.CommandText = "CREATE TABLE [dbo].[ApplicationServer]( "
+ " [Id][int] IDENTITY(1, 1) NOT NULL, "
+ " "
+ " [Server] [nvarchar] "
+ " (max) NULL, "
+ " "
+ " [ServerName] [nvarchar] "
+ " (max) NULL, "
+ " "
+ " [UserName] [nvarchar] (200) NULL, "
+ " [Password] "
+ " [nvarchar] "
+ " (max) NULL, "
+ " "
+ " [DataBase] [nvarchar] (50) NULL, "
+ " CONSTRAINT[PK_ApplicationServer] PRIMARY KEY CLUSTERED "
+ " ( "
+ " [Id] ASC "
+ " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] "
+ " ) ON[PRIMARY] TEXTIMAGE_ON[PRIMARY]";
ExecuteNonQuery(sCommand);
}
string[] conArry;
conArry = SqlConnectionString.Split(';');
List <string> conn = new List <string>();
foreach (var item in conArry)
{
int position = item.IndexOf("=");
if (position < 0)
{
continue;
}
conn.Add(item.Substring(position + 1));
}
if (SqlLocal)
{
sCommand.CommandText = "INSERT INTO [dbo].[ApplicationServer] "
+ " ([Server] "
+ " ,[ServerName] "
+ " ,[UserName] "
+ " ,[Password] "
+ " ,[DataBase])"
+ " VALUES "
+ " (@server "
+ " ,@serverName "
+ " ,'' "
+ " ,'' , @DataBase)";
sCommand.Parameters.Clear();
sCommand.Parameters.Add("server", SqlDbType.NVarChar).Value = "(localdb)\\MSSQLLocalDB";
sCommand.Parameters.Add("serverName", SqlDbType.NVarChar).Value = "SQLLocal";
sCommand.Parameters.Add("DataBase", SqlDbType.NVarChar).Value = "Msp";
ExecuteNonQuery(sCommand);
}
else
{
//sCommand.CommandText = "INSERT INTO [dbo].[ApplicationServer] "
// + " ([Server] "
// + " ,[ServerName] "
// + " ,[UserName] "
// + " ,[Password] "
// + " ,[DataBase])"
// + " VALUES "
// + " (@server "
// + " ,@serverName "
// + " ,'' "
// + " ,'' , @DataBase)";
//sCommand.Parameters.Clear();
//sCommand.Parameters.Add("server", SqlDbType.NVarChar).Value = "(localdb)\\MSSQLLocalDB";
//sCommand.Parameters.Add("serverName", SqlDbType.NVarChar).Value = "SQLLocal";
//sCommand.Parameters.Add("DataBase", SqlDbType.NVarChar).Value = "Msp";
//ExecuteNonQuery(sCommand);
}
#endregion
#region Parameter
if (tblTableList.Rows.Contains("Parameters") == false)
{
sCommand.CommandText = "CREATE TABLE [dbo].[Parameters]( "
+ " [RecId][int] IDENTITY(1, 1) NOT NULL, "
+ " [NumaratorShow] [bit] NULL, "
+ " [SaleApproval] [bit] NULL, "
+ " [SaleOutOfStock] [bit] NULL, "
+ " [SaleCahnge] [bit] NULL, "
+ " [SaleInformationSlip] [bit] NULL, "
+ " [MainSaleForm] [bit] NULL, "
+ " [AutoCurrency] [bit] NULL, "
+ " [UserRecordMy] [bit] NULL, "
+ " [PaymentLock] [bit] NULL, "
+ " [PaymentyForced] [bit] NULL, "
+ " [SaleNewRecord] [bit] NULL, "
+ " [SaleProductEndDate] [bit] NULL, "
+ " [ProductEndDateDay] [int] NULL, "
+ " CONSTRAINT[PK_Parameters] PRIMARY KEY CLUSTERED "
+ " ( "
+ " [RecId] ASC "
+ " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] "
+ " ) ON[PRIMARY]";
ExecuteNonQuery(sCommand);
}
sCommand.CommandText = "INSERT INTO [dbo].[Parameters] "
+ " ([NumaratorShow] "
+ " ,[SaleApproval] "
+ " ,[SaleOutOfStock] "
+ " ,[SaleCahnge] "
+ " ,[SaleInformationSlip] "
+ " ,[MainSaleForm] "
+ " ,[AutoCurrency] "
+ " ,[UserRecordMy] "
+ " ,[PaymentLock] "
+ " ,[PaymentyForced] "
+ " ,[SaleNewRecord] "
+ " ,[SaleProductEndDate] "
+ " ,[ProductEndDateDay]) "
+ " VALUES "
+ " ('True' "
+ " ,'False' "
+ " ,'False' "
+ " ,'False' "
+ " ,'False' "
+ " ,'False' "
+ " ,'False' "
+ " ,'False' "
+ " ,'False' "
+ " ,'True' "
+ " ,'True' "
+ " ,'False' "
+ " ,10)";
sCommand.Parameters.Clear();
ExecuteNonQuery(sCommand);
#endregion
#region Currency
if (tblTableList.Rows.Contains("CurrencyType") == false)
{
sCommand.CommandText = "CREATE TABLE [dbo].[CurrencyType]( "
+ " [RecId][int] IDENTITY(1, 1) NOT NULL, "
+ " [CurrencyCode] [varchar] (3) NOT NULL, "
+ " [Remark] [varchar] (50) NULL, "
+ " [CompanyRecId] [int] NULL, "
+ " CONSTRAINT[PK_CurrencyType] PRIMARY KEY CLUSTERED "
+ "( "
+ " [CurrencyCode] ASC "
+ ")WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] "
+ ") ON[PRIMARY]";
ExecuteNonQuery(sCommand);
}
sCommand.CommandText = "INSERT INTO [dbo].[CurrencyType] ([CurrencyCode],[Remark],[CompanyRecId]) VALUES ('TL','TL',@CompanyRecId) ";
sCommand.Parameters.Clear();
sCommand.Parameters.Add("CompanyRecId", SqlDbType.Int).Value = CompanyRecId;
ExecuteNonQuery(sCommand);
sCommand.CommandText = "INSERT INTO [dbo].[CurrencyType] ([CurrencyCode],[Remark],[CompanyRecId]) VALUES ('USD','USD',@CompanyRecId) ";
sCommand.Parameters.Clear();
sCommand.Parameters.Add("CompanyRecId", SqlDbType.Int).Value = CompanyRecId;
ExecuteNonQuery(sCommand);
#endregion
#region ProgramsControl
if (tblTableList.Rows.Contains("ProgramsControl") == false)
{
sCommand.CommandText = "CREATE TABLE [dbo].[ProgramsControl]( "
+ " [RecId][int] IDENTITY(1, 1) NOT NULL, "
+ " [MspVersion] [nvarchar] (50) NULL, "
+ " [Licence] [nvarchar] (50) NULL, "
+ " [FirstDate] [datetime] NULL, "
+ " [MacAdress] [nvarchar] (50) NULL, "
+ " [IpAdress] [nvarchar] (50) NULL, "
+ " [LocalIpAdress] [nvarchar] (50) NULL, "
+ " [IsDemo] [bit] NULL, "
+ " CONSTRAINT[PK_ProgramsControl] PRIMARY KEY CLUSTERED "
+ " ( "
+ " [RecId] ASC "
+ " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] "
+ " ) ON[PRIMARY]";
ExecuteNonQuery(sCommand);
}
sCommand.CommandText = "INSERT INTO [dbo].[ProgramsControl]([MspVersion],[Licence],[FirstDate],[IsDemo]) VALUES ('1.0.0.0','',@date,@Demo)";
sCommand.Parameters.Clear();
sCommand.Parameters.Add("Demo", SqlDbType.Bit).Value = IsDemo;
sCommand.Parameters.Add("date", SqlDbType.DateTime).Value = dt_RecordDate.DateTime;
//sCommand.Parameters.Add("MacAdress", SqlDbType.NVarChar).Value = AppMain.MAcAdress;
//sCommand.Parameters.Add("IpAdress", SqlDbType.NVarChar).Value = AppMain.IpAdress;
//sCommand.Parameters.Add("LocalIp", SqlDbType.NVarChar).Value = AppMain.LocalIpAdress;
ExecuteNonQuery(sCommand);
#endregion
#region PaymentType
if (tblTableList.Rows.Contains("PaymentType") == false)
{
sCommand.CommandText = "CREATE TABLE [dbo].[PaymentType]( "
+ " [RecId][int] IDENTITY(1, 1) NOT NULL, "
+ " [Remark] [nvarchar] (50) NULL, "
+ " CONSTRAINT[PK_PaymentType] PRIMARY KEY CLUSTERED "
+ " ( "
+ " [RecId] ASC "
+ " )WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON[PRIMARY] "
+ " ) ON[PRIMARY]";
ExecuteNonQuery(sCommand);
}
sCommand.CommandText = "INSERT INTO [dbo].[PaymentType] ([Remark]) VALUES ('Nakit')";
sCommand.Parameters.Clear();
ExecuteNonQuery(sCommand);
sCommand.CommandText = "INSERT INTO [dbo].[PaymentType] ([Remark]) VALUES ('Pos')";
sCommand.Parameters.Clear();
ExecuteNonQuery(sCommand);
sCommand.CommandText = "INSERT INTO [dbo].[PaymentType] ([Remark]) VALUES ('Pos & Nakit')";
sCommand.Parameters.Clear();
ExecuteNonQuery(sCommand);
#endregion
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
finally
{
if (Splash.IsSplashFormVisible)
{
Splash.CloseWaitForm();
}
string path = @"C:\Msp\ConnectString.txt";
if (!File.Exists(path))
{
using (StreamWriter sw = File.CreateText(path))
{
string sifrele = SecurityExtension.Sifrele(SqlConnectionString);
sw.WriteLine(sifrele);
}
}
pageLisansDemo.AllowNext = true;
}
}
/// <summary>
/// 保存数据导入到数据库和表格中
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void toolSave_Click(object sender, EventArgs e)
{
gv.PostEditor();
gv.CloseEditor();
if (gv.SelectedRowsCount == 0)
{
MessageUtil.ShowWarning("请选择导入条目！");
return;
}
successTable.Rows.Clear();
failureTable.Rows.Clear();
List <ArchiveInfoDto> importedArvList = new List <ArchiveInfoDto>();
// 将表格中的数据导入数据库中
if (gv.DataSource != null)
{
// 设置列对应的数据库表字段名
foreach (GridColumn col in gv.Columns)
{
// 从属性类中读取字段对应的显示名
List <FieldCfgDto> arvField = PropertyHelper.FieldCfgItems.Where <FieldCfgDto>(item => item.FieldShowName == col.FieldName).ToList <FieldCfgDto>();
if (arvField.Count == 1)
{
col.Name = arvField[0].FieldShowName;
col.Tag = true; // 指示该列是要写入数据库的信息
}
else
{
col.Tag = false;
}
}
loading.ShowWaitForm();//数据多时界面可能会有卡顿
// 遍历所有行
//for (int i = 0; i < gv.RowCount; i++)
int[] toDelete = gv.GetSelectedRows().Reverse().ToArray();
//List<ArchiveInfoDto> infos=new List<ArchiveInfoDto>();
foreach (int i in toDelete)
{
// 当前行对象转化为类实例
//ArchiveInfoDto info = GridControlHelper.Instance.ConvertDataRowToObject<ArchiveInfoDto>(gv, i);
ArchiveInfoDto info = (ArchiveInfoDto)gv.GetRow(i);//单条保存，如果多条保存出错全部回滚不合理
info.ArvStatus = "在档";
try
{
// 记录写入数据库
CallerFactory.Instance.GetService <IArvOpService>().InToStorage(info);
// 加入写入成功的数据表
successTable.Rows.Add(gv.GetDataRow(i).ItemArray);
tbImport.Rows.RemoveAt(i);//成功写入的记录从表中移除
importedArvList.Add(info);
}
catch (Exception)
{
// 加入写入失败的数据表
failureTable.Rows.Add(gv.GetDataRow(i).ItemArray);
}
}
gc.RefreshDataSource();
OnGetImportArchives(importedArvList);
// 显示导入结果的对话框
FormPBExcelShow frmPBExcelShow = new FormPBExcelShow();
frmPBExcelShow.sCount = successTable.Rows.Count;
frmPBExcelShow.xCount = failureTable.Rows.Count;
frmPBExcelShow.Tb_ImportFailure = failureTable;
frmPBExcelShow.ShowDialog();
}
else
{
MessageUtil.ShowTips("没有数据可以导入");
}
}
private void barBtnXuatBaoCao_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (Object.Equals(objPhong, null))
{
XtraMessageBox.Show("Chưa chọn phòng!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (Object.Equals(objPhong.id, Guid.Empty))
{
XtraMessageBox.Show("Chưa chọn phòng!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
String strViTri = "[Không Rõ]";
if (!Object.Equals(objPhong.vitri, null))
strViTri = objPhong.vitri.coso != null ? objPhong.vitri.coso.ten + (objPhong.vitri.day != null ? " - " + objPhong.vitri.day.ten + (objPhong.vitri.tang != null ? " - " + objPhong.vitri.tang.ten : "") : "") : "";
if (Object.Equals(listCTThietBis, null))
{
XtraMessageBox.Show(String.Format("Phòng {0} ({1}) chưa có thiết bị!", objPhong.ten, strViTri), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
if (listCTThietBis.Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::PTB_GUI.WaitForm1), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReport_Template _XtraReport_Template = new XtraReport_Template(SHARED.Libraries.ReportHelper.FillDatasetFromGrid(gridViewCTThietBi), gridViewCTThietBi, barCheckItemLandscape.Checked);
_XtraReport_Template.SetTitleText(String.Format("Danh Sách Thiết Bị Tại Phòng: {0} ({1})", objPhong.ten, strViTri));
if (barCheckItemThietKe.Checked)
{
ReportDesignTool designTool = new ReportDesignTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
designTool.ShowDesignerDialog();
ReportPrintTool printTool = new ReportPrintTool(designTool.Report);
printTool.ShowPreviewDialog();
}
else
{
ReportPrintTool printTool = new ReportPrintTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show(String.Format("Phòng {0} ({1}) chưa có thiết bị!", objPhong.ten, strViTri), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public void openWaitForm(DevExpress.XtraSplashScreen.SplashScreenManager ssm)
{
ssm.ShowWaitForm();
ssm.SetWaitFormDescription("Espere un momento...");
ssm.SetWaitFormCaption("Cargando");
}
private void barBtnXuatBaoCao_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (Object.Equals(_ViTriHienTai, null))
{
XtraMessageBox.Show("Chưa chọn vị trí!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (Object.Equals(listPhong, null))
{
XtraMessageBox.Show("Không có phòng!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
String strViTri = _ViTriHienTai.coso != null ? _ViTriHienTai.coso.ten + (_ViTriHienTai.day != null ? " - " + _ViTriHienTai.day.ten + (_ViTriHienTai.tang != null ? " - " + _ViTriHienTai.tang.ten : "") : "") : "";
if (listPhong.Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::PTB_GUI.WaitForm1), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReport_Template _XtraReport_Template = new XtraReport_Template(SHARED.Libraries.ReportHelper.FillDatasetFromGrid(gridViewPhong), gridViewPhong, barCheckItemLandscape.Checked);
_XtraReport_Template.SetTitleText("Danh Sách Phòng Tại: " + strViTri);
if (barCheckItemThietKe.Checked)
{
ReportDesignTool designTool = new ReportDesignTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
designTool.ShowDesignerDialog();
ReportPrintTool printTool = new ReportPrintTool(designTool.Report);
printTool.ShowPreviewDialog();
}
else
{
ReportPrintTool printTool = new ReportPrintTool(_XtraReport_Template);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
strViTri = "[" + strViTri + "]";
XtraMessageBox.Show(strViTri + " không có phòng!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void barButtonItemXuatThongKe_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
if (current.Equals(_ucTKPhong))
{
if (Object.Equals(_ucTKPhong.gridControlPhong.DataSource, null))
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (((List<Phong_ThongKe>)_ucTKPhong.gridControlPhong.DataSource).Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::TSCD_GUI.WaitFormLoad), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReportTSCD_Grid _XtraReportTSCD_Grid = new XtraReportTSCD_Grid(_ucTKPhong.gridControlPhong, false);
_XtraReportTSCD_Grid.SetTextTitle("Thống Kê Phòng");
_XtraReportTSCD_Grid.SetTextTitle_TopRight("");
ReportPrintTool printTool = new ReportPrintTool(_XtraReportTSCD_Grid);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (current.Equals(_ucTKTaiSan))
{
if (Object.Equals(_ucTKTaiSan.gridControlTaiSan.DataSource, null))
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (((List<TaiSan_ThongKe>)_ucTKTaiSan.gridControlTaiSan.DataSource).Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::TSCD_GUI.WaitFormLoad), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReportTSCD_Grid _XtraReportTSCD_Grid = new XtraReportTSCD_Grid(_ucTKTaiSan.gridControlTaiSan, false);
_XtraReportTSCD_Grid.SetTextTitle("Thống Kê Tài Sản");
_XtraReportTSCD_Grid.SetTextTitle_TopRight("");
ReportPrintTool printTool = new ReportPrintTool(_XtraReportTSCD_Grid);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (current.Equals(_ucTKHaoMon))
{
if (Object.Equals(_ucTKHaoMon.gridControlHaoMon.DataSource, null))
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (((List<TaiSanHienThi>)_ucTKHaoMon.gridControlHaoMon.DataSource).Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::TSCD_GUI.WaitFormLoad), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReportTSCD_Grid _XtraReportTSCD_Grid = new XtraReportTSCD_Grid(_ucTKHaoMon.gridControlHaoMon, false);
_XtraReportTSCD_Grid.SetTextTitle("Thống Kê Hao Mòn");
_XtraReportTSCD_Grid.SetTextTitle_TopRight("");
ReportPrintTool printTool = new ReportPrintTool(_XtraReportTSCD_Grid);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (current.Equals(_ucTKTHPhong))
{
if (Object.Equals(_ucTKTHPhong.gridControlPhong.DataSource, null))
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (((List<Phong_ThongKe>)_ucTKTHPhong.gridControlPhong.DataSource).Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::TSCD_GUI.WaitFormLoad), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReportTSCD_Grid _XtraReportTSCD_Grid = new XtraReportTSCD_Grid(_ucTKTHPhong.gridControlPhong, false);
_XtraReportTSCD_Grid.SetTextTitle("Thống Kê Tổng Hợp Phòng");
_XtraReportTSCD_Grid.SetTextTitle_TopRight("");
ReportPrintTool printTool = new ReportPrintTool(_XtraReportTSCD_Grid);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (current.Equals(_ucTKTHTaiSan))
{
if (Object.Equals(_ucTKTHTaiSan.gridControlTaiSan.DataSource, null))
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (((List<TaiSanHienThi>)_ucTKTHTaiSan.gridControlTaiSan.DataSource).Count > 0)
{
try
{
DevExpress.XtraSplashScreen.SplashScreenManager splashScreenManager_Report = new DevExpress.XtraSplashScreen.SplashScreenManager(this, typeof(global::TSCD_GUI.WaitFormLoad), true, true, DevExpress.XtraSplashScreen.ParentType.UserControl);
splashScreenManager_Report.ShowWaitForm();
splashScreenManager_Report.SetWaitFormCaption("Đang tạo report");
splashScreenManager_Report.SetWaitFormDescription("Vui lòng chờ trong giây lát...");
XtraReportTSCD_Grid _XtraReportTSCD_Grid = new XtraReportTSCD_Grid(_ucTKTHTaiSan.gridControlTaiSan, false);
_XtraReportTSCD_Grid.SetTextTitle("Thống Kê Tổng Hợp Tài Sản");
_XtraReportTSCD_Grid.SetTextTitle_TopRight("");
ReportPrintTool printTool = new ReportPrintTool(_XtraReportTSCD_Grid);
splashScreenManager_Report.CloseWaitForm();
printTool.ShowPreviewDialog();
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
XtraMessageBox.Show("Chưa có dữ liệu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch
{
XtraMessageBox.Show("Đã xảy ra lỗi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
