public void TestTableReceiver()
{
//DataTable table = new DataTable() { TableName="TableName"};
//table.Columns.Add("ID",typeof(int));
//table.Columns.Add("Name",typeof(string));
//var row = table.NewRow();
//row[0] = 1;
//row[1] = "Adam";
//table.Rows.Add(row);
DataTable table = new DataTable()
{
TableName = "TableName"
};
SqlConnection conn = new SqlConnection("data source=192.168.1.231;initial catalog=PurchaseCloud_20180512;persist security info=True;user id=sa;password=qwe123;MultipleActiveResultSets=True;");
SqlCommand comm = new SqlCommand("SELECT * FROM dbo.SY_V_PRICELIST", conn);
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter(comm);
adapter.Fill(table);
TableSender tableReceiver = new TableSender(table);
tableReceiver.TransportData();
}
public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e)
{
base.AfterExecuteOperationTransaction(e);
var sql = "SELECT EntryID,MaterialID,MateriNumber,MaterialName,SupplierID,SupplierName,Price,Bitmap FROM dbo.SY_V_PRICELIST";
using (DataSet ds = DBServiceHelper.ExecuteDataSet(Context, sql))
{
var table = ds.Tables[0];
table.TableName = "JPTPrice";
TableSender sender = new TableSender(table);
sender.TransportData();
}
}
public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e)
{
base.AfterExecuteOperationTransaction(e);
foreach (var dataEntity in e.DataEntitys)
{
var a = Convert.ToString(dataEntity["ID"]);
var sql = $"SELECT F_SY_PLEntryID AS EntryID,F_SY_MATERIAL AS CloudMatID,sup.FNAME AS [CloudSupplierName],de.F_SY_RAmount AS [Price] ,F_SY_SUPPLIER as SupplierID FROM SY_T_KeyRFQDetail de LEFT JOIN dbo.T_BD_SUPPLIER_L sup ON de.F_SY_SUPPLIER=sup.FSUPPLIERID WHERE FID ={a}";
using (DataSet ds = DBServiceHelper.ExecuteDataSet(Context, sql))
{
var table = ds.Tables[0];
table.TableName = "JPTPlan";
TableSender sender = new TableSender(table);
sender.TransportData();
}
}
}