public string RunView_Service(int iViewType, string strLoginName, string strFieldNames, string strWhere, string strOrderBy, out string ErrorMsg, out bool bolIsError) { ErrorMsg = ""; bolIsError = false; WebSerivce.BaseInfoService service = new WebSerivce.BaseInfoService(); service.Url = mstrWebServiceAddress; DataTable dtReturn = null; try { dtReturn = service.CallView(strLoginName, iViewType, strFieldNames, strWhere, strOrderBy); } catch (Exception ex) { if (ex.InnerException != null) { ErrorMsg = ex.InnerException.Message; } else { ErrorMsg = ex.Message; } bolIsError = true; return(""); } return(RarDataTable(dtReturn)); }
public string RunDirectSQL_Service(string strLoginName, string strSQL, out string ErrorMsg, out bool bolIsError) { ErrorMsg = ""; bolIsError = false; WebSerivce.BaseInfoService service = new WebSerivce.BaseInfoService(); service.Url = mstrWebServiceAddress; DataTable dtReturn = null; try { dtReturn = service.CallDirectSQL(strLoginName, strSQL); } catch (Exception ex) { if (ex.InnerException != null) { ErrorMsg = ex.InnerException.Message; } else { ErrorMsg = ex.Message; } bolIsError = true; return(""); } return(RarDataTable(dtReturn)); }
//调用网络接口 public string RunProcedure_Service(int ProcedureType, string strLoginName, byte[] bSerializeValue, byte[] bSerializeDataType, out string strOut, out string ErrorMsg, out bool bolIsError) { strOut = ""; ErrorMsg = ""; bolIsError = false; DataSet dsReturn = null; WebSerivce.BaseInfoService service = new WebSerivce.BaseInfoService(); service.Url = mstrWebServiceAddress; try { DataTable dtParmValue = new DataTable("SPIN"); List <Dictionary <object, object> > lstDictValue = DeserializeObject(bSerializeValue) as List <Dictionary <object, object> >; Dictionary <object, object> dictDataType = DeserializeObject(bSerializeDataType) as Dictionary <object, object>; foreach (KeyValuePair <object, object> keyvalue in dictDataType) { dtParmValue.Columns.Add(keyvalue.Key.ToString(), GetType(keyvalue.Value.ToString())); } foreach (Dictionary <object, object> dictValue in lstDictValue) { DataRow drNew = dtParmValue.NewRow(); foreach (KeyValuePair <object, object> keyvalue in dictValue) { drNew[keyvalue.Key.ToString()] = keyvalue.Value; } dtParmValue.Rows.Add(drNew); } dtParmValue.AcceptChanges(); DataTable dtOut; dsReturn = service.CallSP(strLoginName, ProcedureType, dtParmValue, out dtOut); strOut = RarDataTable(dtOut); } catch (Exception ex) { if (ex.InnerException != null) { ErrorMsg = ex.InnerException.Message; } else { ErrorMsg = ex.Message; } bolIsError = true; return(""); } return(RarDataSet(dsReturn)); }