usingSystem;usingSystem.Collections.Generic;usingMySql.Data.MySqlClient;usingSystem.Data;usingDapper;usingSystem.Linq;namespaceSelectAll

{classInfo

{public int action_id { get; set; }public int parent_id{ get; set; }public string action_code { get; set; }public string relevance { get; set; }

}classProgram

{//数据库连接配置信息;

public static string constr = "server = localhost;User Id = root;password = 123456;Database = ecshop";static void Main(string[] args)

{/*Info One = new Info();

One.parent_id = 2;

One.action_code = "小弱鸡";

One.relevance = "here~";*/

//插入//Insert(SetInfo(3,"小弱鸡三号","hahahh"));//批量插入

/*List Infos = new List();

Infos.Add(SetInfo(4, "小弱鸡四号", "sdfeff"));

Infos.Add(SetInfo(5, "小弱鸡五号", "sdfsdfdf"));

Infos.Add(SetInfo(6, "小弱鸡六号", "sdfe多维ff"));

Insert(Infos);*/

//删除;//Delete(SetInfo(2, "小弱鸡", "here~"));//更新//Update(SetInfo(2, "小弱鸡二号·改", "hahahh"));

List test =Query();string TestInfo = "";for (int i = 0; i < test.Count; i++)

{

TestInfo= test[i].action_id.ToString() + "," + test[i].parent_id + "," + test[i].action_code + "," +test[i].relevance;

Console.WriteLine(TestInfo);

}

Console.ReadLine();

}///

///无条件查询所有;///

///

public static ListQuery()

{using (IDbConnection connection = newMySqlConnection(constr))

{return connection.Query("select * from sdx_admin_action").ToList();

}

}///

///设置Info对象并返回///

///

///

///

///

public static Info SetInfo(int var_parent_id,string var_action_code, stringvar_relevance)

{

Info tmp= newInfo();

tmp.parent_id=var_parent_id;

tmp.action_code=var_action_code;

tmp.relevance=var_relevance;returntmp;

}///

///执行插入,插入单条信息；///

///

public static intInsert(Info varInfo)

{using (IDbConnection connection = newMySqlConnection(constr))

{returnconnection.Execute("insert into sdx_admin_action(parent_id,action_code,relevance) values(@parent_id,@action_code,@relevance)", varInfo);

}

}///

///批量执行插入;///

///

///

public static int Insert(ListvarInfo)

{using (IDbConnection connection = newMySqlConnection(constr))

{returnconnection.Execute("insert into sdx_admin_action(parent_id,action_code,relevance) values(@parent_id,@action_code,@relevance)",varInfo

);

}

}///

///删除指定条件的行信息;///

///

///

public static intDelete(Info info)

{using (IDbConnection connection = newMySqlConnection(constr))

{returnconnection.Execute("delete from sdx_admin_action where action_code=@action_code",info

);

}

}///

///更新///

///

///

public static intUpdate(Info info)

{using (IDbConnection connection = newMySqlConnection(constr))

{returnconnection.Execute("Update sdx_admin_action set action_code=@action_code where parent_id=@parent_id",info

);

}

}

}

}