/// <summary>
/// 得到一个对象实体
/// </summary>
public HR_Test.Model.StandardResultItemInfo DataRowToModel(DataRow row)
{
HR_Test.Model.StandardResultItemInfo model = new HR_Test.Model.StandardResultItemInfo();
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["testType"] != null)
{
model.testType = row["testType"].ToString();
}
if (row["paramName"] != null)
{
model.paramName = row["paramName"].ToString();
}
if (row["unit"] != null)
{
model.unit = row["unit"].ToString();
}
if (row["paramDiscrible"] != null)
{
model.paramDiscrible = row["paramDiscrible"].ToString();
}
if (row["isCheck"] != null && row["isCheck"].ToString() != "")
{
if ((row["isCheck"].ToString() == "1") || (row["isCheck"].ToString().ToLower() == "true"))
{
model.isCheck = true;
}
else
{
model.isCheck = false;
}
}
if (row["sign"] != null)
{
model.sign = row["sign"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HR_Test.Model.StandardResultItemInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_StandardResultItemInfo set ");
strSql.Append("standardNo=@standardNo,");
strSql.Append("testType=@testType,");
strSql.Append("paramName=@paramName,");
strSql.Append("unit=@unit,");
strSql.Append("paramDiscrible=@paramDiscrible,");
strSql.Append("isCheck=@isCheck,");
strSql.Append("sign=@sign");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@standardNo", OleDbType.VarChar, 255),
new OleDbParameter("@testType", OleDbType.VarChar, 255),
new OleDbParameter("@paramName", OleDbType.VarChar, 255),
new OleDbParameter("@unit", OleDbType.VarChar, 0),
new OleDbParameter("@paramDiscrible", OleDbType.VarChar, 255),
new OleDbParameter("@isCheck", OleDbType.Boolean, 1),
new OleDbParameter("@sign", OleDbType.VarChar, 0),
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = model.standardNo;
parameters[1].Value = model.testType;
parameters[2].Value = model.paramName;
parameters[3].Value = model.unit;
parameters[4].Value = model.paramDiscrible;
parameters[5].Value = model.isCheck;
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 bool Add(HR_Test.Model.StandardResultItemInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_StandardResultItemInfo(");
strSql.Append("standardNo,testType,paramName,unit,paramDiscrible,isCheck,sign)");
strSql.Append(" values (");
strSql.Append("@standardNo,@testType,@paramName,@unit,@paramDiscrible,@isCheck,@sign)");
OleDbParameter[] parameters =
{
new OleDbParameter("@standardNo", OleDbType.VarChar, 255),
new OleDbParameter("@testType", OleDbType.VarChar, 255),
new OleDbParameter("@paramName", OleDbType.VarChar, 255),
new OleDbParameter("@unit", OleDbType.VarChar, 0),
new OleDbParameter("@paramDiscrible", OleDbType.VarChar, 255),
new OleDbParameter("@isCheck", OleDbType.Boolean, 1),
new OleDbParameter("@sign", OleDbType.VarChar, 0)
};
parameters[0].Value = model.standardNo;
parameters[1].Value = model.testType;
parameters[2].Value = model.paramName;
parameters[3].Value = model.unit;
parameters[4].Value = model.paramDiscrible;
parameters[5].Value = model.isCheck;
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.StandardResultItemInfo GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,standardNo,testType,paramName,unit,paramDiscrible,isCheck,sign from tb_StandardResultItemInfo ");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters =
{
new OleDbParameter("@ID", OleDbType.Integer, 4)
};
parameters[0].Value = ID;
HR_Test.Model.StandardResultItemInfo model = new HR_Test.Model.StandardResultItemInfo();
DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
