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