public static string[,] getCatDbAry(string argGenre, int argLng, int argFid) { int num = argLng; int num2 = argFid; string str = argGenre; db db = new db(); string[,] strArray = null; string str2 = cls.getString(jt.itake("global.config.sys->category-ndatabase", "cfg")); string argFpre = cls.getString(jt.itake("global.config.sys->category-nfpre", "cfg")); string argString = cls.cfnames(argFpre, "id"); string str5 = string.Concat(new object[] { "select * from ", str2, " where ", cls.cfnames(argFpre, "hidden"), "=0 and ", cls.cfnames(argFpre, "lng"), "=", num, " and ", cls.cfnames(argFpre, "genre"), "='", str, "' and ", cls.cfnames(argFpre, "fid"), "=", num2, " order by ", cls.cfnames(argFpre, "order"), " asc" }); object[] objArray = db.getDataAry(str5); if (objArray != null) { for (int i = 0; i < objArray.Length; i++) { object[,] argAry = (object[,]) objArray[i]; int num4 = (int) db.getValue(argAry, argString); string[,] strArray2 = new string[,] { { cls.toString(db.getValue(argAry, argString)), cls.toString(db.getValue(argAry, cls.cfnames(argFpre, "topic"))), cls.toString(db.getValue(argAry, cls.cfnames(argFpre, "fid"))) } }; strArray = cls.mergeAry(cls.mergeAry(strArray, strArray2), getCatDbAry(str, num, num4)); } } return strArray; }
public bool checkUsername(string argUserid, string argUsername, string argPassword) { bool flag = false; int num = cls.getNum(argUserid, -1); string str = cls.getSafeString(argUsername); string str2 = cls.getSafeString(argPassword); if (num != -1) { db db = new db(); string str3 = cls.getString(jt.itake("global." + this.ngenre + ":config.ndatabase", "cfg")); string argFpre = cls.getString(jt.itake("global." + this.ngenre + ":config.nfpre", "cfg")); string str5 = cls.cfnames(argFpre, "id"); string argString = string.Concat(new object[] { "select * from ", str3, " where ", str5, "=", num, " and ", cls.cfnames(argFpre, "lock"), "=0" }); object[] objArray = db.getDataAry(argString); if (objArray == null) { return flag; } object[,] argAry = (object[,]) objArray[0]; string str7 = (string) db.getValue(argAry, cls.cfnames(argFpre, "username")); string str8 = (string) db.getValue(argAry, cls.cfnames(argFpre, "password")); if ((str7 == str) && (str8 == str2)) { flag = true; } } return flag; }
// POST api/<controller> public IHttpActionResult Post([FromBody]Dictionary<string, object> value) { string sql = "INSERT INTO products "; string tbn = ""; string val = ""; foreach (var kv in value) { tbn += kv.Key + ","; Regex isNumeric = new Regex(@"^[\d\.]+$"); if (isNumeric.IsMatch((string)kv.Value)) { val += kv.Value + ","; } else { val += "'" + kv.Value + "',"; } } sql += "(" + tbn.Substring(0, tbn.Length - 1) + ") VALUES (" + val.Substring(0, val.Length - 1) + ")"; jtbc.db db = new jtbc.db(0, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=App_Data/test.mdb;"); int num = db.Insert(sql); Dictionary<string, object> ret = new Dictionary<string, object>(); ret.Add("errorCode", num != 0 ? 0 : db.getRState()); ret.Add("insertId", num); return Ok(ret); }
public static void UpdateDatabaseNote(string argGenre, string argFilename, string argField, int argId) { string str = argGenre; string str2 = argFilename; string str3 = argField; int num = argId; db db = new db(); string str4 = cls.getString(jt.itake("global.config.sys->upload-ndatabase", "cfg")); string argFpre = cls.getString(jt.itake("global.config.sys->upload-nfpre", "cfg")); string argString = string.Concat(new object[] { "update ", str4, " set ", cls.cfnames(argFpre, "valid"), "=0,", cls.cfnames(argFpre, "vlreason"), "=2 where ", cls.cfnames(argFpre, "fid"), "=", num, " and ", cls.cfnames(argFpre, "genre"), "='", str, "' and ", cls.cfnames(argFpre, "field"), "='", str3, "'" }); db.Execute(argString); string[] strArray = str2.Split(new char[] { '|' }); for (int i = 0; i < strArray.Length; i++) { string argObject = cls.getSafeString(strArray[i]); if (!cls.isEmpty(argObject)) { db.Execute(string.Concat(new object[] { "update ", str4, " set ", cls.cfnames(argFpre, "fid"), "=", num, ",", cls.cfnames(argFpre, "valid"), "=1 where ", cls.cfnames(argFpre, "genre"), "='", str, "' and ", cls.cfnames(argFpre, "field"), "='", str3, "' and ", cls.cfnames(argFpre, "filename"), "='", argObject, "'" })); } } }
// GET api/<controller>/<id> public IHttpActionResult GetProduct(int id) { jtbc.db db = new jtbc.db(0, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=App_Data/test.mdb;"); products = (Dictionary<string, object>[])db.getDataAry("select * from products where ID=" + id.ToString()); Dictionary<string, object> ret = new Dictionary<string, object>(); ret.Add("errorCode", 0); ret.Add("products", products); return Ok(ret); }
// DELETE api/<controller>/<id> public IHttpActionResult Delete(int id) { jtbc.db db = new jtbc.db(0, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=App_Data/test.mdb;"); string sql = "DELETE FROM products WHERE ID=" + id.ToString(); db.Execute(sql); Dictionary<string, object> ret = new Dictionary<string, object>(); ret.Add("errorCode", 0); return Ok(ret); }
public admin_plus(admin admin) { _admin = admin; _username = admin.username; _role = jt.itake(string.Format("global.{0}.user.user:sel_utype.{1}", config.adminFolder, _admin.popedom), "lng"); string sql = "select a_lasttime, a_lastip from jtbc_admin where a_username = '******'"; object[] data = new db().getDataAry(sql); if (data != null) { object[,] d = (object[,])data[0]; _lastTime = ((DateTime)d[0, 1]).ToString(); _lastIp = d[1, 1].ToString(); } }
public static int dataDelete(db argDb, string argDatabase, string argIdfield, string argId, string argOsql) { db db = argDb; string str = cls.getString(argDatabase); string str2 = cls.getString(argIdfield); string argString = cls.getString(argId); string argObject = cls.getString(argOsql); if (cls.cidary(argString)) { string str5 = "delete from " + str + " where " + str2 + " in (" + argString + ")"; if (!cls.isEmpty(argObject)) { str5 = str5 + argObject; } return db.Executes(str5); } return -101; }
public static int dataSwitch(db argDb, string argDatabase, string argField, string argIdfield, string argId, string argOsql) { db db = argDb; string str = cls.getString(argDatabase); string str2 = cls.getString(argField); string str3 = cls.getString(argIdfield); string argString = cls.getString(argId); string argObject = cls.getString(argOsql); if (cls.cidary(argString)) { string str6 = "update " + str + " set " + str2 + "=abs(" + str2 + "-1) where " + str3 + " in (" + argString + ")"; if (!cls.isEmpty(argObject)) { str6 = str6 + argObject; } return db.Executes(str6); } return -101; }
public bool ckLogin(string argUsername, string argPassword) { bool flag = true; if (cls.isEmpty(this.username) || cls.isEmpty(this.popedom)) { db db = new db(); string argObject = ""; string str2 = cls.getSafeString(argUsername); string str3 = cls.getSafeString(argPassword); string str4 = cls.getString(jt.itake("global.config.admin-ndatabase", "cfg")); string argFpre = cls.getString(jt.itake("global.config.admin-nfpre", "cfg")); string argString = "select * from " + str4 + " where " + cls.cfnames(argFpre, "username") + "='" + str2 + "' and " + cls.cfnames(argFpre, "password") + "='" + str3 + "' and " + cls.cfnames(argFpre, "lock") + "=0"; object[] objArray = db.getDataAry(argString); if (objArray != null) { object[,] argAry = (object[,]) objArray[0]; int argValue = (int) db.getValue(argAry, cls.cfnames(argFpre, "id")); string str7 = (string) db.getValue(argAry, cls.cfnames(argFpre, "username")); string str8 = (string) db.getValue(argAry, cls.cfnames(argFpre, "password")); string str9 = (string) db.getValue(argAry, cls.cfnames(argFpre, "popedom")); session.set("admin-id", argValue); session.set("admin-username", str7); session.set("admin-popedom", str9); cookies.set("admin-username", str7); cookies.set("admin-password", str8); this.id = argValue; this.username = str7; this.popedom = str9; argObject = "update " + str4 + " set " + cls.cfnames(argFpre, "lasttime") + "='" + cls.getDate() + "'," + cls.cfnames(argFpre, "lastip") + "='" + request.ClientIP() + "' where " + cls.cfnames(argFpre, "username") + "='" + str2 + "'"; } else { flag = false; } if (!cls.isEmpty(argObject)) { db.Execute(argObject); } } return flag; }
public bool ckLogins(string argUsername, string argPassword) { string str = argUsername; string argString = argPassword; this.username = ""; this.popedom = ""; session.remove("admin-id"); session.remove("admin-username"); session.remove("admin-popedom"); bool flag = this.ckLogin(str, encode.md5(argString)); int num = 0; if (!flag) { num = 1; } db db = new db(); string str3 = cls.getString(jt.itake("global.config.admin-userlog-ndatabase", "cfg")); string argFpre = cls.getString(jt.itake("global.config.admin-userlog-nfpre", "cfg")); string str5 = string.Concat(new object[] { "insert into ", str3, " (", cls.cfnames(argFpre, "username"), ",", cls.cfnames(argFpre, "error"), ",", cls.cfnames(argFpre, "ip"), ",", cls.cfnames(argFpre, "time"), ") values ('", cls.getSafeString(str), "',", num, ",'", request.ClientIP(), "','", cls.getDate(), "')" }); db.Execute(str5); return flag; }
public void updateProperty(string argField, string argValue, string argType, string argUserId) { string argString = argField; string str2 = argValue; string str3 = argType; string str4 = argUserId; int argID = cls.getNum(str4, -1); if (argID != -1) { string argDatabase = cls.getString(jt.itake("global." + this.ngenre + ":config.ndatabase", "cfg")); string argFpre = cls.getString(jt.itake("global." + this.ngenre + ":config.nfpre", "cfg")); string str7 = cls.cfnames(argFpre, "id"); db db = new db(); switch (str3) { case "0": db.Execute(string.Concat(new object[] { "update ", argDatabase, " set ", cls.cfnames(argFpre, argString), "=", cls.cfnames(argFpre, argString), "+", cls.getNum(str2, 0), " where ", str7, "=", argID })); break; case "1": db.Execute(string.Concat(new object[] { "update ", argDatabase, " set ", cls.cfnames(argFpre, argString), "=", cls.getNum(str2, 0), " where ", str7, "=", argID })); break; case "2": db.Execute(string.Concat(new object[] { "update ", argDatabase, " set ", cls.cfnames(argFpre, argString), "='", encode.addslashes(str2), "' where ", str7, "=", argID })); break; } dbcache.deleteCache(argDatabase, argFpre, argID); } }
public static int dataDelete(db argDb, string argDatabase, string argIdfield, string argId) { return dataDelete(argDb, argDatabase, argIdfield, argId, ""); }
public static int getTopID(db argDb, string argDatabase, string argIdfield) { db db = argDb; string str = argDatabase; string str2 = argIdfield; int num = -1; string argString = "select max(" + str2 + ") from " + str; object[] objArray = db.getDataAry(argString); if (objArray != null) { num = cls.toInt32(db.getValue((object[,]) objArray[0], 0)); } return num; }
public static string itransferStandard(string argStrings) { int num7; object obj2; string argTemplate = ""; string argString = argStrings; string argXInfostr = cls.getParameter(argString, "tpl"); string argObject = cls.getParameter(argString, "tplid"); string str8 = cls.getParameter(argString, "tplstr"); string str9 = cls.getParameter(argString, "type"); string ngenre = cls.getParameter(argString, "genre"); string str11 = cls.getParameter(argString, "ndatabase"); string str12 = cls.getParameter(argString, "nfpre"); string str13 = cls.getParameter(argString, "osql"); string str14 = cls.getParameter(argString, "osqlorder"); string str15 = cls.getParameter(argString, "ocname"); string str16 = cls.getParameter(argString, "ocmode"); string str17 = cls.getParameter(argString, "rowfilter"); string str18 = cls.getParameter(argString, "baseurl"); string str19 = cls.getParameter(argString, "vars"); int num = cls.getNum(cls.getParameter(argString, "topx"), -1); int num2 = cls.getNum(cls.getParameter(argString, "cls"), -1); int num3 = cls.getNum(cls.getParameter(argString, "class"), -1); int argLng = cls.getNum(cls.getParameter(argString, "lng"), -1); int num5 = cls.getNum(cls.getParameter(argString, "bid"), -1); int num6 = cls.getNum(config.dbtype, 0); if (argLng == -1) { argLng = cls.getNum(config.nlng, -1); } if (num <= 0) { return argTemplate; } if (cls.isEmpty(str18) && (!cls.isEmpty(ngenre) && (ngenre != config.ngenre))) { str18 = cls.getActualRoute(ngenre); if (cls.getRight(str18, 1) != "/") { str18 = str18 + "/"; } } if (cls.isEmpty(ngenre)) { ngenre = config.ngenre; } string str20 = ""; string argFpre = ""; string str22 = ""; if (!cls.isEmpty(str11)) { str20 = cls.getString(str11); argFpre = cls.getString(str12); } else if (cls.isEmpty(str15)) { str20 = cls.getString(jt.itake("global." + ngenre + ":config.ndatabase", "cfg")); argFpre = cls.getString(jt.itake("global." + ngenre + ":config.nfpre", "cfg")); } else { str20 = cls.getString(jt.itake("global." + ngenre + ":config.ndatabase-" + str15, "cfg")); argFpre = cls.getString(jt.itake("global." + ngenre + ":config.nfpre-" + str15, "cfg")); } str22 = cls.cfnames(argFpre, "id"); if (cls.isEmpty(str20)) { return argTemplate; } string str23 = ""; string str24 = ""; switch (str9) { case "new": str23 = "select * from " + str20 + " where " + cls.cfnames(argFpre, "hidden") + "=0"; str24 = " order by " + cls.cfnames(argFpre, "time") + " desc"; break; case "-new": str23 = "select * from " + str20 + " where " + cls.cfnames(argFpre, "hidden") + "=0"; str24 = " order by " + cls.cfnames(argFpre, "time") + " asc"; break; case "@new": str23 = "select * from " + str20 + " where 1=1"; str24 = " order by " + cls.cfnames(argFpre, "time") + " desc"; break; case "top": str23 = "select * from " + str20 + " where " + cls.cfnames(argFpre, "hidden") + "=0"; str24 = " order by " + str22 + " desc"; break; case "-top": str23 = "select * from " + str20 + " where " + cls.cfnames(argFpre, "hidden") + "=0"; str24 = " order by " + str22 + " asc"; break; case "@top": str23 = "select * from " + str20 + " where 1=1"; str24 = " order by " + str22 + " desc"; break; case "commendatory": str23 = "select * from " + str20 + " where " + cls.cfnames(argFpre, "hidden") + "=0 and " + cls.cfnames(argFpre, "commendatory") + "=1"; str24 = " order by " + cls.cfnames(argFpre, "time") + " desc"; break; case "-commendatory": str23 = "select * from " + str20 + " where " + cls.cfnames(argFpre, "hidden") + "=0 and " + cls.cfnames(argFpre, "commendatory") + "=1"; str24 = " order by " + cls.cfnames(argFpre, "time") + " asc"; break; case "@commendatory": str23 = "select * from " + str20 + " where " + cls.cfnames(argFpre, "commendatory") + "=1"; str24 = " order by " + cls.cfnames(argFpre, "time") + " desc"; break; case "up": str23 = string.Concat(new object[] { "select * from ", str20, " where ", cls.cfnames(argFpre, "hidden"), "=0 and ", str22, ">", num5 }); str24 = " order by " + str22 + " asc"; break; case "down": str23 = string.Concat(new object[] { "select * from ", str20, " where ", cls.cfnames(argFpre, "hidden"), "=0 and ", str22, "<", num5 }); str24 = " order by " + str22 + " desc"; break; } if (num2 != -1) { string str25 = category.getClassChildIds(ngenre, argLng, cls.toString(num2)); if (!cls.isEmpty(str25)) { string str29 = str23; str23 = str29 + " and " + cls.cfnames(argFpre, "class") + " in (" + str25 + ")"; } } if (num3 != -1) { obj2 = str23; str23 = string.Concat(new object[] { obj2, " and ", cls.cfnames(argFpre, "class"), "=", num3 }); } if ((argLng != -1) && (argLng != -100)) { obj2 = str23; str23 = string.Concat(new object[] { obj2, " and ", cls.cfnames(argFpre, "lng"), "=", argLng }); } if (!cls.isEmpty(str13)) { str23 = str23 + str13; } if (!cls.isEmpty(str14)) { str24 = str14; } str23 = str23 + str24; if ((num6 >= 0) && (num6 < 10)) { str23 = string.Concat(new object[] { "select top ", num, " *", cls.getLRStr(str23, "select *", "rightr") }); } if ((num6 >= 10) && (num6 < 20)) { str23 = str23 + " limit 0," + num; } if (!cls.isEmpty(str8)) { argTemplate = str8; } else if (!cls.isEmpty(argObject)) { string[,] strArray = getJtbcElement(argObject); if ((strArray != null) && (strArray.GetLength(1) == 2)) { argTemplate = strArray[0, 1]; } } else if (argXInfostr.IndexOf(".") != -1) { argTemplate = jt.itake(argXInfostr, "tpl"); } else { argTemplate = jt.itake("global.tpl_transfer." + argXInfostr, "tpl"); } if (!cls.isEmpty(str19)) { string[] strArray2 = str19.Split(new char[] { '|' }); num7 = 0; while (num7 < strArray2.Length) { string str26 = strArray2[num7]; if (!cls.isEmpty(str26)) { string[] strArray3 = str26.Split(new char[] { '=' }); if (strArray3.Length == 2) { argTemplate = argTemplate.Replace("{$" + strArray3[0] + "}", strArray3[1]); } } num7++; } } object[] objArray = new db().getDataAry(str23); if (objArray != null) { string newValue = ""; int num8 = 0; string str2 = cls.ctemplate(ref argTemplate, "{@}"); for (int i = 0; i < objArray.Length; i++) { if (cls.isEmpty(str17) || !cls.cinstr(str17, cls.toString(i + 1), ",")) { num8++; string str4 = str2; object[,] objArray2 = (object[,]) objArray[i]; num7 = 0; while (num7 < objArray2.GetLength(0)) { objArray2[num7, 0] = cls.getLRStr((string) objArray2[num7, 0], argFpre, "rightr"); str4 = str4.Replace("{$" + cls.toString(objArray2[num7, 0]) + "}", encode.htmlencode(cls.toString(objArray2[num7, 1]), "1")); num7++; } config.rstAry = objArray2; str4 = str4.Replace("{$-genre}", ngenre).Replace("{$-lng}", cls.toString(argLng)).Replace("{$-baseurl}", str18).Replace("{$-i}", cls.toString(num8)); for (num7 = 2; num7 < 7; num7++) { int num10 = num8 % num7; str4 = str4.Replace("{$-!mod" + num7 + "}", cls.toString(num10)); if (num10 != 0) { str4 = str4.Replace("{$-!mod" + num7 + "-string}", ""); } else { str4 = str4.Replace("{$-!mod" + num7 + "-string}", cls.toString(str16)); } } str4 = jt.creplace(str4); newValue = newValue + str4; } } argTemplate = argTemplate.Replace(config.jtbccinfo, newValue); } else { argTemplate = ""; } return jt.creplace(argTemplate); }
public static string itransferSQL(string argStrings) { int num; string argTemplate = ""; string argString = argStrings; string argObject = cls.getParameter(argString, "sql"); string argXInfostr = cls.getParameter(argString, "tpl"); string str8 = cls.getParameter(argString, "tplid"); string str9 = cls.getParameter(argString, "tplstr"); string str10 = cls.getParameter(argString, "genre"); string str11 = cls.getParameter(argString, "ocmode"); string str12 = cls.getParameter(argString, "rowfilter"); string str13 = cls.getParameter(argString, "baseurl"); string str14 = cls.getParameter(argString, "vars"); if (cls.isEmpty(argObject)) { return argTemplate; } if (!(cls.getLRStr(argObject, " ", "left").ToLower() == "select")) { return argTemplate; } string str16 = argObject; string ngenre = config.ngenre; if (cls.isEmpty(str13) && (!cls.isEmpty(str10) && (str10 != ngenre))) { str13 = cls.getActualRoute(str10); if (cls.getRight(str13, 1) != "/") { str13 = str13 + "/"; } } if (cls.isEmpty(str10)) { str10 = ngenre; } if (!cls.isEmpty(str9)) { argTemplate = str9; } else if (!cls.isEmpty(str8)) { string[,] strArray = getJtbcElement(str8); if ((strArray != null) && (strArray.GetLength(1) == 2)) { argTemplate = strArray[0, 1]; } } else if (argXInfostr.IndexOf(".") != -1) { argTemplate = jt.itake(argXInfostr, "tpl"); } else { argTemplate = jt.itake("global.tpl_transfer." + argXInfostr, "tpl"); } if (!cls.isEmpty(str14)) { string[] strArray2 = str14.Split(new char[] { '|' }); num = 0; while (num < strArray2.Length) { string str18 = strArray2[num]; if (!cls.isEmpty(str18)) { string[] strArray3 = str18.Split(new char[] { '=' }); if (strArray3.Length == 2) { argTemplate = argTemplate.Replace("{$" + strArray3[0] + "}", strArray3[1]); } } num++; } } object[] objArray = new db().getDataAry(str16); if (objArray != null) { string newValue = ""; int num2 = 0; string str2 = cls.ctemplate(ref argTemplate, "{@}"); for (int i = 0; i < objArray.Length; i++) { if (cls.isEmpty(str12) || !cls.cinstr(str12, cls.toString(i + 1), ",")) { num2++; string str4 = str2; object[,] objArray2 = (object[,]) objArray[i]; num = 0; while (num < objArray2.GetLength(0)) { str4 = str4.Replace("{$" + cls.toString(objArray2[num, 0]) + "}", encode.htmlencode(cls.toString(objArray2[num, 1]), "1")); num++; } config.rstAry = objArray2; str4 = str4.Replace("{$-genre}", str10).Replace("{$-baseurl}", str13).Replace("{$-i}", cls.toString(num2)); for (num = 2; num < 7; num++) { int num4 = num2 % num; str4 = str4.Replace("{$-!mod" + num + "}", cls.toString(num4)); if (num4 != 0) { str4 = str4.Replace("{$-!mod" + num + "-string}", ""); } else { str4 = str4.Replace("{$-!mod" + num + "-string}", cls.toString(str11)); } } str4 = jt.creplace(str4); newValue = newValue + str4; } } argTemplate = argTemplate.Replace(config.jtbccinfo, newValue); } else { argTemplate = ""; } return jt.creplace(argTemplate); }
public static int dataSwitch(db argDb, string argDatabase, string argField, string argIdfield, string argId) { return dataSwitch(argDb, argDatabase, argField, argIdfield, argId, ""); }
public bool Login(string argUsername, string argPassword, string argRemember) { bool flag = false; this.Logout(); string argValue = cls.getSafeString(argUsername); string str2 = encode.md5(cls.getSafeString(argPassword)); int num = cls.getNum(argRemember, 0); db db = new db(); string str3 = cls.getString(jt.itake("global." + this.ngenre + ":config.ndatabase", "cfg")); string argFpre = cls.getString(jt.itake("global." + this.ngenre + ":config.nfpre", "cfg")); string argString = cls.cfnames(argFpre, "id"); string str6 = "select * from " + str3 + " where " + cls.cfnames(argFpre, "username") + "='" + argValue + "' and " + cls.cfnames(argFpre, "password") + "='" + str2 + "' and " + cls.cfnames(argFpre, "lock") + "=0"; object[] objArray = db.getDataAry(str6); if (objArray == null) { return flag; } object[,] argAry = (object[,]) objArray[0]; string str7 = cls.toString(db.getValue(argAry, argString)); if (num == 0) { cookies.set(this.ngenre + "-userid", str7); cookies.set(this.ngenre + "-username", argValue); cookies.set(this.ngenre + "-password", str2); } else { cookies.set(this.ngenre + "-userid", str7, 0x1e13380); cookies.set(this.ngenre + "-username", argValue, 0x1e13380); cookies.set(this.ngenre + "-password", str2, 0x1e13380); } session.set(this.ngenre + "-nuserid", str7); session.set(this.ngenre + "-nusername", argValue); db.Execute("update " + str3 + " set " + cls.cfnames(argFpre, "prelasttime") + "=" + cls.cfnames(argFpre, "lasttime") + " where " + argString + "=" + str7); db.Execute("update " + str3 + " set " + cls.cfnames(argFpre, "lasttime") + "='" + cls.getDate() + "' where " + argString + "=" + str7); return true; }
// GET api/<controller> public IHttpActionResult GetAllUsers() { jtbc.db db = new jtbc.db(0, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=App_Data/test.mdb;"); users = (Dictionary<string, object>[])db.getDataAry("select * from users"); Dictionary<string, object> ret = new Dictionary<string, object>(); ret.Add("errorCode", 0); ret.Add("users", users); return Ok(ret); }
public static object[,] getDBAry(string argDatabase, string argFPre, int argID) { object[,] objArray = null; string str = cls.getString(argDatabase); string argFpre = cls.getString(argFPre); int num = argID; db db = new db(); string argString = string.Concat(new object[] { "select * from ", str, " where ", cls.cfnames(argFpre, "id"), "=", num }); object[] objArray2 = db.getDataAry(argString); if (objArray2 != null) { objArray = (object[,]) objArray2[0]; } return objArray; }
public static string itransferMultiGenre(string argStrings) { int num6; string argTemplate = ""; string argString = argStrings; string argXInfostr = cls.getParameter(argString, "tpl"); string argObject = cls.getParameter(argString, "tplid"); string str8 = cls.getParameter(argString, "tplstr"); string str9 = cls.getParameter(argString, "type"); string str10 = cls.getParameter(argString, "genre"); string str11 = cls.getParameter(argString, "field"); string str12 = cls.getParameter(argString, "osql"); string str13 = cls.getParameter(argString, "osqlorder"); string str14 = cls.getParameter(argString, "ocmode"); string str15 = cls.getParameter(argString, "rowfilter"); string str16 = cls.getParameter(argString, "baseurl"); string str17 = cls.getParameter(argString, "vars"); int num = cls.getNum(cls.getParameter(argString, "topx"), -1); int num2 = cls.getNum(cls.getParameter(argString, "lng"), -1); int num3 = cls.getNum(config.dbtype, 0); if (num2 == -1) { num2 = cls.getNum(config.nlng, -1); } if (num <= 0) { return argTemplate; } string ngenre = config.ngenre; if (cls.isEmpty(str10)) { return argTemplate; } string str19 = ""; string str20 = ""; str19 = str19 + "select * from ("; foreach (string str21 in str10.Split(new char[] { '&' })) { string str22 = cls.getString(jt.itake("global." + str21 + ":config.ndatabase", "cfg")); string argFpre = cls.getString(jt.itake("global." + str21 + ":config.nfpre", "cfg")); if (!cls.isEmpty(str22)) { string str29; str19 = str19 + "select " + cls.cfnames(argFpre, "id") + " as un_id,"; foreach (string str24 in str11.Split(new char[] { '&' })) { str29 = str19; str19 = str29 + cls.cfnames(argFpre, str24) + " as un_" + str24 + ","; } str29 = str19; str19 = str29 + cls.cfnames(argFpre, "time") + " as un_time, '" + str21 + "' as un_genre from " + str22; switch (str9) { case "new": str19 = str19 + " where " + cls.cfnames(argFpre, "hidden") + "=0"; str20 = " order by un_time desc"; break; case "-new": str19 = str19 + " where " + cls.cfnames(argFpre, "hidden") + "=0"; str20 = " order by un_time desc"; break; case "@new": str19 = str19 + " where 1=1"; str20 = " order by un_time desc"; break; case "commendatory": str29 = str19; str19 = str29 + " where " + cls.cfnames(argFpre, "hidden") + "=0 and " + cls.cfnames(argFpre, "commendatory") + "=1"; str20 = " order by un_time desc"; break; case "-commendatory": str29 = str19; str19 = str29 + " where " + cls.cfnames(argFpre, "hidden") + "=0 and " + cls.cfnames(argFpre, "commendatory") + "=1"; str20 = " order by un_time desc"; break; case "@commendatory": str19 = str19 + " where " + cls.cfnames(argFpre, "commendatory") + "=1"; str20 = " order by un_time desc"; break; default: str19 = str19 + " where " + cls.cfnames(argFpre, "hidden") + "=0"; str20 = " order by un_time desc"; break; } if ((num2 != -1) && (num2 != -100)) { object obj2 = str19; str19 = string.Concat(new object[] { obj2, " and ", cls.cfnames(argFpre, "lng"), "=", num2 }); } str19 = str19 + " union all "; } } if (str19.IndexOf(" union all ") != -1) { str19 = cls.getLRStr(str19, " union all ", "leftr"); } str19 = str19 + ") t1 where 1=1"; if (!cls.isEmpty(str12)) { str19 = str19 + str12; } if (!cls.isEmpty(str13)) { str20 = str13; } str19 = str19 + str20; if ((num3 >= 0) && (num3 < 10)) { str19 = string.Concat(new object[] { "select top ", num, " *", cls.getLRStr(str19, "select *", "rightr") }); } if ((num3 >= 10) && (num3 < 20)) { str19 = str19 + " limit 0," + num; } if (!cls.isEmpty(str8)) { argTemplate = str8; } else if (!cls.isEmpty(argObject)) { string[,] strArray3 = getJtbcElement(argObject); if ((strArray3 != null) && (strArray3.GetLength(1) == 2)) { argTemplate = strArray3[0, 1]; } } else if (argXInfostr.IndexOf(".") != -1) { argTemplate = jt.itake(argXInfostr, "tpl"); } else { argTemplate = jt.itake("global.tpl_transfer." + argXInfostr, "tpl"); } if (!cls.isEmpty(str17)) { string[] strArray4 = str17.Split(new char[] { '|' }); num6 = 0; while (num6 < strArray4.Length) { string str25 = strArray4[num6]; if (!cls.isEmpty(str25)) { string[] strArray5 = str25.Split(new char[] { '=' }); if (strArray5.Length == 2) { argTemplate = argTemplate.Replace("{$" + strArray5[0] + "}", strArray5[1]); } } num6++; } } db db = new db(); object[] objArray = db.getDataAry(str19); if (objArray != null) { string newValue = ""; int num7 = 0; string str2 = cls.ctemplate(ref argTemplate, "{@}"); for (int i = 0; i < objArray.Length; i++) { if (cls.isEmpty(str15) || !cls.cinstr(str15, cls.toString(i + 1), ",")) { num7++; string str4 = str2; object[,] argAry = (object[,]) objArray[i]; num6 = 0; while (num6 < argAry.GetLength(0)) { argAry[num6, 0] = cls.getLRStr((string) argAry[num6, 0], "un_", "rightr"); str4 = str4.Replace("{$" + cls.toString(argAry[num6, 0]) + "}", encode.htmlencode(cls.toString(argAry[num6, 1]), "1")); num6++; } config.rstAry = argAry; string argRoutestr = cls.toString(db.getValue(argAry, "genre")); string str27 = ""; if (!cls.isEmpty(str16)) { str27 = str16; } else if (argRoutestr != ngenre) { str27 = cls.getActualRoute(argRoutestr); if (cls.getRight(str27, 1) != "/") { str27 = str27 + "/"; } } str4 = str4.Replace("{$-genre}", encode.htmlencode(argRoutestr)).Replace("{$-baseurl}", str27).Replace("{$-i}", cls.toString(num7)); for (num6 = 2; num6 < 7; num6++) { int num9 = num7 % num6; str4 = str4.Replace("{$-!mod" + num6 + "}", cls.toString(num9)); if (num9 != 0) { str4 = str4.Replace("{$-!mod" + num6 + "-string}", ""); } else { str4 = str4.Replace("{$-!mod" + num6 + "-string}", cls.toString(str14)); } } str4 = jt.creplace(str4); newValue = newValue + str4; } } argTemplate = argTemplate.Replace(config.jtbccinfo, newValue); } else { argTemplate = ""; } return jt.creplace(argTemplate); }
public int getUserID(string argUsername) { int num = 0; string str = cls.getSafeString(argUsername); db db = new db(); string str2 = cls.getString(jt.itake("global." + this.ngenre + ":config.ndatabase", "cfg")); string argFpre = cls.getString(jt.itake("global." + this.ngenre + ":config.nfpre", "cfg")); string argString = cls.cfnames(argFpre, "id"); string str5 = "select * from " + str2 + " where " + cls.cfnames(argFpre, "username") + "='" + str + "'"; object[] objArray = db.getDataAry(str5); if (objArray != null) { object[,] argAry = (object[,]) objArray[0]; num = cls.toInt32(db.getValue(argAry, argString)); } return num; }