private static long GetSessionID(out bool bolIsOverFlow)
{
long lSessionID = 0;
bolIsOverFlow = false;
LBDbParameterCollection parmCol = new LBDbParameterCollection();
parmCol.Add(new LBParameter("ClientIP", enLBDbType.String, MachineIP));
parmCol.Add(new LBParameter("ClientSerial", enLBDbType.String, MachineSeries));
DataSet dsReturn;
Dictionary <string, object> dictValue;
ExecuteSQL.CallSP(15000, false, parmCol, out dsReturn, out dictValue);
if (dictValue.ContainsKey("SessionID"))
{
long.TryParse(dictValue["SessionID"].ToString(), out lSessionID);
}
if (dictValue.ContainsKey("IsOverFlow"))
{
if (dictValue["IsOverFlow"].ToString() == "1")
{
bolIsOverFlow = true;
}
}
return(lSessionID);
}
public static void CallSP(int iSPType, bool bolIsNeedSession, LBDbParameterCollection parmCollection, out DataSet dsReturn, out Dictionary <string, object> dictReturn)
{
dictReturn = new Dictionary <string, object>();
DataTable dtSPIN = new DataTable("SPIN");
foreach (LBParameter parm in parmCollection)
{
if (!dtSPIN.Columns.Contains(parm.ParameterName))
{
dtSPIN.Columns.Add(parm.ParameterName, LBDbType.GetSqlDbType(parm.LBDBType));
}
}
DataRow drNew = dtSPIN.NewRow();
foreach (LBParameter parm in parmCollection)
{
if (parm.Direction != ParameterDirection.Output)
{
drNew[parm.ParameterName] = parm.Value;
}
}
dtSPIN.Rows.Add(drNew);
//LBWebService.LBWebService webservice = GetLBWebService();
string strErrorMsg;
bool bolIsError;
DataTable dtOut;
CallSP(iSPType, bolIsNeedSession, dtSPIN, out dsReturn, out dtOut);
if (dtOut != null && dtOut.Rows.Count > 0)
{
foreach (DataColumn dc in dtOut.Columns)
{
if (!dictReturn.ContainsKey(dc.ColumnName))
{
dictReturn.Add(dc.ColumnName, dtOut.Rows[0][dc.ColumnName]);
}
}
}
}
/// <summary>
/// 调用存储过程或中间层
/// </summary>
/// <param name="iSPType">存储过程号</param>
/// <param name="parmCollection">参数数据</param>
/// <param name="dsReturn">返回的查询数据</param>
/// <param name="dictReturn">返回的参数值</param>
public static void CallSP(int iSPType, LBDbParameterCollection parmCollection, out DataSet dsReturn, out Dictionary <string, object> dictReturn)
{
CallSP(iSPType, true, parmCollection, out dsReturn, out dictReturn);
}