public static void 供应商_日志操作(string 用户名, string 内容)
{
string tablename = CreatlogTable_供应商();
string log_sql = "insert `" + tablename + "`(username,time,text)values(?username,?time,?text)";
MySqlParameter[] log_param = new MySqlParameter[]
{
new MySqlParameter("?username", 用户名),
new MySqlParameter("?time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")),
new MySqlParameter("?text", 内容)
};
MysqlHelper.ExecuteNonQuery(log_sql, ref Program.myPool_supplier, log_param);
}
public static string CreatlogTable_供应商()
{
string sdt = DateTime.Now.ToString("yyyy");
string tablename = "log_" + sdt;
string s_sql = "SELECT table_name FROM information_schema.TABLES WHERE table_name ='" + tablename + "' and `table_schema`='supplier' ";
object ob = MysqlHelper.ExecuteScalar(s_sql, ref Program.myPool_supplier);
if (ob == null)
{
string sql = "CREATE TABLE IF NOT EXISTS `" + tablename + "` LIKE `log_mb`";
MysqlHelper.ExecuteNonQuery(sql, ref Program.myPool_supplier);
}
return(tablename);
}