public Bill_DataDic GetDicByTypeCode(string typecode, string code) { string sql = " select * from bill_DataDic where dicType='" + typecode + "' and diccode='" + code + "'"; DataTable dt = DataHelper.GetDataTable(sql, null, false); if (dt.Rows.Count > 0) { Bill_DataDic dic = new Bill_DataDic(); dic.Cjys = Convert.ToString(dt.Rows[0]["Cjys"]); dic.Cys = Convert.ToString(dt.Rows[0]["Cys"]); dic.DicCode = Convert.ToString(dt.Rows[0]["DicCode"]); dic.DicName = Convert.ToString(dt.Rows[0]["DicName"]); dic.DicType = Convert.ToString(dt.Rows[0]["DicType"]); dic.Cdj = Convert.ToString(dt.Rows[0]["Cdj"]); return(dic); } else { return(null); } }
public IList <Bill_DataDic> GetDicByType(string typecode) { string sql = " select * from bill_DataDic where dicType=@typeCode "; SqlParameter[] sps = { new SqlParameter("@typeCode", typecode) }; DataTable dt = DataHelper.GetDataTable(sql, sps, false); IList <Bill_DataDic> list = new List <Bill_DataDic>(); foreach (DataRow dr in dt.Rows) { Bill_DataDic dic = new Bill_DataDic(); dic.Cjys = Convert.ToString(dr["Cjys"]); dic.Cys = Convert.ToString(dr["Cys"]); dic.DicCode = Convert.ToString(dr["DicCode"]); dic.DicName = Convert.ToString(dr["DicName"]); dic.DicType = Convert.ToString(dr["DicType"]); dic.Cdj = Convert.ToString(dt.Rows[0]["Cdj"]); list.Add(dic); } return(list); }