public string GetXmCodeName(string xmCode)
{
Bill_Xm xm = xmDal.GetXmByCode(xmCode);
if (xm == null)
{
return(null);
}
else
{
return("[" + xm.XmCode + "]" + xm.XmName);
}
}
/// <summary>
/// 根据部门编号查找项目
/// </summary>
/// <param name="deptCode">部门编号</param>
/// <returns></returns>
public IList <Bill_Xm> GetXmByDep(string deptCode)
{
string sql = " select * from bill_xm where (xmdept=@xmdept) or (xmdept=(select top 1 deptcode from dbo.bill_departments where isnull(sjdeptcode,'')='' and deptstatus='1')) ";
SqlParameter[] sps = { new SqlParameter("@xmdept", deptCode) };
DataTable dt = DataHelper.GetDataTable(sql, sps, false);
IList <Bill_Xm> list = new List <Bill_Xm>();
foreach (DataRow dr in dt.Rows)
{
Bill_Xm dic = new Bill_Xm();
dic.SjXm = Convert.ToString(dr["SjXm"]);
dic.XmCode = Convert.ToString(dr["XmCode"]);
dic.XmDept = Convert.ToString(dr["XmDept"]);
dic.XmName = Convert.ToString(dr["XmName"]);
dic.XmStatus = Convert.ToString(dr["XmStatus"]);
list.Add(dic);
}
return(list);
}
/// <summary>
/// 根据部门编号，得到所有末级项目
/// </summary>
/// <param name="deptCode"></param>
/// <returns></returns>
public IList <Bill_Xm> GetmjXmByDep(string deptCode)
{
string sql = " select * from bill_xm where xmdept=@xmdept and xmcode not in (select distinct sjxm from bill_xm where xmdept=@xmdept ) ";
SqlParameter[] sps = { new SqlParameter("@xmdept", deptCode) };
DataTable dt = DataHelper.GetDataTable(sql, sps, false);
IList <Bill_Xm> list = new List <Bill_Xm>();
foreach (DataRow dr in dt.Rows)
{
Bill_Xm dic = new Bill_Xm();
dic.SjXm = Convert.ToString(dr["SjXm"]);
dic.XmCode = Convert.ToString(dr["XmCode"]);
dic.XmDept = Convert.ToString(dr["XmDept"]);
dic.XmName = Convert.ToString(dr["XmName"]);
dic.XmStatus = Convert.ToString(dr["XmStatus"]);
list.Add(dic);
}
return(list);
}
/// <summary>
/// 根据项目编号得到项目信息
/// </summary>
/// <param name="xmCode"></param>
/// <returns></returns>
public Bill_Xm GetXmByCode(string xmCode)
{
string sql = " select * from bill_xm where xmCode=@xmCode ";
SqlParameter[] sps = { new SqlParameter("@xmCode", xmCode) };
using (SqlDataReader dr = DataHelper.GetDataReader(sql, sps))
{
if (dr.Read())
{
Bill_Xm dic = new Bill_Xm();
dic.SjXm = Convert.ToString(dr["SjXm"]);
dic.XmCode = Convert.ToString(dr["XmCode"]);
dic.XmDept = Convert.ToString(dr["XmDept"]);
dic.XmName = Convert.ToString(dr["XmName"]);
dic.XmStatus = Convert.ToString(dr["XmStatus"]);
return(dic);
}
else
{
return(null);
}
}
}
