예제 #1
0
        /// <summary>
        /// 调用存储过程查询出服务分配模块需要显示的相关信息
        /// </summary>
        /// <param name="page"></param>
        /// <returns></returns>
        public static List<ViewCustomServices> GetAll(CommonPage page)
        {
            List<ViewCustomServices> list = new List<ViewCustomServices>();

            string sql = "PagingProc";
            List<SqlParameter> paras = new List<SqlParameter>()
            {
                new SqlParameter("@TbName",page.TbName),
                new SqlParameter("@KeyFile",page.KeyFile),
                new SqlParameter("@ShowFile",page.ShowFile),
                new SqlParameter("@Where",page.Where),
                new SqlParameter("@OrderBy",page.OrderBy),
                new SqlParameter("@PIndex",page.PIndex),
                new SqlParameter("@PSize",page.PSize)
            };
            try
            {
                using (SqlDataReader sr = DBHelp.ExecuteReaderProc(sql, paras))
                {
                    while (sr.Read()) {
                        ViewCustomServices u = new ViewCustomServices();
                        u.CSID = Convert.ToInt32(sr["CSID"].ToString());
                        u.CSCreateDate = sr["CSCreateDate"].ToString();
                        u.CSTitle = sr["CSTitle"].ToString();
                        u.CusName = sr["CusName"].ToString();
                        u.STName = sr["STName"].ToString();
                        u.UserName = sr["UserName"].ToString();
                        u.STID = Convert.ToInt32(sr["STID"].ToString());
                        u.CusID = sr["CusID"].ToString();
                        u.CSState = Convert.ToInt32(sr["CSState"].ToString());
                        u.CSDesc = sr["CSDesc"].ToString();
                        u.CSCreateID = Convert.ToInt32(sr["CSCreateID"]);
                        if (sr["CSDueID"] != null)
                        {
                            u.CSDueID = Convert.ToInt32(sr["CSDueID"]);
                        }
                        if (sr["CSDueDate"] != null)
                        {
                            u.CSDueDate = sr["CSDueDate"].ToString();
                        }
                        if (sr["CSDeal"] != null)
                        {
                            u.CSDeal = sr["CSDeal"].ToString();
                        }
                        if (sr["CSDealDate"] != null)
                        {
                            u.CSDealDate = sr["CSDealDate"].ToString();
                        }
                        if (sr["CSResult"] != null)
                        {
                            u.CSResult = sr["CSResult"].ToString();
                        }
                        if (sr["CSSatisfy"] != null)
                        {
                            u.CSSatisfy = StringDisposeDAL.StrToInt(sr["CSSatisfy"].ToString());
                        }
                        list.Add(u);
                    }
                }
                return list;
            }
            catch (Exception)
            {
                throw;
            }
        }
예제 #2
0
 /// <summary>
 /// 根据id查询
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 public static ViewCustomServices SelectById(string id)
 {
     ViewCustomServices u = null;
     string sql = "select * from ViewCustomServices where CSID=@CSID";
     List<SqlParameter> list = new List<SqlParameter>();
     list.Add(new SqlParameter("@CSID",id));
     using (SqlDataReader sr = DBHelp.ExecuteReader(sql, list)) {
         if (sr.Read())
         {
             u = new ViewCustomServices();
             u.CSID = Convert.ToInt32(sr["CSID"]);
             u.CSCreateDate = sr["CSCreateDate"].ToString();
             u.CSTitle = sr["CSTitle"].ToString();
             u.CusName = sr["CusName"].ToString();
             u.STName = sr["STName"].ToString();
             u.UserName = sr["UserName"].ToString();
             u.STID = Convert.ToInt32(sr["STID"]);
             u.CusID = sr["CusID"].ToString();
             u.CSState = Convert.ToInt32(sr["CSState"]);
             u.CSDesc = sr["CSDesc"].ToString();
             u.CSCreateID = Convert.ToInt32(sr["CSCreateID"]);
             u.CSDueID = Convert.ToInt32(sr["CSDueID"]);
             u.CSDueDate = sr["CSDueDate"].ToString();
             if (sr["CSDeal"].ToString() != "")
             {
                 u.CSDeal = sr["CSDeal"].ToString();
             }
             if (sr["CSDealDate"].ToString() != "")
             {
                 u.CSDealDate = sr["CSDealDate"].ToString();
             }
             if (sr["CSResult"].ToString() != "")
             {
                 u.CSResult = sr["CSResult"].ToString();
             }
             if (sr["CSSatisfy"].ToString() != "")
             {
                 u.CSSatisfy = Convert.ToInt32(sr["CSSatisfy"]);
             }
         }
     }
     return u;
 }