/// <summary> /// 更新一条数据 /// </summary> public bool Update(FriendshipMngSys.Model.DBPerson model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Person set "); strSql.Append("Name=@Name,"); strSql.Append("Age=@Age,"); strSql.Append("IsFemale=@IsFemale,"); strSql.Append("StuNum=@StuNum,"); strSql.Append("Birthplace=@Birthplace,"); strSql.Append("Tel=@Tel,"); strSql.Append("Hourlypay=@Hourlypay,"); strSql.Append("HadDiscount=@HadDiscount,"); strSql.Append("Score=@Score"); strSql.Append(" where ID=@ID "); SQLiteParameter[] parameters = { new SQLiteParameter("@Name", DbType.String), new SQLiteParameter("@Age", DbType.String), new SQLiteParameter("@IsFemale", DbType.Boolean), new SQLiteParameter("@StuNum", DbType.Int32, 4), new SQLiteParameter("@Birthplace", DbType.String), new SQLiteParameter("@Tel", DbType.String), new SQLiteParameter("@Hourlypay", DbType.Int32, 4), new SQLiteParameter("@HadDiscount", DbType.Boolean), new SQLiteParameter("@Score", DbType.Int32, 4), new SQLiteParameter("@ID", DbType.String, 2147483647) }; parameters[0].Value = model.Name; parameters[1].Value = model.Age; parameters[2].Value = model.IsFemale; parameters[3].Value = model.StuNum; parameters[4].Value = model.Birthplace; parameters[5].Value = model.Tel; parameters[6].Value = model.Hourlypay; parameters[7].Value = model.HadDiscount; parameters[8].Value = model.Score; parameters[9].Value = model.ID; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FriendshipMngSys.Model.DBPerson model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Person("); strSql.Append("ID,Name,Age,IsFemale,StuNum,Birthplace,Tel,Hourlypay,HadDiscount,Score)"); strSql.Append(" values ("); strSql.Append("@ID,@Name,@Age,@IsFemale,@StuNum,@Birthplace,@Tel,@Hourlypay,@HadDiscount,@Score)"); SQLiteParameter[] parameters = { new SQLiteParameter("@ID", DbType.String, 2147483647), new SQLiteParameter("@Name", DbType.String), new SQLiteParameter("@Age", DbType.String), new SQLiteParameter("@IsFemale", DbType.Boolean), new SQLiteParameter("@StuNum", DbType.Int32, 4), new SQLiteParameter("@Birthplace", DbType.String), new SQLiteParameter("@Tel", DbType.String), new SQLiteParameter("@Hourlypay", DbType.Int32, 4), new SQLiteParameter("@HadDiscount", DbType.Boolean), new SQLiteParameter("@Score", DbType.Int32, 4) }; parameters[0].Value = model.ID; parameters[1].Value = model.Name; parameters[2].Value = model.Age; parameters[3].Value = model.IsFemale; parameters[4].Value = model.StuNum; parameters[5].Value = model.Birthplace; parameters[6].Value = model.Tel; parameters[7].Value = model.Hourlypay; parameters[8].Value = model.HadDiscount; parameters[9].Value = model.Score; int rows = DbHelperSQLite.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FriendshipMngSys.Model.DBPerson GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,Name,Age,IsFemale,StuNum,Birthplace,Tel,Hourlypay,HadDiscount,Score from Person "); strSql.Append(" where ID=@ID "); SQLiteParameter[] parameters = { new SQLiteParameter("@ID", DbType.String, 2147483647) }; parameters[0].Value = ID; FriendshipMngSys.Model.DBPerson model = new FriendshipMngSys.Model.DBPerson(); DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FriendshipMngSys.Model.DBPerson DataRowToModel(DataRow row) { FriendshipMngSys.Model.DBPerson model = new FriendshipMngSys.Model.DBPerson(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["Age"] != null) { model.Age = row["Age"].ToString(); } if (row["IsFemale"] != null && row["IsFemale"].ToString() != "") { if ((row["IsFemale"].ToString() == "1") || (row["IsFemale"].ToString().ToLower() == "true")) { model.IsFemale = true; } else { model.IsFemale = false; } } if (row["StuNum"] != null && row["StuNum"].ToString() != "") { model.StuNum = int.Parse(row["StuNum"].ToString()); } if (row["Birthplace"] != null) { model.Birthplace = row["Birthplace"].ToString(); } if (row["Tel"] != null) { model.Tel = row["Tel"].ToString(); } if (row["Hourlypay"] != null && row["Hourlypay"].ToString() != "") { model.Hourlypay = int.Parse(row["Hourlypay"].ToString()); } if (row["HadDiscount"] != null && row["HadDiscount"].ToString() != "") { if ((row["HadDiscount"].ToString() == "1") || (row["HadDiscount"].ToString().ToLower() == "true")) { model.HadDiscount = true; } else { model.HadDiscount = false; } } if (row["Score"] != null && row["Score"].ToString() != "") { model.Score = int.Parse(row["Score"].ToString()); } } return(model); }