/// <summary>
///[PolicyTarget]表查询实体的方法
/// </summary>
public static PolicyTarget getPolicyTargetById(int id)
{
PolicyTarget policytarget = null;
string sql = "select * from PolicyTarget where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", id)
};
DataTable dt = DBHelper.GetDataSet(sql, sp);
if (dt.Rows.Count > 0)
{
policytarget = new PolicyTarget();
foreach (DataRow dr in dt.Rows)
{
policytarget.Id = Convert.ToInt32(dr["id"]);
policytarget.PolicyID = Convert.ToInt32(dr["policyID"]);
policytarget.PropertyName = Convert.ToString(dr["propertyName"]);
policytarget.PropertyValue = Convert.ToString(dr["propertyValue"]);
policytarget.PropertyTypeID = Convert.ToInt32(dr["propertyTypeID"]);
policytarget.PropertyID = Convert.ToInt32(dr["propertyID"]);
policytarget.Datatype = Convert.ToInt32(dr["datatype"]);
}
}
return(policytarget);
}
/// <summary>
///[PolicyTarget]表添加的方法
/// </summary>
public static int addPolicyTarget(PolicyTarget policytarget)
{
string sql = "insert into PolicyTarget([policyID],[propertyName],[propertyValue],[propertyTypeID],[propertyID],[datatype]) values (@policyID,@propertyName,@propertyValue,@propertyTypeID,@propertyID,@datatype)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@policyID", policytarget.PolicyID),
new SqlParameter("@propertyName", policytarget.PropertyName),
new SqlParameter("@propertyValue", policytarget.PropertyValue),
new SqlParameter("@propertyTypeID", policytarget.PropertyTypeID),
new SqlParameter("@propertyID", policytarget.PropertyID),
new SqlParameter("@datatype", policytarget.Datatype)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///[PolicyTarget]表修改的方法
/// </summary>
public static int updatePolicyTargetById(PolicyTarget policytarget)
{
string sql = "update PolicyTarget set policyID=@policyID,propertyName=@propertyName,propertyValue=@propertyValue,propertyTypeID=@propertyTypeID,propertyID=@propertyID,datatype=@datatype where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", policytarget.Id),
new SqlParameter("@policyID", policytarget.PolicyID),
new SqlParameter("@propertyName", policytarget.PropertyName),
new SqlParameter("@propertyValue", policytarget.PropertyValue),
new SqlParameter("@propertyTypeID", policytarget.PropertyTypeID),
new SqlParameter("@propertyID", policytarget.PropertyID),
new SqlParameter("@datatype", policytarget.Datatype)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///根据SQL语句获取实体
/// </summary>
public static PolicyTarget getPolicyTargetBySql(string sql)
{
PolicyTarget policytarget = null;
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
policytarget = new PolicyTarget();
foreach (DataRow dr in dt.Rows)
{
policytarget.Id = Convert.ToInt32(dr["id"]);
policytarget.PolicyID = Convert.ToInt32(dr["policyID"]);
policytarget.PropertyName = Convert.ToString(dr["propertyName"]);
policytarget.PropertyValue = Convert.ToString(dr["propertyValue"]);
policytarget.PropertyTypeID = Convert.ToInt32(dr["propertyTypeID"]);
policytarget.PropertyID = Convert.ToInt32(dr["propertyID"]);
policytarget.Datatype = Convert.ToInt32(dr["datatype"]);
}
}
return(policytarget);
}
public static int addPolicyTarget(PolicyTarget policytarget)
{
return(PolicyTargetService.addPolicyTarget(policytarget));
}
public static int updatePolicyTarget(PolicyTarget policytarget)
{
return(PolicyTargetService.updatePolicyTargetById(policytarget));
}
