public static bool LoadData(DataTable table, string rulename, string paramvalue, string pageinfo, string defwhere, string dsname) { try { InParams inparams = SDPClient.NewInParams(); OutParams outparams = SDPClient.NewOutParams(); inparams.SetRequestBody("ServiceName", "DataServices"); inparams.SetRequestBody("ServiceItem", "LoadData"); inparams.SetRequestBody("RuleName", rulename); inparams.SetRequestBody("DefWhere", defwhere); inparams.SetRequestBody("PageInfo", pageinfo); inparams.SetRequestBody("DataSource", dsname); inparams.SetRequestParams(paramvalue); SDPClient.CallService(inparams, outparams); DataTable resultTable = outparams.GetTableParam(rulename).GetDataTableValue(); if (table.Columns.Count <= 0) { DataUtil.InitTableSchemaFromDataRule(table, rulename); } return(DataUtil.CopyTable(resultTable, table)); } catch (Exception e) { System.Console.Out.WriteLine("DataServices.LoadData Exception: {0}", e); throw e; } }
public static String CallCursorStoreProcExt(DataTable table, String procname, String paramvalue, String dsname) { try { InParams inparams = SDPClient.NewInParams(); OutParams outparams = SDPClient.NewOutParams(); inparams.SetRequestBody("ServiceName", "DataServices"); inparams.SetRequestBody("ServiceItem", "CallStoreProc"); inparams.SetRequestBody("StoreProcType", "CursorStoreProcExt"); inparams.SetRequestBody("StoreProcName", procname); inparams.SetRequestBody("DataSource", dsname); inparams.SetRequestParams(paramvalue); SDPClient.CallService(inparams, outparams); DataTable resulttable = outparams.GetTableParamValue(0); DataUtil.CopyTable(resulttable, table); return(outparams.GetStrParamValue("Result")); } catch (Exception e) { System.Console.Out.WriteLine("DataServices.CallCursorStoreProcExt Exception: {0}", e); throw e; } }
public static DataRule LoadDataInfo(DataTable table, String rulename, String paramvalue, String pageinfo, String defwhere, String dsname) { try { InParams inparams = SDPClient.NewInParams(); OutParams outparams = SDPClient.NewOutParams(); inparams.SetRequestBody("ServiceName", "DataServices"); inparams.SetRequestBody("ServiceItem", "LoadDataInfo"); inparams.SetRequestBody("RuleName", rulename); inparams.SetRequestBody("DefWhere", defwhere); inparams.SetRequestBody("PageInfo", pageinfo); inparams.SetRequestBody("DataSource", dsname); inparams.SetRequestParams(paramvalue); SDPClient.CallService(inparams, outparams); DataRule rule = new DataRule(rulename, outparams); SystemContext.RuleManager.AppendDataRule(rule); DataTable resulttable = outparams.GetTableParam(rulename).GetDataTableValue(); DataUtil.InitTableSchemaFromDataRule(table, rule); DataUtil.CopyTable(resulttable, table); return(rule); } catch (Exception e) { System.Console.Out.WriteLine("DataServices.LoadDataInfo Exception: {0}", e); throw e; } }
private void button_callService_Click(object sender, EventArgs e) { InParams inparams = SDPClient.NewInParams(comboBox_proCode.Text.Trim()); OutParams outparams = SDPClient.NewOutParams(); inparams.SetRequestBody(textBox_reqBody.Text.Trim()); inparams.SetRequestParams(textBox_reqParams.Text.Trim()); CallService(inparams, outparams); }
public static String GetStrValueFromService(String servicename, String serviceitem, String serviceparams) { try { InParams inparams = SDPClient.NewInParams(); OutParams outparams = SDPClient.NewOutParams(); inparams.SetRequestBody("ServiceName", servicename); inparams.SetRequestBody("ServiceItem", serviceitem); inparams.SetRequestParams(serviceparams); SDPClient.RouteService(inparams, outparams); return(outparams.GetStrParamValue(0)); } catch (Exception e) { System.Console.Out.WriteLine("CommonServices.GetStrValueFromService Exception: {0}", e); throw e; } }
public static bool OpenSql(DataTable table, String sql, String paramvalue, String pageinfo, String dsname) { try { InParams inparams = SDPClient.NewInParams(); OutParams outparams = SDPClient.NewOutParams(); inparams.SetRequestBody("ServiceName", "DataServices"); inparams.SetRequestBody("ServiceItem", "OpenSql"); inparams.SetRequestBody("SQL", sql); inparams.SetRequestBody("PageInfo", pageinfo); inparams.SetRequestBody("DataSource", dsname); if (TableUtil.IsAutoMetaData(table)) { inparams.SetRequestBody("AutoMetaData", "1"); } else { inparams.SetRequestBody("TableName", table.TableName); } inparams.SetRequestParams(paramvalue); SDPClient.CallService(inparams, outparams); DataTable resulttable = outparams.GetTableParam(0).GetDataTableValue(); DataUtil.CopyTable(resulttable, table); TableUtil.SetProperty(table, "DataSource", outparams.GetStrParamValue("DataSource")); TableUtil.SetProperty(table, "Command", outparams.GetStrParamValue("Command")); return(true); } catch (Exception e) { System.Console.Out.WriteLine("DataServices.OpenSql Exception: {0}", e); throw e; } }
public static void CallService(DataTable table, String servicename, String serviceitem, String paramvalue) { try { InParams inparams = SDPClient.NewInParams(); OutParams outparams = SDPClient.NewOutParams(); inparams.SetRequestBody("ServiceName", servicename); inparams.SetRequestBody("ServiceItem", serviceitem); inparams.SetRequestParams(paramvalue); SDPClient.CallService(inparams, outparams); DataTable resulttable = outparams.GetTableParamValue(0); DataUtil.CopyTable(resulttable, table); } catch (Exception e) { System.Console.Out.WriteLine("DataServices.CallService Exception: {0}", e); throw e; } }
public static String CallStoreProc(String procname, String paramvalue, String dsname) { try { InParams inparams = SDPClient.NewInParams(); OutParams outparams = SDPClient.NewOutParams(); inparams.SetRequestBody("ServiceName", "DataServices"); inparams.SetRequestBody("ServiceItem", "CallStoreProc"); inparams.SetRequestBody("StoreProcType", "StoreProc"); inparams.SetRequestBody("StoreProcName", procname); inparams.SetRequestBody("DataSource", dsname); inparams.SetRequestParams(paramvalue); SDPClient.CallService(inparams, outparams); return(outparams.GetStrParam("Result").GetStrValue()); } catch (Exception e) { System.Console.Out.WriteLine("DataServices.CallStoreProc Exception: {0}", e); throw e; } }