/// <summary>
/// 窗体加载事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void MainFormLoad(object sender, EventArgs e)
{
try
{
ribbonControl1.Minimized = true;
// 加载一些默认皮肤
SkinHelper.InitSkinGallery(rbSkin, true);
// ChildFormManagementHelper.Navigate(this, "http://yd.zt-express.com/Help/Index2", "帮助");
ChildFormManagementHelper.LoadMdiForm(this, "FrmPrintData");
// ChildFormManagementHelper.Navigate(this, "http://zto.com", "申通官网");
// radialMenu1.ShowPopup(Control.MousePosition, true);
//ChildFormManagement.LoadMdiForm(this, "FrmSendManData");
//ChildFormManagement.LoadMdiForm(this, "FrmReceiveManData");
if (xtraTabbedMdiManager1.Pages.Count > 1)
{
xtraTabbedMdiManager1.SelectedPage = xtraTabbedMdiManager1.Pages[1];
}
#region 底部一些基本信息绑定
barItemsUser.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
barItemWeather.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
var version = Assembly.GetExecutingAssembly().GetName().Version;
barItemWelcome.Caption = string.Format("欢迎使用{1}-当前版本：{0}", version, BaseSystemInfo.SoftFullName);
// 得到数据库的版本
BaseParameterManager parameterManager = new BaseParameterManager(BillPrintHelper.DbHelper, BaseSystemInfo.UserInfo, BaseParameterEntity.TableName);
var synchronous = parameterManager.GetParameter("Bill", "DBVersion", "Synchronous");
if (!string.IsNullOrEmpty(synchronous))
{
barItemWelcome.Caption += " 主库版本：" + synchronous;
}
this.Text = string.Format("{0}-当前版本：{1}", this.Text, version);
barItemTime.Caption = string.Format("登录时间：{0} {1}", DateTime.Now.ToString(BaseSystemInfo.DateTimeFormat), DateUtil.GetDayOfWeek(DateTime.Now.DayOfWeek.ToString(), true) + " " + DateHelper.GetChineseDateTime(DateTime.Now));
#endregion
var userManager = new ZtoUserManager(BillPrintHelper.DbHelper);
var userList = userManager.GetList <ZtoUserEntity>(new KeyValuePair <string, object>(ZtoUserEntity.FieldIsDefault, 1), new KeyValuePair <string, object>(ZtoUserEntity.FieldIssendorreceive, 1));
if (!userList.Any())
{
if (XtraMessageBox.Show(@"未添加默认发件人信息，请添加默认发件人信息，有利于提取申通大头笔", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK)
{
var addSendMan = new FrmAddSendMan();
addSendMan.ShowDialog();
addSendMan.Dispose();
}
}
timerUpdate.Start();
//FrmChatMessage chatMessage = new FrmChatMessage();
//chatMessage.Show();
}
catch (Exception ex)
{
ProcessException(ex);
}
}
/// <summary>
/// 同步省市区数据
/// </summary>
/// <param name="delete"></param>
/// <returns></returns>
public static int SynchronousArea(bool delete = false)
{
int result = 0;
if (!System.IO.File.Exists(SqLiteDb))
{
return(result);
}
DateTime?modifiedOn = new DateTime(2014, 01, 01);
string dbConnection = "Data Source={StartupPath}/DataBase/STO.Bill.db;Pooling=true;FailIfMissing=false;Password=ZTO20149988";
dbConnection = dbConnection.Replace("{StartupPath}", System.Windows.Forms.Application.StartupPath);
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(CurrentDbType.SQLite, dbConnection))
{
BaseParameterManager parameterManager = new BaseParameterManager(dbHelper, BaseSystemInfo.UserInfo, BaseParameterEntity.TableName);
var tableName = BaseAreaEntity.TableName;
if (!delete)
{
var synchronous = parameterManager.GetParameter(BaseParameterEntity.TableName, "System", tableName, "Synchronous");
if (!string.IsNullOrEmpty(synchronous))
{
modifiedOn = DateTime.Parse(synchronous);
}
}
if (delete)
{
dbHelper.ExecuteNonQuery("DELETE FROM " + tableName);
}
result = SynchronousTable("UserCenter", tableName, new string[] { BaseAreaEntity.FieldId }, modifiedOn, "Bill", tableName, 20000, false);
if (result > 0)
{
parameterManager.SetParameter(BaseParameterEntity.TableName, "System", tableName, "Synchronous", DateTime.Now.ToString(BaseSystemInfo.DateTimeFormat));
}
}
return(result);
}
/// <summary>
/// 获取参数值
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="categoryId">分类主键</param>
/// <param name="parameterId">参数主键</param>
/// <param name="parameterCode">参数编号</param>
/// <returns>参数值</returns>
public string GetParameter(BaseUserInfo userInfo, string categoryId, string parameterId, string parameterCode)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
// 加强安全验证防止未授权匿名调用
// #if (!DEBUG)
// LogOnService.UserIsLogOn(userInfo);
// #endif
string returnValue = string.Empty;
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType))
{
try
{
dbHelper.Open(UserCenterDbConnection);
BaseParameterManager parameterManager = new BaseParameterManager(dbHelper, userInfo);
returnValue = parameterManager.GetParameter(categoryId, parameterId, parameterCode);
BaseLogManager.Instance.Add(dbHelper, userInfo, this.serviceName, AppMessage.ParameterService_GetParameter, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(returnValue);
}
/// <summary>
/// 登录前运行的方法
/// </summary>
public static void BeforeLogOn()
{
// 0：若文件不存在，就退出数据同步，不进行数据同步
string sqLiteDb = System.Windows.Forms.Application.StartupPath + @"\DataBase\STO.Bill.db";
if (!System.IO.File.Exists(sqLiteDb))
{
return;
}
try
{
// 01：打开业务数据库
string dbConnection = "Data Source={StartupPath}/DataBase/STO.Bill.db;Pooling=true;FailIfMissing=false;Password=ZTO20149988";
dbConnection = dbConnection.Replace("{StartupPath}", System.Windows.Forms.Application.StartupPath);
IDbHelper dbHelper = DbHelperFactory.GetHelper(CurrentDbType.SQLite, dbConnection);
// 02: 先保存个同步时间标志，什么时间成功同步过本地数据库？这样不用每次都同步所有的数据，只同步那个时间之后的数据就可以了。
BaseParameterManager parameterManager = new BaseParameterManager(dbHelper, BaseSystemInfo.UserInfo, BaseParameterEntity.TableName);
// 03：用参数的方式读取同步时间
// 04：检查数据库里的版本号
var synchronous = parameterManager.GetParameter("Bill", "DBVersion", "Synchronous");
if (string.IsNullOrEmpty(synchronous))
{
synchronous = "5.2015.7.15";
parameterManager.SetParameter("Bill", "DBVersion", "Synchronous", synchronous);
}
var versionEntity = new Version(synchronous);
if (versionEntity < new Version("5.2015.08.14"))
{
Upgrade20150814();
}
if (versionEntity < new Version("5.2015.08.21"))
{
Upgrade20150821();
}
if (versionEntity < new Version("5.2015.08.23"))
{
if (Upgrade20150823())
{
// InitExpressData();
}
}
if (versionEntity < new Version("5.2015.08.26"))
{
if (Upgrade20150826())
{
if (Upgrade20150823())
{
// InitExpressData();
parameterManager.SetParameter(BaseParameterEntity.TableName, "Bill", "DBVersion", "Synchronous", "5.2015.08.26");
}
}
}
if (versionEntity < new Version("5.2015.09.14"))
{
Upgrade20150914();
}
if (versionEntity < new Version("5.2015.10.15"))
{
Upgrade20151015();
}
if (versionEntity < new Version("5.2015.10.25"))
{
Upgrade20151025();
}
if (versionEntity < new Version("5.2015.11.05"))
{
Upgrade20151105();
}
if (versionEntity < new Version("5.2015.11.11"))
{
Upgrade20151111();
}
if (versionEntity < new Version("5.2015.12.12"))
{
Upgrade20151212();
}
if (versionEntity < new Version("5.2016.01.20"))
{
Upgrade20160120();
}
if (versionEntity < new Version("6.2016.06.20"))
{
Upgrade20160620();
}
if (versionEntity < new Version("6.2016.07.20"))
{
Upgrade20160720();
}
//if (versionEntity < new Version("6.2016.03.21"))
//{
// parameterManager.SetParameter(BaseParameterEntity.TableName, "Bill", "DBVersion", "Synchronous", "6.2016.03.21");
//}
InitExpressData();
}
catch (Exception ex)
{
// 在本地记录异常
LogUtil.WriteException(ex);
}
}
