/// <summary> /// 函数直接从BLL中的实体类中获取数据并保存,成功返回工程ID值,失败返回-1 /// </summary> /// <returns></returns> public int AddInfo() { //拼凑Sql语句的方法无法存null串,只能存入空字符串 string sqlInsertInfo = "insert into tb_projinfo(pro_name,pro_type,con_province,con_city,unit,con_unit,sup_unit,con_area,con_height,des_unit)" + " values('" + ProjectInfo.Pro_Name + "','" + ProjectInfo.Pro_Type + "','" + ProjectInfo.Con_Province + "','" + ProjectInfo.Con_City + "','" + ProjectInfo.Unit + "','" + ProjectInfo.Sup_Unit + "','" + ProjectInfo.Sup_Unit + "','" + ProjectInfo.Con_Area + "','" + ProjectInfo.Con_Height + "','" + ProjectInfo.Des_Unit + "')"; int isIn = -1; SQLiteConnection conn = null; try { conn = _connBase.connectToDatabase(); //执行插入语句,同时Sqlite自动生成一个ID值 isIn = SQLiteHelper.ExecuteNonQuery(conn, sqlInsertInfo); } catch { } //插入成功则找到ID值 if (isIn == 1) { //查询最大的工程ID string sqlFindLastId = "select max(pro_id) from tb_projinfo"; SQLiteCommand cmd = SQLiteHelper.CreateCommand(conn, sqlFindLastId); DataTable dt = SQLiteHelper.ExecuteDataset(cmd).Tables[0]; return(int.Parse(dt.Rows[dt.Rows.Count - 1][0].ToString())); } else { return(-1);//不成功返回负1 } }