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