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); }