/// <summary>
/// 读取DataRow数据到Model中
/// <summary>
private void DataRowToModel(Dic_UnitInfo model, DataRow dr)
{
model.nID = ObjectConvertClass.static_ext_int(dr["nID"]);
model.strID = ObjectConvertClass.static_ext_string(dr["strID"]);
model.UnitNumber = ObjectConvertClass.static_ext_string(dr["UnitNumber"]);
model.UnitName = ObjectConvertClass.static_ext_string(dr["UnitName"]);
}
/// <summary>
/// 获得数据List
/// <summary>
public List <Dic_UnitInfo> GetDataList(UnitInfoQueryCondition 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_Dic_UnitInfo where 1=1 " + strSqlOption.ToString());
}
else
{
strSql.Append(@"select top " + QueryCondition.rows.ToString() + " * from TAB_Dic_UnitInfo where 1 = 1 " +
strSqlOption.ToString() + " and nID not in ( select top " + (QueryCondition.page - 1) * QueryCondition.rows +
" nID from TAB_Dic_UnitInfo 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];
List <Dic_UnitInfo> list = new List <Dic_UnitInfo>();
foreach (DataRow dr in dt.Rows)
{
Dic_UnitInfo _UnitInfo = new Dic_UnitInfo();
DataRowToModel(_UnitInfo, dr);
list.Add(_UnitInfo);
}
return(list);
}
/// <summary>
/// 添加数据
/// <summary>
public bool Add(Dic_UnitInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TAB_Dic_UnitInfo");
strSql.Append("(UnitNumber,UnitName)");
strSql.Append("values(@UnitNumber,@UnitName)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UnitNumber", model.UnitNumber),
new SqlParameter("@UnitName", model.UnitName)
};
return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 检查数据是否存在
/// <summary>
public bool Exists(Dic_UnitInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from TAB_Dic_UnitInfo where UnitNumber=@UnitNumber");
if (model.nID != 0)
{
strSql.Append(" and nID<>@nID");
}
SqlParameter[] parameters =
{
new SqlParameter("nID", model.nID),
new SqlParameter("UnitNumber", model.UnitNumber)
};
return(ObjectConvertClass.static_ext_int(SqlHelper.ExecuteScalar(ConnectionString, CommandType.Text, strSql.ToString(), parameters)) > 0);
}
/// <summary>
/// 更新数据
/// <summary>
public bool Update(Dic_UnitInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update TAB_Dic_UnitInfo set ");
strSql.Append(" UnitNumber = @UnitNumber, ");
strSql.Append(" UnitName = @UnitName ");
strSql.Append(" where nID = @nID ");
SqlParameter[] parameters =
{
new SqlParameter("@nID", model.nID),
new SqlParameter("@UnitNumber", model.UnitNumber),
new SqlParameter("@UnitName", model.UnitName)
};
return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 获得一个实体对象
/// <summary>
public Dic_UnitInfo GetModel(UnitInfoQueryCondition 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_Dic_UnitInfo where 1=1 " + strSqlOption.ToString());
DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
Dic_UnitInfo _UnitInfo = null;
if (dt.Rows.Count > 0)
{
_UnitInfo = new Dic_UnitInfo();
DataRowToModel(_UnitInfo, dt.Rows[0]);
}
return(_UnitInfo);
}
