/// <summary>
/// 执行无返回值ＳＱＬ语句
/// </summary>
/// <param name="strSQL"></param>
/// <returns></returns>
public int ExecuteSQL(string strSQL)
{
if (DataLib.SysVar.intConnect == 0)
{
JxcService.Service myService = GetService();
string strErr = myService.ExecuteSQL(SysVar.strDB, strSQL);
if (strErr.Length > 0)
{
MessageBox.Show(strErr, "错误");
return(-1);
}
return(0);
}
else
{
CenterLib.Service obj = GetObj();
string strErr = obj.ExecuteSQL(SysVar.strDB, strSQL);
if (strErr.Length > 0)
{
MessageBox.Show(strErr, "错误");
return(-1);
}
return(0);
}
}
/// <summary>
/// 多数据集保存,传递数据集数组及SQL语句数组
/// </summary>
/// <param name="ds"></param>
/// <param name="strSQL"></param>
/// <returns></returns>
public string SaveMuteData(DataSet[] ds, string[] strSQL)
{
if (DataLib.SysVar.intConnect == 0)
{
JxcService.Service myService = GetService();
string strErr = myService.SaveMuteData(SysVar.strDB, ds, strSQL);
if (strErr.Length > 0)
{
MessageBox.Show(strErr, "错误");
return(strErr);
}
return("");
}
else
{
CenterLib.Service obj = GetObj();
string strErr = obj.SaveMuteData(SysVar.strDB, ds, strSQL);
if (strErr.Length > 0)
{
MessageBox.Show(strErr, "错误");
return(strErr);
}
return("");
}
}
/// <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>
/// <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>
/// 根据传过去的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);
}
}
/// <summary>
/// 取得后台设置的帐套
/// </summary>
/// <returns></returns>
public DataSet GetAccount(string sFlag)
{
if (DataLib.SysVar.intConnect == 0)
{
JxcService.Service myService = GetService();
return(myService.GetAccount());
}
else
{
CenterLib.Service obj = GetObj();
DataSet ds1 = obj.GetAccount(sFlag);
return(ds1);
}
}
/// <summary>
/// 测试是否登录成功
/// </summary>
/// <param name="strServer"></param>
/// <returns></returns>
public bool TestLogin(string strServer)
{
SysVar.strServer = strServer;
if (DataLib.SysVar.intConnect == 0)
{
JxcService.Service myService = GetService();
if (myService.Login("YGA", "Kinger") == "success")
{
return(true);
}
else
{
return(false);
}
}
else
{
CenterLib.Service obj = GetObj();
if (obj.Login("YGA", "Kinger") == "success")
{
return(true);
}
else
{
return(false);
}
/*
*
* try
* {
* if (obj.Login("YGA", "Kinger") == "success")
* return true;
* else
* return false;
* }
* catch (Exception E)
* {
* MessageBox.Show(E.Message, "错误");
* return false;
* }
*/
}
}
/// <summary>
/// WebService取得相应服务
/// </summary>
/// <returns></returns>
private JxcService.Service GetService()
{
JxcService.Service myService = new JxcService.Service();
myService.Url = SysVar.strUrl;
return(myService);
}
/// <summary>
/// 从中间层(webservice)取连接数据库字符串
/// </summary>
/// <returns></returns>
public string GetCon()
{
JxcService.Service myService = GetService();
return(myService.GetConStr(DataLib.SysVar.strDB));
}