Exemple #1
0
        public JsonResult GetClientListForDropDownList(string q)
        {
            var list = new BLL.ClientManage.T_tb_ClientManage().GetModelList(" ClientName like '%%" + q + "%%' ");

            return(Json(list, JsonRequestBehavior.AllowGet));
        }
Exemple #2
0
        /// <summary>
        /// 导出药品入库
        /// 作者:章建国
        /// </summary>
        /// <returns></returns>
        public FileResult Export_Sample(string _search, string _searchtype, int _companyid)
        {
            DataTable dt = new DataTable();

            System.IO.MemoryStream stream = new MemoryStream();
            try
            {
                string where = " 1=1 ";
                switch (_searchtype)
                {
                case "样品名称":
                    where += string.Format(" and name like '%%{0}%%' ", _search);
                    break;

                case "样品人":
                    where += string.Format(" and detectionUser like '%%{0}%%' ", _search);
                    break;

                case "抽样日期":
                    var times = _search.Split(',');
                    where += string.Format(" and detectionDate >= '{0}' and  detectionDate <= '{1}' ", times[0], times[1]);
                    break;
                }

                if (_companyid > 0)
                {
                    where += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", _companyid);
                }
                else
                {
                    if (CurrentUserInfo.AreaID > 0 && CurrentUserInfo.DataRange == 3)
                    {
                        int _userid = CurrentUserInfo.PersonnelID;
                        where += string.Format(" and  CreateUser = (select PersonnelID from tb_InPersonnel where AreaID = {0} and PersonnelID = {1}) ", CurrentUserInfo.AreaID, _userid);
                    }
                    else if (CurrentUserInfo.AreaID > 0 && CurrentUserInfo.DataRange == 2)
                    {
                        int _userid = CurrentUserInfo.PersonnelID;
                        where += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", CurrentUserInfo.AreaID);
                    }
                }

                dt = _samplebll.GetList(where).Tables[0];
                BLL.PersonnelManage.T_tb_InPersonnel inpersonnel  = new BLL.PersonnelManage.T_tb_InPersonnel();
                BLL.ClientManage.T_tb_ClientManage   clientManage = new BLL.ClientManage.T_tb_ClientManage();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    try
                    {
                        int userid = Convert.ToInt32(dt.Rows[i]["handleUser"]);
                        dt.Rows[i]["handleUser"] = inpersonnel.GetModel(userid).PersonnelName;
                    }
                    catch
                    {
                    }
                    try
                    {
                        int InspectCompany = Convert.ToInt32(dt.Rows[i]["InspectCompany"]);
                        dt.Rows[i]["InspectCompany"] = clientManage.GetModel(InspectCompany).ClientName;
                    }
                    catch
                    {
                    }
                }
                stream = PublicClass.ExportSampleToExcel(dt);
            }
            catch { }
            string filename = "样品列表" + DateTime.Now.ToFileTime() + ".xls";

            return(File(stream, "application/vnd.ms-excel", filename));
        }
Exemple #3
0
        public String GetInspectAddressById(Int32 id)
        {
            var list = new BLL.ClientManage.T_tb_ClientManage().GetModel(id);

            return(list.Address);
        }
Exemple #4
0
        /// <summary>
        /// 获取所有数据列表
        /// 作者:章建国
        /// </summary>
        /// <returns>将DataTable转换为Json数据格式通过string类型返回</returns>
        public string GetSampleList(int pageNumber, int pageSize, string _searchtext, string _searchtype, int _cid)
        {
            DataTable dt    = new DataTable();
            int       total = 0;

            try
            {
                string where = " 1=1 ";
                switch (_searchtype)
                {
                case "样品名称":
                    where += string.Format(" and name like '%%{0}%%' ", _searchtext);
                    break;

                case "样品人":
                    where += string.Format(" and detectionUser like '%%{0}%%' ", _searchtext);
                    break;

                case "抽样日期":
                    var times = _searchtext.Split(',');
                    where += string.Format(" and detectionDate >= '{0}' and  detectionDate <= '{1}' ", times[0], times[1]);
                    break;
                }

                if (_cid > 0)
                {
                    where += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", _cid);
                }
                else
                {
                    if (CurrentUserInfo.AreaID > 0 && CurrentUserInfo.DataRange == 3)
                    {
                        int _userid = CurrentUserInfo.PersonnelID;
                        where += string.Format(" and  CreateUser = (select PersonnelID from tb_InPersonnel where AreaID = {0} and PersonnelID = {1}) ", CurrentUserInfo.AreaID, _userid);
                    }
                    else if (CurrentUserInfo.AreaID > 0 && CurrentUserInfo.DataRange == 2)
                    {
                        int _userid = CurrentUserInfo.PersonnelID;
                        where += string.Format(" and createUser in (select PersonnelID from tb_InPersonnel where AreaID = {0}) ", CurrentUserInfo.AreaID);
                    }
                }

                dt = _samplebll.GetListByPage(where, "createDate desc", pageNumber * pageSize - (pageSize - 1), pageNumber * pageSize).Tables[0];
                BLL.PersonnelManage.T_tb_InPersonnel inpersonnel  = new BLL.PersonnelManage.T_tb_InPersonnel();
                BLL.ClientManage.T_tb_ClientManage   clientManage = new BLL.ClientManage.T_tb_ClientManage();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    try
                    {
                        int userid = Convert.ToInt32(dt.Rows[i]["handleUser"]);
                        dt.Rows[i]["handleUser"] = inpersonnel.GetModel(userid).PersonnelName;
                    }
                    catch
                    {
                    }
                    try
                    {
                        int InspectCompany = Convert.ToInt32(dt.Rows[i]["InspectCompany"]);
                        dt.Rows[i]["InspectCompany"] = clientManage.GetModel(InspectCompany).ClientName;
                    }
                    catch
                    {
                    }
                }
                total = dt.Rows.Count;
                total = _samplebll.GetModelList(where).Count;
            }
            catch { }
            return(PublicClass.ToJson(dt, total));
        }