| | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | DataTable dt = ds.Tables[0]; |
|---|
| | | if (operatype == "INSERT") |
|---|
| | | if (operatype == "INSERT" || operatype == "UPDATE") |
|---|
| | | { |
|---|
| | | #region INSERT |
|---|
| | | //dt.Columns.Add("MAA005", typeof(string)); |
|---|
| | |
|---|
| | | GYS005='{5}', |
|---|
| | | FUseOrgld='{6}' |
|---|
| | | where ERPID='{0}'; ", dr["ERPID"] |
|---|
| | | , dr["GYS001"], dr["GYS002"], dr["GYS003"], dr["GYS004"], dr["GYS005"], dr["FUseOrgld"]); |
|---|
| | | , dr["GYSA001"], dr["GYSA002"], dr["GYSA003"], dr["GYSA004"], dr["GYSA005"], dr["FUseOrgld"]); |
|---|
| | | } |
|---|
| | | return _sqlHelper.ExecuteNonQuery(sql) > 0; |
|---|
| | | #endregion |
|---|
| | |
|---|
| | | string res = a.Body(US).msg.ToString(); |
|---|
| | | |
|---|
| | | sql = string.Format(@" update sysdec set states='NEW' WHERE TASK_ID='{0}' ", rtaskid); |
|---|
| | | |
|---|
| | | _sqlHelper.ExecuteNonQuery(sql); |
|---|
| | | //string res = a.arg0.ws.MES_TO_ERP_DataTransport(task_name, descript, create_time, creator, operatype, source_table, target_table, data, data_inserted, data_deleted); |
|---|
| | | if (res.Contains("OK")) |
|---|
