| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831 |
- <%@ WebHandler Language="C#" Class="bompackunit" %>
- using System;
- using System.Web;
- using System.Web.SessionState;
- using System.Collections.Generic;
- using System.Collections.Specialized;
- using System.Data;
- using Curtain.DataAccess;
- using DK.XuWei.WebMes;
- public class bompackunit : IHttpHandler, IReadOnlySessionState
- {
- public void ProcessRequest(HttpContext context)
- {
- context.Response.ContentType = "text/plain";
- if (context.Request["m"] is object)
- {
- switch (context.Request["m"].ToString().ToLower())
- {
- case "s":
- {
- context.Response.Write(search(context.Request.Form));
- break;
- }
- case "sync":
- {
- context.Response.Write(sync(context));
- break;
- }
- default:
- {
- break;
- }
- }
- }
- else
- {
- context.Response.Write(new JsonResult(JsonStatus.loginError).ToJson());
- }
- }
- /// <summary>
- /// 查询
- /// </summary>
- /// <returns>json</returns>
- private string search(NameValueCollection form)
- {
- using (IDataAccess conn = DataAccess.Create())
- {
- int page = HttpContext.Current.Request["page"] is object ? Convert.ToInt32(HttpContext.Current.Request["page"]) : 1;
- int rows = HttpContext.Current.Request["rows"] is object ? Convert.ToInt32(HttpContext.Current.Request["rows"]) : 10;
- string sort = HttpContext.Current.Request["sort"] is object ? HttpContext.Current.Request["sort"] : "";
- string order = HttpContext.Current.Request["order"] is object ? HttpContext.Current.Request["order"] : "";
- string sqlStr = @"SELECT * FROM TP_PC_SAPBOMDETAIL WHERE 1= 1";
- List<CDAParameter> sqlPara = new List<CDAParameter>();
- if (!string.IsNullOrEmpty(form["MATNR"]))
- {
- sqlStr += " AND MATNR = @MATNR@ ";
- sqlPara.Add(new CDAParameter("MATNR", form["MATNR"]));
- }
- if (form["MTART"] != null && !string.IsNullOrEmpty(form["MTART"]))
- {
- sqlStr += " AND MTART = '" + form["MTART"] + "'";
- }
- int total = 0;
- DataTable dt = conn.SelectPages(page, rows, out total, sqlStr, sqlPara.ToArray());
- return new JsonResult(dt) { total = total }.ToJson();
- }
- }
- /// <summary>
- /// 同步
- /// </summary>
- /// <returns>json</returns>
- private string sync(HttpContext context)
- {
- string ZTYPE;
- string ZMSG;
- string MTART = "";
- string syncType = (string.IsNullOrEmpty(context.Request["MATNR"]) && (MTART == null || string.IsNullOrEmpty(MTART))) ? "ALL" : "Manual";
- if (context.Request["MTART"] != null && !string.IsNullOrEmpty(context.Request["MTART"]))
- {
- MTART = context.Request["MTART"];
- }
- if (context.Request["MTART[]"] != null && !string.IsNullOrEmpty(context.Request["MTART[]"]))
- {
- MTART = context.Request["MTART[]"].Replace(",", "','");
- }
- DataTable dtResult = SapApi.ZMMFM054(out ZTYPE, out ZMSG, syncType, context.Request["MATNR"], MTART);
- if ("E".Equals(ZTYPE) || dtResult == null || dtResult.Rows.Count == 0)
- {
- return new JsonResult(JsonStatus.otherError).ToJson();
- }
- using (IDataAccess conn = DataAccess.Create())
- {
- // 开启事务
- conn.BeginTransaction();
- int result = 0;
- if (!(string.IsNullOrEmpty(context.Request["MATNR"]) && (MTART == null || string.IsNullOrEmpty(MTART))))
- {
- string sqlStr = @"SELECT * FROM TP_PC_SAPBOMDETAIL WHERE 1= 1";
- List<CDAParameter> sqlPara = new List<CDAParameter>();
- if (!string.IsNullOrEmpty(context.Request["MATNR"]))
- {
- sqlStr += " AND MATNR = @MATNR@ ";
- sqlPara.Add(new CDAParameter("MATNR", context.Request["MATNR"]));
- }
- if (MTART != null && !string.IsNullOrEmpty(MTART))
- {
- sqlStr += " AND MTART = '" + MTART + "'";
- }
- DataTable dt = conn.ExecuteDatatable(sqlStr, sqlPara.ToArray());
- if (dt == null || dt.Rows.Count == 0)
- {
- if (dtResult.Rows.Count > 0)
- {
- //插入dtResult
- string addSql = @"
- INSERT INTO TP_PC_SAPBOMDETAIL (
- MATNR
- ,WERKS
- ,MAKTX
- ,MATKL
- ,WGBEZ
- ,MEINS
- ,LABOR
- ,LGFSB
- ,MTART
- ,LVORM
- ,BSTRF
- ,PRDHA
- ,VTEXT
- ,BSTME
- ,VOLUM
- ,BESKZ
- ,SOBSL
- ,LGPRO
- ,MTPOSMARA
- ,GROES
- ,STPRS
- ,UMREZ
- ,PEINH
- ,XCHAR
- ,ZGG
- ,ZYS
- ,ZCSJ
- ,VRKME
- ,ERSDA
- ,MAABC
- ,BRGEW
- ,NTGEW
- ,VOLEH
- ,ZWLFL
- ,ZWXGG
- ,ZWXMZ
- ,ZWXJZ
- ,ZEWSL
- ,ZEWDW
- ,ZMEINS
- ,ZZXBZ
- ,ZWYM
- ,ZNMAE
- ,ZMYYSL
- ,ZCPCCBZQ
- ,ZCPCCBZH
- ,ZBY1
- ,ZBY2
- ,ZBY3
- ,ZBY4
- ,ZBY5
- ,ZBY6
- ,ACCOUNTID
- ,VALUEFLAG
- ,CREATEUSERID
- ,UPDATEUSERID
- ,ZWLJC
- ) values(
- @MATNR@
- ,@WERKS@
- ,@MAKTX@
- ,@MATKL@
- ,@WGBEZ@
- ,@MEINS@
- ,@LABOR@
- ,@LGFSB@
- ,@MTART@
- ,@LVORM@
- ,@BSTRF@
- ,@PRDHA@
- ,@VTEXT@
- ,@BSTME@
- ,@VOLUM@
- ,@BESKZ@
- ,@SOBSL@
- ,@LGPRO@
- ,@MTPOSMARA@
- ,@GROES@
- ,@STPRS@
- ,@UMREZ@
- ,@PEINH@
- ,@XCHAR@
- ,@ZGG@
- ,@ZYS@
- ,@ZCSJ@
- ,@VRKME@
- ,@ERSDA@
- ,@MAABC@
- ,@BRGEW@
- ,@NTGEW@
- ,@VOLEH@
- ,@ZWLFL@
- ,@ZWXGG@
- ,@ZWXMZ@
- ,@ZWXJZ@
- ,@ZEWSL@
- ,@ZEWDW@
- ,@ZMEINS@
- ,@ZZXBZ@
- ,@ZWYM@
- ,@ZNMAE@
- ,@ZMYYSL@
- ,@ZCPCCBZQ@
- ,@ZCPCCBZH@
- ,@ZBY1@
- ,@ZBY2@
- ,@ZBY3@
- ,@ZBY4@
- ,@ZBY5@
- ,@ZBY6@
- ,@ACCOUNTID@
- ,@VALUEFLAG@
- ,@CREATEUSERID@
- ,@UPDATEUSERID@
- ,@ZWLJC@
- )";
- foreach (DataRow row in dtResult.Rows)
- {
- result += conn.ExecuteNonQuery(addSql,
- new CDAParameter("MATNR", row["MATNR"]),
- new CDAParameter("WERKS", "5320"),
- new CDAParameter("MAKTX", row["MAKTX"]),
- new CDAParameter("MATKL", row["MATKL"]),
- new CDAParameter("WGBEZ", row["WGBEZ"]),
- new CDAParameter("MEINS", row["MEINS"]),
- new CDAParameter("LABOR", row["LABOR"]),
- new CDAParameter("LGFSB", row["LGFSB"]),
- new CDAParameter("MTART", row["MTART"]),
- new CDAParameter("LVORM", row["LVORM"]),
- new CDAParameter("BSTRF", row["BSTRF"]),
- new CDAParameter("PRDHA", row["PRDHA"]),
- new CDAParameter("VTEXT", row["VTEXT"]),
- new CDAParameter("BSTME", row["BSTME"]),
- new CDAParameter("VOLUM", row["VOLUM"]),
- new CDAParameter("BESKZ", row["BESKZ"]),
- new CDAParameter("SOBSL", row["SOBSL"]),
- new CDAParameter("LGPRO", row["LGPRO"]),
- new CDAParameter("MTPOSMARA", row["MTPOS_MARA"]),
- new CDAParameter("GROES", row["GROES"]),
- new CDAParameter("STPRS", row["STPRS"]),
- new CDAParameter("UMREZ", row["UMREZ"]),
- new CDAParameter("PEINH", row["PEINH"]),
- new CDAParameter("XCHAR", row["XCHAR"]),
- new CDAParameter("ZGG", row["ZGG"]),
- new CDAParameter("ZYS", row["ZYS"]),
- new CDAParameter("ZCSJ", row["ZCSJ"]),
- new CDAParameter("VRKME", row["VRKME"]),
- new CDAParameter("ERSDA", row["ERSDA"]),
- new CDAParameter("MAABC", row["MAABC"]),
- new CDAParameter("BRGEW", row["BRGEW"]),
- new CDAParameter("NTGEW", row["NTGEW"]),
- new CDAParameter("VOLEH", row["VOLEH"]),
- new CDAParameter("ZWLFL", row["ZWLFL"]),
- new CDAParameter("ZWXGG", row["ZWXGG"]),
- new CDAParameter("ZWXMZ", row["ZWXMZ"]),
- new CDAParameter("ZWXJZ", row["ZWXJZ"]),
- new CDAParameter("ZEWSL", row["ZEWSL"]),
- new CDAParameter("ZEWDW", row["ZEWDW"]),
- new CDAParameter("ZMEINS", row["ZMEINS"]),
- new CDAParameter("ZZXBZ", row["ZZXBZ"]),
- new CDAParameter("ZWYM", row["ZWYM"]),
- new CDAParameter("ZNMAE", row["ZNMAE"]),
- new CDAParameter("ZMYYSL", row["ZMYYSL"]),
- new CDAParameter("ZCPCCBZQ", row["ZCPCC_BZQ"]),
- new CDAParameter("ZCPCCBZH", row["ZCPCC_BZH"]),
- new CDAParameter("ZBY1", row["ZBY1"]),
- new CDAParameter("ZBY2", row["ZBY2"]),
- new CDAParameter("ZBY3", row["ZBY3"]),
- new CDAParameter("ZBY4", row["ZBY4"]),
- new CDAParameter("ZBY5", row["ZBY5"]),
- new CDAParameter("ZBY6", row["ZBY6"]),
- new CDAParameter("ACCOUNTID", 1),// HttpContext.Current.Session["accountId"]),
- new CDAParameter("VALUEFLAG", 1),
- new CDAParameter("CREATEUSERID", HttpContext.Current.Session["userId"]),
- new CDAParameter("UPDATEUSERID", HttpContext.Current.Session["userId"]),
- new CDAParameter("ZWLJC", row["ZEXTN1"])
- );
- }
- }
- }
- else
- {
- foreach (DataRow row in dtResult.Rows)
- {
- DataRow[] drs = dt.Select("MATNR='" + row["MATNR"] + "' AND WERKS = '" + 5320 + "'");
- //DataRow[] drs = dt.Select("MATNR='" + row["MATNR"] + "'");
- if (drs != null && drs.Length > 0)
- {
- #region 修改
- string uptSql = @"
- update TP_PC_SAPBOMDETAIL set
- MAKTX=@MAKTX@
- ,MATKL=@MATKL@
- ,WGBEZ=@WGBEZ@
- ,MEINS=@MEINS@
- ,LABOR=@LABOR@
- ,LGFSB=@LGFSB@
- ,MTART=@MTART@
- ,LVORM=@LVORM@
- ,BSTRF=@BSTRF@
- ,PRDHA=@PRDHA@
- ,VTEXT=@VTEXT@
- ,BSTME=@BSTME@
- ,VOLUM=@VOLUM@
- ,BESKZ=@BESKZ@
- ,SOBSL=@SOBSL@
- ,LGPRO=@LGPRO@
- ,MTPOSMARA=@MTPOSMARA@
- ,GROES=@GROES@
- ,STPRS=@STPRS@
- ,UMREZ=@UMREZ@
- ,PEINH=@PEINH@
- ,XCHAR=@XCHAR@
- ,ZGG=@ZGG@
- ,ZYS=@ZYS@
- ,ZCSJ=@ZCSJ@
- ,VRKME=@VRKME@
- ,ERSDA=@ERSDA@
- ,MAABC=@MAABC@
- ,BRGEW=@BRGEW@
- ,NTGEW=@NTGEW@
- ,VOLEH=@VOLEH@
- ,ZWLFL=@ZWLFL@
- ,ZWXGG=@ZWXGG@
- ,ZWXMZ=@ZWXMZ@
- ,ZWXJZ=@ZWXJZ@
- ,ZEWSL=@ZEWSL@
- ,ZEWDW=@ZEWDW@
- ,ZMEINS=@ZMEINS@
- ,ZZXBZ=@ZZXBZ@
- ,ZWYM=@ZWYM@
- ,ZNMAE=@ZNMAE@
- ,ZMYYSL=@ZMYYSL@
- ,ZCPCCBZQ=@ZCPCCBZQ@
- ,ZCPCCBZH=@ZCPCCBZH@
- ,ZBY1=@ZBY1@
- ,ZBY2=@ZBY2@
- ,ZBY3=@ZBY3@
- ,ZBY4=@ZBY4@
- ,ZBY5=@ZBY5@
- ,ZBY6=@ZBY6@
- ,ZWLJC=@ZWLJC@
- ,ACCOUNTID=@ACCOUNTID@
- ,VALUEFLAG =@VALUEFLAG@
- ,UPDATEUSERID=@UPDATEUSERID@
- where MATNR=@MATNR@ and WERKS=@WERKS@";
- result += conn.ExecuteNonQuery(uptSql,
- new CDAParameter("MAKTX", row["MAKTX"]),
- new CDAParameter("MATKL", row["MATKL"]),
- new CDAParameter("WGBEZ", row["WGBEZ"]),
- new CDAParameter("MEINS", row["MEINS"]),
- new CDAParameter("LABOR", row["LABOR"]),
- new CDAParameter("LGFSB", row["LGFSB"]),
- new CDAParameter("MTART", row["MTART"]),
- new CDAParameter("LVORM", row["LVORM"]),
- new CDAParameter("BSTRF", row["BSTRF"]),
- new CDAParameter("PRDHA", row["PRDHA"]),
- new CDAParameter("VTEXT", row["VTEXT"]),
- new CDAParameter("BSTME", row["BSTME"]),
- new CDAParameter("VOLUM", row["VOLUM"]),
- new CDAParameter("BESKZ", row["BESKZ"]),
- new CDAParameter("SOBSL", row["SOBSL"]),
- new CDAParameter("LGPRO", row["LGPRO"]),
- new CDAParameter("MTPOSMARA", row["MTPOS_MARA"]),
- new CDAParameter("GROES", row["GROES"]),
- new CDAParameter("STPRS", row["STPRS"]),
- new CDAParameter("UMREZ", row["UMREZ"]),
- new CDAParameter("PEINH", row["PEINH"]),
- new CDAParameter("XCHAR", row["XCHAR"]),
- new CDAParameter("ZGG", row["ZGG"]),
- new CDAParameter("ZYS", row["ZYS"]),
- new CDAParameter("ZCSJ", row["ZCSJ"]),
- new CDAParameter("VRKME", row["VRKME"]),
- new CDAParameter("ERSDA", row["ERSDA"]),
- new CDAParameter("MAABC", row["MAABC"]),
- new CDAParameter("BRGEW", row["BRGEW"]),
- new CDAParameter("NTGEW", row["NTGEW"]),
- new CDAParameter("VOLEH", row["VOLEH"]),
- new CDAParameter("ZWLFL", row["ZWLFL"]),
- new CDAParameter("ZWXGG", row["ZWXGG"]),
- new CDAParameter("ZWXMZ", row["ZWXMZ"]),
- new CDAParameter("ZWXJZ", row["ZWXJZ"]),
- new CDAParameter("ZEWSL", row["ZEWSL"]),
- new CDAParameter("ZEWDW", row["ZEWDW"]),
- new CDAParameter("ZMEINS", row["ZMEINS"]),
- new CDAParameter("ZZXBZ", row["ZZXBZ"]),
- new CDAParameter("ZWYM", row["ZWYM"]),
- new CDAParameter("ZNMAE", row["ZNMAE"]),
- new CDAParameter("ZMYYSL", row["ZMYYSL"]),
- new CDAParameter("ZCPCCBZQ", row["ZCPCC_BZQ"]),
- new CDAParameter("ZCPCCBZH", row["ZCPCC_BZH"]),
- new CDAParameter("ZBY1", row["ZBY1"]),
- new CDAParameter("ZBY2", row["ZBY2"]),
- new CDAParameter("ZBY3", row["ZBY3"]),
- new CDAParameter("ZBY4", row["ZBY4"]),
- new CDAParameter("ZBY5", row["ZBY5"]),
- new CDAParameter("ZBY6", row["ZBY6"]),
- new CDAParameter("ZWLJC", row["ZEXTN1"]),
- new CDAParameter("ACCOUNTID", 1),//HttpContext.Current.Session["accountId"]),
- new CDAParameter("VALUEFLAG", 1),
- new CDAParameter("UPDATEUSERID", HttpContext.Current.Session["userId"]),
- new CDAParameter("MATNR", row["MATNR"]),
- new CDAParameter("WERKS", "5320")
- );
- #endregion
- }
- else
- {
- #region 添加
- // 插入新的
- string addSql = @"
- INSERT INTO TP_PC_SAPBOMDETAIL (
- MATNR
- ,WERKS
- ,MAKTX
- ,MATKL
- ,WGBEZ
- ,MEINS
- ,LABOR
- ,LGFSB
- ,MTART
- ,LVORM
- ,BSTRF
- ,PRDHA
- ,VTEXT
- ,BSTME
- ,VOLUM
- ,BESKZ
- ,SOBSL
- ,LGPRO
- ,MTPOSMARA
- ,GROES
- ,STPRS
- ,UMREZ
- ,PEINH
- ,XCHAR
- ,ZGG
- ,ZYS
- ,ZCSJ
- ,VRKME
- ,ERSDA
- ,MAABC
- ,BRGEW
- ,NTGEW
- ,VOLEH
- ,ZWLFL
- ,ZWXGG
- ,ZWXMZ
- ,ZWXJZ
- ,ZEWSL
- ,ZEWDW
- ,ZMEINS
- ,ZZXBZ
- ,ZWYM
- ,ZNMAE
- ,ZMYYSL
- ,ZCPCCBZQ
- ,ZCPCCBZH
- ,ZBY1
- ,ZBY2
- ,ZBY3
- ,ZBY4
- ,ZBY5
- ,ZBY6
- ,ACCOUNTID
- ,VALUEFLAG
- ,CREATEUSERID
- ,UPDATEUSERID
- ,ZWLJC
- ) values(
- @MATNR@
- ,@WERKS@
- ,@MAKTX@
- ,@MATKL@
- ,@WGBEZ@
- ,@MEINS@
- ,@LABOR@
- ,@LGFSB@
- ,@MTART@
- ,@LVORM@
- ,@BSTRF@
- ,@PRDHA@
- ,@VTEXT@
- ,@BSTME@
- ,@VOLUM@
- ,@BESKZ@
- ,@SOBSL@
- ,@LGPRO@
- ,@MTPOSMARA@
- ,@GROES@
- ,@STPRS@
- ,@UMREZ@
- ,@PEINH@
- ,@XCHAR@
- ,@ZGG@
- ,@ZYS@
- ,@ZCSJ@
- ,@VRKME@
- ,@ERSDA@
- ,@MAABC@
- ,@BRGEW@
- ,@NTGEW@
- ,@VOLEH@
- ,@ZWLFL@
- ,@ZWXGG@
- ,@ZWXMZ@
- ,@ZWXJZ@
- ,@ZEWSL@
- ,@ZEWDW@
- ,@ZMEINS@
- ,@ZZXBZ@
- ,@ZWYM@
- ,@ZNMAE@
- ,@ZMYYSL@
- ,@ZCPCCBZQ@
- ,@ZCPCCBZH@
- ,@ZBY1@
- ,@ZBY2@
- ,@ZBY3@
- ,@ZBY4@
- ,@ZBY5@
- ,@ZBY6@
- ,@ACCOUNTID@
- ,@VALUEFLAG@
- ,@CREATEUSERID@
- ,@UPDATEUSERID@
- ,@ZWLJC@
- )";
- result += conn.ExecuteNonQuery(addSql,
- new CDAParameter("MATNR", row["MATNR"]),
- new CDAParameter("WERKS", "5320"),
- new CDAParameter("MAKTX", row["MAKTX"]),
- new CDAParameter("MATKL", row["MATKL"]),
- new CDAParameter("WGBEZ", row["WGBEZ"]),
- new CDAParameter("MEINS", row["MEINS"]),
- new CDAParameter("LABOR", row["LABOR"]),
- new CDAParameter("LGFSB", row["LGFSB"]),
- new CDAParameter("MTART", row["MTART"]),
- new CDAParameter("LVORM", row["LVORM"]),
- new CDAParameter("BSTRF", row["BSTRF"]),
- new CDAParameter("PRDHA", row["PRDHA"]),
- new CDAParameter("VTEXT", row["VTEXT"]),
- new CDAParameter("BSTME", row["BSTME"]),
- new CDAParameter("VOLUM", row["VOLUM"]),
- new CDAParameter("BESKZ", row["BESKZ"]),
- new CDAParameter("SOBSL", row["SOBSL"]),
- new CDAParameter("LGPRO", row["LGPRO"]),
- new CDAParameter("MTPOSMARA", row["MTPOS_MARA"]),
- new CDAParameter("GROES", row["GROES"]),
- new CDAParameter("STPRS", row["STPRS"]),
- new CDAParameter("UMREZ", row["UMREZ"]),
- new CDAParameter("PEINH", row["PEINH"]),
- new CDAParameter("XCHAR", row["XCHAR"]),
- new CDAParameter("ZGG", row["ZGG"]),
- new CDAParameter("ZYS", row["ZYS"]),
- new CDAParameter("ZCSJ", row["ZCSJ"]),
- new CDAParameter("VRKME", row["VRKME"]),
- new CDAParameter("ERSDA", row["ERSDA"]),
- new CDAParameter("MAABC", row["MAABC"]),
- new CDAParameter("BRGEW", row["BRGEW"]),
- new CDAParameter("NTGEW", row["NTGEW"]),
- new CDAParameter("VOLEH", row["VOLEH"]),
- new CDAParameter("ZWLFL", row["ZWLFL"]),
- new CDAParameter("ZWXGG", row["ZWXGG"]),
- new CDAParameter("ZWXMZ", row["ZWXMZ"]),
- new CDAParameter("ZWXJZ", row["ZWXJZ"]),
- new CDAParameter("ZEWSL", row["ZEWSL"]),
- new CDAParameter("ZEWDW", row["ZEWDW"]),
- new CDAParameter("ZMEINS", row["ZMEINS"]),
- new CDAParameter("ZZXBZ", row["ZZXBZ"]),
- new CDAParameter("ZWYM", row["ZWYM"]),
- new CDAParameter("ZNMAE", row["ZNMAE"]),
- new CDAParameter("ZMYYSL", row["ZMYYSL"]),
- new CDAParameter("ZCPCCBZQ", row["ZCPCC_BZQ"]),
- new CDAParameter("ZCPCCBZH", row["ZCPCC_BZH"]),
- new CDAParameter("ZBY1", row["ZBY1"]),
- new CDAParameter("ZBY2", row["ZBY2"]),
- new CDAParameter("ZBY3", row["ZBY3"]),
- new CDAParameter("ZBY4", row["ZBY4"]),
- new CDAParameter("ZBY5", row["ZBY5"]),
- new CDAParameter("ZBY6", row["ZBY6"]),
- new CDAParameter("ACCOUNTID", 1),// HttpContext.Current.Session["accountId"]),
- new CDAParameter("VALUEFLAG", 1),
- new CDAParameter("CREATEUSERID", HttpContext.Current.Session["userId"]),
- new CDAParameter("UPDATEUSERID", HttpContext.Current.Session["userId"]),
- new CDAParameter("ZWLJC", row["ZEXTN1"])
- );
- #endregion
- }
- }
- }
- }
- else
- {
- string delsql = @"DELETE FROM TP_PC_SAPBOMDETAIL";
- // 删除所有
- result = conn.ExecuteNonQuery(delsql);
- // 插入新的
- string sqlString = @"
- INSERT INTO TP_PC_SAPBOMDETAIL (
- MATNR
- ,WERKS
- ,MAKTX
- ,MATKL
- ,WGBEZ
- ,MEINS
- ,LABOR
- ,LGFSB
- ,MTART
- ,LVORM
- ,BSTRF
- ,PRDHA
- ,VTEXT
- ,BSTME
- ,VOLUM
- ,BESKZ
- ,SOBSL
- ,LGPRO
- ,MTPOSMARA
- ,GROES
- ,STPRS
- ,UMREZ
- ,PEINH
- ,XCHAR
- ,ZGG
- ,ZYS
- ,ZCSJ
- ,VRKME
- ,ERSDA
- ,MAABC
- ,BRGEW
- ,NTGEW
- ,VOLEH
- ,ZWLFL
- ,ZWXGG
- ,ZWXMZ
- ,ZWXJZ
- ,ZEWSL
- ,ZEWDW
- ,ZMEINS
- ,ZZXBZ
- ,ZWYM
- ,ZNMAE
- ,ZMYYSL
- ,ZCPCCBZQ
- ,ZCPCCBZH
- ,ZBY1
- ,ZBY2
- ,ZBY3
- ,ZBY4
- ,ZBY5
- ,ZBY6
- ,ACCOUNTID
- ,VALUEFLAG
- ,CREATEUSERID
- ,UPDATEUSERID
- ,ZWLJC
- ) values(
- @MATNR@
- ,@WERKS@
- ,@MAKTX@
- ,@MATKL@
- ,@WGBEZ@
- ,@MEINS@
- ,@LABOR@
- ,@LGFSB@
- ,@MTART@
- ,@LVORM@
- ,@BSTRF@
- ,@PRDHA@
- ,@VTEXT@
- ,@BSTME@
- ,@VOLUM@
- ,@BESKZ@
- ,@SOBSL@
- ,@LGPRO@
- ,@MTPOSMARA@
- ,@GROES@
- ,@STPRS@
- ,@UMREZ@
- ,@PEINH@
- ,@XCHAR@
- ,@ZGG@
- ,@ZYS@
- ,@ZCSJ@
- ,@VRKME@
- ,@ERSDA@
- ,@MAABC@
- ,@BRGEW@
- ,@NTGEW@
- ,@VOLEH@
- ,@ZWLFL@
- ,@ZWXGG@
- ,@ZWXMZ@
- ,@ZWXJZ@
- ,@ZEWSL@
- ,@ZEWDW@
- ,@ZMEINS@
- ,@ZZXBZ@
- ,@ZWYM@
- ,@ZNMAE@
- ,@ZMYYSL@
- ,@ZCPCCBZQ@
- ,@ZCPCCBZH@
- ,@ZBY1@
- ,@ZBY2@
- ,@ZBY3@
- ,@ZBY4@
- ,@ZBY5@
- ,@ZBY6@
- ,@ACCOUNTID@
- ,@VALUEFLAG@
- ,@CREATEUSERID@
- ,@UPDATEUSERID@
- ,@ZWLJC@
- )";
- foreach (DataRow row in dtResult.Rows)
- {
- result += conn.ExecuteNonQuery(sqlString,
- new CDAParameter("MATNR", row["MATNR"]),
- new CDAParameter("WERKS", "5320"),
- new CDAParameter("MAKTX", row["MAKTX"]),
- new CDAParameter("MATKL", row["MATKL"]),
- new CDAParameter("WGBEZ", row["WGBEZ"]),
- new CDAParameter("MEINS", row["MEINS"]),
- new CDAParameter("LABOR", row["LABOR"]),
- new CDAParameter("LGFSB", row["LGFSB"]),
- new CDAParameter("MTART", row["MTART"]),
- new CDAParameter("LVORM", row["LVORM"]),
- new CDAParameter("BSTRF", row["BSTRF"]),
- new CDAParameter("PRDHA", row["PRDHA"]),
- new CDAParameter("VTEXT", row["VTEXT"]),
- new CDAParameter("BSTME", row["BSTME"]),
- new CDAParameter("VOLUM", row["VOLUM"]),
- new CDAParameter("BESKZ", row["BESKZ"]),
- new CDAParameter("SOBSL", row["SOBSL"]),
- new CDAParameter("LGPRO", row["LGPRO"]),
- new CDAParameter("MTPOSMARA", row["MTPOS_MARA"]),
- new CDAParameter("GROES", row["GROES"]),
- new CDAParameter("STPRS", row["STPRS"]),
- new CDAParameter("UMREZ", row["UMREZ"]),
- new CDAParameter("PEINH", row["PEINH"]),
- new CDAParameter("XCHAR", row["XCHAR"]),
- new CDAParameter("ZGG", row["ZGG"]),
- new CDAParameter("ZYS", row["ZYS"]),
- new CDAParameter("ZCSJ", row["ZCSJ"]),
- new CDAParameter("VRKME", row["VRKME"]),
- new CDAParameter("ERSDA", row["ERSDA"]),
- new CDAParameter("MAABC", row["MAABC"]),
- new CDAParameter("BRGEW", row["BRGEW"]),
- new CDAParameter("NTGEW", row["NTGEW"]),
- new CDAParameter("VOLEH", row["VOLEH"]),
- new CDAParameter("ZWLFL", row["ZWLFL"]),
- new CDAParameter("ZWXGG", row["ZWXGG"]),
- new CDAParameter("ZWXMZ", row["ZWXMZ"]),
- new CDAParameter("ZWXJZ", row["ZWXJZ"]),
- new CDAParameter("ZEWSL", row["ZEWSL"]),
- new CDAParameter("ZEWDW", row["ZEWDW"]),
- new CDAParameter("ZMEINS", row["ZMEINS"]),
- new CDAParameter("ZZXBZ", row["ZZXBZ"]),
- new CDAParameter("ZWYM", row["ZWYM"]),
- new CDAParameter("ZNMAE", row["ZNMAE"]),
- new CDAParameter("ZMYYSL", row["ZMYYSL"]),
- new CDAParameter("ZCPCCBZQ", row["ZCPCC_BZQ"]),
- new CDAParameter("ZCPCCBZH", row["ZCPCC_BZH"]),
- new CDAParameter("ZBY1", row["ZBY1"]),
- new CDAParameter("ZBY2", row["ZBY2"]),
- new CDAParameter("ZBY3", row["ZBY3"]),
- new CDAParameter("ZBY4", row["ZBY4"]),
- new CDAParameter("ZBY5", row["ZBY5"]),
- new CDAParameter("ZBY6", row["ZBY6"]),
- new CDAParameter("ACCOUNTID", 1),//HttpContext.Current.Session["accountId"]),
- new CDAParameter("VALUEFLAG", 1),
- new CDAParameter("CREATEUSERID", HttpContext.Current.Session["userId"]),
- new CDAParameter("UPDATEUSERID", HttpContext.Current.Session["userId"]),
- new CDAParameter("ZWLJC", row["ZEXTN1"])
- );
- }
- }
- conn.Commit();
- return new JsonResult(JsonStatus.success).ToJson();
- }
- }
- public bool IsReusable
- {
- get
- {
- return false;
- }
- }
- }
|
