/// <summary> /// Insert一条数据 /// </summary> /// <param name="bean"></param> /// <returns></returns> bool Insert(BaseEntity bean) { if (bean == null || bean.Count == 0) { throw new Exception("bean 不能为 NULL"); } List <string> _Values = new List <string>(); _Columns.Clear(); Params.Clear(); foreach (var item in bean) { _Columns.Add(DB.GetName(item.Key)); _Values.Add(DB._ParameterPrefix + item.Key); Params.Add(DB.GetParam(item.Key, item.Value.ToString())); } var sql = "INSERT INTO " + GetTableName(bean) + " (" + string.Join(",", _Columns) + ") VALUES (" + string.Join(",", _Values) + "); select ROW_COUNT(),LAST_INSERT_ID();"; var id = -1L; try { if (Db.Insert(sql, Params, ref id)) { if (id > 0) { bean["ID"] = id; } return(true); } return(false); } catch { throw; } finally { if (ShowSQL) { ShowSQLString(sql, Params); } } }