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