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));
}
