Esempio n. 1
0
        public void llenaempleados()
        {
            try
            {
                String bd             = Session["BD"].ToString();
                var    registroPROVEE = Controlasql.ctraeEmpleado(bd);

                if (registroPROVEE.Tables[0].Rows.Count > 0)
                {
                    DataTable dt = registroPROVEE.Tables[0];
                    Select1.Items.Clear();
                    foreach (DataRow row in dt.Rows)
                    {
                        Select1.Items.Add(Convert.ToString(row["Proveedor"]));
                        Select1.DataBind();
                    }
                }
                else
                {
                    Select1.DataSource = null;
                    Select1.DataBind();
                }
            }
            catch (Exception)
            {
            }
        }
Esempio n. 2
0
    /// <summary>
    /// 新增和更新的重填
    /// </summary>
    private void OverWrite()
    {
        if (EDITSTATUS)
        {
            txtUserid.Disabled = true;
            string  strUserid = Request["sid"];
            DataSet ds        = subject.GetsubjectByUserid(strUserid);
            DataRow dr        = ds.Tables[0].Rows[0];
            txtUserid.Value = dr["sid"].ToString();
            txtName.Value   = dr["name"].ToString();

            Select1.DataTextField  = "sortname";
            Select1.DataValueField = "sortid";
            Select1.DataSource     = Sort.GetSort();
            Select1.DataBind();
            Select1.Value = dr["sortid"].ToString();
            //Select1.Value=t
        }
        else
        {
            Select1.DataTextField  = "sortname";
            Select1.DataValueField = "sortid";
            Select1.DataSource     = Sort.GetSort();
            Select1.DataBind();
            div1.Visible    = false;
            txtUserid.Value = "";
            txtName.Value   = "";
        }
    }
Esempio n. 3
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         /*查询空间类型信息*/
         string     strsql = "select * from PType where parentId = 0";
         SqlCommand mycmd  = new SqlCommand(strsql, conn);
         conn.Open();
         SqlDataReader mydr = mycmd.ExecuteReader();
         Select1.DataSource     = mydr;
         Select1.DataTextField  = "category_name";
         Select1.DataValueField = "category_ID";
         Select1.DataBind();
         mydr.Close();
         conn.Close();
     }
 }
Esempio n. 4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);

                string query = "select id, display from Categories";

                SqlDataAdapter sda = new SqlDataAdapter(query, conn);
                DataSet        ds  = new DataSet();
                sda.Fill(ds, "Categories");

                Select1.DataSource     = ds;
                Select1.DataTextField  = "display";
                Select1.DataValueField = "Id";
                Select1.DataBind();
            }
        }
Esempio n. 5
0
        //protected void Page_PreRender(object sender, EventArgs e)
        //{
        //    if (!this.IsPostBack)
        //    {

        //    }


        //}

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DropDownList1.DataSource = arackayit.getPlaka();
                DropDownList1.DataBind();

                DropDownList2.DataSource = dbarac2.getMarkaListe();
                DropDownList2.DataBind();

                string findtext = DropDownList2.Items[0].ToString();

                var query1 = db.aracmarkas.ToList()
                             .Where(x => x.marka == findtext)
                             .Select(x => x.markaID).Single();

                int maid = query1;

                DropDownList3.DataSource = arackayit.getSpesificModel(maid);
                DropDownList3.DataBind();



                //DropDownList3.DataSource = dbarac2.getModel();
                //DropDownList3.DataBind();

                Select1.DataSource = musterikayit.getMusteri();
                Select1.DataBind();

                //DropDownList4.DataSource = musterikayit.getMusteri();
                //DropDownList4.DataBind();


                int year = DateTime.Now.Year;
                for (int i = year - 30; i <= year + 1; i++)
                {
                    ListItem li = new ListItem(i.ToString());
                    DropDownList5.Items.Add(li);
                }
                DropDownList5.Items.FindByText(year.ToString()).Selected = true;
            }
        }
Esempio n. 6
0
 protected void CreaMOdelo_Click(object sender, EventArgs e)
 {
     try
     {
         var registros = Controlasql.CcreaModelo(Textmodelo.Value.ToUpper(), Session["USUARIO"].ToString(), Session["BD"].ToString());
         if (registros > 0)
         {
             Nuevomodelo.Visible = false;
             llenamodelos();
             Select1.Focus();
         }
         else
         {
             serialcantidad.Value = txtserial.Value.ToUpper();
             alerta.Visible       = true;
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 7
0
        protected void Page_Load(object sender, EventArgs e)
        {
            using (SqlConnection cn = new SqlConnection(@"Data Source=DESKTOP-GN1S5UA\SERVER;Initial Catalog=GestionCitas;Integrated Security=SSPI;"))
            {
                if (!this.IsPostBack)
                {
                    {
                        using (SqlCommand cmd = new SqlCommand("SELECT Id,Pais FROM Pais"))
                        {
                            cmd.CommandType = CommandType.Text;
                            cmd.Connection  = cn;
                            cn.Open();
                            Select4.DataSource     = cmd.ExecuteReader();
                            Select4.DataTextField  = "Pais";
                            Select4.DataValueField = "Id";
                            Select4.DataBind();
                            cn.Close();
                        }

                        using (SqlCommand cmd = new SqlCommand("SELECT Id,Aficcion FROM Aficcion"))
                        {
                            cmd.CommandType = CommandType.Text;
                            cmd.Connection  = cn;
                            cn.Open();
                            Select1.DataSource     = cmd.ExecuteReader();
                            Select1.DataTextField  = "Aficcion";
                            Select1.DataValueField = "Id";
                            Select1.DataBind();
                            cn.Close();
                        }

                        using (SqlCommand cmd = new SqlCommand("SELECT Id,Educacion FROM Educacion"))
                        {
                            cmd.CommandType = CommandType.Text;
                            cmd.Connection  = cn;
                            cn.Open();
                            Select5.DataSource     = cmd.ExecuteReader();
                            Select5.DataTextField  = "Educacion";
                            Select5.DataValueField = "Id";
                            Select5.DataBind();
                            cn.Close();
                        }
                        using (SqlCommand cmd = new SqlCommand("SELECT Id,Contextura FROM Contextura"))
                        {
                            cmd.CommandType = CommandType.Text;
                            cmd.Connection  = cn;
                            cn.Open();
                            editprefixes.DataSource     = cmd.ExecuteReader();
                            editprefixes.DataTextField  = "Contextura";
                            editprefixes.DataValueField = "Id";
                            editprefixes.DataBind();
                            cn.Close();
                        }
                        using (SqlCommand cmd = new SqlCommand("SELECT Id,Sexo FROM Sexo"))
                        {
                            cmd.CommandType = CommandType.Text;
                            cmd.Connection  = cn;
                            cn.Open();
                            Select3.DataSource     = cmd.ExecuteReader();
                            Select3.DataTextField  = "Sexo";
                            Select3.DataValueField = "Id";
                            Select3.DataBind();
                            cn.Close();
                        }
                    }
                }
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            #region Recupero el user-name-login
            //ocultar primer item
            RadioButtonList2.Items[0].Attributes.Add("style", "display:none");;

            UserName_ey     = Request.QueryString["UserName_ey"];
            flgadmin        = wS.RetornarRol(UserName_ey);
            Button5.Visible = false;
            if (flgadmin == 1)
            {
                Button5.Visible = true;
            }
            Label2.Text   = "Hola: " + UserName_ey;
            TextBox9.Text = UserName_ey;
            usuario       = UserName_ey;
            #endregion

            #region Crear Carpeta en cliente
            //string newFolder = "Digital Tax _ LE";
            path_Libros = @"J:\COMMON\" + UserName_ey.Replace(".", "_");
            path_Libros = path_Libros.Replace("@", "_");
            //path_Libros = System.IO.Path.Combine(
            //   Environment.GetFolderPath(Environment.SpecialFolder.Desktop),newFolder);

            if (!System.IO.Directory.Exists(path_Libros))
            {
                try
                {
                    System.IO.Directory.CreateDirectory(path_Libros);
                }
                catch (IOException ie)
                {
                    Console.WriteLine("IO Error: " + ie.Message);
                }
            }
            #endregion
            //

            Titulo_registrar_valor.Visible = true;
            CrearTicketid.Visible          = true;
            BuscarTicketid.Visible         = false;
            Titulo_buscar_valor.Visible    = false;

            Titulo_editarestado_valor.Visible = false;
            EditarEstadoid.Visible            = false;



            //Subservice line
            if (!IsPostBack)
            {
                /*
                 * SqlConnection conn = new SqlConnection();
                 * //conn.ConnectionString = "Data Source=10.20.244.25; Initial Catalog=Ticket_DgTAX; Integrated Security=True;";
                 * conn.ConnectionString = @"Data Source=10.20.103.68,49172;Initial Catalog=Ticket_DgTAX;Integrated Security=True;";//24/09/2019 cambio de Servidor, dado que el anterior esta reservado para ejecutar flujos de modeler
                 *
                 * //string ConnectString = "server=10.20.103.68,49172\\SQLEXPRESS;database=Ticket_DgTAX;integrated security=True";
                 * //string ConnectString = "Data Source=10.20.103.68,49172 ;Initial Catalog=Ticket_DgTAX; Integrated Security=True";
                 * //Select distinct Jobs.Subserviceline from usuarios,Jobs,usuarios_job where Jobs.Estado = 1 and usuarios.correo = usuarios_job.correo and usuarios_job.Number_engagement = Jobs.Number_engagement and usuarios.correo = '" + UserName_ey+"'"Select distinct Jobs.Subserviceline from usuarios,Jobs,usuarios_job where Jobs.Estado=1 and usuarios.correo=usuarios_job.correo and usuarios_job.Number_engagement=Jobs.Number_engagement and usuarios.correo='" + UserName_ey + "'";
                 * string QueryString = "Select top 1  Jobs.Subserviceline from Jobs where Jobs.Estado=1";
                 * //SqlConnection conn = new SqlConnection(ConnectString);
                 * conn.Open();
                 * SqlDataAdapter myCommand = new SqlDataAdapter(QueryString, conn);
                 * DataSet ds = new DataSet();
                 * //myCommand.Fill(ds);
                 *
                 * //Select1.DataSource = ds;
                 * //Select1.DataTextField = "Subserviceline";
                 *
                 * //Select1.DataValueField = "Subserviceline";
                 * //Select1.DataBind();
                 * //---
                 * SqlCommand command = new SqlCommand(QueryString, conn);
                 * string Subserviceline = Convert.ToString(command.ExecuteScalar());
                 *
                 * TextBox6.Text = Subserviceline;
                 *
                 * //Jobs dejado sin efecto
                 * /*
                 * QueryString = "Select distinct Jobs.Number_engagement, CONCAT(Jobs.Number_engagement,' - ',Jobs.Client_engagement) as Job_  from usuarios,Jobs,usuarios_job where Jobs.Estado=1 and usuarios.correo=usuarios_job.correo and usuarios_job.Number_engagement=Jobs.Number_engagement and usuarios.correo='" + UserName_ey + "'";
                 * myCommand = new SqlDataAdapter(QueryString, conn);
                 * ds = new DataSet();
                 * myCommand.Fill(ds);
                 *
                 * Select2.DataSource = ds;
                 * Select2.DataTextField = "Job_";
                 * Select2.DataValueField = "Number_engagement";
                 * Select2.DataBind();
                 */
                //---


                //Manager dejado sin efecto

                /*
                 * QueryString = "Select distinct Jobs.Manager_name from usuarios,Jobs,usuarios_job where Jobs.Estado=1 and usuarios.correo=usuarios_job.correo and usuarios_job.Number_engagement=Jobs.Number_engagement and usuarios.correo='" + UserName_ey + "'";
                 * myCommand = new SqlDataAdapter(QueryString, conn);
                 * ds = new DataSet();
                 * myCommand.Fill(ds);
                 *
                 * //Select3.DataSource = ds;
                 * //Select3.DataTextField = "Manager_name";
                 * //Select3.DataValueField = "Manager_name";
                 * //Select3.DataBind();
                 *
                 * //---
                 * command = new SqlCommand(QueryString, conn);
                 * string Manager_name = Convert.ToString(command.ExecuteScalar());
                 *
                 * TextBox8.Text = Manager_name;
                 */
                TextBox6.Text = "BTC";
                ServiceReference1.WSSoapClient wS = new ServiceReference1.WSSoapClient();
                DataSet ds = wS.LLenarListaGerente();
                //Seleccion de Gerente
                //QueryString = "Select distinct Manager_name  from Jobs where Jobs.Estado=1 ";
                //myCommand = new SqlDataAdapter(QueryString, conn);
                //ds = new DataSet();
                //myCommand.Fill(ds);

                Select1.DataSource     = ds;
                Select1.DataTextField  = "Manager_name";
                Select1.DataValueField = "Manager_name";
                Select1.DataBind();
                //Senior
                //conn.Close();
            }
        }
Esempio n. 9
0
        protected void Button3_Click(object sender, EventArgs e)
        {
            string tc   = TextBox9.Text;
            string isim = TextBox10.Text;

            //List<string> ifmusteriexists = db.musteris.ToList()
            //                    .Where(x => x.tckn == tc)
            //                    .Select(x => x.tckn).ToList();

            //if (ifmusteriexists.Count == 0)
            //{

            //}
            //else
            //{
            //    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('Bu TC Kimlik NO'ya sahip müşteri mevcut', 'HATA');", true);
            //}

            if (tc == "" || isim == "")
            {
                //ShowMessageBox(Page, "TCKN veya isim girmeyi unuttunuz, lütfen tekrar deneyin");
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('TCKN veya isim girmeyi unuttunuz, lütfen tekrar deneyin', 'HATALI GİRİŞ');", true);
            }
            else if (tc.Length != 11)
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('TCKN hatalı girildi', 'HATALI GİRİŞ');", true);
            }

            else
            {
                int cevap = musterikayit.ekleMusteri(tc, isim);

                if (cevap == 1)
                {
                    //ShowMessageBox(Page, "Kayıt Başarıyla Eklendi");
                    //Label2.Text = "Kayıt Başarıyla Eklendi";
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentSuccess('Kayıt Başarıyla Eklendi', 'İşlem Başarılı');", true);
                    TextBox9.Text  = "";
                    TextBox10.Text = "";
                }

                else if (cevap == 2)
                {
                    //ShowMessageBox(Page, "Girilen TC No'ya ait kayıt zaten mevcut, lütfen listeden seçip tekrar deneyin");
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('Girilen TC Noya ait kayıt zaten mevcut, lütfen listeden seçip tekrar deneyin', '');", true);
                }

                else
                {
                    //ShowMessageBox(Page, "Kayıt eklenirken bir hata oluştu");
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentError('Kayıt eklenirken beklenmeyen bir sorun oluştu', 'HATA');", true);
                }


                //DropDownList4.DataSource = musterikayit.getMusteri();
                //DropDownList4.DataBind();

                Select1.DataSource = musterikayit.getMusteri();
                Select1.DataBind();
            }
        }
Esempio n. 10
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            /*TextBox2.Text = DropDownList2.SelectedValue;
            *  TextBox3.Text = DropDownList3.SelectedValue;
            *  TextBox4.Text = DropDownList4.SelectedValue;
            *  TextBox5.Text = DropDownList5.SelectedValue;*/
            try
            {
                string maid1  = TextBox2.Text;
                string moid1  = TextBox3.Text;
                string musid1 = TextBox4.Text;
                string sene   = TextBox5.Text;

                string plaka    = TextBox1.Text;
                string ruhsatno = TextBox6.Text;
                string saseno   = TextBox7.Text;
                string motorno  = TextBox8.Text;

                if (maid1 == "" || moid1 == "" || musid1 == "" || sene == "")
                {
                    //ShowMessageBox(Page, "Marka, model, müşteri ya da yıl seçimini unuttunuz, lütfen tekrar deneyin");
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('Marka, model, müşteri ya da yıl seçimini unuttunuz', 'HATALI GİRİŞ');", true);
                    //TextBox1.Text = "";
                    //TextBox2.Text = "";
                    //TextBox3.Text = "";
                    //TextBox4.Text = "";
                    //TextBox5.Text = "";
                    //TextBox6.Text = "";
                    //TextBox7.Text = "";
                    //TextBox8.Text = "";
                }
                else if (plaka == "" || ruhsatno == "" || saseno == "" || motorno == "")
                {
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('Plaka, Ruhsat No, Şase No ya da Motor No girmeyi unuttunuz', 'HATALI GİRİŞ');", true);
                    //TextBox1.Text = "";
                    //TextBox2.Text = "";
                    //TextBox3.Text = "";
                    //TextBox4.Text = "";
                    //TextBox5.Text = "";
                    //TextBox6.Text = "";
                    //TextBox7.Text = "";
                    //TextBox8.Text = "";
                }

                else
                {
                    var query1 = db.aracmarkas.ToList()
                                 .Where(x => x.marka == maid1)
                                 .Select(x => x.markaID).Single();

                    var query2 = db.aracmodels.ToList()
                                 .Where(x => x.model == moid1)
                                 .Select(x => x.modelID).Single();

                    var query3 = db.musteris.ToList()
                                 .Where(x => x.adSoyad == musid1)
                                 .Select(x => x.musteriID).Single();


                    string pl     = TextBox1.Text;
                    int    maid   = query1;
                    int    moid   = query2;
                    int    musid  = query3;
                    int    yil    = Convert.ToInt32(TextBox5.Text);
                    string ruhsat = TextBox6.Text;
                    string sase   = TextBox7.Text;
                    string motor  = TextBox8.Text;

                    int cevap = arackayit.ekleArac(pl, maid, moid, musid, yil, ruhsat, sase, motor);

                    if (cevap == 1)
                    {
                        ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentSuccess('Kayıt Başarıyla Eklendi', 'İşlem Başarılı');", true);

                        //ShowMessageBox(Page, "Kayıt Başarıyla Eklendi");
                        //Label1.Text = "Kayıt Başarıyla Eklendi";

                        //TextBox1.Text = "";
                        //TextBox2.Text = "";
                        //TextBox3.Text = "";
                        //TextBox4.Text = "";
                        //TextBox5.Text = "";
                        //TextBox6.Text = "";
                        //TextBox7.Text = "";
                        //TextBox8.Text = "";



                        //servisislem.ekleServisKayit()
                    }

                    else if (cevap == 2)
                    {
                        //ShowMessageBox(Page, "Girilen plakaya ait kayıt zaten mevcut, lütfen listeden seçip tekrar deneyin");
                        ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentWarning('Girilen plakaya ait kayıt zaten mevcut, lütfen listeden seçip tekrar deneyin', 'HATALI GİRİŞ');", true);
                    }

                    else
                    {
                        //ShowMessageBox(Page, "Kayıt eklenirken bir hata oluştu");
                        ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CallMyFunction", "showContentError('Kayıt eklenirken beklenmeyen bir hata oluştu', 'HATA');", true);
                    }

                    DropDownList1.DataBind();
                    DropDownList2.DataBind();
                    DropDownList3.DataBind();
                    //DropDownList4.DataBind();
                    Select1.DataBind();
                }
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Hata')", true);
            }
        }