public void TestMethod1() { var datastr = "{'tablename':'xs_zdjbxx','wheret':'ysdm=^666666^'}"; var datastr1 = "Ëwı²¼µ¾±½µwwÈïʴº²ÈÈw|wǸµÂµÄwwÉô½®®wÍ"; var key = "PGY"; var r1 = ComTool.CustomDecryption(datastr, key, false); var r2 = ComTool.CustomDecryption(r1, key, true); Assert.IsTrue(r1 == r2); }
public object GetAct() { var type = (ComEnum.ActEnum)Type; object obj = null; Data = ComTool.CustomDecryption(Data.ToString(), ComWebSetting.AppSetingConfig["Key"], true, Data.ToString().Length % (ComWebSetting.KEY.Length % 5)); var SQl = Data.ToString().Replace("~", "\\\"").Replace("^", "\\\'");//~双引号 ^单引号 switch (type) { case ComEnum.ActEnum.Select: //查尽量带t {"Type":"1","Data":"{'tablename':'xs_zdjbxx t','fields':'zl,ysdm','WhereT':'t.zddm=^610821104200GB00039^','Orderby':'t.bsm'}"} obj = JsonConvert.DeserializeObject <ActSelect>(SQl); break; case ComEnum.ActEnum.Insert: //增values不加引号 {"Type":"2","Data":"{'tablename':'xs_zdjbxx','fields':'zl,ysdm','values':'神木县大柳塔镇光明路66666,666666'}"} obj = JsonConvert.DeserializeObject <ActInsert>(SQl); break; case ComEnum.ActEnum.Update: //更新values不加引号 {"Type":"3","Data":"{'tablename':'xs_zdjbxx t','fields':'zl,ysdm','values':'神木县大柳塔镇光明路,6001010001','WhereT':'t.zddm=^610821104200GB00039^'}"} obj = JsonConvert.DeserializeObject <ActUpdate>(SQl); break; case ComEnum.ActEnum.Delete: //删除 {"Type":"4","Data":"{'tablename':'xs_zdjbxx','wheret':'ysdm=^666666^'}"} obj = JsonConvert.DeserializeObject <ActDelete>(SQl); break; case ComEnum.ActEnum.Other: //多条不用begin不行 {"Type":"5","Data":"begin update xs_zdjbxx set zl=zl||'1' where zddm='610821104200GB00030';update xs_zdjbxx set zl=zl||'2' where zddm='610821104200GB00031'; end;"} obj = Data.ToString(); break; case ComEnum.ActEnum.SelectPageProc: obj = JsonConvert.DeserializeObject <PageParam>(SQl); break; case ComEnum.ActEnum.Proc: //注意sql用select *时 一定要带别名 t.* /*{"Type":"6","Data":{"ProcName":"Pager","Param":[{"ParamName":"datasql","DbType":"varchar2","Direction":"in","Value":"select t.* from manage_user t"},{"ParamName":"pagesize","DbType":"int32","Direction":"in","Value":"5"},{"ParamName":"currtpage","DbType":"int32","Direction":"in","Value":"1"},{"ParamName":"pagenum","DbType":"int32","Direction":"out","Value":""},{"ParamName":"numcount","DbType":"int32","Direction":"out","Value":""},{"ParamName":"v_cur","DbType":"cursor","Direction":"out","Value":""}],"IsRetTable":"True"}}*/ obj = JsonConvert.DeserializeObject <ComProcParam>(SQl); break; } return(obj); }