/// <summary> /// 删除 /// </summary> /// <param name="tablename">表名,例如:sys_employee</param> /// <param name="strJson">["10","11"]或{"key1":"201201010001","key2":"201201010001"}或者{"where_1":"input_dt>='20120101'"}</param> /// <param name="msg"></param> public static void Delete(string tablename, string strJson, ref string msg) { try { string database = str_dbDefault; if (database == "") database = "db_drsyn"; tablename = database + "." + tablename; ws.data.jsonDal.OperateDataJsonHelper opdata = new ws.data.jsonDal.OperateDataJsonHelper(); opdata.Gen_Delete(tablename, strJson, ref msg); string pstda = opdata.GenOperateJson(); string rtn = SendHttpRequest.SendRequestByJson(pstda); if (rtn.Substring(0, 6) == "<error") { msg = rtn; } } catch (Exception ex) { msg = ex.Message; } }
/// <summary> /// 添加 /// </summary> /// <param name="tablename">表名,例如:sys_employee</param> /// <param name="strJson">{a:'aaa',b:'bb'}或[{a:'aaa',b:'bb'},{a:'aaa1',b:'bb2'}]</param> /// <msg></msg> /// <returns>添加成功的id,例如:100或1,2,3</returns> public static string Insert(string tablename,string strJson,ref string msg) { try { string database = str_dbDefault; if (database == "") database = "db_drsyn"; tablename = database + "." + tablename; ws.data.jsonDal.OperateDataJsonHelper opdata = new ws.data.jsonDal.OperateDataJsonHelper(); opdata.Gen_Insert(tablename, strJson, ref msg); string pstda = opdata.GenOperateJson(); string rtn = SendHttpRequest.SendRequestByJson(pstda); if (rtn.Substring(0, 6) == "<error") { msg = rtn; return ""; } return rtn.Replace("<succ msg='", "").Replace("'/>", ""); } catch (Exception ex) { msg = ex.Message; return ""; } }