private void button1_Click(object sender, EventArgs e)
{
if (db.add != 0)
{
if (DGVDate.RowCount != 0)
{
int iddel = Convert.ToInt32(DGVDate[0, DGVDate.CurrentCell.RowIndex].Value);
Form_Delete form_Delete = new Form_Delete();
form_Delete.ShowDialog();
this.OnLoad(e);
int i = form_Delete.ii;
if (i == 1)
{
string quest = $"DELETE FROM Производство WHERE КодПроизводство = {iddel}";
db.connect.Open();
OleDbCommand dataCommander = new OleDbCommand(quest, db.connect);
dataCommander.ExecuteNonQuery();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(db.selectProizvodstv, db.connect);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
DGVDate.DataSource = ds.Tables[0].DefaultView;
DGVDate.Columns[0].Visible = false;
}
form_Delete.ii = 0;
}
}
}
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);
}
}
}
