在项目的开发中使用Remoting,并且所有的数据请求服务都是通过Remoting完成的,所以自然就在其中到了传递参数的存储过程,在业务逻辑中把参数构建好后传递到Remoting服务端,在取出存储过程的参数时报错,具体错误不记得了,自己尝试了各种方法也不行,上网资讯也没有结果,最后变通了一下,问题解决了,例子如下:
以下部分为客户调用端
1
//先声明参数
2
private const string PARAM_GUID = "@GUID";
3
private const string PARAM_VGA_TREEGUID = "@VGATreeGUID";
4
private const string PARAM_MB_TREEGUID = "@MBTreeGUID";
5![](/Images/OutliningIndicators/None.gif)
6
public static string GetProductTypeByGUID(string GUID, String VGATreeID, String MbTreeID)
7
{
8
try
9
{
10
int lcID = Thread.CurrentThread.CurrentUICulture.LCID;
11![](/Images/OutliningIndicators/InBlock.gif)
12
BaseModel bt = new BaseModel();
13![](/Images/OutliningIndicators/InBlock.gif)
14
//构建一个哈希表,把参数依次压入
15
Hashtable parames = new Hashtable();
16
parames.Add(PARAM_PROGUID, GUID);
17
parames.Add(PARAM_VGA_TREEGUID, VGATreeID);
18
parames.Add(PARAM_MB_TREEGUID, MbTreeID);
19![](/Images/OutliningIndicators/InBlock.gif)
20
//把存储过程名称和带参数的哈希表传入
21
DataAccess.DataBase.RunProcedureDataSet(lcID, "GetProductTypeByTreeID", parames, ref bt);
22![](/Images/OutliningIndicators/InBlock.gif)
23
return bt.Rows[0]["ProductType"].ToString();
24
}
25
catch (Exception ex)
26
{
27
CommFunction.WriteErrorLogFile("public static string GetProductTypeByGUID(stirng GUID, String VGATreeID, String MbTreeID)出错:" + ex.Message);
28
return "Other";
29
}
30
}
31![](/Images/OutliningIndicators/None.gif)
32![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/InBlock.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/InBlock.gif)
24
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
25
![](/Images/OutliningIndicators/InBlock.gif)
26
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
27
![](/Images/OutliningIndicators/InBlock.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
30
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
31
![](/Images/OutliningIndicators/None.gif)
32
![](/Images/OutliningIndicators/None.gif)
以下为服务端:
1
public void Query(int lcid, string SQLString, Hashtable cmdHashtable, ref BaseModel baseModel)
![](/Images/OutliningIndicators/ContractedBlock.gif)