public static void Send_MSG_By_QA_DB(string[][] msgs) { string _dbConString = ConfigurationManager.ConnectionStrings["TD_OA"].ConnectionString; using (MySQLConnection conn = new MySQLConnection(_dbConString)) { conn.Open(); MySQLCommand commn = new MySQLCommand("set names gb2312; ", conn); commn.ExecuteNonQuery(); commn.Dispose(); for (int _s = 0, _sCnt = msgs.Length; _s < _sCnt; _s++) { if (msgs[_s].Length < 2) { continue; } commn = new MySQLCommand(OA_MSG_SEND_SQL, conn); string[] _values = new string[] { "yutao", msgs[_s][0], msgs[_s][1], System.DateTime.Now.ToLocalTime().ToString() }; for (int _i = 0, _iCnt = OA_MSG_PARAMS.Length; _i < _iCnt; _i++) { DbParameter dbParameter = commn.CreateParameter(); dbParameter.DbType = DbType.String; dbParameter.ParameterName = string.Format("@{0}", OA_MSG_PARAMS[_i]); dbParameter.Value = _values[_i]; dbParameter.Direction = ParameterDirection.Input; commn.Parameters.Add(dbParameter); } commn.ExecuteNonQuery(); } conn.Close(); } }