public static bool Vld_UserName(global::ENTITY.CusUsers userlogin)
{
string sql = @"select customerid from CusUsers where Customername =@Customername";
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@Customername", SqlDbType.VarChar)
};
para[0].Value = userlogin.Customername;
return((DBHelp.ExecuteScalar(sql, para) != null) ? true : false);
}
public static bool ulogin(global::ENTITY.CusUsers userlogin)
{
string sql = @"select customerid from CusUsers where Customername =@Customername and customerpwd =@customerpwd and IsCusAdmin=@IsCusAdmin";
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@Customername", SqlDbType.VarChar),
new SqlParameter("@customerpwd", SqlDbType.VarChar),
new SqlParameter("@IsCusAdmin", SqlDbType.Int)
};
para[0].Value = userlogin.Customername;
para[1].Value = userlogin.customerpwd;
para[2].Value = userlogin.IsCusAdmin;
return((DBHelp.ExecuteScalar(sql, para) != null) ? true : false);
}
