/// <summary> /// 带参数SQL,并返回结果数据集 /// </summary> /// <param name="strSQL"></param> /// <param name="parm"></param> /// <returns></returns> public DataSet GetOtherDs(string strSQL, Hashtable parm) { string err = ""; if (DataLib.SysVar.intConnect == 0) { JxcService.Service myService = GetService(); byte[] bytes = DataSetCompression.SerializeData(parm); byte[] bUserData = myService.GetOtherByte(ref err, SysVar.strDB, strSQL, bytes); if (err != "") { MessageBox.Show(err, "错误"); err = ""; return(null); } DataSet ds = DataSetCompression.DecompressionDataSet(bUserData); return(ds); } else { CenterLib.Service obj = GetObj(); byte[] bUserData = obj.GetOtherByte(ref err, SysVar.strDB, strSQL, parm); if (err != "") { MessageBox.Show(err, "错误"); err = ""; return(null); } DataSet ds = DataSetCompression.DecompressionDataSet(bUserData); return(ds); } }
/// <summary> /// 多数据集保存(带参数) /// </summary> /// <param name="ds"></param> /// <param name="strSQL"></param> /// <returns></returns> public string SaveMuteData1(DataSet[] ds, string[] strSQL, Hashtable parm) { if (DataLib.SysVar.intConnect == 0) { JxcService.Service myService = GetService(); byte[] bytes = DataSetCompression.SerializeData(parm); string strErr = myService.SaveMuteData1(SysVar.strDB, ds, strSQL, bytes); if (strErr.Length > 0) { MessageBox.Show(strErr, "错误"); return(strErr); } return(""); } else { CenterLib.Service obj = GetObj(); string strErr = obj.SaveMuteData1(SysVar.strDB, ds, strSQL, parm); if (strErr.Length > 0) { MessageBox.Show(strErr, "错误"); return(strErr); } return(""); } }
/// <summary> /// 根据传过去的SQL语句得到相应数据集 /// </summary> /// <param name="strSQL"></param> /// <returns></returns> public DataSet GetDs(string strSQL) { string err = ""; DataSet ds = null; byte[] bUserData = null; if (DataLib.SysVar.intConnect == 0) { JxcService.Service myService = GetService(); bUserData = myService.GetCompressDataSet(ref err, SysVar.strDB, strSQL); if (err != "") { MessageBox.Show(err, "错误"); err = ""; return(null); } ds = DataSetCompression.DecompressionDataSet(bUserData); return(ds); } else { CenterLib.Service obj = GetObj(); bUserData = obj.GetCompressDataSet(ref err, SysVar.strDB, strSQL); if (err != "") { MessageBox.Show(err, "错误"); err = ""; return(null); } ds = DataSetCompression.DecompressionDataSet(bUserData); return(ds); } }