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