/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.Demographic model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Demographic set ");
strSql.Append("PID=@PID,");
strSql.Append("Gender=@Gender,");
strSql.Append("BirthDay=@BirthDay,");
strSql.Append("Age=@Age,");
strSql.Append("Race=@Race,");
strSql.Append("HomeTown=@HomeTown,");
strSql.Append("Phone1=@Phone1,");
strSql.Append("Phone2=@Phone2,");
strSql.Append("Address=@Address,");
strSql.Append("Email=@Email");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@PID", OleDbType.Integer, 4),
new OleDbParameter("@Gender", OleDbType.VarChar, 2),
new OleDbParameter("@BirthDay", OleDbType.Date),
new OleDbParameter("@Age", OleDbType.Integer, 4),
new OleDbParameter("@Race", OleDbType.VarChar, 50),
new OleDbParameter("@HomeTown", OleDbType.VarChar, 50),
new OleDbParameter("@Phone1", OleDbType.VarChar, 50),
new OleDbParameter("@Phone2", OleDbType.VarChar, 50),
new OleDbParameter("@Address", OleDbType.VarChar, 50),
new OleDbParameter("@Email", OleDbType.VarChar, 50),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.Gender;
parameters[2].Value = model.BirthDay;
parameters[3].Value = model.Age;
parameters[4].Value = model.Race;
parameters[5].Value = model.HomeTown;
parameters[6].Value = model.Phone1;
parameters[7].Value = model.Phone2;
parameters[8].Value = model.Address;
parameters[9].Value = model.Email;
parameters[10].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Demographic DataRowToModel(DataRow row)
{
Maticsoft.Model.Demographic model = new Maticsoft.Model.Demographic();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["PID"] != null && row["PID"].ToString() != "")
{
model.PID = int.Parse(row["PID"].ToString());
}
if (row["Gender"] != null)
{
model.Gender = row["Gender"].ToString();
}
if (row["BirthDay"] != null && row["BirthDay"].ToString() != "")
{
model.BirthDay = DateTime.Parse(row["BirthDay"].ToString());
}
if (row["Age"] != null && row["Age"].ToString() != "")
{
model.Age = int.Parse(row["Age"].ToString());
}
if (row["Race"] != null)
{
model.Race = row["Race"].ToString();
}
if (row["HomeTown"] != null)
{
model.HomeTown = row["HomeTown"].ToString();
}
if (row["Phone1"] != null)
{
model.Phone1 = row["Phone1"].ToString();
}
if (row["Phone2"] != null)
{
model.Phone2 = row["Phone2"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["Email"] != null)
{
model.Email = row["Email"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.Demographic model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Demographic(");
strSql.Append("PID,Gender,BirthDay,Age,Race,HomeTown,Phone1,Phone2,Address,Email)");
strSql.Append(" values (");
strSql.Append("@PID,@Gender,@BirthDay,@Age,@Race,@HomeTown,@Phone1,@Phone2,@Address,@Email)");
OleDbParameter[] parameters =
{
new OleDbParameter("@PID", OleDbType.Integer, 4),
new OleDbParameter("@Gender", OleDbType.VarChar, 2),
new OleDbParameter("@BirthDay", OleDbType.Date),
new OleDbParameter("@Age", OleDbType.Integer, 4),
new OleDbParameter("@Race", OleDbType.VarChar, 50),
new OleDbParameter("@HomeTown", OleDbType.VarChar, 50),
new OleDbParameter("@Phone1", OleDbType.VarChar, 50),
new OleDbParameter("@Phone2", OleDbType.VarChar, 50),
new OleDbParameter("@Address", OleDbType.VarChar, 50),
new OleDbParameter("@Email", OleDbType.VarChar, 50)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.Gender;
parameters[2].Value = model.BirthDay;
parameters[3].Value = model.Age;
parameters[4].Value = model.Race;
parameters[5].Value = model.HomeTown;
parameters[6].Value = model.Phone1;
parameters[7].Value = model.Phone2;
parameters[8].Value = model.Address;
parameters[9].Value = model.Email;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Demographic GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,PID,Gender,BirthDay,Age,Race,HomeTown,Phone1,Phone2,Address,Email from Demographic ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.Demographic model = new Maticsoft.Model.Demographic();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
