protected void tbsv_Click(object sender, EventArgs e)       
            {
         

                int P = int.Parse(prdqty.Text);

            if (txtpno.Text == "")
            {
                Response.Write("<script>alert('Please Select Order No')</script>");

            }
            else if (ddpitem.SelectedValue == "0")
            {
                Response.Write("<script>alert('Please Select Item')</script>");
            }
            else if (DDSecbas.SelectedValue == "0")
            {
                Response.Write("<script>alert('Please Select Section')</script>");
            }
            else if (DDlWrknam.SelectedValue == "0")
            {
                Response.Write("<script>alert('Please Select Worker')</script>");
            }
            else if (P > 1 && txtrmk.Text == "")
            {
                Response.Write("<script>alert('Please Input Remarks')</script>");
            }

            else
            {

                SqlCommand cmd = new SqlCommand("spInsertPorderder", con);
                cmd.CommandType = CommandType.StoredProcedure;
                // cmd.Parameters.AddWithValue("@RollNo", TextBox4.Text.Trim());
                cmd.Parameters.AddWithValue("@Codeitem", ddpitem.SelectedValue);

                cmd.Parameters.AddWithValue("@OrderNo", txtpno.Text);
                cmd.Parameters.AddWithValue("@prdqty", prdqty.Text.Trim());
                cmd.Parameters.AddWithValue("@IDWoker", DDlWrknam.SelectedValue);

                cmd.Parameters.AddWithValue("@EntryDate", txtentrydate.Text);
                cmd.Parameters.AddWithValue("@FID", DDLFl.SelectedValue);
                // cmd.Parameters.AddWithValue("@PBsize", txtpbs.Text);
                // cmd.Parameters.AddWithValue("@Weight", txtpbs.Text);
                cmd.Parameters.AddWithValue("@Weight", string.IsNullOrEmpty(txtpbs.Text) ? (object)DBNull.Value : txtpbs.Text);

                cmd.Parameters.AddWithValue("@SecID", DDSecbas.SelectedValue);
                cmd.Parameters.AddWithValue("@Rmk", txtrmk.Text);
                cmd.Parameters.AddWithValue("@BrefNo", txtbnv.Text);
                //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);
                cmd.Parameters.AddWithValue("@IPAddress", lblIP.Text);
                // cmd.Parameters.AddWithValue("@ETime", txttime.Text);
                //     cmd.Parameters.AddWithValue("@ETime", DateTime.Now.ToString("hh:mm"));
                cmd.Parameters.AddWithValue("@ETime", DateTime.Now.ToString("hh:mm:ss"));
                //    cmd.Parameters.AddWithValue("@CustomerID", hfdCustomerID.Value);
                cmd.Parameters.AddWithValue("@Gweigth", txttw.Text);
                cmd.Parameters.Add("@OID", SqlDbType.Int);
                cmd.Parameters["@OID"].Direction = ParameterDirection.Output;





                 con.Open();
                    cmd.ExecuteNonQuery();



                int ResultValue = 0;
                if (!(cmd.Parameters["@OID"].Value is DBNull))
                {
                    ResultValue = Convert.ToInt32(cmd.Parameters["@OID"].Value);
                    string Url = "CRBigbal.aspx?OID=" + ResultValue;
                        Response.Write("<script language='javascript'>window.open('" + Url + "','_blank','');");
                        Response.Write("</script>");
                }
                //con.Close();

               /}




         

                }
            }
            }