//private void button1_Click(object sender, EventArgs e)
//{
// MySqlConnectionStringBuilder connBuilder =
// new MySqlConnectionStringBuilder();
// connBuilder.Add("Database", "zjzl");
// connBuilder.Add("Data Source", "localhost");
// connBuilder.Add("User Id", "root");
// connBuilder.Add("Password", "123");
// //connBuilder.Add("Charset", "utf8");
// MySqlConnection connection =
// new MySqlConnection(connBuilder.ConnectionString);
// try
// {
// MySqlCommand cmd = connection.CreateCommand();
// cmd.CommandType = CommandType.Text;
// cmd.CommandText = "select id, name, level, price from material;";
// connection.Open();
// MySqlDataReader dr = cmd.ExecuteReader();
// while (dr.Read())
// {
// comboBoxMaterialName.Items.Add(dr["name"].ToString());
// comboBoxMaterialLevel.Items.Add(dr["level"].ToString());
// //com
// }
// dr.Close();
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.ToString());
// }
// finally
// {
// if (connection != null)
// {
// connection.Close();
// }
// }
//}
//private void button2_Click(object sender, EventArgs e)
//{
// MySqlConnection connection = MySqlConnHelper.GetMySqlConn(Properties.Settings.Default.DbConn);
// try
// {
// MySqlCommand cmd = connection.CreateCommand();
// cmd.CommandType = CommandType.Text;
// cmd.CommandText = "insert into material(name, level, price) values(@name, @level, 0.05);";
// cmd.Parameters.Clear();
// cmd.Parameters.AddWithValue("@name", "紫荆泽兰");
// cmd.Parameters.AddWithValue("@level", "5");
// connection.Open();
// cmd.ExecuteNonQuery();
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.ToString());
// }
// finally
// {
// if (connection != null)
// {
// connection.Close();
// }
// }
//}
#endregion
private void Init()
{
#region 数量单位/Units
//string s = Properties.Settings.Default["Units"].ToString();
//if (!string.IsNullOrEmpty(s))
//{
// string[] ss = s.Split(seperator, StringSplitOptions.RemoveEmptyEntries);
// if (ss != null)
// {
// comboBoxUnits.Items.AddRange(ss);
// comboBoxUnits.SelectedIndex = 0;
// }
//}
#endregion
MySqlConnection conn = null;
try
{
conn = MySqlConnHelper.GetMySqlConn(Properties.Settings.Default.DbConn);
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select id, name, level, price from material order by name asc, level asc;";
adapter.SelectCommand = cmd;
DataTable dt = new DataTable();
conn.Open();
adapter.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
tableMaterial = new ArrayList();
string pastName = null;
for (int i = 0; i < dt.Rows.Count; i++)
{
TableMaterial tm = new TableMaterial();
tm.id = int.Parse(dt.Rows[i]["id"].ToString());
tm.name = dt.Rows[i]["name"].ToString();
tm.level = dt.Rows[i]["level"].ToString();
tm.price = decimal.Parse(dt.Rows[i]["price"].ToString());
tableMaterial.Add(tm);
if (pastName != tm.name)
{
comboBoxMaterialName.Items.Add(tm.name);
}
pastName = tm.name;
}
}
}
catch (MySqlException sqlEx)
{
WriteLog(sqlEx.ToString());
NotifyHelper.NotifyUser("无法连接服务器");
}
catch (Exception ex)
{
WriteLog(ex.ToString());
NotifyHelper.NotifyUser("获取数据失败");
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
private void Init()
{
#region ������λ/Units
//string s = Properties.Settings.Default["Units"].ToString();
//if (!string.IsNullOrEmpty(s))
//{
// string[] ss = s.Split(seperator, StringSplitOptions.RemoveEmptyEntries);
// if (ss != null)
// {
// comboBoxUnits.Items.AddRange(ss);
// comboBoxUnits.SelectedIndex = 0;
// }
//}
#endregion
MySqlConnection conn = null;
try
{
conn = MySqlConnHelper.GetMySqlConn(Properties.Settings.Default.DbConn);
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select id, name, level, price from material order by name asc, level asc;";
adapter.SelectCommand = cmd;
DataTable dt = new DataTable();
conn.Open();
adapter.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
tableMaterial = new ArrayList();
string pastName = null;
for (int i = 0; i < dt.Rows.Count; i++)
{
TableMaterial tm = new TableMaterial();
tm.id = int.Parse(dt.Rows[i]["id"].ToString());
tm.name = dt.Rows[i]["name"].ToString();
tm.level = dt.Rows[i]["level"].ToString();
tm.price = decimal.Parse(dt.Rows[i]["price"].ToString());
tableMaterial.Add(tm);
if (pastName != tm.name)
{
comboBoxMaterialName.Items.Add(tm.name);
}
pastName = tm.name;
}
}
}
catch (MySqlException sqlEx)
{
WriteLog(sqlEx.ToString());
NotifyHelper.NotifyUser("�����ӷ�����");
}
catch (Exception ex)
{
WriteLog(ex.ToString());
NotifyHelper.NotifyUser("��ȡ����ʧ��");
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
private void RefreshPurPerList()
{
listViewPurPerInfo.Items.Clear();
MySqlConnection conn = null;
try
{
conn = MySqlConnHelper.GetMySqlConn(Properties.Settings.Default.DbConn);
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"select t.id, t.name, t.ni, t.upper, t.tag, t.upper_used,
t.org_id, s.name as org_name
from pur_customer t, pur_organization s
where t.org_id=s.id order by t.name asc;";
adapter.SelectCommand = cmd;
DataTable dt = new DataTable();
conn.Open();
adapter.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
listViewPurPerInfo.BeginUpdate();
for (int i = 0; i < dt.Rows.Count; i++)
{
ListViewItem item = new ListViewItem(dt.Rows[i]["id"].ToString());
item.SubItems.Add(dt.Rows[i]["name"].ToString());
item.SubItems.Add(dt.Rows[i]["org_name"].ToString());
item.SubItems.Add(dt.Rows[i]["ni"].ToString());
item.SubItems.Add(dt.Rows[i]["upper"].ToString());
item.SubItems.Add(dt.Rows[i]["org_id"].ToString()); //5
item.SubItems.Add(dt.Rows[i]["tag"].ToString()); //6
item.SubItems.Add(dt.Rows[i]["upper_used"].ToString()); //7
listViewPurPerInfo.Items.Add(item);
}
listViewPurPerInfo.EndUpdate();
}
#region pur_organazition
// ��������ÿ��ˢ��ʱ��ˢ��tableOrg��
// ��ȻЧ�ʲ�����ã�������ά���dz���--������ģ�����֮������
// if (tableOrg == null) // ֻ����һ��
{
cmd.CommandText = "select id, name from pur_organization order by name asc";
adapter.SelectCommand = cmd;
dt.Clear();
conn.Open();
adapter.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
tableOrg = new ArrayList();
comboBoxPurOrg.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
TableMaterial tm = new TableMaterial();
tm.id = int.Parse(dt.Rows[i]["id"].ToString());
tm.name = dt.Rows[i]["name"].ToString();
tableOrg.Add(tm);
ListItem org = new ListItem(tm.id.ToString(), tm.name);
comboBoxPurOrg.Items.Add(org);
}
comboBoxPurOrg.DisplayMember = "Name";
comboBoxPurOrg.ValueMember = "ID";
}
}
#endregion
}
catch (Exception ex)
{
WriteLog(ex.ToString());
NotifyHelper.NotifyUser("����ʧ��: " + ex.Message);
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
private void Init()
{
MySqlConnection conn = null;
try
{
Reset();
eraseTimer.Elapsed += new ElapsedEventHandler(eraseTimer_Elapsed);
eraseTimer.Interval = 2500;
string pastName = null;
conn = MySqlConnHelper.GetMySqlConn(Properties.Settings.Default.DbConn);
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
MySqlDataAdapter adapter = null;
adapter = new MySqlDataAdapter();
DataTable dt = null;
conn.Open();
#region ����Ա
//adapter = new MySqlDataAdapter();
cmd.CommandText = "select id, name from employee";
adapter.SelectCommand = cmd;
dt = new DataTable();
adapter.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ListItem mt = new ListItem();
mt.ID = dt.Rows[i]["id"].ToString();
mt.Name = string.Format("{0} -- {1}", dt.Rows[i]["name"].ToString(), mt.ID);
comboBoxOperator.Items.Add(mt);
}
comboBoxOperator.DisplayMember = "Name";
comboBoxOperator.ValueMember = "ID";
}
#endregion
#region ԭ��
cmd.CommandText = "select id, name, level, price from material order by name asc, level asc;";
adapter.SelectCommand = cmd;
dt = new DataTable();
adapter.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
tableMaterial = new ArrayList();
for (int i = 0; i < dt.Rows.Count; i++)
{
TableMaterial tm = new TableMaterial();
tm.id = int.Parse(dt.Rows[i]["id"].ToString());
tm.name = dt.Rows[i]["name"].ToString();
tm.level = dt.Rows[i]["level"].ToString();
tableMaterial.Add(tm);
if (pastName != tm.name)
{
comboBoxMaterialName.Items.Add(tm.name);
}
pastName = tm.name;
}
}
#endregion
#region ����
//adapter = new MySqlDataAdapter();
cmd.CommandText = "select id, name, level, price from product order by name asc, level asc;";
adapter.SelectCommand = cmd;
dt = new DataTable();
adapter.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
tableProduct = new ArrayList();
for (int i = 0; i < dt.Rows.Count; i++)
{
TableMaterial tm = new TableMaterial();
tm.id = int.Parse(dt.Rows[i]["id"].ToString());
tm.name = dt.Rows[i]["name"].ToString();
tm.level = dt.Rows[i]["level"].ToString();
tableProduct.Add(tm);
if (pastName != tm.name)
{
comboBoxProductName.Items.Add(tm.name);
}
pastName = tm.name;
}
}
#endregion
}
catch (MySqlException sqlEx)
{
WriteLog(sqlEx.ToString());
NotifyHelper.NotifyUser("�����ӷ�����");
}
catch (Exception ex)
{
WriteLog(ex.ToString());
NotifyHelper.NotifyUser("��ȡ����ʧ��");
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
private void Init()
{
MySqlConnection conn = null;
try
{
eraseTimer.Interval = 2000;
eraseTimer.Elapsed += new ElapsedEventHandler(eraseTimer_Elapsed);
conn = MySqlConnHelper.GetMySqlConn(Properties.Settings.Default.DbConn);
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select id, name, level, price from product order by name asc, level asc;";
adapter.SelectCommand = cmd;
DataTable dt = new DataTable();
conn.Open();
adapter.Fill(dt);
#region 物品
if (dt.Rows.Count > 0)
{
tableMaterial = new ArrayList();
string pastName = null;
for (int i = 0; i < dt.Rows.Count; i++)
{
TableMaterial tm = new TableMaterial();
tm.id = int.Parse(dt.Rows[i]["id"].ToString());
tm.name = dt.Rows[i]["name"].ToString();
tm.level = dt.Rows[i]["level"].ToString();
decimal tmpPrice = 0.0M;
if (decimal.TryParse(dt.Rows[i]["price"].ToString(), out tmpPrice))
{
tm.price = tmpPrice;
}
tableMaterial.Add(tm);
if (pastName != tm.name)
{
comboBoxMaterialName.Items.Add(tm.name);
}
pastName = tm.name;
}
}
#endregion
cmd.CommandText = "select id, name from sale_customer order by id asc";
adapter.SelectCommand = cmd;
dt = new DataTable();
adapter.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
//customers = new ArrayList();
for (int j = 0; j < dt.Rows.Count; j++)
{
SaleCustomer saleCustomer = new SaleCustomer();
saleCustomer.id = int.Parse(dt.Rows[j]["id"].ToString());
saleCustomer.name = dt.Rows[j]["name"].ToString();
comboBoxCorpName.Items.Add(saleCustomer);
}
comboBoxCorpName.DisplayMember = "name";
comboBoxCorpName.ValueMember = "id";
}
}
catch (MySqlException sqlEx)
{
WriteLog(sqlEx.ToString());
NotifyHelper.NotifyUser("无法连接服务器: " + sqlEx.Message);
}
catch (Exception ex)
{
WriteLog(ex.ToString());
NotifyHelper.NotifyUser("获取数据失败: " + ex.Message);
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
private void Init()
{
MySqlConnection conn = null;
try
{
Reset();
eraseTimer.Elapsed += new ElapsedEventHandler(eraseTimer_Elapsed);
eraseTimer.Interval = 2500;
string pastName = null;
conn = MySqlConnHelper.GetMySqlConn(Properties.Settings.Default.DbConn);
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
MySqlDataAdapter adapter = null;
adapter = new MySqlDataAdapter();
DataTable dt = null;
conn.Open();
#region 操作员
//adapter = new MySqlDataAdapter();
cmd.CommandText = "select id, name from employee";
adapter.SelectCommand = cmd;
dt = new DataTable();
adapter.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ListItem mt = new ListItem();
mt.ID = dt.Rows[i]["id"].ToString();
mt.Name = string.Format("{0} -- {1}", dt.Rows[i]["name"].ToString(), mt.ID);
comboBoxOperator.Items.Add(mt);
}
comboBoxOperator.DisplayMember = "Name";
comboBoxOperator.ValueMember = "ID";
}
#endregion
#region 原料
cmd.CommandText = "select id, name, level, price from material order by name asc, level asc;";
adapter.SelectCommand = cmd;
dt = new DataTable();
adapter.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
tableMaterial = new ArrayList();
for (int i = 0; i < dt.Rows.Count; i++)
{
TableMaterial tm = new TableMaterial();
tm.id = int.Parse(dt.Rows[i]["id"].ToString());
tm.name = dt.Rows[i]["name"].ToString();
tm.level = dt.Rows[i]["level"].ToString();
tableMaterial.Add(tm);
if (pastName != tm.name)
{
comboBoxMaterialName.Items.Add(tm.name);
}
pastName = tm.name;
}
}
#endregion
#region 产出
//adapter = new MySqlDataAdapter();
cmd.CommandText = "select id, name, level, price from product order by name asc, level asc;";
adapter.SelectCommand = cmd;
dt = new DataTable();
adapter.Fill(dt);
conn.Close();
if (dt.Rows.Count > 0)
{
tableProduct = new ArrayList();
for (int i = 0; i < dt.Rows.Count; i++)
{
TableMaterial tm = new TableMaterial();
tm.id = int.Parse(dt.Rows[i]["id"].ToString());
tm.name = dt.Rows[i]["name"].ToString();
tm.level = dt.Rows[i]["level"].ToString();
tableProduct.Add(tm);
if (pastName != tm.name)
{
comboBoxProductName.Items.Add(tm.name);
}
pastName = tm.name;
}
}
#endregion
}
catch (MySqlException sqlEx)
{
WriteLog(sqlEx.ToString());
NotifyHelper.NotifyUser("无法连接服务器");
}
catch (Exception ex)
{
WriteLog(ex.ToString());
NotifyHelper.NotifyUser("获取数据失败");
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
