/// <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)); }