protected override void ConfigureServer(database::Raven.Database.Config.RavenConfiguration serverConfiguration) { serverConfiguration.AuthenticationMode = "oauth"; serverConfiguration.AnonymousUserAccessMode = database::Raven.Database.Server.AnonymousUserAccessMode.None; serverConfiguration.Catalog.Catalogs.Add(new AssemblyCatalog(typeof(AuthenticationUser).Assembly)); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string dob = null; database q = new database(); DataTable t,d; t = q.select("select name,email from reg_login where email='" + Session["emailID"].ToString().Trim() + "'"); d = q.select("select *from detail where email='" + Session["emailID"].ToString().Trim() + "'"); if (t.Rows.Count > 0) { txtname.Text = t.Rows[0][0].ToString(); txtemail.Text = t.Rows[0][1].ToString(); if (d.Rows[0][1].ToString() == "Male") Male.Checked = true; if (d.Rows[0][1].ToString() == "Female") Female.Checked = true; txtadd.Text = d.Rows[0][2].ToString(); txtstate.Text = d.Rows[0][3].ToString(); txtcity.Text = d.Rows[0][4].ToString(); txtpin.Text = d.Rows[0][5].ToString(); txtmobile.Text = d.Rows[0][6].ToString(); } } }
public static void add_ipAddress(string ip, string name) { database Database = new database(); Database.open_connection(); Database.insert_datbase_ip_connection(ip, name); Database.close_connection(); }
private void button1_Click(object sender, EventArgs e) { database da = new database(); int j = da.getLastEmpId(); int k = da.getEmppass(j); da.insertInUserTable(j, k, "Employee"); }
public static void session_connection(string id, bool status) { database _database_ = new database(); _database_.open_connection(); _database_.update_datebase_session_connection(id, status); _database_.close_connection(); }
private void showUserInfo(object sender, EventArgs e) { database db = new database(); string query = "select * from userinfo where name = '" + username + "'"; DataTable dt = db.Table(query); new adminShowUserInfo(0, dt).ShowDialog(); }
public Filter(Appointments appForm) { InitializeComponent(); dbConn = new database(); this.appForm = appForm; scheduledMin = Convert.ToDateTime(schedule_datetime1.Value); }
//var model1 = (Employee)TempData["data"]; // return View(model1); public IEnumerable <SelectListItem> GetStates() { List <SelectListItem> states = new List <SelectListItem>(); string query = "select * from dbo.States"; database ob2 = new database(); return(ob2.dbState(query)); }
private ResultSet getRowsTableSP(database db, string Padre = "", string IDCta = "") { String sql = "SELECT * FROM VESTADO_CUENTA_PENSIONADOS where PADRE = " + Padre + " and ID_ESTADODECUENTA = " + IDCta; sql += " ORDER BY ID_CTAPENSIONADO "; return(db.getTable(sql)); }
private ResultSet getRowsTableH(database db, string IDCta = "") { String sql = "SELECT * FROM VESTADO_CUENTA where PADRE = " + IDCta; sql += " ORDER BY FECHAPAGO "; return(db.getTable(sql)); }
public static void Delete(string id) { database db = new database(); db.AddParameter("@DesigId", id); db.AddParameter("@QryType", "D"); db.ExecuteSP("DesigProc"); }
public static object GetDesignationTypeID(string DesignCode) { database db = new database(); db.AddParameter("@DesignationCode", DesignCode); db.AddParameter("@QryType", "G"); return(db.GetDataValue("DesigCode")); }
public static void update_table_ip(string[] befor, string[] after) { database _database_ = new database(); _database_.open_connection(); _database_.update_table_ip(befor, after); _database_.close_connection(); }
public validarusuario(string f) { InitializeComponent(); guia = true; folio = f; db = new database(); ValidateUser(); }
public Corte_de_Caja() { InitializeComponent(); db = new database(); CultureInfo.GetCultureInfo("es-MX"); timer1.Interval = 1; timer1.Start(); }
private void employeeTableDataGridView_Enter(object sender, EventArgs e) { database da = new database(); int j = da.getLastEmpId(); int k = da.getEmppass(j); da.insertInUserTable(j, k, "Employee"); }
public override global::System.Data.DataSet Clone() { database cln = ((database)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static void update_table_properties(int[] befor, int[] after) { database _database_ = new database(); _database_.open_connection(); _database_.update_table_properties(befor, after); _database_.close_connection(); }
public Login() { InitializeComponent(); LoginUsuario.Focus(); groupBoxusuario.Visible = true; db = new database(); progressBar1.Visible = false; }
private void btnDatosCPActBuscar_Click(object sender, EventArgs e) { database datos = new database(); string tipoBusqueda = "", parametroBusqueda = "", valorParametroBusqueda = ""; try { if (rbDatosCPActualizarClientes.Checked == true) { tipoBusqueda = rbDatosCPActualizarClientes.Text; tipo = tipoBusqueda; if (rbDatosCPActualizarTodos.Checked == true) { parametroBusqueda = rbDatosCPActualizarTodos.Text; } else if (rbDatosCPActualizarRFC.Checked == true) { parametroBusqueda = rbDatosCPActualizarRFC.Text; valorParametroBusqueda = txtDatosCPActRFC.Text; } else if (rbDatosCPActualizarNombre.Checked == true) { parametroBusqueda = rbDatosCPActualizarNombre.Text; valorParametroBusqueda = txtDatosCPActNombre.Text; } else { } } else if (rbDatosCPActualizarProvedores.Checked == true) { tipoBusqueda = rbDatosCPActualizarProvedores.Text; tipo = tipoBusqueda; if (rbDatosCPActualizarTodos.Checked == true) { parametroBusqueda = rbDatosCPActualizarTodos.Text; } else if (rbDatosCPActualizarRFC.Checked == true) { parametroBusqueda = rbDatosCPActualizarRFC.Text; valorParametroBusqueda = txtDatosCPActRFC.Text; } else if (rbDatosCPActualizarNombre.Checked == true) { parametroBusqueda = rbDatosCPActualizarNombre.Text; valorParametroBusqueda = txtDatosCPActNombre.Text; } else { } } else { MessageBox.Show("Parametros de busqueda no valido"); } dgvActualizar.DataSource = datos.listaCP(tipoBusqueda, parametroBusqueda, valorParametroBusqueda); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public sFormModels GetRestartModels(dFormData dFormData, string cuurip) { database database = new database(); List <dbparam> dbparamlist = new List <dbparam>(); dbparamlist.Add(new dbparam("@formId", dFormData.formId.TrimEnd())); dbparamlist.Add(new dbparam("@inoper", dFormData.newid.TrimEnd())); if (database.checkActiveSql("mssql", "flyformstring", "exec web.deletefilldeta @formId,@inoper;", dbparamlist) != "istrue") { return(new sFormModels() { status = "error" }); } DataTable mainRows = new DataTable(); mainRows = database.checkSelectSql("mssql", "flyformstring", "exec web.searchmaindeta @formId,@inoper;", dbparamlist); switch (mainRows.Rows.Count) { case 0: return(new sFormModels() { status = "nodata" }); } int i = 1; dbparamlist.Add(new dbparam("@random", mainRows.Rows[0]["randsub"].ToString().TrimEnd())); dbparamlist.Add(new dbparam("@number", mainRows.Rows[0]["number"].ToString().TrimEnd())); dbparamlist.Add(new dbparam("@finish", mainRows.Rows[0]["finish"].ToString().TrimEnd())); List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); foreach (DataRow dr in database.checkSelectSql("mssql", "flyformstring", "exec web.searchsubdeta @formId,@inoper,@random,@number,@finish;", dbparamlist).Rows) { dbparamlist.Clear(); dbparamlist.Add(new dbparam("@formId", dFormData.formId.TrimEnd())); dbparamlist.Add(new dbparam("@iid", int.Parse(dr["iid"].ToString().TrimEnd()))); dbparamlist.Add(new dbparam("@inoper", dFormData.newid.TrimEnd())); dbparamlist.Add(new dbparam("@random", mainRows.Rows[0]["randopt"].ToString().TrimEnd())); List <Dictionary <string, object> > answeritems = new List <Dictionary <string, object> >(); foreach (DataRow drs in database.checkSelectSql("mssql", "flyformstring", "exec web.searchoptiondeta @formId,@iid,@inoper,@random;", dbparamlist).Rows) { answeritems.Add(new Dictionary <string, object>() { { "id", drs["id"].ToString().TrimEnd() }, { "values", drs["value"].ToString().TrimEnd() }, { "showAnswer", drs["answer"].ToString().TrimEnd() == "1" }, { "showRight", drs["right"].ToString().TrimEnd() == "1" } }); } items.Add(new Dictionary <string, object>() { { "iid", dr["iid"].ToString().TrimEnd() }, { "title", $"{i}.{dr["tile"].ToString().TrimEnd()}" }, { "showVeri", dr["verified"].ToString().TrimEnd() == "1" }, { "showDrop", false }, { "showFile", false }, { "outValue", dr["outValue"].ToString().TrimEnd() }, { "value", dr["value"].ToString().TrimEnd() }, { "showMenu", false }, { "type_", dr["type"].ToString().TrimEnd() }, { "operation", dr["operation"].ToString().TrimEnd() }, { "area", dr["area"].ToString().TrimEnd() }, { "eror", dr["eror"].ToString().TrimEnd() }, { "showCheck", dr["checked"].ToString().TrimEnd() == "1" }, { "answeritems", answeritems.ToArray() } }); i++; } return(new sFormModels() { formId = mainRows.Rows[0]["formId"].ToString().TrimEnd(), tile = mainRows.Rows[0]["tile"].ToString().TrimEnd(), desc = mainRows.Rows[0]["desc"].ToString().TrimEnd(), exam = mainRows.Rows[0]["examed"].ToString().TrimEnd() == "1", restart = mainRows.Rows[0]["restarted"].ToString().TrimEnd() == "1", finish = mainRows.Rows[0]["finish"].ToString().TrimEnd() == "1", score = $"{mainRows.Rows[0]["score"].ToString().TrimEnd()}分", items = items, status = "istrue" }); }
public static routine addSpecificCourse(string cid) { database db = new database(); routine r = new routine(); r.courses = new List <course>(); string query = "select * from timing where cid = " + cid; course c; c.slots = new List <coursetime>(); coursetime t = new coursetime(); DataTable dt = db.Table(query); bool isMatch; for (int i = 0; i < dt.Rows.Count; i++) { isMatch = false; c = new course(); t.day = dt.Rows[i]["day"].ToString(); t.start = DateTime.Parse(dt.Rows[i]["start"].ToString()); t.end = DateTime.Parse(dt.Rows[i]["endt"].ToString()); string AMPM; if (t.start.Hour >= 1 && t.start.Hour <= 3) { AMPM = t.start.ToString(); AMPM = AMPM.Remove(AMPM.Length - 2, 2); AMPM += "PM"; t.start = DateTime.Parse(AMPM); } if (t.end.Hour >= 1 && t.end.Hour <= 5) { AMPM = t.end.ToString(); AMPM = AMPM.Remove(AMPM.Length - 2, 2); AMPM += "PM"; t.end = DateTime.Parse(AMPM); } for (int j = 0; j < r.courses.Count; j++) { if (dt.Rows[i]["sec"].ToString() == r.courses[j].section) { isMatch = true; r.courses[j].slots.Add(t); break; } } if (isMatch == false) { c.slots = new List <coursetime>(); c.name = dt.Rows[i]["cname"].ToString(); c.section = dt.Rows[i]["sec"].ToString(); c.slots.Add(t); r.courses.Add(c); } } return(r); }
/// <summary> /// Función que revisa trae un colaborador por su clave. /// </summary> /// <param name="clave">Clave del colaborador que se desea revisar</param> /// <returns>Objeto Colaborador con los datos personales </returns> public static Colaborador ObtienePorClave(long clave) { Colaborador persona = null; /* Solo se permite el acceso a personas que tengan fuentas de correo terminadas en "@anahuac.mx" */ database db = new database(); /* Buscamos al colaborador para revisar que este registrado como un colaborador en el sorteo activo actual */ ResultSet dbPersona = db.getTable(String.Format(@" SELECT top 1 C.CLAVE, C.NOMBRE, C.APATERNO, C.AMATERNO, c.CORREO_P, S.CUENTA, SE.PK_SORTEO FROM COLABORADORES_ASIGNACION CA, SECTORES SE, SORTEOS S, COLABORADORES C WHERE CA.PK_SECTOR=SE.PK1 AND SE.PK_SORTEO=S.PK1 AND S.ACTIVO = 1 AND CA.PK_COLABORADOR = {0} AND C.CORREO_P LIKE '*****@*****.**'", clave)); long sorteo_colab = -1; // Si existe la persona con correo anahuac, entonces extraemos sus datos if (dbPersona.Next()) { persona = new Colaborador() { clave = clave, identificador = dbPersona.Get("CLAVE"), nombre = dbPersona.Get("NOMBRE"), apellido_paterno = dbPersona.Get("APATERNO"), apellido_materno = dbPersona.Get("AMATERNO"), correo = dbPersona.Get("CORREO_P").ToLower(), referencia_bancaria = dbPersona.Get("CUENTA") }; sorteo_colab = dbPersona.GetLong("PK_SORTEO"); } /* Si la persona existe, obtenemos los datos del estado de cuenta */ if (persona != null) { ResultSet dbEdoCuenta = db.getTable(String.Format(@" SELECT TOP 1 IMPORTE, ABONO, SALDO FROM vESTADO_CUENTA_COLABORADOR edo WHERE edo.PK_COLABORADOR = {0}", clave)); /* Si encontramos datos, entonces extraemos la información del estado de cuenta */ if (dbEdoCuenta.Next()) { persona.monto_total = dbEdoCuenta.GetDecimal("IMPORTE"); persona.monto_abonado = dbEdoCuenta.GetDecimal("ABONO"); persona.monto_deudor = dbEdoCuenta.GetDecimal("SALDO"); } } ; return(persona); }
public static void delete_session_time(string id) { database Database = new database(); current_user CurrentUser = new current_user(id); Database.open_connection(); Database.delete_datebase("user_session", "where user_id='" + id + "' and start_status='0'"); Database.close_connection(); }
public validarchofer(string fol) { InitializeComponent(); timer2.Enabled = true; db = new database(); folioguia = fol; ValidateUserGUIA(); reporte = true; }
private static void save_session_time(int count_sec, string id) { database Database = new database(); current_user CurrentUser = new current_user(id); Database.open_connection(); Database.update_datebase_session_time_count(count_sec, CurrentUser); Database.close_connection(); }
private void button4_Click(object sender, EventArgs e) { DataTable dk = new DataTable(); database dt = new database(); int k = Convert.ToInt32(textBox3.Text.ToString()); dk = dt.getProductData(k); dataGridView2.DataSource = dk; }
private string createTree(string nivel, string name, SessionDB sesion) { database db = new database(); String menu = "<ul id=\"" + name + "\">"; String sql = "SELECT PK1, NOMBRE, PADRE,DISPONIBLE FROM JERARQUIAS WHERE PADRE = '" + nivel + "' ORDER BY ORDEN"; //SqlDataReader res = db.getRows(sql); ResultSet res = db.getTable(sql); //if (res.HasRows) /* */ { while (res.Next()) { // Abrimos el nodo con el nombre del primer dependiente // Utilizaremos esta variable para ver si seguimos consultado la BDD int tiene_dependientes = 0; string pk1 = res.Get("PK1"); String sqlchild = "SELECT * FROM JERARQUIAS WHERE PADRE = '" + pk1 + "'"; String numrowssqlchild = "SELECT COUNT(PK1) AS 'MAX' FROM JERARQUIAS WHERE PADRE = '" + pk1 + "'"; tiene_dependientes = sesion.db.Count(numrowssqlchild); /* * if (tiene_dependientes > 0) { urlweb = "javascript:;"; } * else { bullet = ""; classstyle = ""; classstyleactive = " class=\"active\" "; }*/ //Validamos si tiene permiso //sesion.permisos.havePermission(res.GetInt("PK_PERMISO")) || res.GetInt("PK_PERMISO") == 0 if (true) { menu += "<li "; menu += "><a href=\" \">" + res.Get("NOMBRE") + "</a>"; } // Si tiene dependientes, ejecutamos recursivamente // tomando como parámetro el nuevo nivel if (tiene_dependientes > 0) { //if(idmenu==Integer.valueOf(rs.getString("PK1"))){ menu += this.createTree(res.Get("PK1"), " ", sesion); //} } // Cerramos el nodo menu += "</li>"; } } // Cerramos la lista menu += "</ul>"; return(menu); }
void Start() { sensor = SensorsComponent.SensorFactory.GetInstance(currentSensor, robotPrefab); createMaze.onClick.AddListener(createMazeButtonListener); expDB = new database(); manualButton.onClick.AddListener(manualButtonListener); automaticButton.onClick.AddListener(automaticButtonListener); backButton.interactable = false; }
public IActionResult country(string countryName) { ViewBag.country = countryName; try { ViewBag.countryExists = "true"; database db = new database(database.maindb); db.AddParam("?country", countryName); MySqlDataReader rd = db.ExecuteReader("select * from countries where lower(country)=lower(?country)"); if (!rd.HasRows) { ViewBag.climate = "N.A."; ViewBag.death_rate = "N.A."; ViewBag.obesity = "N.A."; } while (rd.Read()) { ViewBag.climate = rd.GetString("climate"); double death_rate = rd.GetDouble("death_rate"); if (death_rate == 0) { ViewBag.death_rate = "N.A."; } else { ViewBag.death_rate = death_rate; } double obesity = rd.GetDouble("obesity"); if (obesity == 0) { ViewBag.obesity = "N.A."; } else { ViewBag.obesity = obesity; } } Dictionary <string, Country> cslist = new Countries().getDictionar(); ViewBag.code = ""; try { ViewBag.code = cslist[countryName].Code; } catch { } } catch { } ViewBag.nr = 0; try { ObjectResult obj = (ObjectResult) new MeAd.Raml.SearchController().Get(countryName); Dictionary <string, Countries.CountryDiseases> countryDiseases = (Dictionary <string, Countries.CountryDiseases>)obj.Value; ViewBag.countryDiseases = countryDiseases; } catch { } return(View()); }
public static List <Curso> GetCurso() { database db = getDataBase(); var query = from c in db.Curso select c; List <Curso> curso = new List <Curso>(query.AsEnumerable()); return(curso); }
public static void DropCurso() { database db = getDataBase(); if (db.DatabaseExists() == true) { db.DeleteDatabase(); } }
//========================================================================== public static void Main(string[] astrArg) { ContextMenu cm; MenuItem miCurr; int iIndex = 0; string status = "running"; // Kontextmenü erzeugen cm = new ContextMenu(); // Kontextmenüeinträge erzeugen miCurr = new MenuItem(); miCurr.Index = iIndex++; miCurr.Text = "&Aktion 1"; // Eigenen Text einsetzen miCurr.Click += new System.EventHandler(Action1Click); cm.MenuItems.Add(miCurr); // Kontextmenüeinträge erzeugen miCurr = new MenuItem(); miCurr.Index = iIndex++; miCurr.Text = "&Beenden"; miCurr.Click += new System.EventHandler(ExitClick); cm.MenuItems.Add(miCurr); // NotifyIcon selbst erzeugen notico = new NotifyIcon(); notico.Icon = new Icon("git.ico"); // Eigenes Icon einsetzen notico.Text = "OVEye-Server | "+ status; // Eigenen Text einsetzen notico.Visible = true; notico.ContextMenu = cm; Console.WriteLine("Erstelle Server"); Server x = new Server(); database y = new database(); //Erstellt Thread prüfen = new Thread(delegate() { y.renewActiveConnections(x.clientList); }); // Ohne Appplication.Run geht es nicht Application.Run(); }
protected void btn_clk(object sender, EventArgs e) { string password; DataTable t; database q = new database(); t = q.select("select *from reg_login where email ='" + txtemail.Text.ToString().Trim() + "'"); if(t.Rows.Count>0) { password = t.Rows[0][1].ToString(); if (password == txtpassword.Text) { Session["Email"] = txtemail.Text; Response.Redirect("home.aspx"); } else txtemail.Text = " invalid password"; } else txtpassword.Text = "Invalid user name"; }
protected void Page_Load(object sender, EventArgs e) { myDB = (database)Session["myDB"]; curUser = (user)Session["curUser"]; designUser = (user)Session["designUser"]; userInfoColl = myDB.getUserInfoCollection(); if (designUser != null) { usersBoardColl = myDB.getUsersBoardCollection(designUser); } if (curUser.Account_Type == "client") { boardPnl.Visible = true; usersBoardColl = myDB.getUsersBoardCollection(curUser); board_item.loadBoards(usersBoardColl, boardNameList); } else if (curUser.Account_Type == "designer") { designerPnl.Visible = true; switchUserBtn.Visible = true; user.loadUsers(userInfoColl, designerUserList, curUser); } }
protected void Page_Load(object sender, EventArgs e) { myDB = (database)Session["myDB"]; userInfoColl = myDB.getUserInfoCollection(); }
protected void Page_Load(object sender, EventArgs e) { i = (int)Session["i"]; el = (elements)Session["el"]; myDB = (database)Session["myDB"]; curUser = (user)Session["curUser"]; boardName = (string)Session["boardName"]; queryItems = (List<product_image>)Session["queryItems"]; usersBoardColl = myDB.getUsersBoardCollection(curUser); p = (product_image)Session["p"]; setImage(p); }
protected void Page_Load(object sender, EventArgs e) { allItems = (List<product_image>)Session["allItems"]; myDB = (database)Session["myDB"]; myDB.retrieveImagesCollection(); imgColl = myDB.getImagesCollection(); elements.loadElements(imgColl, colorList, lineList, lightList, formList, spaceList, textureList, patternList, massList, balanceList, unityList, harmonyList, rhythmList, proportionList, varietyList, emphasisList, scaleList, typeList); }
protected void Page_Load(object sender, EventArgs e) { if (ddlDnsTypelist.SelectedValue.Trim().Equals("6")) { DB = new dbDns("dns"); } else { DB = new dbDns("dnsalarm"); } if (!IsPostBack) { initDnsTypeList(); dbConfig configDB = new dbConfig(); string gUserName = configDB.getUserName(User.Identity.Name); string gIP = Request.ServerVariables["Remote_Addr"]; string gContent = "木马查询"; common.setLog(User.Identity.Name, gUserName, gIP, gContent); formInit(); } else { switch (qrytypelist.SelectedItem.Value) { case "0"://自选时间段 Condition += "vTime > '" + Convert.ToDateTime(sdate.Value.ToString()).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + Convert.ToDateTime(edate.Value.ToString()).AddDays(1).ToString("yyyy-MM-dd") + "'"; break; case "1"://前三天 Condition += "vTime > '" + DateTime.Today.AddDays(-3).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; case "2"://前一周 Condition += "vTime > '" + DateTime.Today.AddDays(-7).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; case "3"://前一月 Condition += "vTime > '" + DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; case "5"://昨天 Condition += "vTime > '" + DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; } //获取选中的服务器 foreach (ListItem li in cblHost.Items) { if (li.Selected) { if (selectedCount == 0) //防止只选一个站点时,出现在,1的情况 查询报错 { sParent = li.Value; } else { sParent += "," + li.Value + ""; } selectedCount++; } } if (selectedCount <= 0)//tedi3231 added 2010.02.01 没有选中任何站点时显示用户能看到的所有站点 { sParent = common.GetHosrList(User.Identity.Name); } Condition += " and nParent in (" + sParent + ")"; if (txtvDstIp.Text.ToString() != "")//数据库中为numeric 类型,因而需要先将值转化为数字类型 Condition += " and vDstIp = dmc_config.dbo.f_IP2Int('" + txtvDstIp.Text.ToString() + "')"; if (txtvDstMac.Text.ToString() != "") Condition += " and vDstMac ='" + txtvDstMac.Text.ToString() + "' "; if (txtvAddr.Text.ToString() != "")//数据库中为numeric 类型,因而需要先将值转化为数字类型 Condition += " and vAddr = dmc_config.dbo.f_IP2Int('" + txtvAddr.Text.ToString() + "') "; if (txtvName.Text.ToString() != "") { if (fromeq.Checked) Condition += " and vName = '" + txtvName.Text.ToString() + "'"; else Condition += " and vName like '%" + txtvName.Text.ToString() + "%'"; } //用户IP if (!string.IsNullOrEmpty(tbUserIp.Text)) { Condition += " and vSrcIp = dmc_config.dbo.f_IP2Int('" + tbUserIp.Text.ToString() + "') "; } //用户MAC if (!string.IsNullOrEmpty(tbUserMac.Text)) { Condition += " and vSrcMac= '" + tbUserMac.Text.ToString() + "' "; } // 是否静默 if (this.ddlStateFlag.SelectedValue.Trim() == "0") { Condition += " and vStateFlag = 0 "; } else if (this.ddlStateFlag.SelectedValue.Trim() == "1") { Condition += " and vStateFlag = 1 "; } //域名类型 string typeval = ddlDnsTypelist.SelectedValue.Trim(); if (!string.IsNullOrEmpty(typeval) && typeval != "-1") { if (typeval == "0") // 如果为所有黑名单,则显示黑名单的三种类别 { Condition += " and (vType=7 or vType=8 or vType=9 ) "; } else if (typeval == "10") { Condition += " and (vType=3 or vType=4 or vType=5 ) "; } else if (typeval == "11") //其他域名 可疑域名 所有异常域名 { Condition += " and (vType=2 or vType=3 or vType=4 or vType=5 ) "; } else { Condition += " and vType = " + typeval + " "; } } //ip归属地查询 if (ddlIpList.SelectedValue.Trim() != "-1") { Condition += " and ipnum = " + ddlIpList.SelectedValue.Trim(); } int senstive = common.GetSenstiveCheck(this.CheckBoxList2); if (senstive > 0) Condition += " and ( (nKey & " + senstive + ")>0 ) "; // 条件传给存储过程的时候,最前面不需要跟上and if (!string.IsNullOrEmpty(Condition) && Condition.Length > 4 && Condition.Substring(0, 5) == " and ") Condition = Condition.Substring(5); } }
protected void Page_Load(object sender, EventArgs e) { _RecordCount = Convert.ToInt32(lblRecordCount.Text); _PageCount = _RecordCount / _PageSize; if (_RecordCount % _PageSize > 0) _PageCount++; _PageIndex = Convert.ToInt32(lblPageIndex.Text); int selectedCount = 0; string sParent = "'0'"; DB = CreateDataBase(this.DropDownList1.SelectedValue.Trim()); if (!IsPostBack) { dbConfig configDB = new dbConfig(); string gUserName = configDB.getUserName(User.Identity.Name); string gIP = Request.ServerVariables["Remote_Addr"]; string gContent = "网站查询"; common.setLog(User.Identity.Name, gUserName, gIP, gContent); formInit(); } else { switch (qrytypelist.SelectedItem.Value) { case "0"://自选时间段 Condition += "vTime > '" + Convert.ToDateTime(sdate.Value.ToString()).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + Convert.ToDateTime(edate.Value.ToString()).AddDays(1).ToString("yyyy-MM-dd") + "'"; break; case "1"://前三天 Condition += "vTime > '" + DateTime.Today.AddDays(-3).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; case "2"://前一周 Condition += "vTime > '" + DateTime.Today.AddDays(-7).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; case "3"://前一月 Condition += "vTime > '" + DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; case "5"://昨天 Condition += "vTime > '" + DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; } //获取选中的服务器 foreach (ListItem li in cblHost.Items) { if (li.Selected) { sParent += "," + li.Value + ""; selectedCount++; } } //tedi3231 added 2010.02.01 没有选中任何站点时显示用户能看到的所有站点 if (sParent.Length <= 3) { sParent = common.GetHosrList(User.Identity.Name); } if (selectedCount < cblHost.Items.Count) Condition += " and nParent in (" + sParent + ")"; if (txtSrcAddr.Text.ToString() != "") Condition += " and vSrcAddr = dmc_config.dbo.[f_IP2int]('" + txtSrcAddr.Text.ToString() + "')"; if (txtSrcMac.Text.ToString() != "") Condition += " and vSrcMac = '" + txtSrcMac.Text.ToString() + "'"; int senstive = GetSenstiveCheck(); if( senstive> 0 ) Condition += " and ( (nKey & " + senstive+ ")>0 ) "; //if (txtWeburl.Text.ToString() != "") //{ // if (weburleq.Checked) // Condition += " and vURL = '" + txtWeburl.Text.ToString() + "'"; // else // Condition += " and vURL like '%" + txtWeburl.Text.ToString().Trim() + "%'"; //} //if (txtWebIP.Text.ToString() != "") // Condition += " and vDstAddr = dmc_config.dbo.[f_IP2int]('" + txtWebIP.Text.ToString() + "')"; // 条件传给存储过程的时候,最前面不需要跟上and if (!string.IsNullOrEmpty(Condition) && Condition.Length > 4 && Condition.Substring(0, 5) == " and ") Condition = Condition.Substring(5); } }
protected override void ConfigureServer(database::Raven.Database.Config.RavenConfiguration serverConfiguration) { serverConfiguration.RunInMemory = false; serverConfiguration.DefaultStorageTypeName = "esent"; }
public string getUpdateSqlCode(int row, database.Preferences.MySQLRow mysqlRow, MySqlConnection connection) { setDefaultItemValues(row); ItemTemplates.ItemTemplateRow tempRow = (ItemTemplates.ItemTemplateRow)this.ItemTemplate.Rows[row]; System.Data.DataTable columnsTable = new System.Data.DataTable(); //automatic detection if (mysqlRow.cellDetection == true && connection != null) { try { connection.Open(); string SQL = "SHOW COLUMNS FROM " + mysqlRow.ItemTemplateTable; MySqlCommand cmd = new MySqlCommand(SQL, connection); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { columnsTable.Columns.Add(reader.GetString(0)); } } catch (MySqlException ex) { System.Windows.Forms.MessageBox.Show(ex.Message); columnsTable = this.ItemTemplate; } finally { connection.Close(); } } else { columnsTable = this.ItemTemplate.Clone(); if (mysqlRow.ArtiID == false) columnsTable.Columns.Remove("ArtiID"); } string dataSQL = ""; bool insertedData = false; string sqlCodeRaw = ""; int i = 0; foreach (System.Data.DataColumn column in columnsTable.Columns) { if (this.ItemTemplate.Columns.Contains(column.ColumnName)) { if (sqlCodeRaw != "") sqlCodeRaw += ", "; sqlCodeRaw += "`" + column.ColumnName + "` = @value"+i; } i++; } string sqlCode = "UPDATE " + mysqlRow.ItemTemplateTable + " SET " + sqlCodeRaw; MySqlCommand c = new MySqlCommand(sqlCode); i = 0; foreach (System.Data.DataColumn column in columnsTable.Columns) { if (this.ItemTemplate.Columns.Contains(column.ColumnName)) { object value = tempRow[column.ColumnName]; c.Parameters.AddWithValue("value" + i, value); } i++; } foreach (System.Data.DataColumn column in columnsTable.Columns) { if (this.ItemTemplate.Columns.Contains(column.ColumnName)) { if (column.Unique == false && column.ColumnName != "ItemTemplate_ID") { if (tempRow.IsNull(column.ColumnName)) { if (insertedData != false) dataSQL += ", "; else insertedData = true; dataSQL += "`" + column.ColumnName + "` = NULL"; break; } else { object value = tempRow[column.ColumnName]; //if (value.GetType() != System.DBNull.Value.GetType()) //{ //Alle Spalten die einen Wert enthalten werdne in der SQL aufgelistet, um NULL-Werte automatisch setzen zu können //columnsSQL switch (value.GetType().ToString()) { case "System.String": { if (insertedData != false) dataSQL += ", "; else insertedData = true; dataSQL += "`" + column.ColumnName + "` = '" + this.escapeString(value.ToString()) + "'"; break; } case "System.Boolean": { if (insertedData != false) dataSQL += ", "; else insertedData = true; if ((bool)value == true) dataSQL += "`" + column.ColumnName + "` = 1"; else dataSQL += "`" + column.ColumnName + "` = 0"; break; } case "System.DBNull": { if (insertedData != false) dataSQL += ", "; else insertedData = true; dataSQL += "`" + column.ColumnName + "` = NULL"; break; } default: { if (insertedData != false) dataSQL += ", "; else insertedData = true; dataSQL += "`" + column.ColumnName + "` = " + value.ToString(); break; } } } } } } string code; code = "UPDATE " + mysqlRow.ItemTemplateTable + " SET " + dataSQL + " WHERE `Id_nb` = '" + tempRow.Id_nb + "' LIMIT 1"; return code; }
protected override void ConfigureServer(database::Raven.Database.Config.RavenConfiguration serverConfiguration) { serverConfiguration.AnonymousUserAccessMode = database::Raven.Database.Server.AnonymousUserAccessMode.None; database::Raven.Database.Server.Security.Authentication.EnableOnce(); }
protected void Page_Load(object sender, EventArgs e) { myDB = (database)Session["myDB"]; curUser = (user)Session["curUser"]; designUser = (user)Session["designUser"]; userInfoColl = myDB.getUserInfoCollection(); imgColl = myDB.getImagesCollection(); allItems = product_image.getItems(imgColl); Session["imgColl"] = imgColl; Session["allItems"] = allItems; elements.loadElements(imgColl, colorList, lineList, lightList, formList, spaceList, textureList, patternList, massList, balanceList, unityList, harmonyList, rhythmList, proportionList, varietyList, emphasisList, scaleList, typeList); if (curUser.Account_Type == "client") { boardPnl.Visible = true; usersBoardColl = myDB.getUsersBoardCollection(curUser); board_item.loadBoards(usersBoardColl, boardNameList); } else if (curUser.Account_Type == "designer") { designerPnl.Visible = true; user.loadUsers(userInfoColl, designerUserList, curUser); } }
private void BinddtgData(string TableType) { DB = CreateDataBase(this.DropDownList1.SelectedValue.Trim()); if (_PageIndex < 1) _PageIndex = 1; _RecordCount = DB.getCount(qrytypelist.SelectedItem.Value, Condition); if (_RecordCount > 0) { _PageCount = _RecordCount / _PageSize; if (_RecordCount % _PageSize > 0) _PageCount++; } DataSet ds = DB.RunProcedure(TableType, _PageSize, _PageIndex, "Asc", Condition); dtgData.DataSource = ds.Tables[0].DefaultView; dtgData.DataBind(); ViewState["ds"] = ds; lblRecordCount.Text = _RecordCount.ToString(); lblPageCount.Text = _PageCount.ToString(); lblPageIndex.Text = _PageIndex.ToString(); if (_PageIndex > 1) lnkPrev.Visible = true; else lnkPrev.Visible = false; if (_PageIndex < _PageCount) lnkNext.Visible = true; else lnkNext.Visible = false; BindlsbPage(_PageCount, _PageIndex); }
protected void Page_Load(object sender, EventArgs e) { _RecordCount = Convert.ToInt32(lblRecordCount.Text); _PageCount = _RecordCount / _PageSize; if (_RecordCount % _PageSize > 0) _PageCount++; _PageIndex = Convert.ToInt32(lblPageIndex.Text); int selectedCount = 0; string sParent = "0"; if (rdlCategory.SelectedValue == "mail_box") DB = new dbMailBox(rdlMailType.SelectedValue); else { if (rdlMailType.SelectedValue == "Pop") DB = new dbMailSite("Get"); else DB = new dbMailSite("Send"); } if (!IsPostBack) { dbConfig configDB = new dbConfig(); string gUserName = configDB.getUserName(User.Identity.Name); string gIP = Request.ServerVariables["Remote_Addr"]; string gContent = "邮件查询"; common.setLog(User.Identity.Name, gUserName, gIP, gContent); formInit(); } else { switch (qrytypelist.SelectedItem.Value) { case "0"://自选时间段 Condition += "vTime > '" + Convert.ToDateTime(sdate.Value.ToString()).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + Convert.ToDateTime(edate.Value.ToString()).AddDays(1).ToString("yyyy-MM-dd") + "'"; break; case "1"://前三天 Condition += "vTime > '" + DateTime.Today.AddDays(-3).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; case "2"://前一周 Condition += "vTime > '" + DateTime.Today.AddDays(-7).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; case "3"://前一月 Condition += "vTime > '" + DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; case "5"://昨天 Condition += "vTime > '" + DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd") + "'"; Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'"; break; } //获取选中的服务器 foreach (ListItem li in cblHost.Items) { if (li.Selected) { sParent += "," + li.Value + ""; selectedCount++; } } if (selectedCount < cblHost.Items.Count) Condition += " and nParent in (" + sParent + ")"; if (txtSrcAddr.Text.ToString() != "") Condition += " and vSrcAddr = dmc_config.dbo.[f_IP2int]('" + txtSrcAddr.Text.ToString() + "')"; if (txtSrcMac.Text.ToString() != "") Condition += " and vSrcMac = dmc_config.dbo.[f_IP2int]('" + txtSrcMac.Text.ToString() + "')"; if (txtDstAddr.Text.ToString() != "") Condition += " and vDstAddr = dmc_config.dbo.[f_IP2int]('" + txtDstAddr.Text.ToString() + "')"; if (txtDstMac.Text.ToString() != "") Condition += " and vDstMac = '" + txtDstMac.Text.ToString() + "'"; if (txtDstAddr.Text.ToString() != "") Condition += " and vDstAddr = dmc_config.dbo.[f_IP2int]('" + txtDstAddr.Text.ToString() + "')"; if (txtDstMac.Text.ToString() != "") Condition += " and vDstMac = '" + txtDstMac.Text.ToString() + "'"; if (txtLpFrom.Text.ToString() != "") { if (fromeq.Checked) Condition += " and vLpFrom = '" + txtLpFrom.Text.ToString() + "'"; else Condition += " and vLpFrom like '%" + txtLpFrom.Text.ToString() + "%'"; } if (txtLpTo.Text.ToString() != "") { if (toeq.Checked) Condition += " and vLpTo = '" + txtLpTo.Text.ToString() + "'"; else Condition += " and vLpTo like '%" + txtLpTo.Text.ToString() + "%'"; } if (txtLpTitle.Text.ToString() != "") Condition += " and vLpTitle like '%" + txtLpTitle.Text.ToString() + "%'"; if (txtLogin.Text.ToString() != "") Condition += " and vLogin like '%" + txtLogin.Text.ToString() + "%'"; if (rdlMode.SelectedValue == "1")//敏感模式 Condition += " and nKey > 0"; int senstive = common.GetSenstiveCheck(this.CheckBoxList2); if (senstive > 0) Condition += " and ( (nKey & " + senstive + ")>0 ) "; // 条件传给存储过程的时候,最前面不需要跟上and if (!string.IsNullOrEmpty(Condition) && Condition.Length > 4 && Condition.Substring(0, 5) == " and ") Condition = Condition.Substring(5); } }
protected void Page_Load(object sender, EventArgs e) { myDB = (database)Session["myDB"]; boardName = (string)Session["boardName"]; curUser = (user)Session["curUser"]; designUser = (user)Session["designUser"]; userInfoColl = myDB.getUserInfoCollection(); images = (List<product_image>)Session["allItems"]; imgColl = myDB.getImagesCollection(); elements.loadElements(imgColl, colorList, lineList, lightList, formList, spaceList, textureList, patternList, massList, balanceList, unityList, harmonyList, rhythmList, proportionList, varietyList, emphasisList, scaleList, typeList); if (curUser.Account_Type == "client") { usersBoardColl = myDB.getUsersBoardCollection(curUser); userNameLbl.Text = curUser.Username; board_item.loadBoards(usersBoardColl, boardNameList); } else if (curUser.Account_Type == "designer") { if (designUser != null) { usersBoardColl = myDB.getUsersBoardCollection(designUser); userNameLbl.Text = designUser.Username; } else { userNameLbl.Text = curUser.Username; usersBoardColl = myDB.getUsersBoardCollection(curUser); } switchUserBtn.Visible = true; user.loadUsers(userInfoColl, designerUserList, curUser); } boardNameLbl.Text = boardName; if (!Page.IsPostBack) { if (boardName != null) { optionsPnl.Visible = true; boardNamePnl.Visible = true; if (curUser.Account_Type == "designer") { userNamePnl.Visible = true; } } else { boardNamePnl.Visible = false; userNamePnl.Visible = false; if (curUser.Account_Type == "designer") { switchUserPnl.Visible = true; } else { changeBoardPnl.Visible = true; } } } }
protected void Page_Load(object sender, EventArgs e) { myDB = (database)Session["myDB"]; boardName = (string)Session["boardName"]; curUser = (user)Session["curUser"]; designUser = (user)Session["designUser"]; userInfoColl = myDB.getUserInfoCollection(); boardNameLbl.Text = boardName; userNameLbl.Text = curUser.Username; userErrLbl.Text = ""; boardErrLbl.Text = ""; resetBoard(); if (curUser.Account_Type == "client") { userNamePnl.Visible = false; usersBoardColl = myDB.getUsersBoardCollection(curUser); board_item.loadBoards(usersBoardColl, boardNameList); } else if (curUser.Account_Type == "designer") { userNamePnl.Visible = true; switchUserBtn.Visible = true; if (designUser != null) { usersBoardColl = myDB.getUsersBoardCollection(designUser); userNameLbl.Text = designUser.Username; } else { usersBoardColl = myDB.getUsersBoardCollection(curUser); } user.loadUsers(userInfoColl, designerUserList, curUser); } if (!Page.IsPostBack) { boardNamePnl.Visible = true; if (boardName != null) { loadImages(usersBoardColl, boardName); inspirationPnl.Visible = true; } else { inspirationPnl.Visible = false; userNamePnl.Visible = false; boardNamePnl.Visible = false; changeBoardBtn.Visible = false; if (curUser.Account_Type == "designer") { switchUserPnl.Visible = true; } else { changeBoardPnl.Visible = true; } } } }
protected void Page_Load(object sender, EventArgs e) { myDB = (database)Session["myDB"]; curUser = (user)Session["curUser"]; userInfoColl = myDB.getUserInfoCollection(); curUser = user.findUser(userInfoColl, curUser.Username); Session["curUser"] = curUser; usernameLbl.Text = curUser.Username; emailAddressLbl.Text = curUser.Email; phoneLbl.Text = curUser.Phone; designerLbl.Text = curUser.Designer; passwordFieldValidator.ControlToValidate = "passwordTxt"; cnfrmPassFieldValidator.ControlToValidate = "cnfrmPassTxt"; changeEmailFieldValidator.ControlToValidate = "emailAddressTxt"; if (curUser.Account_Type == "client") { clientPnl.Visible = true; } else { designerPnl.Visible = true; user.loadClients(userInfoColl, clientList, curUser); } }
public string getInsertSqlCode(int row, database.Preferences.MySQLRow mysqlRow, MySqlConnection connection) { setDefaultItemValues(row); ItemTemplates.ItemTemplateRow tempRow = (ItemTemplates.ItemTemplateRow)this.ItemTemplate.Rows[row]; System.Data.DataTable columnsTable = new System.Data.DataTable(); //automatic detection if (mysqlRow.cellDetection == true && connection != null) { try { connection.Open(); string SQL = "SHOW COLUMNS FROM " + mysqlRow.ItemTemplateTable; MySqlCommand cmd = new MySqlCommand(SQL, connection); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { columnsTable.Columns.Add(reader.GetString(0)); } } catch (MySqlException ex) { System.Windows.Forms.MessageBox.Show(ex.Message); columnsTable = this.ItemTemplate; } finally { connection.Close(); } } else { columnsTable = this.ItemTemplate.Clone(); if (mysqlRow.ArtiID == false) columnsTable.Columns.Remove("ArtiID"); } string columnsSQL = ""; string dataSQL = ""; bool insertedColumn = false; bool insertedData = false; foreach (System.Data.DataColumn column in columnsTable.Columns) { if (this.ItemTemplate.Columns.Contains(column.ColumnName)) { if(!tempRow.IsNull(column.ColumnName)) { object value = tempRow[column.ColumnName]; switch (value.GetType().ToString()) { case "System.String": { if ((string)value != "") { if (insertedColumn == false) { columnsSQL += "`" + column.ColumnName + "`"; insertedColumn = true; } else columnsSQL += ", `" + column.ColumnName + "`"; if (insertedData != false) dataSQL += ", "; else insertedData = true; dataSQL += "'" + this.escapeString(value.ToString()) + "'"; } break; } case "System.Boolean": { if (insertedColumn == false) { columnsSQL += "`" + column.ColumnName + "`"; insertedColumn = true; } else columnsSQL += ", `" + column.ColumnName + "`"; if (insertedData != false) dataSQL += ", "; else insertedData = true; if ((bool)value == true) dataSQL += "1"; else dataSQL += "0"; break; } default: { if (System.Convert.ToInt32(value) != 0) { if (insertedColumn == false) { columnsSQL += "`" + column.ColumnName + "`"; insertedColumn = true; } else columnsSQL += ", `" + column.ColumnName + "`"; if (insertedData != false) dataSQL += ", "; else insertedData = true; dataSQL += value.ToString(); } break; } } } } } string code; code = "REPLACE INTO " + mysqlRow.ItemTemplateTable + " (" + columnsSQL + ") VALUES (" + dataSQL + ")"; return code; }
protected override void ConfigureServer(database::Raven.Database.Config.RavenConfiguration serverConfiguration) { serverConfiguration.AnonymousUserAccessMode = database::Raven.Database.Server.AnonymousUserAccessMode.None; }
protected void Page_Load(object sender, EventArgs e) { myDB = (database)Session["myDB"]; curUser = (user)Session["curUser"]; boardName = (string)Session["boardName"]; images = (List<product_image>)Session["allItems"]; imgColl = myDB.getImagesCollection(); usersBoardColl = myDB.getUsersBoardCollection(curUser); board_item.loadBoards(usersBoardColl, boardNameList); elements.loadElements(imgColl, colorList, lineList, lightList, formList, spaceList, textureList, patternList, massList, balanceList, unityList, harmonyList, rhythmList, proportionList, varietyList, emphasisList, scaleList, typeList); boardNameLbl.Text = "Selected Board: " + boardName; }