[asemshahen5]

PHP كود :

       public Int32 VerifyEntredQuantity(string Product_S_N, int QuantityEntred)
        {
            System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
            System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter();
            System.Data.SqlClient.SqlConnection con =
                new System.Data.SqlClient.SqlConnection("Server =(local);database=TestDB;integrated security=True");
            DataTable dt6 = new DataTable();
            dt6.Clear();
            cmd = new System.Data.SqlClient.SqlCommand("select Count(*) from Products where Product_S_N='" + Product_S_N + "' and Quantity > '" + QuantityEntred + "'", con);
            da = new System.Data.SqlClient.SqlDataAdapter(cmd);
            da.Fill(dt6);
            if (dt6.Rows.Count<=0)
            {
                return 0;
            }
            return Convert.ToInt32(dt6.Rows[0][0]);
        }