private async void btnCount_Click(object sender, RoutedEventArgs e)
{
//GetCount
int i = (await sysMenuItemF.GetCount(tbIn.Text));
tbResult.Text = SafeConverter.JsonSerializeObject(i);
}
public string GetJsonDataWithPage(string strSql, int pageIndex, int pageSize)
{
DataTable dt = GetDataTable(strSql, null, null);
DataTable newdt = dt.Copy(); //copy dt的框架
if (pageIndex > 0)
{
newdt.Clear();
int rowbegin = (pageIndex - 1) * pageSize;
int rowend = pageIndex * pageSize;
if (rowbegin < dt.Rows.Count)
{
if (rowend > dt.Rows.Count)
{
rowend = dt.Rows.Count;
}
for (int i = rowbegin; i <= rowend - 1; i++)
{
DataRow newdr = newdt.NewRow();
DataRow dr = dt.Rows[i];
foreach (DataColumn column in dt.Columns)
{
newdr[column.ColumnName] = dr[column.ColumnName];
}
newdt.Rows.Add(newdr);
}
}
}
return(SafeConverter.JsonSerializeObject(newdt));
}
private async void button4_Click(object sender, RoutedEventArgs e)
{
//DelById
bool m_SysUser = (await testEfCodeFirstF.Delete(tbIn.Text));
tbResult.Text = SafeConverter.JsonSerializeObject(m_SysUser);
}
private async void button2_Click(object sender, RoutedEventArgs e)
{
//GetByParam
List <SysMenuItem> m_SysMenuItem = (await sysMenuItemF.GetByParam(tbIn.Text));
tbResult.Text = SafeConverter.JsonSerializeObject(m_SysMenuItem);
}
private async void btnGetPage_Click(object sender, RoutedEventArgs e)
{
//GetPage
List <SysMenuItem> m_SysMenuItem = (await sysMenuItemF.GetPageData(10, 1, true, "CREATION_DATE", tbIn.Text));
tbResult.Text = SafeConverter.JsonSerializeObject(m_SysMenuItem);
}
public string PostInventorySyn()
{
NetLog.Write("MES库存同步SAP（初始化）" + " ");
var oldBatchs = GetFDIInventorySynBacths("");
List <FDIInventorySynBacth> Batchs = new List <FDIInventorySynBacth>();
var oldMains = GetFDIInventorySyns("");
List <FDIInventorySyn> Mains = new List <FDIInventorySyn>();
foreach (var m in oldMains)
{
FDIInventorySyn main = new FDIInventorySyn();
main.CopyDataItem(m);
main.Batchs = new List <FDIInventorySynBacth>();
foreach (var d in oldBatchs.Where(c => c.ItemCode == m.ItemCode))
{
FDIInventorySynBacth detial = new FDIInventorySynBacth();
detial.CopyDataItem(d);
main.Batchs.Add(detial);
}
Mains.Add(main);
}
string jsonText = SafeConverter.JsonSerializeObject(Mains);
return(jsonText);
}
private async void button3_Click(object sender, RoutedEventArgs e)
{
//Add
TestEFCodeFirst test = new TestEFCodeFirst()
{
PKNO = tbIn.Text,
USER_NAME = "Test1",
PASSWORD = "******",
};
string value = SafeConverter.JsonSerializeObject(test);
TestEFCodeFirst test2 = SafeConverter.JsonDeserializeObject <TestEFCodeFirst>(value);
bool m_SysUser = (await testEfCodeFirstF.Add(test));
tbResult.Text = SafeConverter.JsonSerializeObject(m_SysUser);
}
public string PostRawMaterial()
{
NetLog.Write("MES回传SAP原材料入库" + " ");
var oldBatchs = GetFDIPostRawMaterialBatchs("");
List <FDIPostRawMaterialBatch> Batchs = new List <FDIPostRawMaterialBatch>();
var oldDetails = GetFDIPostRawMaterialDetails("");
var oldMains = GetFDIPostRawMaterials("");
List <FDIPostRawMaterial> Mains = new List <FDIPostRawMaterial>();
foreach (var m in oldMains)
{
FDIPostRawMaterial main = new FDIPostRawMaterial();
main.CopyDataItem(m);
main.Details = new List <FDIPostRawMaterialDetail>();
foreach (var d in oldDetails.Where(c => c.DocEntry == m.DocEntry))
{
FDIPostRawMaterialDetail detial = new FDIPostRawMaterialDetail();
detial.CopyDataItem(d);
detial.Batchs = new List <FDIPostRawMaterialBatch>();
foreach (var b in oldBatchs.Where(c => c.DocEntry == m.DocEntry && c.LineNum == d.LineId))
{
FDIPostRawMaterialBatch batch = new FDIPostRawMaterialBatch();
batch.CopyDataItem(b);
detial.Batchs.Add(batch);
}
main.Details.Add(detial);
}
Mains.Add(main);
}
string jsonText = SafeConverter.JsonSerializeObject(Mains);
return(jsonText);
}
public string PostDNOrder()
{
NetLog.Write("MES回传SAP销售发货单" + " ");
var oldBatchs = GetFDIPostSaleOrderBatchs("");
List <FDIPostSaleOrderBatch> Batchs = new List <FDIPostSaleOrderBatch>();
var oldDetails = GetFDIPostSaleOrderDetails("");
var oldMains = GetFDIPostSaleOrders("Flag_In = 0");
List <FDIPostSaleOrder> Mains = new List <FDIPostSaleOrder>();
foreach (var m in oldMains)
{
FDIPostSaleOrder main = new FDIPostSaleOrder();
main.CopyDataItem(m);
main.Details = new List <FDIPostSaleOrderDetail>();
foreach (var d in oldDetails.Where(c => c.DocEntry == m.DocEntry))
{
FDIPostSaleOrderDetail detail = new FDIPostSaleOrderDetail();
detail.CopyDataItem(d);
main.Details.Add(detail);
detail.Batchs = new List <FDIPostSaleOrderBatch>();
foreach (var b in oldBatchs.Where(c => c.DocEntry == m.DocEntry && c.LineNum == d.LineId))
{
FDIPostSaleOrderBatch batch = new FDIPostSaleOrderBatch();
batch.CopyDataItem(b);
detail.Batchs.Add(batch);
}
}
Mains.Add(main);
}
string jsonText = SafeConverter.JsonSerializeObject(Mains);
return(jsonText);
}
public string GetJsonDataByParam(string strSql, string[] parameterNames, string[] parameterValues)
{
DataTable dt = GetDataTable(strSql, parameterNames, parameterValues);
return(SafeConverter.JsonSerializeObject(dt));
}
public string GetJsonData(string strSql)
{
DataTable dt = GetDataTable(strSql, null, null);
return(SafeConverter.JsonSerializeObject(dt));
}
private async void button_Click(object sender, RoutedEventArgs e)
{
SysMenuItem m_SysUser = (await sysMenuItemF.GetById(tbIn.Text));
tbResult.Text = SafeConverter.JsonSerializeObject(m_SysUser);
}
