public static DataSet GetCardMain(int CardID) { //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { byte[] da = ft.GetCardMain(CardID); ft.Close(); return(Byte2DS(da)); } finally { ft.Close(); } }
public static DataSet GetDS(string Bll, string Exc, object[] par) { ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { byte[] da = ft.getZipData(Bll, Exc, par); ft.Close(); return(Byte2DS(da)); } catch (Exception ex) { DataSet ds = new DataSet(); ds.Tables.Add(); return(ds); } finally { ft.Close(); } }
public static object GetOne(string bll, string Exc, object[] par) { //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { return(ft.GetOne(bll, Exc, par)); } finally { ft.Close(); } }
public static void Updata(string bll, DataTable dt) { //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { ft.Updata(bll, "UpdateByDt", dt); } finally { ft.Close(); } }
public static string AddLog(string UserName) { //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { return(ft.AddLog(UserName)); } finally { ft.Close(); } }
public static DateTime GetDateTime() { //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { return(ft.GetDateTime()); } finally { ft.Close(); } }
public static object GetSingle(string SQLString) { //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { return(ft.GetSingle(SQLString)); } finally { ft.Close(); } }
public static void CloseClient() { //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { ft.CloseClient(); } finally { ft.Close(); } }
public static DataSet GetDSForPrcoce(string storedProcName, object[] parameters, string tableName) { // System.ServiceModel.Dispatcher.DispatchRuntime.AutomaticInputSessionShutdown = false; //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { byte[] da = ft.GetDSForPrcoce(storedProcName, parameters, tableName); ft.Close(); return(Byte2DS(da)); } catch (Exception ex) { DataSet ds = new DataSet(); ds.Tables.Add(); return(ds); } finally { ft.Close(); } }
public static void ExecSql(string bll, string Exc, object[] par) { //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { ft.ExecSql(bll, Exc, par); } catch { } finally { ft.Close(); } }
public static string CarID(string aa) { //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { return(ft.CarID(aa)); } catch (Exception ex) { return(ex.ToString()); } finally { ft.Close(); } }
public static DateTime GetLastBackupTime() { //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { return(ft.GetLastBackupTime()); } catch { return(Convert.ToDateTime("1900-1-1")); } finally { ft.Close(); } }
public static int Add(string bll, DataTable dt) { //ChatCallBack callBack = new ChatCallBack(); //InstanceContext instance = new InstanceContext(callBack); ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { return(ft.Add(bll, "AddByDt", dt)); } catch (Exception ex) { return(0); } finally { ft.Close(); } }
public static DataTable GetBySql(string sql) { ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { byte[] da = ft.GetBySql(sql); DataTable dt = ToDataTable(da); dt.TableName = "dt"; return(dt); } catch (Exception ex) { return(new DataTable()); } finally { ft.Close(); } }
public static int UpOrAdd(string bll, DataTable dt) { ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); try { DataRow[] drs = dt.Select("(A>1)"); StringBuilder ss = new StringBuilder(); for (int j = 0; j < drs.Length; j++) { for (int i = 0; i < dt.Columns.Count; i++) { //ss.Append(i); //ss.Append("ю"); ss.Append(drs[j][i].ToString()); ss.Append("ж"); } ss.Append("й"); } MemoryStream ms = new MemoryStream(); StreamWriter sw = new StreamWriter(ms); sw.Write(ss.ToString()); sw.Close(); byte[] bsrc = ms.ToArray(); ms.Close(); ms.Dispose(); ms = new MemoryStream(); ms.Position = 0; // 压缩数组序列并返回压缩后的数组 DeflateStream zipStream = new DeflateStream(ms, CompressionMode.Compress); zipStream.Write(bsrc, 0, bsrc.Length); zipStream.Close(); zipStream.Dispose(); return(Convert.ToInt32(ft.GetOne(bll, "UpOrAdd", new object[] { ms.ToArray() }))); } finally { ft.Close(); } }
public static DataSet GetDT(string Bll, string Exc, object[] par) { ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); //try //{ // byte[] da = ft.getZipData(Bll, Exc, par); // ft.Close(); // return Byte2DS(da); //} //catch (Exception ex) //{ // DataSet ds = new DataSet(); // ds.Tables.Add(); // return ds; //} //finally //{ // ft.Close(); //} try { byte[] da = ft.GetJson(Bll, Exc, par); DataTable dt = ToDataTable(da); DataSet ds = new DataSet(); ds.DataSetName = "ds"; ds.Tables.Add(dt); return(ds); } catch (Exception ex) { DataSet ds = new DataSet(); ds.Tables.Add(); return(ds); } finally { ft.Close(); } }
public static string GetStringList(string Bll, string Exc, object[] par) { ServiceReference1.FileTransportServiceClient ft = new ServiceReference1.FileTransportServiceClient(); string strDS = string.Empty; try { byte[] da = ft.GetStringList(Bll, Exc, par); MemoryStream ms = new MemoryStream(); ms.Write(da, 0, da.Length); ms.Position = 0; DeflateStream ZipStream = new DeflateStream(ms, CompressionMode.Decompress); MemoryStream UnzipStream = new MemoryStream(); byte[] sDecompressed = new byte[128]; while (true) { int bytesRead = ZipStream.Read(sDecompressed, 0, 128); if (bytesRead == 0) { break; } UnzipStream.Write(sDecompressed, 0, bytesRead); } ZipStream.Close(); ms.Close(); UnzipStream.Position = 0;// 解压起始位置设置为头 StreamReader sr = new StreamReader(UnzipStream); strDS = sr.ReadToEnd(); } catch (Exception ex) { } finally { ft.Close(); } return(strDS); }