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();
}