/// <summary> /// 验证用户名是否可用 /// </summary> /// <param name="User_Name">用户名</param> /// <returns>bool</returns> public bool Find_User(string User_Name) { string sql = "select * from ygb where user_name=@user_name"; SqlParameter[] spr = { new SqlParameter("@user_name", User_Name) }; DataTable dt = new DataTable(); try { dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr); if (dt.Rows.Count > 0) { return(false); } else { return(true); } } catch (Exception) { throw; } }
/// <summary> /// 得到一条消息数据 /// </summary> /// <param name="Getto">目的地</param> /// <param name="flag">标记</param> /// <returns>SYS.Model.XXXXB</returns> public SYS.Model.XXXXB GetModel(string Getto, string flag) { string sql = "select top 1 ID,* from xxxxb where Getto=@Getto and Flag=@Flag"; SqlParameter[] spr = { new SqlParameter("@Getto", Getto), new SqlParameter("@Flag", flag) }; try { DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr); SYS.Model.XXXXB xxxb = null; if (dt.Rows.Count > 0) { xxxb = new SYS.Model.XXXXB(); xxxb.ID = int.Parse(dt.Rows[0]["ID"].ToString()); xxxb.Title = dt.Rows[0]["Title"].ToString(); xxxb.Content = dt.Rows[0]["Content"].ToString(); xxxb.Comefrom = dt.Rows[0]["Comefrom"].ToString(); xxxb.Other = dt.Rows[0]["Other"].ToString(); xxxb.Message_Type = dt.Rows[0]["Message_Message_Type"].ToString(); xxxb.Flag = dt.Rows[0]["Flag"].ToString(); } return(xxxb); } catch (Exception) { throw; } }
/// <summary> /// 用职位名称获取一个职位 /// </summary> /// <param name="ZWMC">string 职位名称</param> /// <returns>ZWB Model</returns> public ZWB Get_ZWBH(string ZWMC) { string sql = "select * from zwb where zwmc=@zwmc"; SqlParameter[] spr = { new SqlParameter("@zwmc", ZWMC) }; ZWB zw = new ZWB(); try { DataTable dt = new DataTable(); dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr); if (dt.Rows.Count > 0) { zw.ZWBH = Convert.ToInt32(dt.Rows[0]["ZWBH"].ToString()); zw.ZWMC = dt.Rows[0]["ZWMC"].ToString(); zw.ZWQX = Convert.ToInt32(dt.Rows[0]["ZWQX"].ToString()); zw.ZWSM = dt.Rows[0]["ZWSM"].ToString(); } return(zw); } catch (Exception) { throw; } }
/// <summary> /// 用检测编号和次数查询一条检测数据 /// </summary> /// <param name="jcbh">检测编号</param> /// <param name="jccs">检测次数</param> /// <returns>ASM检测数据Model</returns> public ZYJS_JCXXB Get_ZYJS_jcxx(string jcbh) { string sql = "select * from zyjs_jcxxb where jcbh=@jcbh"; SqlParameter[] spr = { new SqlParameter("@jcbh", jcbh) }; try { ZYJS_JCXXB vmas = new ZYJS_JCXXB(); DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr); if (dt.Rows.Count > 0) { vmas.JCBH = dt.Rows[0]["JCBH"].ToString();//1 vmas.JCZMC = dt.Rows[0]["JCZMC"].ToString(); vmas.JCRQ = dt.Rows[0]["JCRQ"].ToString(); vmas.CSYQXH = dt.Rows[0]["CSYQXH"].ToString();//6 vmas.JCY = dt.Rows[0]["JCY"].ToString(); vmas.SHY = dt.Rows[0]["SHY"].ToString(); vmas.PZR = dt.Rows[0]["PZR"].ToString(); } else { vmas.JCBH = jcbh; } return(vmas); } catch (Exception) { throw; } }