public void GetDataBaseDefault()
{
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
Class_DataBaseConDefault class_DataBaseConDefault = new Class_DataBaseConDefault();
class_DataBaseConDefault = class_PublicMethod.FromXmlToDefaultValueObject <Class_DataBaseConDefault>("DataBaseDefaultValues");
if (class_DataBaseConDefault == null)
{
databaseType = "MySql";
dataBaseName = "test01";
dataSourceUserName = "******";
dataSourcePassWord = "******";
dataSourceUrl = "101.201.101.138";
Port = 10001;
}
else
{
databaseType = class_DataBaseConDefault.databaseType;
dataBaseName = class_DataBaseConDefault.dataBaseName;
dataSourceUserName = class_DataBaseConDefault.dataSourceUserName;
dataSourcePassWord = class_DataBaseConDefault.dataSourcePassWord;
dataSourceUrl = class_DataBaseConDefault.dataSourceUrl;
Port = class_DataBaseConDefault.Port;
}
}
private void timer1_Tick(object sender, EventArgs e)
{
this.timer1.Enabled = false;
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
if (class_PublicMethod.GetVersionUpdateInfo(this.progressBarControl1))
{
this.DialogResult = DialogResult.OK;
}
}
private void barButtonItem18_ItemClick(object sender, ItemClickEventArgs e)
{
if (!Class_MyInfo.UseTypeValue.Equals("R005"))
{
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
Form_WindowSelect form_WindowSelect = new Form_WindowSelect();
form_WindowSelect.OperateType = "删除";
if (form_WindowSelect.ShowDialog() == DialogResult.OK)
{
if (class_PublicMethod.DeleteXml(form_WindowSelect.PageKey, form_WindowSelect.PageType))
{
if (IsTabbedMdi)
{
XtraMdiTabPage xtraMdiTabPage = null;
foreach (XtraMdiTabPage xtra in xtraTabbedMdiManager1.Pages)
{
if ((xtra.MdiChild.Tag as Class_WindowType).XmlFileName == form_WindowSelect.PageKey)
{
xtraMdiTabPage = xtra;
}
}
if (xtraMdiTabPage != null)
{
xtraMdiTabPage.MdiChild.Close();
}
}
else
{
Form form = null;
foreach (Form item in this.MdiChildren)
{
if ((item.Tag as Class_WindowType).XmlFileName == form_WindowSelect.PageKey)
{
form = item;
}
}
if (form != null)
{
form.Close();
}
}
displayAlertMessage("温馨", "指定窗体已删除成功！", null, 3);
}
else
{
displayAlertMessage("温馨", "指定窗体删除失败！", null, 3);
}
}
form_WindowSelect.Dispose();
}
else
{
MessageBox.Show("前端开发者没有删除权限!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
}
private void frmMain_Load(object sender, EventArgs e)
{
this.Text = _Text + " V " + this.Version + " 作者：梁昊";
OpenHistoryWin();
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
if ((this.MdiChildren.Length == 0) && (class_PublicMethod.GetOpenWelcome()))
{
openFirstPage();
}
}
private void pri_SetBandedGridViewStyle(BandedGridView bgv)
{
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
Font font = new Font("Tahoma", class_PublicMethod.GetGridFontSize());
bgv.OptionsView.ShowColumnHeaders = true;
bgv.OptionsView.ColumnAutoWidth = false;
bgv.OptionsView.ShowAutoFilterRow = true;
//bgv.Appearance.OddRow.BackColor = Color.Beige;
bgv.OptionsView.EnableAppearanceOddRow = true;
bgv.OptionsCustomization.AllowGroup = false;
bgv.OptionsView.ShowFooter = false;
//bgv.Appearance.Row.Font = new System.Drawing.Font("Tahoma", 11F);
bgv.Appearance.Row.Font = font;
}
private void barButtonItem7_ItemClick(object sender, ItemClickEventArgs e)
{
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
Font font = new Font("Tahoma", class_PublicMethod.GetGridFontSize());
FontDialog fontDialog = new FontDialog
{
Font = font
};
if (fontDialog.ShowDialog() == DialogResult.OK)
{
class_PublicMethod.SetGridFontSize(fontDialog.Font.Size);
}
fontDialog.Dispose();
}
private void barButtonItem8_ItemClick(object sender, ItemClickEventArgs e)
{
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
Class_DataBaseConDefault class_DataBaseConDefault = new Class_DataBaseConDefault();
class_DataBaseConDefault = class_PublicMethod.FromXmlToDefaultValueObject <Class_DataBaseConDefault>("DataBaseDefaultValues");
Form_DataBaseDefaultSet form_DataBaseDefaultSet = new Form_DataBaseDefaultSet(class_DataBaseConDefault);
if (form_DataBaseDefaultSet.ShowDialog() == DialogResult.OK)
{
if (class_PublicMethod.DataBaseDefaultValueToXml("DataBaseDefaultValues", form_DataBaseDefaultSet.class_DataBaseConDefault))
{
MessageBox.Show("已将数据库连接默认值，保存到本地!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
}
form_DataBaseDefaultSet.Dispose();
}
/// <summary>
/// 综合设置
/// </summary>
private void _AllSetUp()
{
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
Class_AllParamSetUp class_AllParamSetUp = new Class_AllParamSetUp();
class_AllParamSetUp = class_PublicMethod.FromXmlToAllParamSetUpObject <Class_AllParamSetUp>("Class_AllParamSetUp");
Form_AllSetUp form_AllSetUp = new Form_AllSetUp(class_AllParamSetUp);
if (form_AllSetUp.ShowDialog() == DialogResult.OK)
{
if (class_PublicMethod.DataBaseAllParamSetUpValueToXml("Class_AllParamSetUp", form_AllSetUp.class_AllParamSetUp))
{
MessageBox.Show("已将参数默认值，保存到本地!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
}
form_AllSetUp.Dispose();
}
private void SetCompoment()
{
this.panelControl2.Visible = this.SelectDes;
class_PublicMethod = new Class_PublicMethod();
this.Text += "---" + OperateType;
memoEdit1.ReadOnly = true;
GridC gridC = new GridC();
gridC.SetGridBar(this.gridControl1);
gridC.SetGridBar(this.gridControl2);
gridC.SetGridBar(this.gridControl3);
gridC.SetGridBar(this.gridControl4);
foreach (GridColumn grid in this.gridView1.Columns)
{
GridColumn gridColumn = new GridColumn();
gridColumn = grid;
this.gridView2.Columns.Add(gridColumn);
this.gridView3.Columns.Add(gridColumn);
this.gridView4.Columns.Add(gridColumn);
}
GridViewC gridViewC = new GridViewC();
gridViewC.SetGridView(this.gridView1, true);
gridViewC.SetGridView(this.gridView2, true);
gridViewC.SetGridView(this.gridView3, true);
gridViewC.SetGridView(this.gridView4, true);
Class_SQLiteOperator class_SQLiteOperator = new Class_SQLiteOperator();
DataSet dataSet = new DataSet();
dataSet = class_SQLiteOperator.GetAllWindowInfomation();
this.gridControl1.DataSource = dataSet.Tables[0];
this.gridControl2.DataSource = dataSet.Tables[1];
this.gridControl3.DataSource = dataSet.Tables[2];
this.gridControl4.DataSource = dataSet.Tables[3];
this.xtraTabControl1.SelectedTabPageIndex = 0;
this.gridView1.Focus();
Class_SystemDefault class_SystemDefaul = class_PublicMethod.FromXmlToSystemDefaultObject <Class_SystemDefault>(FileFullName);
if (class_SystemDefaul != null)
{
this.xtraTabControl1.SelectedTabPageIndex = class_SystemDefaul.SelectOpenWindowIndex;
}
}
public Class_SqlServer2017DataBase(string ip, string dataBaseName, string userName, string passWord)
{
if (ip != null)
{
this.Ip = ip;
this.DataBaseName = dataBaseName;
this.UserName = userName;
this.PassWord = passWord;
}
else
{
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
Class_DataBaseConDefault class_DataBaseConDefault = new Class_DataBaseConDefault();
class_DataBaseConDefault = class_PublicMethod.FromXmlToSelectObject <Class_DataBaseConDefault>("DataBaseDefaultValues");
if (class_DataBaseConDefault == null)
{
this.Ip = "221.234.36.229";
this.DataBaseName = "QD_MANAGER";
this.UserName = "******";
this.PassWord = "******";
}
else
{
if (class_DataBaseConDefault.databaseType == "SqlServer 2017")
{
this.Ip = class_DataBaseConDefault.dataSourceUrl;
this.DataBaseName = class_DataBaseConDefault.dataBaseName;
this.UserName = class_DataBaseConDefault.dataSourceUserName;
this.PassWord = class_DataBaseConDefault.dataSourcePassWord;
}
}
}
IniFieldTypeChange();
ConnectString = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}"
, this.Ip
, this.DataBaseName
, this.UserName
, this.PassWord);
mydb = new Mydb(ConnectString);
}
private void barButtonItem12_ItemClick(object sender, ItemClickEventArgs e)
{
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
Form_WindowSelect form_WindowSelect = new Form_WindowSelect(true);
form_WindowSelect.OperateType = "效仿添加";
if (form_WindowSelect.ShowDialog() == DialogResult.OK)
{
string PageKey = form_WindowSelect.PageKey;
if ((PageKey != null) && (PageKey.Length > 0))
{
PageKey = class_PublicMethod.CopyToNewXml(PageKey, form_WindowSelect.NewPageType, form_WindowSelect.PageType);
if (PageKey != null)
{
switch (form_WindowSelect.NewPageType)
{
case "select":
OpenSelectWin(PageKey);
break;
case "insert":
OpenInsertWin(PageKey);
break;
case "update":
OpenUpdateWin(PageKey);
break;
case "delete":
OpenDeleteWin(PageKey);
break;
default:
OpenSelectWin(PageKey);
break;
}
}
}
}
form_WindowSelect.Dispose();
}
private void barButtonItem9_ItemClick(object sender, ItemClickEventArgs e)
{
Form_UpdatePass form_UpdatePass = new Form_UpdatePass();
if (form_UpdatePass.ShowDialog() == DialogResult.OK)
{
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
if (class_PublicMethod.UpdatePassWord(form_UpdatePass.PassWord) > 0)
{
MessageBox.Show("密码修改成功！", "温馨提示"
, MessageBoxButtons.OK
, MessageBoxIcon.Information
, MessageBoxDefaultButton.Button1);
}
else
{
MessageBox.Show("密码修改失败！", "温馨提示"
, MessageBoxButtons.OK
, MessageBoxIcon.Error
, MessageBoxDefaultButton.Button1);
}
}
form_UpdatePass.Dispose();
}
public void OpenDeleteWin(string xmlFileName)
{
IClass_InterFaceDataBase class_InterFaceDataBase;
Class_PublicMethod class_PublicMethod = new Class_PublicMethod();
Class_DeleteAllModel class_DeleteAllModel = new Class_DeleteAllModel();
Class_DeleteAllModel.Class_InsertDataBase class_DeleteDataBase = new Class_DeleteAllModel.Class_InsertDataBase();
try
{
Class_WindowType class_WindowType = new Class_WindowType();
class_WindowType.WindowType = "delete";
Form_Delete form;
if (xmlFileName != null)
{
if (File.Exists(string.Format("{0}\\delete\\{1}.xml", Application.StartupPath, xmlFileName)))
{
class_DeleteAllModel = class_PublicMethod.FromXmlToDeleteObject <Class_DeleteAllModel>(xmlFileName);
class_DeleteDataBase = class_DeleteAllModel.class_SelectDataBase;
switch (class_DeleteDataBase.databaseType)
{
case "MySql":
class_InterFaceDataBase = new Class_MySqlDataBase(class_DeleteDataBase.dataSourceUrl, class_DeleteDataBase.dataBaseName, class_DeleteDataBase.dataSourceUserName, class_DeleteDataBase.dataSourcePassWord, class_DeleteDataBase.Port);
break;
case "SqlServer 2017":
class_InterFaceDataBase = new Class_SqlServer2017DataBase(class_DeleteDataBase.dataSourceUrl, class_DeleteDataBase.dataBaseName, class_DeleteDataBase.dataSourceUserName, class_DeleteDataBase.dataSourcePassWord);
break;
default:
class_InterFaceDataBase = new Class_MySqlDataBase(class_DeleteDataBase.dataSourceUrl, class_DeleteDataBase.dataBaseName, class_DeleteDataBase.dataSourceUserName, class_DeleteDataBase.dataSourcePassWord, class_DeleteDataBase.Port);
break;
}
class_WindowType.XmlFileName = xmlFileName;
form = new Form_Delete(mySkinName, xmlFileName);
form.Text = string.Format("DELETE：{0}", xmlFileName);
form.Tag = class_WindowType;
OpenSubForm(form);
}
else
{
MessageBox.Show(string.Format("文件【{0}.xml】不存在，无法打开界面！", xmlFileName)
, "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
form = new Form_Delete(mySkinName);
form.Text = "新DELETE";
form.Tag = class_WindowType;
OpenSubForm(form);
}
}
catch (Exception e)
{
if (xmlFileName != null)
{
MessageBox.Show(string.Format("数据库[{0}:{3}]：Url[{1}],端口[{2}]，连接失败，无法打开该界面！\r\n异常：{4}。"
, class_DeleteDataBase.databaseType
, class_DeleteDataBase.dataSourceUrl
, class_DeleteDataBase.Port
, class_DeleteDataBase.dataBaseName
, e.Message)
, "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show(string.Format("异常：{0}。", e.Message)
, "错误信息", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
