/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.SportLife model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SportLife set ");
strSql.Append("PID=@PID,");
strSql.Append("Period=@Period,");
strSql.Append("SixMinuteTest=@SixMinuteTest,");
strSql.Append("SixMinuteTestDate=@SixMinuteTestDate,");
strSql.Append("StGeorgeTest=@StGeorgeTest,");
strSql.Append("StGeorgeTestDate=@StGeorgeTestDate,");
strSql.Append("StGeorgeTestFile=@StGeorgeTestFile,");
strSql.Append("CATTest=@CATTest,");
strSql.Append("CATTestDate=@CATTestDate,");
strSql.Append("MMRCTest=@MMRCTest,");
strSql.Append("MMRCTestDate=@MMRCTestDate");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@PID", OleDbType.Integer, 4),
new OleDbParameter("@Period", OleDbType.Integer, 4),
new OleDbParameter("@SixMinuteTest", OleDbType.Integer, 4),
new OleDbParameter("@SixMinuteTestDate", OleDbType.Date),
new OleDbParameter("@StGeorgeTest", OleDbType.Integer, 4),
new OleDbParameter("@StGeorgeTestDate", OleDbType.Date),
new OleDbParameter("@StGeorgeTestFile", OleDbType.VarChar, 255),
new OleDbParameter("@CATTest", OleDbType.Integer, 4),
new OleDbParameter("@CATTestDate", OleDbType.Date),
new OleDbParameter("@MMRCTest", OleDbType.Integer, 4),
new OleDbParameter("@MMRCTestDate", OleDbType.Date),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.Period;
parameters[2].Value = model.SixMinuteTest;
parameters[3].Value = model.SixMinuteTestDate;
parameters[4].Value = model.StGeorgeTest;
parameters[5].Value = model.StGeorgeTestDate;
parameters[6].Value = model.StGeorgeTestFile;
parameters[7].Value = model.CATTest;
parameters[8].Value = model.CATTestDate;
parameters[9].Value = model.MMRCTest;
parameters[10].Value = model.MMRCTestDate;
parameters[11].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SportLife DataRowToModel(DataRow row)
{
Maticsoft.Model.SportLife model = new Maticsoft.Model.SportLife();
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["Period"] != null && row["Period"].ToString() != "")
{
model.Period = int.Parse(row["Period"].ToString());
}
if (row["SixMinuteTest"] != null && row["SixMinuteTest"].ToString() != "")
{
model.SixMinuteTest = int.Parse(row["SixMinuteTest"].ToString());
}
if (row["SixMinuteTestDate"] != null && row["SixMinuteTestDate"].ToString() != "")
{
model.SixMinuteTestDate = DateTime.Parse(row["SixMinuteTestDate"].ToString());
}
if (row["StGeorgeTest"] != null && row["StGeorgeTest"].ToString() != "")
{
model.StGeorgeTest = int.Parse(row["StGeorgeTest"].ToString());
}
if (row["StGeorgeTestDate"] != null && row["StGeorgeTestDate"].ToString() != "")
{
model.StGeorgeTestDate = DateTime.Parse(row["StGeorgeTestDate"].ToString());
}
if (row["StGeorgeTestFile"] != null)
{
model.StGeorgeTestFile = row["StGeorgeTestFile"].ToString();
}
if (row["CATTest"] != null && row["CATTest"].ToString() != "")
{
model.CATTest = int.Parse(row["CATTest"].ToString());
}
if (row["CATTestDate"] != null && row["CATTestDate"].ToString() != "")
{
model.CATTestDate = DateTime.Parse(row["CATTestDate"].ToString());
}
if (row["MMRCTest"] != null && row["MMRCTest"].ToString() != "")
{
model.MMRCTest = int.Parse(row["MMRCTest"].ToString());
}
if (row["MMRCTestDate"] != null && row["MMRCTestDate"].ToString() != "")
{
model.MMRCTestDate = DateTime.Parse(row["MMRCTestDate"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.SportLife model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SportLife(");
strSql.Append("PID,Period,SixMinuteTest,SixMinuteTestDate,StGeorgeTest,StGeorgeTestDate,StGeorgeTestFile,CATTest,CATTestDate,MMRCTest,MMRCTestDate)");
strSql.Append(" values (");
strSql.Append("@PID,@Period,@SixMinuteTest,@SixMinuteTestDate,@StGeorgeTest,@StGeorgeTestDate,@StGeorgeTestFile,@CATTest,@CATTestDate,@MMRCTest,@MMRCTestDate)");
OleDbParameter[] parameters =
{
new OleDbParameter("@PID", OleDbType.Integer, 4),
new OleDbParameter("@Period", OleDbType.Integer, 4),
new OleDbParameter("@SixMinuteTest", OleDbType.Integer, 4),
new OleDbParameter("@SixMinuteTestDate", OleDbType.Date),
new OleDbParameter("@StGeorgeTest", OleDbType.Integer, 4),
new OleDbParameter("@StGeorgeTestDate", OleDbType.Date),
new OleDbParameter("@StGeorgeTestFile", OleDbType.VarChar, 255),
new OleDbParameter("@CATTest", OleDbType.Integer, 4),
new OleDbParameter("@CATTestDate", OleDbType.Date),
new OleDbParameter("@MMRCTest", OleDbType.Integer, 4),
new OleDbParameter("@MMRCTestDate", OleDbType.Date)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.Period;
parameters[2].Value = model.SixMinuteTest;
parameters[3].Value = model.SixMinuteTestDate;
parameters[4].Value = model.StGeorgeTest;
parameters[5].Value = model.StGeorgeTestDate;
parameters[6].Value = model.StGeorgeTestFile;
parameters[7].Value = model.CATTest;
parameters[8].Value = model.CATTestDate;
parameters[9].Value = model.MMRCTest;
parameters[10].Value = model.MMRCTestDate;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.SportLife GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,PID,Period,SixMinuteTest,SixMinuteTestDate,StGeorgeTest,StGeorgeTestDate,StGeorgeTestFile,CATTest,CATTestDate,MMRCTest,MMRCTestDate from SportLife ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
Maticsoft.Model.SportLife model = new Maticsoft.Model.SportLife();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
