private void button2_Click(object sender, EventArgs e)
{
try
{
List<string[]> result = new List<string[]>();
// string sql = "select * from consume_items_supplier";
// mysql.MySqlRead(ref result);
string sql = @"create table consume_records_image(
RECORD_NO BIGINT AUTO_INCREMENT PRIMARY KEY NOT NULL,
ITEM_NO INTEGER(7) NOT NULL COMMENT '货号',
fileName VARCHAR(1024) NOT NULL COMMENT '图像文件名',
WORK_DATE timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '发货时间')ENGINE=InnoDB
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
COMMENT='发货图片记录'";
sql=@"CREATE DATABASE `consume_db_temp`
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci'";
MySqlSimpleOper mysql = new MySqlSimpleOper("127.0.0.1", "consume_db", "root", "123456", sql);
string[] array=new string[1];
array[0] = sql;
mysql.MySqlExecuteNoQuery(array);
/*
//sql = "update consume_records set qty=4";
//mysql.SqlString = sql;
//mysql.OracleUpdate();
string[] sqls = new string[4];
sqls[0] = @"insert into consume_records (item_no,name,qty,shpe_name,work_date) values (123456,'123',1,'测试',now())";
//sqls[0] = @"insert into consume_records (item_no,name,qty,shpe_name,work_date) values (123456,'123',1,'测试','2015-08-19')";
//sqls[1] = @"insert into consume_records (item_no,name,qty,shpe_name,work_date) values (123456,'123',1,'测试','2015-08-21')";
//sqls[2] = @"update consume_records set qty=5 where qty=1 and work_date='2015-08-19'";
//sqls[3] = @"insert into consume_records (record_no,item_no,name,qty,shpe_name,work_date) values (1,123456,'123',1,'测试','2015-08-19')";
mysql.MySqlExecuteNoQuery(sqls);
sql = @"delete from consume_records where qty=2";
mysql.MySqlDelete(sql);
* */
}
catch (System.Exception ex)
{
if (ex.Message.IndexOf("exists", 0) != -1)
{
MessageBox.Show("表已存在");
}
}
}
public override void OutPut(ref List<string[]> paramers)
{
//取得结果
mySqlSimpleOper = new MySqlSimpleOper(db_name, user, pwd, GetSql());
mySqlSimpleOper.MySqlRead(ref paramers);
}
public override void OutPut(ref List<string[]> parameters)
{
try
{
//取得结果
string[] parameter_out = new string[1];
mySqlSimpleOper = new MySqlSimpleOper(db_name, user, pwd);
mySqlSimpleOper.MySqlInsert(GetSql(), ref parameter_out);
for (int i = 0; i < parameter_out.Length; i++)
{
parameters[i][0] = parameter_out[i];
}
}
catch (System.Exception ex)
{
MessageBox.Show("失败!" + ex.StackTrace + ex.Message);
throw;
}
}
public override void OutPut(ref List<string[]> parameters)
{
try
{
Sql_result_struct sql_struct = new Sql_result_struct2();
string[] parameter_out = new string[sql_struct.GetParamCount()];
for (int i = 0; i < parameter_out.Length; i++)
{
parameter_out[i] = parameters[i][0];
}
//取得结果
mySqlSimpleOper = new MySqlSimpleOper(db_name, user, pwd);
mySqlSimpleOper.MySqlExecuteNoQuery(GetSqls(), ref parameter_out);
for (int i = 0; i < parameter_out.Length; i++)
{
parameters[i][0] = parameter_out[i];
}
}
catch (System.Exception ex)
{
MessageBox.Show("失败!" + ex.StackTrace + ex.Message);
throw;
}
}
//库存
public override void OutPut(ref List<string[]> parameters)
{
//
//Sql_result_struct sql_struct = new Sql_result_struct1();
//parameters[0] = new string[sql_struct.GetParamCount()];
//取得结果
mySqlSimpleOper = new MySqlSimpleOper(db_name, user, pwd, GetSql());
mySqlSimpleOper.MySqlRead(ref parameters);
}
public override void OutPut(ref List<string[]> parameters)
{
try
{
mySqlSimpleOper = new MySqlSimpleOper(db_name, user, pwd, GetSql());
mySqlSimpleOper.MySqlRead(ref parameters);
}
catch (System.Exception ex)
{
MessageBox.Show("失败!" + ex.StackTrace + ex.Message);
throw;
}
}
