private void ViewTotQTybyPartNO()
 {
     a = '0';
     if (DropPartNo.Text != "")
     {
         DBServer Db = new DBServer();
         DataSet  ds = new DataSet();
         Db.PartNo = DropPartNo.Text;
         ds        = Db.ViewTotQtybyPartnos(Db);
         if (ds.Tables[0].Rows.Count > 0)
         {
             if (ds.Tables[0].Rows[0].ItemArray[0].ToString() != "")
             {
                 a = Convert.ToDouble(ds.Tables[0].Rows[0].ItemArray[0].ToString());
                 TxtProducedQty1.Text = Convert.ToString(a);
             }
             //b =  TxtProducedQty.Text;
             //c = a + b;
             else
             {
                 a = '0';
                 TxtProducedQty1.Text = "0";
             }
         }
         else
         {
         }
     }
 }