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