From 6ceeba7c1e8903c850d125a4823cc36507e43de9 Mon Sep 17 00:00:00 2001
From: lu <99954486@qq.com>
Date: 星期二, 26 十一月 2024 16:50:41 +0800
Subject: [PATCH] 排产
---
DevApp/Gs.DevApp/DevFrm/Sys/EasyCode.cs | 800 +++++++++++++++++++++++++++++++++-----------------------
1 files changed, 467 insertions(+), 333 deletions(-)
diff --git a/DevApp/Gs.DevApp/DevFrm/Sys/EasyCode.cs b/DevApp/Gs.DevApp/DevFrm/Sys/EasyCode.cs
index 8ee3357..8803af2 100644
--- a/DevApp/Gs.DevApp/DevFrm/Sys/EasyCode.cs
+++ b/DevApp/Gs.DevApp/DevFrm/Sys/EasyCode.cs
@@ -1,7 +1,6 @@
-锘縰sing Newtonsoft.Json;
-using Oracle.ManagedDataAccess.Client;
-using System;
+锘縰sing System;
using System.Collections.Generic;
+using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;
@@ -10,398 +9,614 @@
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
+using DevExpress.XtraEditors;
+using Gs.DevApp.ToolBox;
+using Newtonsoft.Json;
+using Oracle.ManagedDataAccess.Client;
namespace Gs.DevApp.DevFrm.Sys
{
- public partial class EasyCode : DevExpress.XtraEditors.XtraForm
+ public partial class EasyCode : XtraForm
{
+ private readonly string oracleCon =
+ "User Id=system;Password=admin110;Data Source=localhost:1521/MYTEST2;";
+
//this.txt_sqlconn.Text = "Data Source=2kn4sh70028.vicp.fun,26144;Initial Catalog=gs_Mes;User ID=sa;Password =admin110";
- string sqlCon = "Data Source=192.168.1.146;Initial Catalog=GS_MES;User ID=sa;Password =qixi123";
- string oracleCon = "User Id=system;Password=admin110;Data Source=localhost:1521/MYTEST2;";
+ private readonly string sqlCon =
+ "Data Source=192.168.1.146;Initial Catalog=GS_MES;User ID=sa;Password =qixi123";
+
public EasyCode()
{
InitializeComponent();
getTable();
- this.btnPathSelect.Click += (s, e) =>
+ btnPathSelect.Click += (s, e) =>
{
- string _GetfilePath = FileSelector.BrowseFilePathForSave();
+ var _GetfilePath = FileSelector.BrowseFilePathForSave();
txtPath.Text = _GetfilePath;
};
- this.btnUpSelect.Click += BtnUpSelect_Click;
- this.btnUp.Click += BtnUp_Click;
+ btnUpSelect.Click += BtnUpSelect_Click;
+ btnUp.Click += BtnUp_Click;
}
+
+ #region 鎵归噺璇诲彇
+
+ private void btnTable_Click(object sender, EventArgs e)
+ {
+ using (var connection = new OracleConnection(oracleCon))
+ {
+ try
+ {
+ connection.Open();
+ using (var command = connection.CreateCommand())
+ {
+ command.CommandText =
+ "SELECT * FROM " + txtTable1.Text.Trim();
+ using (var oracleDataReader = command.ExecuteReader())
+ {
+ using (var bulkCopy = new SqlBulkCopy(sqlCon))
+ {
+ bulkCopy.DestinationTableName =
+ txtTable1.Text.Trim();
+ bulkCopy.WriteToServer(oracleDataReader);
+ }
+ }
+ }
+
+ MsgHelper.ShowInformation("鎻愮ず锛屾搷浣滄垚鍔燂紒");
+ }
+ catch (Exception ex)
+ {
+ Console.WriteLine(ex.Message);
+ MsgHelper.ShowError("鎻愮ず锛�" + ex.Message);
+ }
+ finally
+ {
+ if (connection.State != ConnectionState.Closed)
+ connection.Close();
+ }
+ }
+ }
+
+ #endregion
+
+ #region 鎵归噺鍑嗗
+
+ private void btnRemark_Click(object sender, EventArgs e)
+ {
+ if (txtTable2.Text.Trim().Length <= 0)
+ {
+ MessageBox.Show("璇疯緭鍏ヨ〃鍚�");
+ return;
+ }
+
+ using (var conn = new SqlConnection(sqlCon))
+ {
+ using (var cmd = new SqlCommand("[tmp_property]", conn))
+ {
+ try
+ {
+ conn.Open();
+ cmd.CommandType = CommandType.StoredProcedure;
+ SqlParameter[] parameters =
+ {
+ new SqlParameter("@tabname", txtTable2.Text.Trim()),
+ new SqlParameter("@com", txtOracleDec.Text.Trim())
+ };
+ foreach (var parameter in parameters)
+ cmd.Parameters.Add(parameter);
+ cmd.ExecuteNonQuery();
+ MsgHelper.ShowInformation("鎻愮ず锛屾搷浣滄垚鍔燂紒");
+ }
+ catch (Exception ex)
+ {
+ MsgHelper.ShowError("鎻愮ず锛�" + ex.Message);
+ }
+ finally
+ {
+ conn.Close();
+ }
+ }
+ }
+ }
+
+ #endregion
#region 浠ｇ爜鐢熸垚
/// <summary>
- /// 纭畾鐢熸垚
+ /// 纭畾鐢熸垚
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnOk_Click(object sender, EventArgs e)
{
- if (txt_table.EditValue == null || string.IsNullOrEmpty(txt_table.EditValue.ToString()))
+ if (txt_table.EditValue == null ||
+ string.IsNullOrEmpty(txt_table.EditValue.ToString()))
{
MessageBox.Show("璇烽�夋嫨琛�");
return;
}
+
if (txtPath.Text.Trim() == "")
{
MessageBox.Show("璇烽�夋嫨鐢熸垚璺緞");
return;
}
- string _strName = _getClassName();
- List<object> list = txt_table.Properties.Items.GetCheckedValues();
- DataTable dt1 = _getCol(_getTableName(list[0].ToString()));
- List<DataTable> dtList = new List<DataTable>();
- int j = 0;
- foreach (object obj in list)
+
+ var _strName = _getClassName();
+ var list = txt_table.Properties.Items.GetCheckedValues();
+ var dt1 = _getCol(_getTableName(list[0].ToString()));
+ var dtList = new List<DataTable>();
+ var j = 0;
+ foreach (var obj in list)
{
if (j > 0)
dtList.Add(_getCol(_getTableName(obj.ToString())));
j++;
}
+
ReadMainFile(dt1, _strName, dtList);
ReadDesignerFile(dt1, _strName, dtList);
ReadResxFile(dt1, _strName);
- string path = txtPath.Text;
+ var path = txtPath.Text;
lbMsg.Text = "鐢熸垚鎴愬姛锛岃矾寰勶細" + path;
- return;
}
+
/// <summary>
- /// 璇诲彇鏁版嵁搴撹〃
+ /// 璇诲彇鏁版嵁搴撹〃
/// </summary>
private void getTable()
{
- DataSet dset = new DataSet();
- using (SqlConnection connection = new SqlConnection(sqlCon))
+ var dset = new DataSet();
+ using (var connection = new SqlConnection(sqlCon))
{
connection.Open();
- SqlCommand cmd = new SqlCommand();
+ var cmd = new SqlCommand();
cmd.Connection = connection;
- cmd.CommandText = "SELECT TABLE_NAME,(SELECT top 1 value AS ExtendedPropertyValue FROM sys.extended_properties WHERE minor_id=0 and major_id = OBJECT_ID(''+TABLE_NAME+'')) as TABLE_DESC FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' order by TABLE_NAME asc";
- using (SqlDataAdapter dt = new SqlDataAdapter(cmd))
+ cmd.CommandText =
+ "SELECT TABLE_NAME,(SELECT top 1 value AS ExtendedPropertyValue FROM sys.extended_properties WHERE minor_id=0 and major_id = OBJECT_ID(''+TABLE_NAME+'')) as TABLE_DESC FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' order by TABLE_NAME asc";
+ using (var dt = new SqlDataAdapter(cmd))
{
dt.Fill(dset, "0");
}
}
+
if (dset != null && dset.Tables.Count > 0)
{
txt_table.Properties.Items.Clear();
- string[] strs = new string[dset.Tables[0].Rows.Count];
- for (int i = 0; i < dset.Tables[0].Rows.Count; i++)
- {
- strs[i] = dset.Tables[0].Rows[i]["TABLE_NAME"].ToString() + "(" + dset.Tables[0].Rows[i]["TABLE_DESC"].ToString() + ")";
- }
+ var strs = new string[dset.Tables[0].Rows.Count];
+ for (var i = 0; i < dset.Tables[0].Rows.Count; i++)
+ strs[i] = dset.Tables[0].Rows[i]["TABLE_NAME"] + "(" +
+ dset.Tables[0].Rows[i]["TABLE_DESC"] + ")";
txt_table.Properties.Items.AddRange(strs);
}
}
+
/// <summary>
- /// 璇诲彇鍒楀悕
+ /// 璇诲彇鍒楀悕
/// </summary>
/// <returns></returns>
private DataTable _getCol(string tableName)
{
- System.Text.StringBuilder sb = new StringBuilder();
- sb.Append("SELECT COLUMN_NAME = a.name, DATA_TYPE = b.name, REMARK = isnull(g.[value],a.name) ");
- sb.Append(" FROM syscolumns a left join systypes b on a.xusertype = b.xusertype inner join sysobjects d on a.id = d.id and d.xtype = 'U' and d.name<>'dtproperties' ");
+ var sb = new StringBuilder();
+ sb.Append(
+ "SELECT COLUMN_NAME = a.name, DATA_TYPE = b.name, REMARK = isnull(g.[value],a.name) ");
+ sb.Append(
+ " FROM syscolumns a left join systypes b on a.xusertype = b.xusertype inner join sysobjects d on a.id = d.id and d.xtype = 'U' and d.name<>'dtproperties' ");
sb.Append(" left join syscomments e on a.cdefault = e.id ");
- sb.Append(" left join sys.extended_properties g on a.id = G.major_id and a.colid = g.minor_id ");
- sb.Append(" left join sys.extended_properties f on d.id = f.major_id and f.minor_id = 0 ");
+ sb.Append(
+ " left join sys.extended_properties g on a.id = G.major_id and a.colid = g.minor_id ");
+ sb.Append(
+ " left join sys.extended_properties f on d.id = f.major_id and f.minor_id = 0 ");
sb.Append(" where d.name = '" + tableName + "'");
sb.Append(" order by a.id, a.colorder");
- DataSet dset = new DataSet();
- using (SqlConnection connection = new SqlConnection(sqlCon))
+ var dset = new DataSet();
+ using (var connection = new SqlConnection(sqlCon))
{
connection.Open();
- SqlCommand cmd = new SqlCommand();
+ var cmd = new SqlCommand();
cmd.Connection = connection;
cmd.CommandText = sb.ToString();
- using (SqlDataAdapter dt = new SqlDataAdapter(cmd))
+ using (var dt = new SqlDataAdapter(cmd))
{
dt.Fill(dset, "0");
}
}
- if (dset != null && dset.Tables.Count > 0)
- {
- return dset.Tables[0];
- }
+
+ if (dset != null && dset.Tables.Count > 0) return dset.Tables[0];
return null;
}
+
/// <summary>
- /// 璇绘ā鐗堣矾寰�
+ /// 璇绘ā鐗堣矾寰�
/// </summary>
/// <param name="fileType">cs,Designer.cs</param>
/// <returns></returns>
private string _getTemple(string fileType)
{
if (txt_table.Properties.Items.GetCheckedValues().Count < 2)
- return (@"\templeEasyCode\category1\category." + fileType);
- return (@"\templeEasyCode\category2\category." + fileType);
+ return @"\templeEasyCode\category1\category." + fileType;
+ return @"\templeEasyCode\category2\category." + fileType;
}
+
/// <summary>
- /// 璇诲彇鏂囦欢绫诲悕
+ /// 璇诲彇鏂囦欢绫诲悕
/// </summary>
/// <returns></returns>
private string _getClassName()
{
- string str = ToolBox.UtilityHelper.ToCamelCase(_getMainTable());
- string result = str.Substring(0, 1).ToUpper() + str.Substring(1);
+ var str = UtilityHelper.ToCamelCase(_getMainTable());
+ var result = str.Substring(0, 1).ToUpper() + str.Substring(1);
return "Frm_" + result;
}
+
/// <summary>
- /// 璇诲彇涓昏〃
+ /// 璇诲彇涓昏〃
/// </summary>
/// <returns></returns>
private string _getMainTable()
{
- List<object> ckList = txt_table.Properties.Items.GetCheckedValues();
- string _strName = ckList[0].ToString();
+ var ckList = txt_table.Properties.Items.GetCheckedValues();
+ var _strName = ckList[0].ToString();
foreach (string str in ckList)
- {
if (str.Length < _strName.Length)
_strName = str;
- }
return _getTableName(_strName);
}
+
/// <summary>
- /// 鎴彇琛ㄥ悕
+ /// 鎴彇琛ㄥ悕
/// </summary>
/// <param name="strName"></param>
/// <returns></returns>
private string _getTableName(string strName)
{
- string _tableName = strName.Split('(')[0];
+ var _tableName = strName.Split('(')[0];
return _tableName;
}
+
/// <summary>
- /// 绗竴涓枃浠�
+ /// 绗竴涓枃浠�
/// </summary>
/// <param name="dt"></param>
/// <param name="_FileName"></param>
- void ReadMainFile(DataTable dt, string _FileName, List<DataTable> dtList = null)
+ private void ReadMainFile(DataTable dt, string _FileName,
+ List<DataTable> dtList = null)
{
- string _tempPath = Application.StartupPath + _getTemple("cs");
- string contents = System.IO.File.ReadAllText(_tempPath);
- string line = Environment.NewLine;
- StringBuilder sb = new StringBuilder();
+ var _tempPath = Application.StartupPath + _getTemple("cs");
+ var contents = File.ReadAllText(_tempPath);
+ var line = Environment.NewLine;
+ var sb = new StringBuilder();
sb.Append(contents);
sb.Replace("{clsName}", _getClassName());
- string _fullPath = txtPath.Text + "\\" + _FileName + ".cs";
- if (System.IO.File.Exists(_fullPath))
- System.IO.File.Delete(_fullPath);
- System.IO.StreamWriter sw = System.IO.File.CreateText(_fullPath);
+ var _fullPath = txtPath.Text + "\\" + _FileName + ".cs";
+ if (File.Exists(_fullPath))
+ File.Delete(_fullPath);
+ var sw = File.CreateText(_fullPath);
sw.Write(sb.ToString());
sw.Close();
sw.Dispose();
}
+
/// <summary>
- /// 绗簩涓枃浠�
+ /// 绗簩涓枃浠�
/// </summary>
/// <param name="dt"></param>
/// <param name="_FileName"></param>
- void ReadDesignerFile(DataTable dt, string _FileName, List<DataTable> dtList = null)
+ private void ReadDesignerFile(DataTable dt, string _FileName,
+ List<DataTable> dtList = null)
{
- string _tempPath = Application.StartupPath + _getTemple("Designer.cs");
- string contents = System.IO.File.ReadAllText(_tempPath);
- StringBuilder strbuilder = new StringBuilder();
- string line = Environment.NewLine;
+ var _tempPath = Application.StartupPath + _getTemple("Designer.cs");
+ var contents = File.ReadAllText(_tempPath);
+ var strbuilder = new StringBuilder();
+ var line = Environment.NewLine;
strbuilder.Append(contents);
strbuilder.Replace("{clsName}", _getClassName());
- int _RowCount = dt.Rows.Count;
+ var _RowCount = dt.Rows.Count;
if (dt.Rows.Count > 0)
{
- string _FieldName = "";//瀛楁鍚�
- string _FieldText = "";//瀛楁鏂囨湰
- string _FieldNameSql = "";//鍘熷瀛楁鍚嶏紝涓昏鐢ㄤ簬鏌ヨ
+ var _FieldName = ""; //瀛楁鍚�
+ var _FieldText = ""; //瀛楁鏂囨湰
+ var _FieldNameSql = ""; //鍘熷瀛楁鍚嶏紝涓昏鐢ㄤ簬鏌ヨ
int _x = 0, _y = 0, _Tabindex = 210;
- string _ControlType = "TextEdit";//鎺т欢绫诲瀷锛岀洰鍓嶄笉浣滃垽鏂兘涓烘枃鏈
- string _lbType = "LabelControl";
- System.Text.StringBuilder _gvItemCol = new StringBuilder();
- for (int c = 0; c < _RowCount; c++)
+ var _ControlType = "TextEdit"; //鎺т欢绫诲瀷锛岀洰鍓嶄笉浣滃垽鏂兘涓烘枃鏈
+ var _lbType = "LabelControl";
+ var _gvItemCol = new StringBuilder();
+ for (var c = 0; c < _RowCount; c++)
{
- _x = 20 + c % 4 * 250;//璁＄畻鎺т欢鍦╔杞翠綅缃�
- if (c % 4 == 0)
- {
- _y = 20 + 32 * c / 4;//璁＄畻鎺т欢鍦╕杞寸殑浣嶇疆
- }
+ _x = 20 + c % 4 * 250; //璁＄畻鎺т欢鍦╔杞翠綅缃�
+ if (c % 4 == 0) _y = 20 + 32 * c / 4; //璁＄畻鎺т欢鍦╕杞寸殑浣嶇疆
_Tabindex = c % 4 + c / 4 + _Tabindex;
switch (dt.Rows[c]["DATA_TYPE"].ToString())
{
default:
- _FieldName = ToolBox.UtilityHelper.ToCamelCase(dt.Rows[c]["COLUMN_NAME"].ToString());
- _FieldText = dt.Rows[c]["REMARK"].ToString();
- _FieldNameSql = "query_a." + dt.Rows[c]["COLUMN_NAME"].ToString();
+ _FieldName = UtilityHelper.ToCamelCase(
+ dt.Rows[c]["COLUMN_NAME"].ToString().Trim());
+ _FieldText = dt.Rows[c]["REMARK"].ToString().Trim();
+ _FieldNameSql = "query_a." +
+ dt.Rows[c]["COLUMN_NAME"].ToString()
+ .Trim();
break;
}
- string _labName = "lb_" + _FieldName;//label鍚�
- string _txtName = "txt_" + _FieldName;//鏂囨湰妗嗗悕
- string _gvName = "gv_" + _FieldName;//gv涓殑鍒楀悕
+
+ var _labName = "lb_" + _FieldName; //label鍚�
+ var _txtName = "txt_" + _FieldName; //鏂囨湰妗嗗悕
+ var _gvName = "gv_" + _FieldName; //gv涓殑鍒楀悕
if (_gvItemCol.Length > 0)
_gvItemCol.Append(",");
_gvItemCol.Append("this." + _gvName);
//BQSetControlObject 瀹炰緥鍖栨帶浠�
- string BQSetControlObject = ("BQSetControlObject" + line + "this." + _labName + " = new DevExpress.XtraEditors." + _lbType + "();" + line);
- BQSetControlObject = (BQSetControlObject + "this." + _txtName + " = new DevExpress.XtraEditors." + _ControlType + "(); " + line);
- BQSetControlObject = (BQSetControlObject + "this." + _gvName + " = new DevExpress.XtraGrid.Columns.GridColumn(); " + line);
- strbuilder.Replace("BQSetControlObject", BQSetControlObject);
+ var BQSetControlObject = "BQSetControlObject" + line +
+ "this." + _labName +
+ " = new DevExpress.XtraEditors." +
+ _lbType + "();" + line;
+ BQSetControlObject = BQSetControlObject + "this." +
+ _txtName +
+ " = new DevExpress.XtraEditors." +
+ _ControlType + "(); " + line;
+ BQSetControlObject = BQSetControlObject + "this." +
+ _gvName +
+ " = new DevExpress.XtraGrid.Columns.GridColumn(); " +
+ line;
+ strbuilder.Replace("BQSetControlObject",
+ BQSetControlObject);
//BQSetControlInfo 璁剧疆鎺т欢淇℃伅浣嶇疆澶у皬鍚嶇О
- string BQSetControlInfo = "BQSetControlInfo" + line
- //label
- + "//" + line
- + "//" + _labName + line
- + "//" + line
- + "this." + _labName + ".Location = new System.Drawing.Point(" + _x + ", " + _y + ");" + line
- + "this." + _labName + ".Name = \"" + _labName + "\";" + line
- + "this." + _labName + ".Size = new System.Drawing.Size(150,21);" + line
- + "this." + _labName + ".TabIndex = " + _Tabindex + ";" + line
- + "this." + _labName + ".Appearance.Font = new System.Drawing.Font(\"Tahoma\", 10F);" + line
- + "this." + _labName + ".Text = \"" + _FieldText + " \";" + line
- //鏂囨湰
- + "//" + line
- + "//" + _txtName + line
- + "//" + line
- + "this." + _txtName + ".Location = new System.Drawing.Point(" + (_x + 60) + ", " + _y + ");" + line
- + "this." + _txtName + ".Name = \"" + _txtName + "\";" + line
- + "this." + _txtName + ".Size = new System.Drawing.Size(150,21);" + line
- + "this." + _txtName + ".TabIndex = " + _Tabindex + ";" + line
- + "this." + _txtName + ".Properties.Appearance.Font = new System.Drawing.Font(\"Tahoma\", 10F);" + line
- //涓籫ridView
- + "//" + line
- + "//" + _gvName + line
- + "//" + line
- + "this." + _gvName + ".AppearanceCell.Font = new System.Drawing.Font(\"Tahoma\", 10F);" + line
- + "this." + _gvName + ".AppearanceCell.Options.UseFont = true;" + line
- + "this." + _gvName + ".FieldName = \"" + _FieldName + "\";" + line
- + "this." + _gvName + ".Caption = \"" + _FieldText + " \";" + line
- + "this." + _gvName + ".Tag = \"" + _FieldNameSql + "\";" + line
- + "this." + _gvName + ".MinWidth =50;" + line
- + "this." + _gvName + ".Visible = true;" + line
- + "this." + _gvName + ".Width =94;" + line
- + "this." + _gvName + ".OptionsColumn.AllowEdit = false;" + line
- + "this." + _gvName + ".VisibleIndex = 0;" + line;
+ var BQSetControlInfo = "BQSetControlInfo" + line
+ //label
+ + "//" + line
+ + "//" + _labName + line
+ + "//" + line
+ + "this." + _labName +
+ ".Location = new System.Drawing.Point(" + _x + ", " +
+ _y + ");" + line
+ + "this." + _labName + ".Name = \"" + _labName + "\";" +
+ line
+ + "this." + _labName +
+ ".Size = new System.Drawing.Size(150,21);" + line
+ + "this." + _labName + ".TabIndex = " + _Tabindex +
+ ";" + line
+ + "this." + _labName +
+ ".Appearance.Font = new System.Drawing.Font(\"Tahoma\", 10F);" +
+ line
+ + "this." + _labName + ".Text = \"" + _FieldText +
+ " \";" + line
+ //鏂囨湰
+ + "//" + line
+ + "//" + _txtName + line
+ + "//" + line
+ + "this." + _txtName +
+ ".Location = new System.Drawing.Point(" + (_x + 60) +
+ ", " + _y + ");" + line
+ + "this." + _txtName + ".Name = \"" + _txtName + "\";" +
+ line
+ + "this." + _txtName +
+ ".Size = new System.Drawing.Size(150,21);" + line
+ + "this." + _txtName + ".TabIndex = " + _Tabindex +
+ ";" + line
+ + "this." + _txtName +
+ ".Properties.Appearance.Font = new System.Drawing.Font(\"Tahoma\", 10F);" +
+ line
+ //涓籫ridView
+ + "//" + line
+ + "//" + _gvName + line
+ + "//" + line
+ + "this." + _gvName +
+ ".AppearanceCell.Font = new System.Drawing.Font(\"Tahoma\", 10F);" +
+ line
+ + "this." + _gvName +
+ ".AppearanceCell.Options.UseFont = true;" + line
+ + "this." + _gvName + ".FieldName = \"" + _FieldName +
+ "\";" + line
+ + "this." + _gvName + ".Caption = \"" + _FieldText +
+ " \";" + line
+ + "this." + _gvName + ".Tag = \"" + _FieldNameSql +
+ "\";" + line
+ + "this." + _gvName + ".MinWidth =50;" + line
+ + "this." + _gvName + ".Visible = true;" + line
+ + "this." + _gvName + ".Width =94;" + line
+ + "this." + _gvName +
+ ".OptionsColumn.AllowEdit = false;" + line
+ + "this." + _gvName + ".VisibleIndex = 0;" + line;
strbuilder.Replace("BQSetControlInfo", BQSetControlInfo);
//BQAddControltoMContainer//灏嗘帶浠舵坊鍔犲埌panel1瀹瑰櫒涓�
- string BQAddControltoMContainer = "BQAddControltoMContainer" + line + " this.panel1.Controls.Add(this." + _labName + ");" + line;
- BQAddControltoMContainer += " this.panel1.Controls.Add(this." + _txtName + ");" + line;
- strbuilder.Replace("BQAddControltoMContainer", BQAddControltoMContainer);
+ var BQAddControltoMContainer = "BQAddControltoMContainer" +
+ line +
+ " this.panel1.Controls.Add(this." +
+ _labName + ");" + line;
+ BQAddControltoMContainer +=
+ " this.panel1.Controls.Add(this." + _txtName + ");" +
+ line;
+ strbuilder.Replace("BQAddControltoMContainer",
+ BQAddControltoMContainer);
//BQCreateConrolObejct //鍒涘缓鎺т欢
- string BQCreateConrolObejct = "BQCreateConrolObejct" + line + "private DevExpress.XtraEditors." + _lbType + " " + _labName + ";" + line;
- BQCreateConrolObejct += "private DevExpress.XtraEditors." + _ControlType + " " + _txtName + ";" + line;
- BQCreateConrolObejct += " private DevExpress.XtraGrid.Columns.GridColumn " + _gvName + ";" + line;
- strbuilder.Replace("BQCreateConrolObejct", BQCreateConrolObejct);
+ var BQCreateConrolObejct = "BQCreateConrolObejct" + line +
+ "private DevExpress.XtraEditors." +
+ _lbType + " " + _labName + ";" +
+ line;
+ BQCreateConrolObejct += "private DevExpress.XtraEditors." +
+ _ControlType + " " + _txtName +
+ ";" + line;
+ BQCreateConrolObejct +=
+ " private DevExpress.XtraGrid.Columns.GridColumn " +
+ _gvName + ";" + line;
+ strbuilder.Replace("BQCreateConrolObejct",
+ BQCreateConrolObejct);
}
+
//鎶婂垪鍔犲叆鍒癵ridview涓�
strbuilder.Replace("{colList}", _gvItemCol.ToString());
//鏋勫缓鏄庣粏gridview1
if (dtList != null && dtList.Count > 0)
{
- int _idx = 1;
- System.Text.StringBuilder _tabItem = new System.Text.StringBuilder();
- foreach (DataTable dt2 in dtList)
+ var _idx = 1;
+ var _tabItem = new StringBuilder();
+ foreach (var dt2 in dtList)
{
- string _tabMxPage = "tabMxPage" + _idx.ToString();
- string _gcMx = "gcMx" + _idx.ToString();
- string _gvMx = "gvMx" + _idx.ToString();
+ var _tabMxPage = "tabMxPage" + _idx;
+ var _gcMx = "gcMx" + _idx;
+ var _gvMx = "gvMx" + _idx;
if (_tabItem.Length > 0)
_tabItem.Append(",");
_tabItem.Append("this." + _tabMxPage);
//BQSetControlObject 瀹炰緥鍖栨帶浠�
- string ss = "BQSetControlObject" + line;
- ss += (" this." + _tabMxPage + " = new DevExpress.XtraTab.XtraTabPage();") + line;
- ss += (" this." + _gcMx + " = new DevExpress.XtraGrid.GridControl();") + line;
- ss += (" this." + _gvMx + " = new DevExpress.XtraGrid.Views.Grid.GridView();");
+ var ss = "BQSetControlObject" + line;
+ ss += " this." + _tabMxPage +
+ " = new DevExpress.XtraTab.XtraTabPage();" + line;
+ ss += " this." + _gcMx +
+ " = new DevExpress.XtraGrid.GridControl();" +
+ line;
+ ss += " this." + _gvMx +
+ " = new DevExpress.XtraGrid.Views.Grid.GridView();";
strbuilder.Replace("BQSetControlObject", ss);
//BQSetControlInfo 璁剧疆鎺т欢淇℃伅浣嶇疆澶у皬鍚嶇О
- string inf = "BQSetControlInfo" + line
- + "this." + _tabMxPage + ".Controls.Add(this." + _gcMx + ");"
- + "this." + _tabMxPage + ".Name = \"" + _tabMxPage + "\";" + line
- + "this." + _tabMxPage + ".Size = new System.Drawing.Size(1186, 112);" + line
- + "this." + _tabMxPage + ".Text = \"鏄庣粏" + _idx.ToString() + "\";" + line
- + "//" + line
- + "//" + _gcMx + line
- + "//" + line
- + " this." + _gcMx + ".Dock = System.Windows.Forms.DockStyle.Fill;" + line
- + " this." + _gcMx + ".Location = new System.Drawing.Point(0, 0);" + line
- + " this." + _gcMx + ".MainView = this." + _gvMx + ";" + line
- + " this." + _gcMx + ".Name = \"" + _gcMx + "\";" + line
- + " this." + _gcMx + ".Size = new System.Drawing.Size(1124, 215);" + line
- + " this." + _gcMx + ".TabIndex = 0;" + line
- + " this." + _gcMx + ".ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] { this." + _gvMx + "});" + line
- + "//" + line
- + "//" + _gvMx + line
- + "//" + line
- + " this." + _gvMx + ".GridControl = this." + _gcMx + ";" + line
- + " this." + _gvMx + ".Name = \"" + _gvMx + "\";" + line
- + " this." + _gvMx + ".OptionsFind.ShowSearchNavButtons = false;" + line
- + " this." + _gvMx + ".OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Bottom;" + line
- + " this." + _gvMx + ".OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.True;" + line
- + " this." + _gvMx + ".OptionsView.ShowGroupPanel = false;" + line
- + " this." + _gvMx + ".Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { {colMx1List}});";
+ var inf = "BQSetControlInfo" + line
+ + "this." + _tabMxPage + ".Controls.Add(this." +
+ _gcMx + ");"
+ + "this." + _tabMxPage + ".Name = \"" + _tabMxPage +
+ "\";" + line
+ + "this." + _tabMxPage +
+ ".Size = new System.Drawing.Size(1186, 112);" + line
+ + "this." + _tabMxPage + ".Text = \"鏄庣粏" + _idx +
+ "\";" + line
+ + "//" + line
+ + "//" + _gcMx + line
+ + "//" + line
+ + " this." + _gcMx +
+ ".Dock = System.Windows.Forms.DockStyle.Fill;" +
+ line
+ + " this." + _gcMx +
+ ".Location = new System.Drawing.Point(0, 0);" + line
+ + " this." + _gcMx + ".MainView = this." + _gvMx +
+ ";" + line
+ + " this." + _gcMx + ".Name = \"" + _gcMx + "\";" +
+ line
+ + " this." + _gcMx +
+ ".Size = new System.Drawing.Size(1124, 215);" + line
+ + " this." + _gcMx + ".TabIndex = 0;" + line
+ + " this." + _gcMx +
+ ".ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] { this." +
+ _gvMx + "});" + line
+ + "//" + line
+ + "//" + _gvMx + line
+ + "//" + line
+ + " this." + _gvMx + ".GridControl = this." +
+ _gcMx + ";" + line
+ + " this." + _gvMx + ".Name = \"" + _gvMx + "\";" +
+ line
+ + " this." + _gvMx +
+ ".OptionsFind.ShowSearchNavButtons = false;" + line
+ + " this." + _gvMx +
+ ".OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Bottom;" +
+ line
+ + " this." + _gvMx +
+ ".OptionsBehavior.AllowAddRows = DevExpress.Utils.DefaultBoolean.True;" +
+ line
+ + " this." + _gvMx +
+ ".OptionsView.ShowGroupPanel = false;" + line
+ + " this." + _gvMx +
+ ".Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] { {colMx1List}});";
strbuilder.Replace("BQSetControlInfo", inf);
//BQCreateConrolObejct //鍒涘缓鎺т欢
- string _cc = "BQCreateConrolObejct" + line;
- _cc += " private DevExpress.XtraTab.XtraTabPage " + _tabMxPage + ";" + line;
- _cc += " private DevExpress.XtraGrid.GridControl " + _gcMx + ";" + line;
- _cc += " private DevExpress.XtraGrid.Views.Grid.GridView " + _gvMx + ";";
+ var _cc = "BQCreateConrolObejct" + line;
+ _cc += " private DevExpress.XtraTab.XtraTabPage " +
+ _tabMxPage + ";" + line;
+ _cc += " private DevExpress.XtraGrid.GridControl " +
+ _gcMx + ";" + line;
+ _cc +=
+ " private DevExpress.XtraGrid.Views.Grid.GridView " +
+ _gvMx + ";";
strbuilder.Replace("BQCreateConrolObejct", _cc);
- System.Text.StringBuilder _layout = new StringBuilder();
+ var _layout = new StringBuilder();
_layout.Append("this.tabMxPage1.SuspendLayout();");
strbuilder.Replace("{layoutList}", _layout.ToString());
- System.Text.StringBuilder _resume = new StringBuilder();
+ var _resume = new StringBuilder();
_resume.Append("this.tabMxPage1.ResumeLayout(false);");
- strbuilder.Replace("{resumeLayout}", _resume.ToString());
- System.Text.StringBuilder _beg = new StringBuilder();
- _beg.Append("((System.ComponentModel.ISupportInitialize)(this." + _gcMx + ")).BeginInit();" + line);
- _beg.Append(" ((System.ComponentModel.ISupportInitialize)(this." + _gvMx + ")).BeginInit();" + line);
+ strbuilder.Replace("{resumeLayout}",
+ _resume.ToString());
+ var _beg = new StringBuilder();
+ _beg.Append(
+ "((System.ComponentModel.ISupportInitialize)(this." +
+ _gcMx + ")).BeginInit();" + line);
+ _beg.Append(
+ " ((System.ComponentModel.ISupportInitialize)(this." +
+ _gvMx + ")).BeginInit();" + line);
strbuilder.Replace("{begInit}", _beg.ToString());
///////////////////
_RowCount = dt2.Rows.Count;
_gvItemCol = new StringBuilder();
- for (int c = 0; c < _RowCount; c++)
+ for (var c = 0; c < _RowCount; c++)
{
switch (dt2.Rows[c]["DATA_TYPE"].ToString())
{
default:
- _FieldName = ToolBox.UtilityHelper.ToCamelCase(dt2.Rows[c]["COLUMN_NAME"].ToString());
- _FieldText = dt2.Rows[c]["REMARK"].ToString();
- _FieldNameSql = "query_a." + dt2.Rows[c]["COLUMN_NAME"].ToString();
+ _FieldName =
+ UtilityHelper.ToCamelCase(
+ dt2.Rows[c]["COLUMN_NAME"]
+ .ToString());
+ _FieldText = dt2.Rows[c]["REMARK"]
+ .ToString();
+ _FieldNameSql = "query_a." +
+ dt2.Rows[c]["COLUMN_NAME"];
break;
}
- string _gvColName = _gvMx + _FieldName;
+
+ var _gvColName = _gvMx + _FieldName;
if (_gvItemCol.Length > 0)
_gvItemCol.Append(",");
_gvItemCol.Append("this." + _gvColName);
//BQSetControlObject 瀹炰緥鍖栨帶浠�
- string BQSetControlObject = "BQSetControlObject" + line;
- BQSetControlObject += ("this." + _gvColName + " = new DevExpress.XtraGrid.Columns.GridColumn(); ");
- strbuilder.Replace("BQSetControlObject", BQSetControlObject);
+ var BQSetControlObject =
+ "BQSetControlObject" + line;
+ BQSetControlObject += "this." + _gvColName +
+ " = new DevExpress.XtraGrid.Columns.GridColumn(); ";
+ strbuilder.Replace("BQSetControlObject",
+ BQSetControlObject);
//BQSetControlInfo 璁剧疆鎺т欢淇℃伅浣嶇疆澶у皬鍚嶇О
- string BQSetControlInfo = "BQSetControlInfo" + line
- + "this." + _gvColName + ".AppearanceCell.Font = new System.Drawing.Font(\"Tahoma\", 10F);" + line
- + "this." + _gvColName + ".AppearanceCell.Options.UseFont = true;" + line
- + "this." + _gvColName + ".FieldName = \"" + _FieldName + "\";" + line
- + "this." + _gvColName + ".Caption = \"" + _FieldText + " \";" + line
- + "this." + _gvColName + ".Tag = \"" + _FieldNameSql + "\";" + line
- + "this." + _gvColName + ".MinWidth = 50;" + line
- + "this." + _gvColName + ".Visible = true;" + line
- + "this." + _gvColName + ".Width =94;" + line
- + "this." + _gvColName + ".OptionsColumn.AllowEdit = true;" + line
- + "this." + _gvColName + ".VisibleIndex = 0;" + line;
- strbuilder.Replace("BQSetControlInfo", BQSetControlInfo);
+ var BQSetControlInfo = "BQSetControlInfo" + line
+ + "this." + _gvColName +
+ ".AppearanceCell.Font = new System.Drawing.Font(\"Tahoma\", 10F);" +
+ line
+ + "this." + _gvColName +
+ ".AppearanceCell.Options.UseFont = true;" + line
+ + "this." + _gvColName + ".FieldName = \"" +
+ _FieldName + "\";" + line
+ + "this." + _gvColName + ".Caption = \"" +
+ _FieldText + " \";" + line
+ + "this." + _gvColName + ".Tag = \"" +
+ _FieldNameSql + "\";" + line
+ + "this." + _gvColName + ".MinWidth = 50;" +
+ line
+ + "this." + _gvColName + ".Visible = true;" +
+ line
+ + "this." + _gvColName + ".Width =94;" + line
+ + "this." + _gvColName +
+ ".OptionsColumn.AllowEdit = true;" + line
+ + "this." + _gvColName + ".VisibleIndex = 0;" +
+ line;
+ strbuilder.Replace("BQSetControlInfo",
+ BQSetControlInfo);
//BQCreateConrolObejct //鍒涘缓鎺т欢
- string BQCreateConrolObejct = "BQCreateConrolObejct" + line;
- BQCreateConrolObejct += " private DevExpress.XtraGrid.Columns.GridColumn " + _gvColName + ";";
- strbuilder.Replace("BQCreateConrolObejct", BQCreateConrolObejct);
+ var BQCreateConrolObejct =
+ "BQCreateConrolObejct" + line;
+ BQCreateConrolObejct +=
+ " private DevExpress.XtraGrid.Columns.GridColumn " +
+ _gvColName + ";";
+ strbuilder.Replace("BQCreateConrolObejct",
+ BQCreateConrolObejct);
}
- strbuilder.Replace("{colMx1List}", _gvItemCol.ToString());
+
+ strbuilder.Replace("{colMx1List}",
+ _gvItemCol.ToString());
_idx++;
}
+
strbuilder.Replace("{tabMx1List}", _tabItem.ToString());
}
- System.IO.File.Delete(txtPath.Text + "\\" + _FileName + ".Designer.cs");
- string path = txtPath.Text;
- System.IO.StreamWriter sw = System.IO.File.CreateText(path + "\\" + _FileName + ".Designer.cs");
+
+ File.Delete(txtPath.Text + "\\" + _FileName + ".Designer.cs");
+ var path = txtPath.Text;
+ var sw =
+ File.CreateText(path + "\\" + _FileName + ".Designer.cs");
sw.Write(strbuilder.ToString());
sw.Close();
sw.Dispose();
@@ -410,38 +625,38 @@
/// <summary>
- /// 绗笁涓枃浠�
+ /// 绗笁涓枃浠�
/// </summary>
/// <param name="dt"></param>
/// <param name="_FileName"></param>
- void ReadResxFile(DataTable dt, string _FileName)
+ private void ReadResxFile(DataTable dt, string _FileName)
{
- string _Temppath = Application.StartupPath + _getTemple("resx");
- string contents = System.IO.File.ReadAllText(_Temppath);
- StringBuilder strbuilder = new StringBuilder();
- string line = Environment.NewLine;
+ var _Temppath = Application.StartupPath + _getTemple("resx");
+ var contents = File.ReadAllText(_Temppath);
+ var strbuilder = new StringBuilder();
+ var line = Environment.NewLine;
strbuilder.Append(contents);
- System.IO.File.Delete(txtPath.Text + "\\" + _FileName + ".resx");
- string path = txtPath.Text;
- System.IO.StreamWriter sw = System.IO.File.CreateText(path + "\\" + _FileName + ".resx");
+ File.Delete(txtPath.Text + "\\" + _FileName + ".resx");
+ var path = txtPath.Text;
+ var sw = File.CreateText(path + "\\" + _FileName + ".resx");
sw.Write(strbuilder.ToString());
sw.Close();
sw.Dispose();
}
-
#endregion
#region 鏂囦欢涓婁紶
+
/// <summary>
- /// 閫夋嫨涓婁紶鏂囦欢
+ /// 閫夋嫨涓婁紶鏂囦欢
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnUpSelect_Click(object sender, EventArgs e)
{
- OpenFileDialog openFileDialog = new OpenFileDialog();
+ var openFileDialog = new OpenFileDialog();
// 璁剧疆鍒濆鐩綍
openFileDialog.InitialDirectory = "c:\\";
// 璁剧疆鏂囦欢杩囨护閫夐」锛屽锛�"鏂囨湰鏂囦欢 (*.txt)|*.txt|鎵�鏈夋枃浠� (*.*)|*.*"
@@ -449,29 +664,28 @@
// 璁剧疆鏍囬
openFileDialog.Title = "閫夋嫨鏂囦欢";
// 鏄剧ず瀵硅瘽妗�
- DialogResult result = openFileDialog.ShowDialog();
+ var result = openFileDialog.ShowDialog();
// 纭鐢ㄦ埛娌℃湁鍙栨秷鎿嶄綔
if (result == DialogResult.OK)
{
// 鑾峰彇閫変腑鐨勬枃浠惰矾寰�
- string filePath = openFileDialog.FileName;
+ var filePath = openFileDialog.FileName;
Console.WriteLine($"閫変腑鐨勬枃浠�: {filePath}");
txtUpUrl.Text = filePath;
}
-
}
/// <summary>
- /// 纭畾涓婁紶
+ /// 纭畾涓婁紶
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void BtnUp_Click(object sender, EventArgs e)
{
- string WebApiUrl = System.Configuration.ConfigurationSettings.AppSettings.Get("WebApiUrl").ToString();
- string address = WebApiUrl + "Upload/UploadFile";
- string filePath = txtUpUrl.Text.Trim();
- string apiUrl = address; // 鏇挎崲涓轰綘鐨凙PI鍦板潃
+ var WebApiUrl = ConfigurationSettings.AppSettings.Get("WebApiUrl");
+ var address = WebApiUrl + "Upload/UploadFile";
+ var filePath = txtUpUrl.Text.Trim();
+ var apiUrl = address; // 鏇挎崲涓轰綘鐨凙PI鍦板潃
await UploadFileAsync(apiUrl, filePath);
}
@@ -480,37 +694,39 @@
using (var httpClient = new HttpClient())
using (var form = new MultipartFormDataContent())
{
- httpClient.DefaultRequestHeaders.Add("token", ToolBox.UtilityHelper.GetBasicAuthTicket());
+ httpClient.DefaultRequestHeaders.Add("token",
+ UtilityHelper.GetBasicAuthTicket());
using (var fs = File.OpenRead(filePath))
using (var streamContent = new StreamContent(fs))
{
form.Add(streamContent, "file", Path.GetFileName(filePath));
var response = await httpClient.PostAsync(url, form);
- string responseString = await response.Content.ReadAsStringAsync();
+ var responseString =
+ await response.Content.ReadAsStringAsync();
MessageBox.Show(responseString);
}
}
}
+
#endregion
#region 鎺ㄩ�佹祴璇�
+
/// <summary>
- /// 纭畾鎺ㄩ��
+ /// 纭畾鎺ㄩ��
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnMes_Click(object sender, EventArgs e)
{
- List<dynamic> _list = new List<dynamic>();
- for (int i = 0; i < 20; i++)
- {
+ var _list = new List<dynamic>();
+ for (var i = 0; i < 20; i++)
_list.Add(new
{
- t1 = "test1_" + i.ToString(),//鍗曚綅缂栧彿
- t2 = "hi2_" + i.ToString(),//鍗曚綅鍚嶇О
+ t1 = "test1_" + i, //鍗曚綅缂栧彿
+ t2 = "hi2_" + i //鍗曚綅鍚嶇О
});
- }
var _json = new
{
category = "鍗曚綅淇℃伅",
@@ -518,17 +734,19 @@
};
try
{
- string _apiUrl = "http://localhost:5263/";
- string _strReturnJson = HttpPost(_apiUrl, "ErpMes/PushMesByCategory", JsonConvert.SerializeObject(_json));
+ var _apiUrl = "http://localhost:5263/";
+ var _strReturnJson = HttpPost(_apiUrl,
+ "ErpMes/PushMesByCategory",
+ JsonConvert.SerializeObject(_json));
txtMesResult.Text = _strReturnJson;
}
catch (Exception ex)
{
- ToolBox.MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
+ MsgHelper.Warning("鎻愮ず锛�" + ex.Message);
}
}
+
/// <summary>
- ///
/// </summary>
/// <param name="url">apiUrl鏍瑰湴鍧�</param>
/// <param name="meth">apiUrl鏂规硶鍚�</param>
@@ -537,8 +755,8 @@
public static string HttpPost(string url, string meth, string param)
{
//杩欐槸涓�涓櫄鎷熺殑token锛屼笉鑳藉垹闄�
- string token = (Guid.NewGuid().ToString() + "~" + Guid.NewGuid().ToString());
- HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(url + meth);
+ var token = Guid.NewGuid() + "~" + Guid.NewGuid();
+ var request = (HttpWebRequest)WebRequest.Create(url + meth);
request.Method = "POST";
request.ContentType = "application/json";
request.Headers.Add("token", token);
@@ -556,7 +774,8 @@
response = request.GetResponse();
if (response != null)
{
- StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.UTF8);
+ var reader = new StreamReader(response.GetResponseStream(),
+ Encoding.UTF8);
responseStr = reader.ReadToEnd();
reader.Close();
}
@@ -571,95 +790,10 @@
requestStream = null;
response = null;
}
+
return responseStr;
}
-
#endregion
-
- #region 鎵归噺璇诲彇
- private void btnTable_Click(object sender, EventArgs e)
- {
-
- using (OracleConnection connection = new OracleConnection(oracleCon))
- {
- try
- {
- connection.Open();
- using (OracleCommand command = connection.CreateCommand())
- {
- command.CommandText = "SELECT * FROM " + txtTable1.Text.Trim();
- using (OracleDataReader oracleDataReader = command.ExecuteReader())
- {
- using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlCon))
- {
- bulkCopy.DestinationTableName = txtTable1.Text.Trim();
- bulkCopy.WriteToServer(oracleDataReader);
- }
- }
- }
- ToolBox.MsgHelper.ShowInformation("鎻愮ず锛屾搷浣滄垚鍔燂紒");
- }
- catch (Exception ex)
- {
- Console.WriteLine(ex.Message);
- ToolBox.MsgHelper.ShowError("鎻愮ず锛�" + ex.Message);
- }
- finally
- {
- if (connection.State != System.Data.ConnectionState.Closed)
- {
- connection.Close();
- }
- }
- }
-
- }
- #endregion
-
- #region 鎵归噺鍑嗗
- private void btnRemark_Click(object sender, EventArgs e)
- {
-
- if (txtTable2.Text.Trim().Length <= 0)
- {
- MessageBox.Show("璇疯緭鍏ヨ〃鍚�");
- return;
- }
- using (SqlConnection conn = new SqlConnection(sqlCon))
- {
- using (SqlCommand cmd = new SqlCommand("[tmp_property]", conn))
- {
- try
- {
- conn.Open();
- cmd.CommandType = CommandType.StoredProcedure;
- SqlParameter[] parameters = new SqlParameter[] {
- new SqlParameter("@tabname",txtTable2.Text.Trim()),
- new SqlParameter("@com",txtOracleDec.Text.Trim()),
- };
- foreach (SqlParameter parameter in parameters)
- {
- cmd.Parameters.Add(parameter);
- }
- cmd.ExecuteNonQuery();
- ToolBox.MsgHelper.ShowInformation("鎻愮ず锛屾搷浣滄垚鍔燂紒");
- }
- catch (Exception ex)
- {
- ToolBox.MsgHelper.ShowError("鎻愮ず锛�" + ex.Message);
- }
- finally
- {
- conn.Close();
- }
- }
- }
- }
- #endregion
-
-
}
-}
-
-
+}
\ No newline at end of file
--
Gitblit v1.9.3