/// <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);
}
