public static DataSet Get(string tableQuery)
{
QueryServiceClient client = new QueryServiceClient();
DataSet dataSet = new DataSet();
Paging paging = null;
try
{
if (string.IsNullOrEmpty(Logon.User) && string.IsNullOrEmpty(Logon.Password))
{
client.ClientCredentials.Windows.ClientCredential.Domain = Logon.Domain;
client.ClientCredentials.Windows.ClientCredential.UserName = Logon.DefaultUser;
client.ClientCredentials.Windows.ClientCredential.Password = Logon.DefaultPassword;
}
else
{
client.ClientCredentials.Windows.ClientCredential.Domain = Logon.Domain;
client.ClientCredentials.Windows.ClientCredential.UserName = Logon.User;
client.ClientCredentials.Windows.ClientCredential.Password = Logon.Password;
}
dataSet = client.ExecuteStaticQuery(tableQuery, ref paging);
}
catch (Exception ex)
{
string msg = ex.Message;
}
return(dataSet);
}
public static DataSet Paging()
{
QueryServiceClient client = new QueryServiceClient();
Paging paging = new ValueBasedPaging()
{
RecordLimit = 20
};
DataSet dataset;
int page = 10;
int i = 0;
do
{
dataset = client.ExecuteStaticQuery("STMSalesDaily", ref paging);
DataRow row = dataset.Tables[0].Rows[0];
i++;
if (i == page)
{
return(dataset);
}
}while (((ValueBasedPaging)paging).Bookmark != null);
return(dataset);
}
public static DataSet Get(string tableQuery)
{
QueryServiceClient client = new QueryServiceClient();
DataSet dataSet = new DataSet();
Paging paging = null;
try
{
client.ClientCredentials.Windows.ClientCredential.Domain = UserAccount.Domain;
client.ClientCredentials.Windows.ClientCredential.UserName = UserAccount.Username;
client.ClientCredentials.Windows.ClientCredential.Password = UserAccount.Password;
dataSet = client.ExecuteStaticQuery(tableQuery, ref paging);
}
catch (Exception ex)
{
string msg = ex.Message;
}
return(dataSet);
}
