public string SelectMaxconfig_major_kind()
{
string sql = "select max([major_kind_id])+1 from [dbo].[config_major_kind]";
string max = SqlDBHelper.DGZ(sql).ToString();
return(max);
}
public int SelectCount(engage_interviewModel e)
{
string sql = string.Format(@"select max(interview_amount) from [dbo].[engage_interview] where [human_name]='{0}'", e.human_name);
string max = SqlDBHelper.DGZ(sql).ToString();
if (max == "")
{
return(1);
}
return(int.Parse(max));
}
public int Login(users s)
{
string sql = string.Format(@"select count(*) from [user] where [user_name]='{0}' and user_password='******'", s.user_name, s.user_password);
return((int)SqlDBHelper.DGZ(sql));
}
public int engage_resumeAddSelect(engage_major_release_Model r)
{
string sql = string.Format("select count(*) from engage_major_release where [major_kind_id]={0} and [major_id]={1} and [engage_type]='{2}'", r.major_kind_id, r.major_id, r.engage_type);
return(int.Parse(SqlDBHelper.DGZ(sql).ToString()));
}