public static object GetValue(string selectcmd)
{
BarCode.DataService.ReturnClass result = new BarCode.DataService.ReturnClass();
BarCode.DataService.DataService service = new BarCode.DataService.DataService();
result = service.GetValue(selectcmd, userid, password, server, database);
if (!result.IsOK)
{
errorText = result.Message;
}
return(result.Value);
}
/// <summary>
/// 执行命令
/// </summary>
/// <param name="commandtext">命令语句</param>
public static bool Execute(string commandtext)
{
BarCode.DataService.ReturnClass result = new BarCode.DataService.ReturnClass();
BarCode.DataService.DataService service = new BarCode.DataService.DataService();
result = service.Execute(commandtext, userid, password, server, database);
if (!result.IsOK)
{
errorText = result.Message;
}
return(result.IsOK);
}
/// <summary>
/// 检查用户有效性
/// </summary>
/// <param name="userid"></param>
/// <param name="password"></param>
/// <returns></returns>
public static bool CheckUser(string userid, string password)
{
BarCode.DataService.ReturnClass result = new BarCode.DataService.ReturnClass();
BarCode.DataService.DataService service = new BarCode.DataService.DataService();
result = service.CheckUser(userid, password, server, database);
if (!result.IsOK)
{
errorText = result.Message;
}
return(result.IsOK);
}
/// <summary>
/// 查询数据，返回数据集
/// </summary>
/// <param name="selectcmd">查询语句</param>
/// <returns></returns>
public static DataSet GetData(string selectcmd)
{
errorText = "";
DataSet ds = new DataSet();
BarCode.DataService.DataService service = new BarCode.DataService.DataService();
//System.Windows.Forms.MessageBox.Show(service.Timeout)
BarCode.DataService.ReturnClass result = service.GetData(selectcmd, userid, password, server, database);
if (result.IsOK)
{
string xml = (string)result.Value;
StringReader reader = new StringReader(xml);
XmlReader xr = XmlReader.Create(reader);
ds.ReadXml(xr);
}
else
{
System.Windows.Forms.MessageBox.Show(result.Message);
errorText = result.Message;
}
return(ds);
}
