Example #1
0
 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, "'"
              }));
         }
     }
 }
Example #2
0
		// 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);
		}
Example #3
0
 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;
 }
Example #4
0
 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;
 }
Example #5
0
        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);
            }
        }
Example #6
0
 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;
 }