示例#1
0
        public bool CheckBookingNumberInFactory(string BookingNumber, string ExternalBID)
        {
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "sp_Dry_DrawlMaster";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@BookingNumber", BookingNumber);
            cmd.Parameters.AddWithValue("@BranchId", ExternalBID);
            cmd.Parameters.AddWithValue("@Flag", 36);
            var sdr = PrjClass.ExecuteScalar(cmd);

            if (Int32.Parse(sdr) > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
示例#2
0
        public bool checkAcsRights(string pageTitle, string userId, string BID)
        {
            SqlCommand cmd = new SqlCommand();
            string     res = string.Empty;

            cmd.CommandText = "sp_Dry_BarcodeMaster";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@PageTitle", pageTitle);
            cmd.Parameters.AddWithValue("@UserTypeId", userId);
            cmd.Parameters.AddWithValue("@BranchId", BID);
            cmd.Parameters.AddWithValue("@Flag", 34);
            res = PrjClass.ExecuteScalar(cmd);
            if (res == "True")
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }