private void alterState( string strID ) { string mySql = "update message set MState=1 where MState<>1 and MID=" + strID; DBConn myDB = new DBConn(); myDB.ExecuteNonQuery(mySql); myDB.Close(); }
protected void Page_Load(object sender, System.EventArgs e) { if (!IsPostBack) { //执行删除 if (Request.Params["id"] != null)//Request.Params传递参数ID=0 { string sSql; sSql = "delete tblMode where id=" + Request.Params["id"]; DBConn myDB1 = new DBConn(); myDB1.ExecuteNonQuery(sSql ); myDB1.Close(); } //执行编辑 if (Request.Params["Editid"] != null) { AddButton.Visible = false; EditButton.Visible = true; EditButton.ToolTip = Request.Params["Editid"]; getFieldVaule(); getFieldVaule(); } BindGrid(); } }
protected void Page_Load(object sender, System.EventArgs e) { //权限检查 if( Session["adminName"]==null || Session["adminName"].ToString() == String.Empty ) { Response.Write("<font color=#ff0000>对不起,您没足够权限访问此页!!</font>"); Response.Write("<a href=index.aspx>重新登陆</a>"); Response.End(); return; } if( !IsPostBack ) { if (Request.QueryString["ac"]!= null) { string mySql = "update [Order] set OState=" + (string)(Request.QueryString["ac"]) + " where OID='" + (string)(Request.QueryString["oid"])+"'"; DBConn myDB = new DBConn(); myDB.ExecuteNonQuery(mySql); myDB.Close(); } getData(); } }
protected void Button1_Click(object sender, System.EventArgs e) { string strName = TextBox1.Text; if( strName.Trim() == String.Empty ) { Response.Write("<script>"); Response.Write("alert('请输入类别名称!!!');"); Response.Write("</script>"); return; } else if( strName.Length > 35 ) { Response.Write("<script>"); Response.Write("alert('输入类别名称太长了!!!');"); Response.Write("</script>"); return; } DBConn myDB = new DBConn(); string sql="insert into Category(CName) values('" + strName + "')"; myDB.ExecuteNonQuery(sql); myDB.Close(); Response.Write("<script>"); Response.Write("alert('成功添加!!!');"); Response.Write("</script>"); TextBox1.Text=""; getData(); }
private void getData()//绑定数据 { DBConn myDB = new DBConn(); string sql="select * from Category order by CID desc"; DataGrid1.DataSource = myDB.getDataReader(sql); DataGrid1.DataBind(); myDB.Close(); }
private void getData() { DBConn myDB = new DBConn(); string sql="select * from admin order by addtime"; adminDataGrid.DataSource = myDB.getDataReader(sql); adminDataGrid.DataBind(); myDB.Close(); }
protected void Page_Load(object sender, System.EventArgs e) { //权限检查 if( Session["adminName"]==null || Session["adminName"].ToString() == String.Empty ) { Response.Write("<font color=#ff0000 style='FONT-SIZE: 12px'>对不起,您没足够权限访问此页!!</font><br>"); Response.Write("<a href=index.aspx target=_top style='FONT-SIZE: 12px'>重新登陆</a><br>"); Response.End(); return; } if( !IsPostBack ) { getCategory();//绑定类别下拉列表 if( Request.QueryString["id"] == null) { Response.Write("没有这个二手书"); Response.End(); } string strID = Request.QueryString["id"].ToString().Trim(); //获取ID对应的二手书信息 DBConn myDB1 = new DBConn(); string sqlP="select * from Products where PID=" + strID; SqlDataReader dr = myDB1.getDataReader(sqlP); if ( dr.Read() ) { myimg.Src = "../showPP.aspx?id=" + dr["PID"].ToString(); ViewState["PID"] = dr["PID"].ToString(); txtName.Text = CleanString.htmlOutputText( dr["PName"].ToString() ); txtCPrice.Text = double.Parse( dr["PCPrice"].ToString() ).ToString("f2");//小数点后面的位数2位 txtFPrice.Text = double.Parse( dr["PFPrice"].ToString() ).ToString("f2"); txtNPrice.Text = double.Parse( dr["PNPrice"].ToString() ).ToString("f2"); txtBewrite.Text = CleanString.htmlOutputText( dr["PBewrite"].ToString() ); txtUseMode.Text = CleanString.htmlOutputText( dr["PUseMode"].ToString() ); txtValidity.Text = CleanString.htmlOutputText( dr["PValidity"].ToString() ); try//分类 { ddlCategory.SelectedValue = dr["CID"].ToString(); } catch { ddlCategory.SelectedIndex = 0; } } dr.Close(); myDB1.Close(); } }
private void getCategory() { DBConn myDB = new DBConn(); string sql="select * from Category"; ddlCategory.DataSource = myDB.getDataReader(sql); ddlCategory.DataTextField = "CName"; ddlCategory.DataValueField = "CID"; ddlCategory.DataBind(); myDB.Close(); }
private void getVData() { string sql="select * from Products Left Outer join Category on Products.CID = Category.CID where PCommend=1 order by PID desc"; DBConn myDB = new DBConn(); DataGrid1.DataSource = myDB.getDataReader(sql); DataGrid1.DataBind(); myDB.Close(); }
private void getddlClassData()//绑定类别 { DBConn myDB = new DBConn(); string sql="select * from Category order by CID desc"; ddlClass.DataSource = myDB.getDataReader(sql); ddlClass.DataTextField = "CName"; ddlClass.DataBind(); myDB.Close(); ddlClass.Items.Insert(0,new ListItem("所有分类","-1")); }
private void getDataCount() { string mySql="select count(*) as [num] from [message] where MState=" + ViewState["MState"].ToString(); DBConn myDB = new DBConn(); SqlDataReader mydr = myDB.getDataReader( mySql ); if( mydr.Read() ) { lblNum.Text = mydr["num"].ToString(); } mydr.Close(); myDB.Close(); }
private void getAnnounce() { string mySql="select * from append where id='3'"; DBConn myDB = new DBConn(); SqlDataReader mydr = myDB.getDataReader( mySql ); if( mydr.Read() ) { txtAnnounce.Text = CleanString.htmlOutputText( mydr["text"].ToString() ); } mydr.Close(); myDB.Close(); }
protected void btnOk_Click(object sender, System.EventArgs e) { string strAnnounce = CleanString.htmlInputText( txtAnnounce.Text ); string mySql="update [Append] set [text]='" + strAnnounce + "' where [id]='3'"; DBConn myDB = new DBConn(); int iNum = myDB.ExecuteNonQuery( mySql ); myDB.Close(); if( iNum == 1 ) { Response.Write("<script>"); Response.Write("alert('[公告栏] 修改成功!!!');"); Response.Write("</script>"); } }
private bool checkAdmin( string strAdmin ) { bool bTemp = false; DBConn myDB = new DBConn(); string mySql = "select * from admin where username='******'"; SqlDataReader mydr = myDB.getDataReader( mySql ); if( mydr.Read() ) { bTemp = true; } else { bTemp = false; } mydr.Close(); myDB.Close(); return bTemp; }
protected void EditButton_Click(object sender, EventArgs e) {//修改记录 if (CheckPut() ) { string sSql = "Update tblMode set 名称= '" + txtTitle.Text.Trim() + "',备注='" + txtRate.Text.Trim() + "' where id=" + EditButton.ToolTip; DBConn myDB1 = new DBConn(); myDB1.ExecuteNonQuery(sSql ); myDB1.Close(); } BindGrid(); txtRate.Text = " "; txtTitle.Text = " "; AddButton.Visible = true; EditButton.Visible = false; }
private void getPData()//获取ID对应的二手书信息 { string strID = ViewState["PID"].ToString(); DBConn myDB1 = new DBConn(); string sqlP = "select PName,PStock,PSellNum from Products where PID=" + strID; SqlDataReader dr = myDB1.getDataReader(sqlP); if (dr.Read()) { lblPName.Text = dr["PName"].ToString(); lblPStock.Text = dr["PStock"].ToString(); lblPSellNum.Text = dr["PSellNum"].ToString(); } dr.Close(); myDB1.Close(); }
private void getData( string strID ) { string mySql = "select * from message where MID=" + strID; DBConn myDB = new DBConn(); SqlDataReader mydr = myDB.getDataReader( mySql ); if( mydr.Read() ) { lblUName.Text = mydr["UName"].ToString(); lblUPhone.Text = mydr["UPhone"].ToString(); string strUEmail = mydr["UEmail"].ToString(); lblUEmail.Text = "<a href='mailto:" + strUEmail + "'>" + strUEmail + "</a>"; lblMTitle.Text = mydr["MTitle"].ToString(); txtMContent.Text = CleanString.htmlOutputText( mydr["MContent"].ToString() ); lblDate.Text = mydr["Pubdate"].ToString(); } mydr.Close(); myDB.Close(); }
protected void ShowTodoList() { string selectString = "SELECT * FROM schedule"; selectString += "WHERE u_name=@user AND date=@date ORDER BY time"; DBConn conn = new DBConn(); SqlCommand cmd = new SqlCommand(selectString, conn.GetConn()); cmd.Parameters.AddWithValue("@user", Membership.GetUser().UserName); cmd.Parameters.AddWithValue("@date", string.Format("{0:yyyy-MM-dd}", selectedDate)); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ShowTodo(dr["serial_no"].ToString(), dr["time"].ToString(), dr["todo"].ToString(), dr["has_done"].ToString()); } dr.Close(); conn.Close(); }
private bool isAdmin(string strAdmin, string strPassword) { bool bTemp = false; DBConn myDB = new DBConn(); string mySql = "select * from tblUser where UserName='******' and Psw='" + strPassword + "'"; SqlDataReader mydr = myDB.getDataReader(mySql); if (mydr.Read()) { bTemp = true; } else { bTemp = false; } mydr.Close(); myDB.Close(); return(bTemp); }
protected void rdPreguntaRanking_UpdateCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { GridEditableItem editedItem = e.Item as GridEditableItem; string sCodPregRanking = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["cod_preg_ranking"].ToString(); string sPregRanking = (editedItem["PregRanking"].Controls[0] as TextBox).Text; try { DBConn oConn = new DBConn(); if (oConn.Open()) { AppPregRanking oPregRanking = new AppPregRanking(ref oConn); oPregRanking.CodPregRanking = sCodPregRanking; oPregRanking.PregRanking = sPregRanking; oPregRanking.Accion = "EDITAR"; oPregRanking.Put(); if (string.IsNullOrEmpty(oPregRanking.Error)) { oPregRanking.SerializaTblPregRanking(ref oConn, Server.MapPath(".") + @"\binary\"); } else { rdPreguntaRanking.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + oPregRanking.Error)); e.Canceled = true; } oConn.Close(); } else { rdPreguntaRanking.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + oConn.Error)); e.Canceled = true; } } catch (Exception ex) { rdPreguntaRanking.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + ex.Message)); e.Canceled = true; } }
protected void btnSave_Click(object sender, EventArgs e) { DBConn oConn = new DBConn(); if (oConn.Open()) { SysParamEmail oParamEmail = new SysParamEmail(ref oConn); oParamEmail.TipoEmail = rdCmbEmails.SelectedValue; oParamEmail.NomEmail = txtNomEmail.Text; oParamEmail.AsuntoEmail = txtAsunto.Text; oParamEmail.CuerpoEmail = rdCuerpoEmail.Content; oParamEmail.Accion = hdd_accion.Value; oParamEmail.Put(); if (string.IsNullOrEmpty(oParamEmail.Error)) { oParamEmail.Path = Server.MapPath(".") + @"\binary\"; oParamEmail.TipoEmail = string.Empty; oParamEmail.SerializaParamEmail(); } oConn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { oWeb.ValidaSessionAdm(); if (!IsPostBack) { CodCliente.Value = oWeb.GetData("CodCliente"); DBConn oConn = new DBConn(); if (oConn.Open()) { cSysUsuario oSysUsuario = new cSysUsuario(ref oConn); oSysUsuario.CodUser = CodCliente.Value; DataTable dtUser = oSysUsuario.GetSysUsuario(); if (dtUser != null) { Label1.Text = dtUser.Rows[0]["nom_user"].ToString() + " " + dtUser.Rows[0]["ape_user"].ToString(); } dtUser = null; } oConn.Close(); Load_ListBox(); } }
protected void btnGrabar2_Click(object sender, EventArgs e) { try { DBConn oConn = new DBConn(); if (oConn.Open()) { string sFile = string.Empty; StringBuilder sPath = new StringBuilder(); sPath.Append(Server.MapPath(".")); sPath.Append(@"\images\logos\"); cAppLogoCliente oAppLogoCliente = new cAppLogoCliente(ref oConn); oAppLogoCliente.NKey_cliente = CodCliente.Value; oAppLogoCliente.LogoCliente = string.Empty; oAppLogoCliente.Tipo = string.Empty; DataTable dtlogo = oAppLogoCliente.Get(); if (dtlogo != null) { sFile = dtlogo.Rows[0]["logo_cliente"].ToString(); sPath.Append(sFile); File.Delete(sPath.ToString()); } dtlogo = null; oAppLogoCliente.Accion = "EDITAR"; oAppLogoCliente.Put(); getImage("nada.jpg"); } oConn.Close(); } catch (Exception Ex) { Response.Write("Error: " + Ex.Message); } }
protected void getMenuAntalis(System.Web.UI.HtmlControls.HtmlGenericControl oHtmControl, string pCoduser) { DBConn oConn = new DBConn(); if (oConn.Open()) { SyrPerfilesUsuarios oSysPerfilesUsuarios = new SyrPerfilesUsuarios(ref oConn); oSysPerfilesUsuarios.CodUsuario = pCoduser; oSysPerfilesUsuarios.CodPerfil = "7"; DataTable dtPerfil = oSysPerfilesUsuarios.Get(); if (dtPerfil != null) { if (dtPerfil.Rows.Count > 0) { cAntsUsuarios oAntsUsuarios = new cAntsUsuarios(ref oConn); oAntsUsuarios.CodUsuario = pCoduser; DataTable dtAntRoles = oAntsUsuarios.GetRoles(); if (dtAntRoles != null) { foreach (DataRow oRow in dtAntRoles.Rows) { if (oRow["cod_rol"].ToString() == "1") { oHtmControl.Controls.Add(new LiteralControl("<li><a href='../antalis/pagos_antalis.aspx'>Ingreso de Pago</a></li>")); } if (oRow["cod_rol"].ToString() == "2") { oHtmControl.Controls.Add(new LiteralControl("<li><a href='../antalis/controllerpagos.aspx'>Validación de Pago</a></li>")); } } } dtAntRoles = null; oHtmControl.Controls.Add(new LiteralControl("<li><a href='../antalis/reportevalijas.aspx'>Valijas Validadas</a></li>")); } } dtPerfil = null; } oConn.Close(); }
protected void rdContenido_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { DBConn oConn = new DBConn(); if (oConn.Open()) { CmsContenidos oContenidos = new CmsContenidos(ref oConn); oContenidos.CodNodo = CodNodo.Value; GridColumn oGridColumn; oGridColumn = rdContenido.MasterTableView.Columns.FindByUniqueName("NomContenido"); oGridColumn.HeaderText = oCulture.GetResource("Contenido", "NomContenido"); oGridColumn = rdContenido.MasterTableView.Columns.FindByUniqueName("EstContenido"); oGridColumn.HeaderText = oCulture.GetResource("Contenido", "EstContenido"); rdContenido.DataSource = oContenidos.Get(); oConn.Close(); } }
protected void rdTemplate_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { DBConn oConn = new DBConn(); if (oConn.Open()) { CmsTemplate oTemplate = new CmsTemplate(ref oConn); oTemplate.Get(); GridColumn oGridColumn; oGridColumn = rdTemplate.MasterTableView.Columns.FindByUniqueName("NomTemplate"); oGridColumn.HeaderText = oCulture.GetResource("Template", "NomTemplate"); oGridColumn = rdTemplate.MasterTableView.Columns.FindByUniqueName("EstTemplate"); oGridColumn.HeaderText = oCulture.GetResource("Template", "EstTemplate"); rdTemplate.DataSource = oTemplate.Get(); oConn.Close(); } }
protected void rdUsuarios_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { switch (e.CommandName) { case "cmdEliminar": string CodCentroDist = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["cod_centrodist"].ToString(); DBConn oConn = new DBConn(); if (oConn.Open()) { cAntCentrosDistribucion oCentrosDistribucion = new cAntCentrosDistribucion(ref oConn); oCentrosDistribucion.CodUsuario = CodUsuario.Value; oCentrosDistribucion.CodCentroDist = CodCentroDist; oCentrosDistribucion.Accion = "ELIMINAR"; oCentrosDistribucion.Put(); rdUsuarios.Rebind(); rdCentrosDistribucion.Rebind(); UpdatePanel2.Update(); } oConn.Close(); break; } }
protected void cmbox_contrato_SelectedIndexChanged(object sender, EventArgs e) { if (cmbox_contrato.SelectedValue != "0") { DBConn oConn = new DBConn(); if (oConn.Open()) { cFactura oFactura = new cFactura(ref oConn); oFactura.NumContrato = cmbox_contrato.SelectedValue; oFactura.isNullComprobante = true; DataTable dtComprobanteImpuesto = oFactura.Get(); if (dtComprobanteImpuesto != null) { if (dtComprobanteImpuesto.Rows.Count > 0) { ddlmesventa.Items.Clear(); ddlmesventa.Items.Add(new ListItem("<< Seleccione Periodo >>", "0")); foreach (DataRow oRow in dtComprobanteImpuesto.Rows) { ddlmesventa.Items.Add(new ListItem(oRow["periodo"].ToString(), oRow["codigo_factura"].ToString())); } } else { ddlmesventa.Items.Clear(); ddlmesventa.Items.Add(new ListItem("<< No existen meses a declarar >>", "0")); } } dtComprobanteImpuesto = null; } oConn.Close(); } else { ddlmesventa.Items.Clear(); ddlmesventa.Items.Add(new ListItem("<< No existen meses a declarar >>", "0")); } }
protected void LoadGrid() { DBConn oConn = new DBConn(); if (oConn.Open()) { cCliente oCliente = new cCliente(ref oConn); oCliente.CodMonitor = CodMonitorView.Value; //oCliente.CodPage = hddCodPage.Value; oCliente.CodPage = oCmbPages.SelectedValue; if (string.IsNullOrEmpty(bVista.Value)) { GridClientes.DataSource = oCliente.GetClientByPageMonitor(); } else { GridClientes.DataSource = oCliente.GetHoldingByPageMonitor(); } GridClientes.DataBind(); } oConn.Close(); }
public DataTable getDatatble() { DataTable dt = null; DBConn oConn = new DBConn(); if (oConn.Open()) { cProyeccionPago oProyeccionPago = new cProyeccionPago(ref oConn); oProyeccionPago.CodDeudor = hddCodDeudor.Value; oProyeccionPago.CodNkey = ((!string.IsNullOrEmpty(cmbCliente.SelectedValue) ? cmbCliente.SelectedValue : hdd_arrNkeyCliente.Value)); oProyeccionPago.NcodHolding = cmbHolding.SelectedValue; oProyeccionPago.NkeyUsuario = oIsUsuario.NKeyUsuario; oProyeccionPago.TipoUsuario = oIsUsuario.TipoUsuario; oProyeccionPago.DtFchIni = DateTime.Parse(RadDatePicker1.SelectedDate.ToString()).ToString("yyyyMMdd"); oProyeccionPago.DtFchFin = DateTime.Parse(RadDatePicker2.SelectedDate.ToString()).ToString("yyyyMMdd"); dt = oProyeccionPago.Get(); } oConn.Close(); return(dt); }
/// <summary> /// restituisce la lista di oggetti /// </summary> /// <param name="id">di deafualt a zero (prende tutti e record), altrimenti recupera l'id indicato</param> /// <returns></returns> public List <Servizio> select(int id = 0) { List <Servizio> servizi = new List <Servizio>(); DBConn d = new DBConn(); string q = (id > 0) ? "select * from servizi where id_servizio = " + id + " order by sigla_servizio" : "select * from servizi order by sigla_servizio"; DataTable dt = d.Select(q); foreach (DataRow dr in dt.Rows) { servizi.Add(new Servizio( Convert.ToInt16(dr[0]), Convert.ToString(dr[1]), Convert.ToString(dr[2]) )); } d.Close(); return(servizi); }
protected void rdCampoUsuarios_DeleteCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { DBConn oConn = new DBConn(); if (oConn.Open()) { string pCodCampo = (e.Item.ItemIndex > -1 ? e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["cod_campo"].ToString() : string.Empty); SyrCampoOpciones oCampoOpciones = new SyrCampoOpciones(ref oConn); oCampoOpciones.CodCampo = pCodCampo; oCampoOpciones.Accion = "ELIMINAR"; oCampoOpciones.Put(); SyrInfoUsuarios oInfoUsuarios = new SyrInfoUsuarios(ref oConn); oInfoUsuarios.CodCampo = pCodCampo; oInfoUsuarios.Accion = "ELIMINAR"; oInfoUsuarios.Put(); SysUsuario oUsuario = new SysUsuario(ref oConn); DataTable dUsuario = oUsuario.Get(); if (dUsuario.Rows.Count > 0) { foreach (DataRow oRow in dUsuario.Rows) { oInfoUsuarios.CodUsuario = oRow["cod_usuario"].ToString(); oInfoUsuarios.SerializaTblInfoUsuario(ref oConn, Server.MapPath(".") + @"\binary\", "InfoUsuario_" + oRow["cod_usuario"].ToString() + ".bin"); } } dUsuario = null; SysCampoUsuarios oCampoUsuarios = new SysCampoUsuarios(ref oConn); oCampoUsuarios.CodCampo = pCodCampo; oCampoUsuarios.Accion = "ELIMINAR"; oCampoUsuarios.Put(); oCampoUsuarios.SerializaTblCmpUsuario(ref oConn, Server.MapPath(".") + @"\binary\", "CampoUsuarios.bin"); oConn.Close(); } }
protected void rdPreguntaRanking_InsertCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item; string sPregRanking = (insertedItem["PregRanking"].Controls[0] as TextBox).Text; try { DBConn oConn = new DBConn(); if (oConn.Open()) { AppPregRanking oPregRanking = new AppPregRanking(ref oConn); oPregRanking.EstPregRanking = "V"; oPregRanking.PregRanking = sPregRanking; oPregRanking.Accion = "CREAR"; oPregRanking.Put(); if (string.IsNullOrEmpty(oPregRanking.Error)) { oPregRanking.SerializaTblPregRanking(ref oConn, Server.MapPath(".") + @"\binary\"); } else { rdPreguntaRanking.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + oPregRanking.Error)); e.Canceled = true; } oConn.Close(); } else { rdPreguntaRanking.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + oConn.Error)); e.Canceled = true; } } catch (Exception ex) { rdPreguntaRanking.Controls.Add(new LiteralControl("Unable to insert Employee. Reason: " + ex.Message)); e.Canceled = true; } }
protected void btnGrabar_Click(object sender, EventArgs e) { oIsUsuario = oWeb.GetObjUsuario(); DBConn oConn = new DBConn(); if (oConn.Open()) { AppBanner oBanner = new AppBanner(ref oConn); oBanner.CodBanner = CodBanner.Value; oBanner.NomBanner = txtTituloBanner.Text; oBanner.TipoBanner = rdCmbTipoBanner.SelectedValue; oBanner.EstBanner = rdCmbEstado.SelectedValue; oBanner.Accion = (string.IsNullOrEmpty(CodBanner.Value) ? "CREAR" : "EDITAR"); oBanner.Put(); CodBanner.Value = oBanner.CodBanner; if (string.IsNullOrEmpty(oBanner.Error)) { oConn.Commit(); StringBuilder cPath = new StringBuilder(); cPath.Append(Server.MapPath(".")).Append(@"\binary\"); oBanner.CodBanner = string.Empty; oBanner.SerializaBanner(ref oConn, cPath.ToString()); Image.Visible = true; AppImgBanner oImgBanner = new AppImgBanner(ref oConn); cPath = new StringBuilder(); cPath.Append(Server.MapPath(".")).Append(@"\binary\"); oImgBanner.SerializaImgBanner(ref oConn, cPath.ToString()); } else { oConn.Rollback(); } oConn.Close(); } rdImage.Rebind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { msg.Text = ""; } if (Request["mode"] != null) { if (Request["mode"].ToString() == "modify") { lbltitle.Text = "회원 정보 수정"; string sql = "select * from member where m_id='" + Session["id"].ToString() + "'"; DBConn conn = new DBConn(); OleDbCommand cmd = new OleDbCommand(sql, conn.GetConn()); OleDbDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { txtID.Text = reader["m_id"].ToString(); txtName.Text = reader["m_name"].ToString(); txtEmail.Text = reader["m_email"].ToString(); txtPhone.Text = reader["m_phone"].ToString(); txtID.Enabled = false; txtName.Enabled = false; Button1.Visible = false; } reader.Close(); conn.Close(); } } else { lbltitle.Text = "회원가입"; } }
protected void Page_Load(object sender, System.EventArgs e) { //权限检查 if (Session["adminName"] == null || Session["adminName"].ToString() == String.Empty) { Response.Write("<font color=#ff0000>对不起,您没足够权限访问此页!!</font>"); Response.Write("<a href=index.aspx>重新登陆</a>"); Response.End(); return; } if (!IsPostBack) { if (Request.QueryString["id"] == null) { Response.Write("没有这个二手书"); Response.End(); } string strID = Request.QueryString["id"].ToString().Trim(); if (strID == String.Empty) { strID = "-1"; } DBConn myDB1 = new DBConn(); string sqlP = "select PName from Products where PID=" + strID; SqlDataReader dr = myDB1.getDataReader(sqlP); if (dr.Read()) { lblName.Text = dr["PName"].ToString(); } dr.Close(); myDB1.Close(); ViewState["PID"] = strID; } }
protected void Page_Load(object sender, System.EventArgs e) { //权限检查 if( Session["adminName"]==null || Session["adminName"].ToString() == String.Empty ) { Response.Write("<font color=#ff0000>对不起,您没足够权限访问此页!!</font>"); Response.Write("<a href=index.aspx>重新登陆</a>"); Response.End(); return; } if( !IsPostBack ) { if( Request.QueryString["id"] == null) { Response.Write("没有这个二手书"); Response.End(); } string strID = Request.QueryString["id"].ToString().Trim(); if( strID == String.Empty ) { strID = "-1"; } DBConn myDB1 = new DBConn(); string sqlP="select PName from Products where PID=" + strID; SqlDataReader dr = myDB1.getDataReader(sqlP); if( dr.Read() ) { lblName.Text = dr["PName"].ToString(); } dr.Close(); myDB1.Close(); ViewState["PID"] = strID; } }
public static void webMethodCall(string DataKeyValues, string CodPage, string CodCliente) { string[] ListID = DataKeyValues.Split('|'); DBConn oConn = new DBConn(); if (oConn.Open()) { cAptPagesKpi oAptPagesKpi = new cAptPagesKpi(ref oConn); oAptPagesKpi.CodCliente = CodCliente; oAptPagesKpi.CodPage = CodPage; oAptPagesKpi.Accion = "ELIMINAR"; oAptPagesKpi.Put(); oAptPagesKpi.Accion = "CREAR"; for (int i = 0; i < ListID.Length; i++) { oAptPagesKpi.CodKpi = ListID[i].ToString(); oAptPagesKpi.Put(); } } oConn.Close(); }
private bool isAdmin( string strAdmin, string strPassword ) { bool bTemp = false; strPassword = FormsAuthentication.HashPasswordForStoringInConfigFile( strPassword ,"MD5"); DBConn myDB = new DBConn(); string mySql = "select * from admin where username='******' and password='******'"; SqlDataReader mydr = myDB.getDataReader( mySql ); if( mydr.Read() ) { bTemp = true; } else { bTemp = false; } mydr.Close(); myDB.Close(); return bTemp; }
protected void rdClienteUsuario_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { switch (e.CommandName) { case "cmdDelete": string pNkeyCliente = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["nkey_user"].ToString(); DBConn oConn = new DBConn(); if (oConn.Open()) { SysClienteUsuario oClienteUsuario = new SysClienteUsuario(ref oConn); oClienteUsuario.CodUsuario = CodUsuario.Value; oClienteUsuario.NkeyUser = pNkeyCliente; oClienteUsuario.Accion = "ELIMINAR"; oClienteUsuario.Put(); oConn.Close(); } rdClienteUsuario.Rebind(); rdCliente.Rebind(); UpdatePanel2.Update(); break; } }
protected void rdReportesUsuario_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { DBConn oConn = new DBConn(); if (oConn.Open()) { GridColumn oGridColumn; oGridColumn = rdReportesUsuario.MasterTableView.Columns.FindByUniqueName("NomConsulta"); oGridColumn.HeaderText = oCulture.GetResource("Reportes", "NomConsulta"); cDebtUsrAsignados oDebtUsrAsignados = new cDebtUsrAsignados(ref oConn); oDebtUsrAsignados.CodUsuario = CodUsuario.Value; oDebtUsrAsignados.NOTIn = true; if (!string.IsNullOrEmpty(txtBuscar.Text)) { oDebtUsrAsignados.NomConsulta = txtBuscar.Text; } rdReportesUsuario.DataSource = oDebtUsrAsignados.GetConsultaByUsuario(); oConn.Close(); } }
public DataTable getDatatble() { DataTable dt = null; DBConn oConn = new DBConn(); if (oConn.Open()) { cResumenCobranza oResumenCobranza = new cResumenCobranza(ref oConn); oResumenCobranza.CodDeudor = hddCodDeudor.Value; oResumenCobranza.CodNkey = ((!string.IsNullOrEmpty(cmbCliente.SelectedValue) ? cmbCliente.SelectedValue : hdd_arrNkeyCliente.Value)); oResumenCobranza.NcodHolding = cmbHolding.SelectedValue; oResumenCobranza.NkeyUsuario = oIsUsuario.NKeyUsuario; oResumenCobranza.TipoUsuario = oIsUsuario.TipoUsuario; oResumenCobranza.NumPago = rdTxtNumPago.Text; oResumenCobranza.DtFchIni = DateTime.Parse(RadDatePicker3.SelectedDate.ToString()).ToString("yyyyMMdd"); oResumenCobranza.DtFchFin = DateTime.Parse(RadDatePicker4.SelectedDate.ToString()).ToString("yyyyMMdd"); dt = oResumenCobranza.Get(); } oConn.Close(); return(dt); }
// Получить данные о работниках public static List <string> GetEmployee(int Current) { List <string> ResultList = new List <string>(); DBConn.Open(); // Поиск работников кроме текущего DBComm.CommandText = @"SELECT Name, Login, Position FROM Employee INNER JOIN Accounts ON Accounts.ID = Employee.AccID WHERE Employee.ID != @EI"; DBComm.Parameters.AddWithValue("@EI", Current); SQLiteDataReader Reader = DBComm.ExecuteReader(); while (Reader.Read()) { ResultList.Add(Reader.GetString(0) + ";" + Reader.GetString(1) + ";" + Reader.GetString(2)); } Reader.Close(); DBConn.Close(); return(ResultList); }
// Получить информацию о родителе public static object[] ReadParentInfo(int ID) { object[] ResultArray = new object[3]; DBConn.Open(); DBComm.CommandText = @"SELECT Name, Phone, Email FROM Parent WHERE ID == @PI"; DBComm.Parameters.AddWithValue("@PI", ID); // Выполнение запроса SQLiteDataReader Reader = DBComm.ExecuteReader(); while (Reader.Read()) { ResultArray[0] = Reader.GetString(0); ResultArray[1] = Reader.GetString(1); ResultArray[2] = Reader.GetString(2); } Reader.Close(); DBConn.Close(); return(ResultArray); }
// Получить минимальный класс ребенка в группе public static int GetGroupGrade(string GroupName) { DBConn.Open(); // Поиск детей из группы с указанным названием DBComm.CommandText = @"SELECT MIN(Grade) FROM Child WHERE GroupID IN (SELECT ID FROM 'Group' WHERE Name = @GN)"; DBComm.Parameters.AddWithValue("@GN", GroupName); SQLiteDataReader Reader = DBComm.ExecuteReader(); int Grade = 0; while (Reader.Read()) { Grade = Reader.GetInt32(0); } Reader.Close(); DBConn.Close(); return(Grade); }
// Получить контактные данные преподавателей public static List <MailAddress> GetEmployeeEmail(string GroupName) { List <MailAddress> ResultList = new List <MailAddress>(); DBConn.Open(); // Поиск родителей, указавших адрес электронной почты и чьи дети учатся в группе с измененным расписанием DBComm.CommandText = @"SELECT Email, Name FROM Employee WHERE Email IS NOT NULL AND ID IN (SELECT EduID FROM 'Group' WHERE Name = @GN)"; DBComm.Parameters.AddWithValue("@GN", GroupName); SQLiteDataReader Reader = DBComm.ExecuteReader(); while (Reader.Read()) { ResultList.Add(new MailAddress(Reader.GetString(0), Reader.GetString(1))); } Reader.Close(); DBConn.Close(); return(ResultList); }
protected void rdReportesUsuario_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { switch (e.CommandName) { case "cmdDelete": string pCodConsulta = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["cod_consulta"].ToString(); DBConn oConn = new DBConn(); if (oConn.Open()) { cDebtUsrAsignados oDebtUsrAsignados = new cDebtUsrAsignados(ref oConn); oDebtUsrAsignados.CodUsuario = CodUsuario.Value; oDebtUsrAsignados.CodConsulta = pCodConsulta; oDebtUsrAsignados.Accion = "ELIMINAR"; oDebtUsrAsignados.Put(); oConn.Close(); } rdReportesUsuario.Rebind(); rdReportesNotIn.Rebind(); UpdatePanel2.Update(); break; } }
protected void rdPerfilUsuario_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { switch (e.CommandName) { case "cmdDelete": string pCodUsuario = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["cod_user"].ToString(); DBConn oConn = new DBConn(); if (oConn.Open()) { SyrPerfilesUsuarios oPerfilesUsuarios = new SyrPerfilesUsuarios(ref oConn); oPerfilesUsuarios.CodUsuario = pCodUsuario; oPerfilesUsuarios.CodPerfil = CodPerfil.Value; oPerfilesUsuarios.Accion = "ELIMINAR"; oPerfilesUsuarios.Put(); oConn.Close(); } rdPerfilUsuario.Rebind(); rdUsuarios.Rebind(); UpdatePanel2.Update(); break; } }
protected void Page_Load(object sender, EventArgs e) { DBConn oConn = new DBConn(); if (oConn.Open()) { cSysUsuario oSysUsuario = new cSysUsuario(ref oConn); DataTable dtSysUsuario = oSysUsuario.GetSysUsuario(); if (dtSysUsuario != null) { if (dtSysUsuario.Rows.Count > 0) { foreach (DataRow oRow in dtSysUsuario.Rows) { Response.Write(oRow["nom_user"].ToString() + " " + oRow["ape_user"].ToString() + " - " + fUnCrypt(oRow["pwd_user"].ToString())); Response.Write("<br>"); } } } } oConn.Close(); }
protected void btnFind_Click(object sender, EventArgs e) { string sql = "select m_id from member where m_phone='" + txtNameID.Text + "'"; DBConn conn = new DBConn(); OleDbCommand cmd = new OleDbCommand(sql, conn.GetConn()); OleDbDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { idcheck = reader["m_id"].ToString(); lblResult.Text = idcheck; } else { lblResult.Text = "검색 결과가 없습니다."; } reader.Close(); conn.Close(); }
protected void btnOK_Click(object sender, System.EventArgs e) { string strName = txtAdmin.Text; string strPassword = txtPassword.Text; string strRPassword = txtRPassword.Text; if( strName == String.Empty ) { Response.Write("<script>"); Response.Write("alert('请输入管理名!!!');"); Response.Write("</script>"); return; } if( strPassword == String.Empty ) { Response.Write("<script>"); Response.Write("alert('请输入密码!!!');"); Response.Write("</script>"); return; } if( strRPassword == String.Empty ) { Response.Write("<script>"); Response.Write("alert('请输入确认密码!!!');"); Response.Write("</script>"); return; } if( txtPassword.Text.Length < 6 ) { Response.Write("<script>"); Response.Write("alert('密码长度至少6位!!!');"); Response.Write("</script>"); return; } strPassword = FormsAuthentication.HashPasswordForStoringInConfigFile( strPassword ,"MD5"); DBConn myDB = new DBConn(); string mySql = "UPDATE [admin] SET [password]='" + strPassword + "' WHERE [username]='" + strName + "'"; int iTemp = myDB.ExecuteNonQuery( mySql ); myDB.Close(); if( iTemp != 0 ) { Response.Write("<script>"); Response.Write("alert('您的密码修改成功!!!');"); Response.Write("</script>"); } else { Response.Write("<script>"); Response.Write("alert('密码修改失败!!!');"); Response.Write("</script>"); } }
private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string strid = e.Item.Cells[0].Text; DBConn myDB = new DBConn(); string sql="update Products set PCommend=0 where PID="+strid; myDB.ExecuteNonQuery(sql); myDB.Close(); getPData(); getVData(); }
private void getOrderData( string strOID ) { DBConn myDB = new DBConn(); string sql="select * from [Order] where OID='" + strOID + "'"; SqlDataReader dr = myDB.getDataReader( sql ); if( dr.Read() ) { lblOrderID.Text = dr["OID"].ToString(); lblTName.Text = dr["TName"].ToString(); string strEmail = dr["Email"].ToString(); lblEmail.Text = "<a href='mailto:" + strEmail + "'>" + strEmail + "</a>"; lblPhone.Text = dr["Phone"].ToString(); lblPID.Text = dr["PID"].ToString(); lblPName.Text = dr["PName"].ToString(); lblPPrice.Text = double.Parse( dr["PPrice"].ToString() ).ToString("C"); lblPNum.Text = dr["PNum"].ToString(); lblTotalPrice.Text = double.Parse( dr["TotalPrice"].ToString() ).ToString("C"); lblPubdate.Text = dr["Pubdate"].ToString(); lblOState.Text = dr["OState"].ToString(); if (lblPID.Text=="0") lblDetailP.Text = "<a href='../P_OderInfo.aspx?id=" + dr["OID"].ToString() + "' target='_blank'>查看批量购买的产品详情</a>"; } /*else { Response.Write("<script>"); Response.Write("alert('没有订单编号为[ " + strOID + " ]这条记录!!!');"); Response.Write("</script>"); }*/ dr.Close(); myDB.Close(); }
protected void btnOK_Click(object sender, System.EventArgs e) { string strName = txtName.Text; string strPassword = txtPassword.Text.Trim(); if( strPassword == String.Empty ) { Response.Write("<script>"); Response.Write("alert('请输入管理员密码!!!');"); Response.Write("</script>"); return; } if( isAdmin( strName, strPassword ) ) { DBConn myDB = new DBConn(); string mySql = "delete from [Order]"; myDB.ExecuteNonQuery( mySql ); string sql = "delete from [tblP_Order]"; myDB.ExecuteNonQuery(sql ); myDB.Close(); Response.Write("<script>"); Response.Write("alert('清空所有订单记录 成功!!!');"); Response.Write("</script>"); } else { Response.Write("<script>"); Response.Write("alert('请输入正确的 管理员密码!!!');"); Response.Write("</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { string strID = Request.QueryString["id"]; string iNum; if (txtN.Text == String.Empty) { Response.Write("<script>"); Response.Write("alert('请填写入货数量!!!');"); Response.Write("</script>"); return; } iNum = this.txtN.Text; DBConn myDB2 = new DBConn(); string mySql = "update Products set PStock=PStock+" + iNum + " where PID=" + strID; myDB2.ExecuteNonQuery( mySql ); // mySql = "Insert into tblLog(Pid,isN) values ( '" + strID + "', '" + iNum + "')"; mySql = "update tblLog set isN=isN+" + iNum + "where PID=" + strID; myDB2.ExecuteNonQuery( mySql ); myDB2.Close(); Response.Write("<script>"); Response.Write("alert('提交成功数据!!!');location.href='productAlter.aspx';"); Response.Write("</script>"); }
private void adminDataGrid_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string strAdmin = e.Item.Cells[1].Text; DBConn myDB = new DBConn(); string sql="Delete from admin where username='******'"; myDB.ExecuteNonQuery(sql); myDB.Close(); getData(); }
private void messageDataGrid_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string strid = e.Item.Cells[0].Text; DBConn myDB = new DBConn(); string sql="Delete from [message] where MID="+strid; myDB.ExecuteNonQuery(sql); myDB.Close(); getData(); }
protected void btnAdd_Click(object sender, System.EventArgs e) { string strName = txtName.Text; string strPassword = txtPassword.Text; string strRPassword = txtRPassword.Text; if( strName == String.Empty ) { Response.Write("<script>"); Response.Write("alert('请输入管理名!!!');"); Response.Write("</script>"); return; } if( strPassword == String.Empty ) { Response.Write("<script>"); Response.Write("alert('请输入密码!!!');"); Response.Write("</script>"); return; } if( strRPassword == String.Empty ) { Response.Write("<script>"); Response.Write("alert('请输入确认密码!!!');"); Response.Write("</script>"); return; } if( checkAdmin( strName ) ) { Response.Write("<script>"); Response.Write("alert('管理员[ " + strName + " ]已经存在!!!');"); Response.Write("</script>"); return; } if( txtPassword.Text.Length < 6 ) { Response.Write("<script>"); Response.Write("alert('密码长度至少6位!!!');"); Response.Write("</script>"); return; } strPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(strPassword, "MD5"); DBConn myDB = new DBConn(); string mySql = "INSERT INTO [Admin]([username],[password],[addtime]) VALUES('" + strName + "','" + strPassword + "','" + DateTime.Now + "')"; myDB.ExecuteNonQuery( mySql ); myDB.Close(); txtName.Text = ""; Response.Write("<script>"); Response.Write("alert('管理员添加成功!!!');"); Response.Write("</script>"); }
protected void btnOK_Click(object sender, System.EventArgs e) { string strName = txtName.Text; string strPassword = txtPassword.Text.Trim(); if( strPassword == String.Empty ) { Response.Write("<script>"); Response.Write("alert('请输入管理员密码!!!');"); Response.Write("</script>"); return; } if( txtPassword.Text.Length < 6 ) { Response.Write("<script>"); Response.Write("alert('密码长度至少6位!!!');"); Response.Write("</script>"); return; } if( isAdmin( strName, strPassword ) ) { DBConn myDB = new DBConn(); string mySql = "DELETE FROM [Category]"; myDB.ExecuteNonQuery( mySql ); mySql = "DELETE FROM [Message]"; myDB.ExecuteNonQuery( mySql ); mySql = "DELETE FROM [Order]"; myDB.ExecuteNonQuery( mySql ); mySql = "DELETE FROM [Products]"; myDB.ExecuteNonQuery(mySql); mySql = "DELETE FROM [tblBasket]"; myDB.ExecuteNonQuery(mySql); mySql = "DELETE FROM [tblFav]"; myDB.ExecuteNonQuery(mySql); mySql = "DELETE FROM [tblLeaveWord]"; myDB.ExecuteNonQuery(mySql); mySql = "DELETE FROM [tblLog]"; myDB.ExecuteNonQuery(mySql); mySql = "DELETE FROM [tblMode]"; myDB.ExecuteNonQuery(mySql); mySql = "DELETE FROM [tblP_Order]"; myDB.ExecuteNonQuery(mySql); mySql = "DELETE FROM [tblUser]"; myDB.ExecuteNonQuery( mySql ); myDB.Close(); Response.Write("<script>"); Response.Write("alert('系统初始化 成功!!!');"); Response.Write("</script>"); } else { Response.Write("<script>"); Response.Write("alert('请输入正确的 管理员密码!!!');"); Response.Write("</script>"); } }
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string strid = e.Item.Cells[0].Text; TextBox tb = (TextBox)(e.Item.Cells[1].Controls[0]); string strName =tb.Text.Trim(); if( strName == String.Empty ) { Response.Write("<script>"); Response.Write("alert('请输入类别名称!!!');"); Response.Write("</script>"); return; } else if( strName.Length > 20 ) { Response.Write("<script>"); Response.Write("alert('输入类别名称太长了!!!');"); Response.Write("</script>"); return; } DBConn myDB = new DBConn(); string sql="update Category set CName='" + strName + "' where CID=" + strid; myDB.ExecuteNonQuery(sql); myDB.Close(); Response.Write("<script>"); Response.Write("alert('更新成功!!!');"); Response.Write("</script>"); DataGrid1.EditItemIndex = -1;//退回到编辑状态 getData(); }