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;
}
}
//0 货号 1 类型 2 品名
public override void OutPut(ref List <string[]> paramers)
{
//
//Sql_result_struct sql_struct = new Sql_result_struct0();
//paramers[0] = new string[sql_struct.GetParamCount()];
//取得结果
mySqlSimpleOper = new MySqlSimpleOper(db_name, user, pwd, GetSql());
mySqlSimpleOper.MySqlRead(ref paramers);
}
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;
}
}
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 Form1()
{
InitializeComponent();
initRecptComponent();
initCameraComponent();
initMainPanelQueryComponent();
showRecptComponent();
issue_name_itemNo1.Event_ItemNo += new issue_name_itemNo.Del_ItemNo(issue1_Event_ItemNo);
recpt_name_itemNo1.Event_recpt_ItemNo += new recpt_name_itemNo.Del_recpt_ItemNo(recpt_Event_ItemNo);
event_control_close += new control_close(camerDriver1.camerDriver_Closed);
event_control_show += new control_show(camerDriver1.camerDriver_Open);
MySqlSimpleOper.SetServerIp("127.0.0.1");
//
preMySql();
}
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[]> paramers)
{
//取得结果
mySqlSimpleOper = new MySqlSimpleOper(db_name, user, pwd, GetSql());
mySqlSimpleOper.MySqlRead(ref paramers);
}
