public List <RefCodeData> GetFullRefCodeData(string _refCodeName)
{
List <RefCodeData> _ret = new List <RefCodeData>();
string[] _fnames = _refCodeName.Split('.');
string _sql = string.Format("select DM,MC,PYZT,PX,SFYX,BZ,FATHERCODE,SFXS,SFLR,SFYJD from JSODS.{0} order by PX,DM", _fnames[_fnames.Length - 1]);
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringProfile, CommandType.Text, _sql);
while (dr.Read())
{
RefCodeData _rdata = new RefCodeData(
dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? 0 : Convert.ToInt32(dr.GetDouble(3)),
dr.IsDBNull(4) ? true : (dr.GetString(4) == "1"),
dr.IsDBNull(5) ? "" : dr.GetString(5),
dr.IsDBNull(6) ? "" : dr.GetString(6),
dr.IsDBNull(7) ? true : (dr.GetString(7) == "1"),
dr.IsDBNull(8) ? true : (dr.GetString(8) == "1"),
dr.IsDBNull(9) ? true : (dr.GetString(9) == "1"));
_ret.Add(_rdata);
}
dr.Close();
return(_ret);
}
public List <RefCodeData> GetChildRefCodeData(string _refCodeName, string _fatherCode)
{
List <RefCodeData> _ret = new List <RefCodeData>();
string[] _fnames = _refCodeName.Split('.');
string _sql = string.Format("select DM,MC,PYZT,PX,SFYX,BZ,FATHERCODE,SFXS,SFLR,SFYJD from JSODS.{0} ", _fnames[_fnames.Length - 1]);
if (_fatherCode == string.Empty)
{
_sql += "where FATHERCODE IS NULL order by PX,DM";
}
else
{
_sql += " where FATHERCODE = :FCODE order by PX,DM";
}
SqlParameter[] _param = new SqlParameter[] {
new SqlParameter(":FCODE", SqlDbType.NVarChar, 50)
};
_param[0].Value = _fatherCode;
using (SqlConnection cn = SqlHelper.OpenConnection())
{
using (SqlDataReader dr = SqlHelper.ExecuteReader(cn, CommandType.Text, _sql, _param))
{
while (dr.Read())
{
RefCodeData _rdata = new RefCodeData(
dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? 0 : Convert.ToInt32(dr.GetDouble(3)),
dr.IsDBNull(4) ? true : (dr.GetString(4) == "1"),
dr.IsDBNull(5) ? "" : dr.GetString(5),
dr.IsDBNull(6) ? "" : dr.GetString(6),
dr.IsDBNull(7) ? true : (dr.GetString(7) == "1"),
dr.IsDBNull(8) ? true : (dr.GetString(8) == "1"),
dr.IsDBNull(9) ? true : (dr.GetString(9) == "1"));
_ret.Add(_rdata);
}
dr.Close();
}
return(_ret);
}
}
public RefCodeData GetRefCodeByCode(string _refCodeName, string _value)
{
RefCodeData _ret = null;
string[] _fnames = _refCodeName.Split('.');
string _sql = string.Format("select DM,MC,PYZT,PX,SFYX,BZ,FATHERCODE,SFXS,SFLR,SFYJD from JSODS.{0} ", _fnames[_fnames.Length - 1]);
_sql += " where DM = :CODE order by PX,DM";
SqlParameter[] _param = new SqlParameter[] {
new SqlParameter(":CODE", SqlDbType.NVarChar, 50)
};
_param[0].Value = _value;
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringProfile, CommandType.Text, _sql, _param);
while (dr.Read())
{
_ret = new RefCodeData(
dr.GetString(0),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? 0 : Convert.ToInt32(dr.GetDouble(3)),
dr.IsDBNull(4) ? true : (dr.GetString(4) == "1"),
dr.IsDBNull(5) ? "" : dr.GetString(5),
dr.IsDBNull(6) ? "" : dr.GetString(6),
dr.IsDBNull(7) ? true : (dr.GetString(7) == "1"),
dr.IsDBNull(8) ? true : (dr.GetString(8) == "1"),
dr.IsDBNull(9) ? true : (dr.GetString(9) == "1"));
}
dr.Close();
return(_ret);
}
