public string WebDBSqlOne(string strProcName, SortedList SDList)
{
DataSet dsIn = SDListToDS(SDList);
TEST.CHE9000.CHE9000SoapClient TT = new TEST.CHE9000.CHE9000SoapClient();
string strBack = TT.ServerDBQueryOne(strProcName, dsIn);
return strBack;
}
public DataSet WebDBSqlDS(string strProcName, SortedList SDList)
{
DataSet dsIn = SDListToDS(SDList);
TEST.CHE9000.CHE9000SoapClient TT = new TEST.CHE9000.CHE9000SoapClient();
DataSet dsOut = TT.ServerDBQuery(strProcName, dsIn);
return dsOut;
}
public DataTable WebDBSqlDT(string strProcName, SortedList SDList)
{
DataSet dsIn = SDListToDS(SDList);
TEST.CHE9000.CHE9000SoapClient TT = new TEST.CHE9000.CHE9000SoapClient();
DataSet dsOut = TT.ServerDBQuery(strProcName, dsIn);
if (dsOut != null && dsOut.Tables.Count > 0)
{
return dsOut.Tables[0];
}
else
{
return null;
}
}
public string picUP(int iBillID, int iTYPE, string strFileName, string strPicData)
{
TEST.CHE9000.CHE9000SoapClient TT = new TEST.CHE9000.CHE9000SoapClient();
string strBack = TT.ServerPICSave(iBillID, iTYPE, strFileName, strPicData);
return strBack;
}
public string picDown(int iFILEID)
{
TEST.CHE9000.CHE9000SoapClient TT = new TEST.CHE9000.CHE9000SoapClient();
string strBack = TT.ServerPICReadByID(iFILEID);
return strBack;
}