/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HR_Test.Model.Standard model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Standard set ");
strSql.Append("standardNo=@standardNo,");
strSql.Append("standardName=@standardName,");
strSql.Append("testType=@testType,");
strSql.Append("resultTableName=@resultTableName,");
strSql.Append("selTableName=@selTableName,");
strSql.Append("methodTableName=@methodTableName,");
strSql.Append("sign=@sign");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@standardNo", OleDbType.VarChar, 255),
new OleDbParameter("@standardName", OleDbType.VarChar, 255),
new OleDbParameter("@testType", OleDbType.VarChar, 255),
new OleDbParameter("@resultTableName", OleDbType.VarChar, 255),
new OleDbParameter("@selTableName", OleDbType.VarChar, 255),
new OleDbParameter("@methodTableName", OleDbType.VarChar, 255),
new OleDbParameter("@sign", OleDbType.VarChar, 0),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.standardNo;
parameters[1].Value = model.standardName;
parameters[2].Value = model.testType;
parameters[3].Value = model.resultTableName;
parameters[4].Value = model.selTableName;
parameters[5].Value = model.methodTableName;
parameters[6].Value = model.sign;
parameters[7].Value = model.ID;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HR_Test.Model.Standard DataRowToModel(DataRow row)
{
HR_Test.Model.Standard model = new HR_Test.Model.Standard();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["standardNo"] != null)
{
model.standardNo = row["standardNo"].ToString();
}
if (row["standardName"] != null)
{
model.standardName = row["standardName"].ToString();
}
if (row["testType"] != null)
{
model.testType = row["testType"].ToString();
}
if (row["resultTableName"] != null)
{
model.resultTableName = row["resultTableName"].ToString();
}
if (row["selTableName"] != null)
{
model.selTableName = row["selTableName"].ToString();
}
if (row["methodTableName"] != null)
{
model.methodTableName = row["methodTableName"].ToString();
}
if (row["sign"] != null)
{
model.sign = row["sign"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HR_Test.Model.Standard model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_Standard(");
strSql.Append("standardNo,standardName,testType,resultTableName,selTableName,methodTableName,sign)");
strSql.Append(" values (");
strSql.Append("@standardNo,@standardName,@testType,@resultTableName,@selTableName,@methodTableName,@sign)");
OleDbParameter[] parameters =
{
new OleDbParameter("@standardNo", OleDbType.VarChar, 255),
new OleDbParameter("@standardName", OleDbType.VarChar, 255),
new OleDbParameter("@testType", OleDbType.VarChar, 255),
new OleDbParameter("@resultTableName", OleDbType.VarChar, 255),
new OleDbParameter("@selTableName", OleDbType.VarChar, 255),
new OleDbParameter("@methodTableName", OleDbType.VarChar, 255),
new OleDbParameter("@sign", OleDbType.VarChar, 0)
};
parameters[0].Value = model.standardNo;
parameters[1].Value = model.standardName;
parameters[2].Value = model.testType;
parameters[3].Value = model.resultTableName;
parameters[4].Value = model.selTableName;
parameters[5].Value = model.methodTableName;
parameters[6].Value = model.sign;
int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HR_Test.Model.Standard GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,standardNo,standardName,testType,resultTableName,selTableName,methodTableName,sign from tb_Standard ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
HR_Test.Model.Standard model = new HR_Test.Model.Standard();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
