/// <summary>
/// 获得数据List
/// </summary>
public PlanWriteCardSectionList GetDataList(PlanWriteCardSectionQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
if (QueryCondition.page == 0)
{
strSql.Append("select * ");
strSql.Append(" FROM Tab_Plan_WriteCardSection where 1=1 " + strSqlOption.ToString());
}
else
{
strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from Tab_Plan_WriteCardSection where 1 = 1 " +
strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows +
" nID from Tab_Plan_WriteCardSection where 1=1 " + strSqlOption.ToString() + " order by nID desc) order by nID desc");
}
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
PlanWriteCardSectionList list = new PlanWriteCardSectionList();
foreach (DataRow dr in dt.Rows)
{
PlanWriteCardSection _PlanWriteCardSection = new PlanWriteCardSection();
DataRowToModel(_PlanWriteCardSection, dr);
list.Add(_PlanWriteCardSection);
}
return(list);
}
/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DataRowToModel(PlanWriteCardSection model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["niD"]);
model.strTrainPlanGUID = ObjectConvertClass.static_ext_string(dr["strTrainPlanGUID"]);
model.strSectionID = ObjectConvertClass.static_ext_string(dr["strSectionID"]);
model.strSectionName = ObjectConvertClass.static_ext_string(dr["strSectionName"]);
model.strJWDNumber = ObjectConvertClass.static_ext_string(dr["strJWDNumber"]);
}
/// <summary>
/// 检查数据是否存在
/// </summary>
public bool Exists(PlanWriteCardSection _PlanWriteCardSection)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from Tab_PlanWriteCardSection where niD=@niD");
SqlParameter[] parameters =
{
new SqlParameter("niD", _PlanWriteCardSection.nID)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), parameters)) > 0);
}
/// <summary>
/// 添加数据
/// </summary>
public int Add(PlanWriteCardSection model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Tab_Plan_WriteCardSection");
strSql.Append("(strTrainPlanGUID,strSectionID,strSectionName,strJWDNumber)");
strSql.Append("values(@strTrainPlanGUID,@strSectionID,@strSectionName,@strJWDNumber)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@strTrainPlanGUID", model.strTrainPlanGUID),
new SqlParameter("@strSectionID", model.strSectionID),
new SqlParameter("@strSectionName", model.strSectionName),
new SqlParameter("@strJWDNumber", model.strJWDNumber)
};
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), parameters)));
}
/// <summary>
/// 获得一个实体对象
/// </summary>
public PlanWriteCardSection GetModel(PlanWriteCardSectionQueryCondition QueryCondition)
{
SqlParameter[] sqlParams;
StringBuilder strSqlOption = new StringBuilder();
QueryCondition.OutPut(out strSqlOption, out sqlParams);
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * ");
strSql.Append(" FROM Tab_Plan_WriteCardSection where 1=1 " + strSqlOption.ToString());
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
PlanWriteCardSection _PlanWriteCardSection = null;
if (dt.Rows.Count > 0)
{
_PlanWriteCardSection = new PlanWriteCardSection();
DataRowToModel(_PlanWriteCardSection, dt.Rows[0]);
}
return(_PlanWriteCardSection);
}
/// <summary>
/// 更新数据
/// </summary>
public bool Update(PlanWriteCardSection model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update Tab_Plan_WriteCardSection set ");
strSql.Append(" strTrainPlanGUID = @strTrainPlanGUID, ");
strSql.Append(" strSectionID = @strSectionID, ");
strSql.Append(" strSectionName = @strSectionName, ");
strSql.Append(" strJWDNumber = @strJWDNumber ");
strSql.Append(" where niD = @niD ");
SqlParameter[] parameters =
{
new SqlParameter("@strTrainPlanGUID", model.strTrainPlanGUID),
new SqlParameter("@strSectionID", model.strSectionID),
new SqlParameter("@strSectionName", model.strSectionName),
new SqlParameter("@strJWDNumber", model.strJWDNumber)
};
return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0);
}