示例#1
0
        public string save(string param, string param2)
        {
            if (HttpContext.Current.Request.GetUserCookie("userid") == "")
            {
                return("");
            }
            string ss_userid = HttpContext.Current.Request.GetUserCookie("userid");

            //===========================================================================master
            string saleno    = JObject.Parse(param)["saleno"].ToString();
            string chasu     = JObject.Parse(param)["chasu"].ToString();
            string csaleno   = JObject.Parse(param)["csaleno"].ToString();
            string gucd      = JObject.Parse(param)["gucd"].ToString();
            string scd       = JObject.Parse(param)["scd"].ToString();
            string saledt    = JObject.Parse(param)["saledt"].ToString();
            string userid    = JObject.Parse(param)["userid"].ToString();
            string custcd    = JObject.Parse(param)["custcd"].ToString();
            string termcd    = JObject.Parse(param)["termcd"].ToString();
            string janamt    = JObject.Parse(param)["janamt"].ToString();
            string whcd      = JObject.Parse(param)["whcd"].ToString();
            string ydt       = JObject.Parse(param)["ydt"].ToString();
            string dotel     = JObject.Parse(param)["dotel"].ToString();
            string framecd   = JObject.Parse(param)["framecd"].ToString();
            string doaddr    = JObject.Parse(param)["doaddr"].ToString();
            string rmk       = JObject.Parse(param)["rmk"].ToString();
            string carnm     = JObject.Parse(param)["carnm"].ToString();
            string carno     = JObject.Parse(param)["carno"].ToString();
            string carpayamt = JObject.Parse(param)["carpayamt"].ToString();
            string checkdt   = JObject.Parse(param)["checkdt"].ToString();
            string outdt     = JObject.Parse(param)["outdt"].ToString();
            string outtime   = JObject.Parse(param)["outtime"].ToString();
            string useyn     = JObject.Parse(param)["useyn"].ToString();
            string inuser    = ss_userid;

            //== 전표번호 가져오기 ==================================================
            FormManager fm  = new FormManager();
            XmlDocument dom = new XmlDocument();

            dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>");
            dom.SelectSingleNode("//act").InnerText = "proc";

            XmlNode node;

            node = dom.CreateNode(XmlNodeType.Element, "zrow", "");
            fm.icnitMakeNode(dom, node, "varchar", "csaleno", csaleno, "20");
            fm.icnitMakeNode(dom, node, "varchar", "saledt", saledt, "10");
            dom.SelectSingleNode("//xmldata").AppendChild(node);

            string query = @"PAGE31_GET_SALENO";

            dom.SelectSingleNode("//proc").InnerText = query;

            object no = new object();

            if (saleno == "")
            {
                no     = CallDB.getExcuteScalar(dom);
                saleno = (no ?? "").ToString();
            }

            List <XmlDocument> domList = new List <XmlDocument>();

            //=== master data ==============================================================
            fm  = new FormManager();
            dom = new XmlDocument();
            dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>");
            dom.SelectSingleNode("//act").InnerText = "proc";
            node = dom.CreateNode(XmlNodeType.Element, "zrow", "");
            fm.icnitMakeNode(dom, node, "varchar", "saleno", saleno, "20");
            fm.icnitMakeNode(dom, node, "numeric", "chasu", chasu, "20");
            fm.icnitMakeNode(dom, node, "varchar", "csaleno", csaleno, "20");
            fm.icnitMakeNode(dom, node, "varchar", "gucd", gucd, "10");
            fm.icnitMakeNode(dom, node, "varchar", "scd", scd, "10");
            fm.icnitMakeNode(dom, node, "varchar", "saledt", saledt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "userid", userid, "20");
            fm.icnitMakeNode(dom, node, "varchar", "custcd", custcd, "20");
            fm.icnitMakeNode(dom, node, "varchar", "termcd", termcd, "10");
            fm.icnitMakeNode(dom, node, "numeric", "janamt", janamt, "20");
            fm.icnitMakeNode(dom, node, "varchar", "whcd", whcd, "10");
            fm.icnitMakeNode(dom, node, "varchar", "ydt", ydt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "dotel", dotel, "100");
            fm.icnitMakeNode(dom, node, "varchar", "framecd", framecd, "20");
            fm.icnitMakeNode(dom, node, "numeric", "doaddr", doaddr, "20");
            fm.icnitMakeNode(dom, node, "varchar", "rmk", rmk, "2000");
            fm.icnitMakeNode(dom, node, "varchar", "carnm", carnm, "1000");
            fm.icnitMakeNode(dom, node, "varchar", "carno", carno, "200");
            fm.icnitMakeNode(dom, node, "numeric", "carpayamt", carpayamt, "20");
            fm.icnitMakeNode(dom, node, "varchar", "checkdt", checkdt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "outdt", outdt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "outtime", outtime, "20");
            fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "10");
            fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");

            dom.SelectSingleNode("//xmldata").AppendChild(node);

            query = @"PAGE31_SAVE";
            dom.SelectSingleNode("//proc").InnerText = query;
            domList.Add(dom);

            //===========================================================================detail
            fm  = new FormManager();
            dom = new XmlDocument();
            dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>");
            dom.SelectSingleNode("//act").InnerText = "proc";
            dynamic dynJson = JsonConvert.DeserializeObject(param2);

            foreach (var item in dynJson)
            {
                saleno = saleno;
                string saleseq   = (item.saleseq ?? "").ToString();
                string itemcd    = (item.itemcd ?? "").ToString();
                string qty       = (item.qty ?? "").ToString();
                string boxqty    = (item.boxqty ?? "").ToString();
                string curcd     = (item.curcd ?? "").ToString();
                string unitprice = (item.unitprice ?? "").ToString();
                string supplyamt = (item.supplyamt ?? "").ToString();
                string vat       = (item.vat ?? "").ToString();
                string totamt    = (item.totamt ?? "").ToString();
                rmk = (item.rmk ?? "").ToString();
                string sno    = (item.sno ?? "").ToString();
                string prodno = (item.prodno ?? "").ToString();
                string caseno = (item.caseno ?? "").ToString();
                inuser = ss_userid;

                node = dom.CreateNode(XmlNodeType.Element, "zrow", "");
                fm.icnitMakeNode(dom, node, "varchar", "saleno", saleno, "20");
                fm.icnitMakeNode(dom, node, "numeric", "saleseq", saleseq, "20");
                fm.icnitMakeNode(dom, node, "varchar", "itemcd", itemcd, "20");
                fm.icnitMakeNode(dom, node, "numeric", "qty", qty, "20");
                fm.icnitMakeNode(dom, node, "numeric", "boxqty", boxqty, "20");
                fm.icnitMakeNode(dom, node, "varchar", "curcd", curcd, "10");
                fm.icnitMakeNode(dom, node, "numeric", "unitprice", unitprice, "20");
                fm.icnitMakeNode(dom, node, "numeric", "supplyamt", supplyamt, "20");
                fm.icnitMakeNode(dom, node, "numeric", "vat", vat, "20");
                fm.icnitMakeNode(dom, node, "numeric", "totamt", totamt, "20");
                fm.icnitMakeNode(dom, node, "varchar", "rmk", rmk, "2000");
                fm.icnitMakeNode(dom, node, "varchar", "sno", sno, "50");
                fm.icnitMakeNode(dom, node, "varchar", "prodno", prodno, "200");
                fm.icnitMakeNode(dom, node, "varchar", "caseno", caseno, "200");
                fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");
                dom.SelectSingleNode("//xmldata").AppendChild(node);
            }
            query = @"PAGE31_DETAIL_SAVE";
            dom.SelectSingleNode("//proc").InnerText = query;
            domList.Add(dom);

            //=== jan 전표 ==============================================================
            //fm = new FormManager();
            //dom = new XmlDocument();
            //dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>");
            //dom.SelectSingleNode("//act").InnerText = "proc";
            //node = dom.CreateNode(XmlNodeType.Element, "zrow", "");
            //fm.icnitMakeNode(dom, node, "varchar", "saleno" , saleno    , "20"   );
            //fm.icnitMakeNode(dom, node, "varchar", "inuser" , inuser    , "20"   );
            //dom.SelectSingleNode("//xmldata").AppendChild(node);

            //query = @"PAGE31_SAVE_JAN";
            //dom.SelectSingleNode("//proc").InnerText = query;
            //domList.Add(dom);

            result result = CallDB.getXmlTransAll(domList);

            return(JsonConvert.SerializeObject(result));
        }
        public string save(string param, string param2)
        {
            if (HttpContext.Current.Request.GetUserCookie("userid") == "")
            {
                return("");
            }
            string ss_userid = HttpContext.Current.Request.GetUserCookie("userid");

            //===========================================================================master
            string jpno     = JObject.Parse(param)["jpno"].ToString();
            string chasu    = JObject.Parse(param)["chasu"].ToString();
            string cjpno    = JObject.Parse(param)["cjpno"].ToString();
            string gucd     = JObject.Parse(param)["gucd"].ToString();
            string scd      = JObject.Parse(param)["scd"].ToString();
            string jpdt     = JObject.Parse(param)["jpdt"].ToString();
            string termcd   = JObject.Parse(param)["termcd"].ToString();
            string pidt     = JObject.Parse(param)["pidt"].ToString();
            string userid   = JObject.Parse(param)["userid"].ToString();
            string custcd   = JObject.Parse(param)["custcd"].ToString();
            string whcd     = JObject.Parse(param)["whcd"].ToString();
            string janamt   = JObject.Parse(param)["janamt"].ToString();
            string pino     = JObject.Parse(param)["pino"].ToString();
            string curcd    = JObject.Parse(param)["curcd"].ToString();
            string bcheckdt = JObject.Parse(param)["bcheckdt"].ToString();
            string paycd    = JObject.Parse(param)["paycd"].ToString();
            string paydt    = JObject.Parse(param)["paydt"].ToString();
            string lcno     = JObject.Parse(param)["lcno"].ToString();
            string amt      = JObject.Parse(param)["amt"].ToString();
            string tolper   = JObject.Parse(param)["tolper"].ToString();
            string tolamt   = JObject.Parse(param)["tolamt"].ToString();
            string usance   = JObject.Parse(param)["usance"].ToString();
            string mandt    = JObject.Parse(param)["mandt"].ToString();
            string blno     = JObject.Parse(param)["blno"].ToString();
            string shipdt   = JObject.Parse(param)["shipdt"].ToString();
            string chuldt   = JObject.Parse(param)["chuldt"].ToString();
            string ipdt     = JObject.Parse(param)["ipdt"].ToString();
            string conbandt = JObject.Parse(param)["conbandt"].ToString();
            string shipnm   = JObject.Parse(param)["shipnm"].ToString();
            string rmk      = JObject.Parse(param)["rmk"].ToString();
            string useyn    = JObject.Parse(param)["useyn"].ToString();
            string inuser   = ss_userid;

            //== 전표번호 가져오기 ==================================================
            FormManager fm  = new FormManager();
            XmlDocument dom = new XmlDocument();

            dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>");
            dom.SelectSingleNode("//act").InnerText = "proc";

            XmlNode node;

            node = dom.CreateNode(XmlNodeType.Element, "zrow", "");
            fm.icnitMakeNode(dom, node, "varchar", "cjpno", cjpno, "20");
            fm.icnitMakeNode(dom, node, "varchar", "jpdt", jpdt, "10");
            dom.SelectSingleNode("//xmldata").AppendChild(node);

            string query = @"PAGE21_GET_JPNO";

            dom.SelectSingleNode("//proc").InnerText = query;

            object no = new object();

            if (jpno == "")
            {
                no   = CallDB.getExcuteScalar(dom);
                jpno = (no ?? "").ToString();
            }

            List <XmlDocument> domList = new List <XmlDocument>();

            //=== master data ==============================================================
            fm  = new FormManager();
            dom = new XmlDocument();
            dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>");
            dom.SelectSingleNode("//act").InnerText = "proc";
            node = dom.CreateNode(XmlNodeType.Element, "zrow", "");
            fm.icnitMakeNode(dom, node, "varchar", "jpno", jpno, "20");
            fm.icnitMakeNode(dom, node, "numeric", "chasu", chasu, "20");
            fm.icnitMakeNode(dom, node, "varchar", "cjpno", cjpno, "20");
            fm.icnitMakeNode(dom, node, "varchar", "gucd", gucd, "1");
            fm.icnitMakeNode(dom, node, "varchar", "scd", scd, "10");
            fm.icnitMakeNode(dom, node, "varchar", "jpdt", jpdt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "termcd", termcd, "10");
            fm.icnitMakeNode(dom, node, "varchar", "pidt", pidt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "userid", userid, "20");
            fm.icnitMakeNode(dom, node, "varchar", "custcd", custcd, "20");
            fm.icnitMakeNode(dom, node, "varchar", "whcd", whcd, "20");
            fm.icnitMakeNode(dom, node, "numeric", "janamt", janamt, "20");
            fm.icnitMakeNode(dom, node, "varchar", "pino", pino, "20");
            fm.icnitMakeNode(dom, node, "varchar", "curcd", curcd, "20");
            fm.icnitMakeNode(dom, node, "varchar", "bcheckdt", bcheckdt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "paycd", paycd, "10");
            fm.icnitMakeNode(dom, node, "varchar", "paydt", paydt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "lcno", lcno, "50");
            fm.icnitMakeNode(dom, node, "numeric", "amt", amt, "20");
            fm.icnitMakeNode(dom, node, "numeric", "tolper", tolper, "20");
            fm.icnitMakeNode(dom, node, "numeric", "tolamt", tolamt, "20");
            fm.icnitMakeNode(dom, node, "varchar", "usance", usance, "200");
            fm.icnitMakeNode(dom, node, "varchar", "mandt", mandt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "blno", blno, "50");
            fm.icnitMakeNode(dom, node, "varchar", "shipdt", shipdt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "chuldt", chuldt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "ipdt", ipdt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "conbandt", conbandt, "10");
            fm.icnitMakeNode(dom, node, "varchar", "shipnm", shipnm, "200");
            fm.icnitMakeNode(dom, node, "varchar", "rmk", rmk, "2000");
            fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "1");
            fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");
            dom.SelectSingleNode("//xmldata").AppendChild(node);

            query = @"PAGE21_SAVE";
            dom.SelectSingleNode("//proc").InnerText = query;
            domList.Add(dom);
            //result result = CallDB.getXmlTrans(dom);
            //if (result.code != "OK") return JsonConvert.SerializeObject(result);
            //== detail data =========================================================================
            fm  = new FormManager();
            dom = new XmlDocument();
            dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>");
            dom.SelectSingleNode("//act").InnerText = "proc";
            //JObject json = JObject.Parse(param2);
            //JObject json = new JObject();//  JObject.Parse(param2);
            dynamic dynJson = JsonConvert.DeserializeObject(param2);

            //if(dynJson == null || dynJson.Count == 0) {
            //    return JsonConvert.SerializeObject(result);
            //}
            foreach (var item in dynJson)
            {
                jpno = jpno;
                string jpseq     = (item.jpseq ?? "").ToString();
                string itemcd    = (item.itemcd ?? "").ToString();
                string qty       = (item.qty ?? "").ToString();
                string boxqty    = (item.boxqty ?? "").ToString();
                string unitprice = (item.unitprice ?? "").ToString();
                string supplyamt = (item.supplyamt ?? "").ToString();
                string vat       = (item.vat ?? "").ToString();
                string totamt    = (item.totamt ?? "").ToString();
                string conqty    = (item.conqty ?? "").ToString();
                string sqm       = (item.sqm ?? "").ToString();
                rmk = (item.rmk ?? "").ToString();
                string tongdt = (item.tongdt ?? "").ToString();
                string passdt = (item.passdt ?? "").ToString();
                string port   = (item.port ?? "").ToString();
                string conno  = (item.conno ?? "").ToString();
                string docno  = (item.docno ?? "").ToString();
                string ckcd   = (item.ckcd ?? "").ToString();
                string ftdt   = (item.ftdt ?? "").ToString();
                conbandt = (item.conbandt ?? "").ToString();
                string inyodt      = (item.inyodt ?? "").ToString();
                string incheckdt   = (item.incheckdt ?? "").ToString();
                string inchecktime = (item.inchecktime ?? "").ToString();
                string sno         = (item.sno ?? "").ToString();
                string prodcd      = (item.prodcd ?? "").ToString();
                string casenom     = (item.casenom ?? "").ToString();
                string proddt      = (item.proddt ?? "").ToString();
                inuser = ss_userid;

                node = dom.CreateNode(XmlNodeType.Element, "zrow", "");
                fm.icnitMakeNode(dom, node, "varchar", "jpno", jpno, "20");
                fm.icnitMakeNode(dom, node, "numeric", "jpseq", jpseq, "20");
                fm.icnitMakeNode(dom, node, "varchar", "itemcd", itemcd, "20");
                fm.icnitMakeNode(dom, node, "numeric", "qty", qty, "20");
                fm.icnitMakeNode(dom, node, "numeric", "boxqty", boxqty, "20");
                fm.icnitMakeNode(dom, node, "numeric", "unitprice", unitprice, "20");
                fm.icnitMakeNode(dom, node, "numeric", "supplyamt", supplyamt, "20");
                fm.icnitMakeNode(dom, node, "numeric", "vat", vat, "20");
                fm.icnitMakeNode(dom, node, "numeric", "totamt", totamt, "20");
                fm.icnitMakeNode(dom, node, "numeric", "conqty", conqty, "20");
                fm.icnitMakeNode(dom, node, "numeric", "sqm", sqm, "20");
                fm.icnitMakeNode(dom, node, "varchar", "rmk", rmk, "2000");
                fm.icnitMakeNode(dom, node, "varchar", "tongdt", tongdt, "10");
                fm.icnitMakeNode(dom, node, "varchar", "passdt", passdt, "10");
                fm.icnitMakeNode(dom, node, "varchar", "port", port, "10");
                fm.icnitMakeNode(dom, node, "varchar", "conno", conno, "50");
                fm.icnitMakeNode(dom, node, "varchar", "docno", docno, "200");
                fm.icnitMakeNode(dom, node, "varchar", "ckcd", ckcd, "10");
                fm.icnitMakeNode(dom, node, "varchar", "ftdt", ftdt, "10");
                fm.icnitMakeNode(dom, node, "varchar", "conbandt", conbandt, "10");
                fm.icnitMakeNode(dom, node, "varchar", "inyodt", inyodt, "10");
                fm.icnitMakeNode(dom, node, "varchar", "incheckdt", incheckdt, "10");
                fm.icnitMakeNode(dom, node, "varchar", "inchecktime", inchecktime, "10");
                fm.icnitMakeNode(dom, node, "varchar", "sno", sno, "50");
                fm.icnitMakeNode(dom, node, "varchar", "prodcd", prodcd, "200");
                fm.icnitMakeNode(dom, node, "varchar", "casenom", casenom, "200");
                fm.icnitMakeNode(dom, node, "varchar", "proddt", proddt, "10");
                fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");
                dom.SelectSingleNode("//xmldata").AppendChild(node);
            }
            query = @"PAGE21_DETAIL_SAVE";
            dom.SelectSingleNode("//proc").InnerText = query;
            domList.Add(dom);

            //=== jan 전표 ==============================================================
            //fm = new FormManager();
            //dom = new XmlDocument();
            //dom.LoadXml("<xml><proc/><act/><xmldata></xmldata><xmlclipdata/></xml>");
            //dom.SelectSingleNode("//act").InnerText = "proc";
            //node = dom.CreateNode(XmlNodeType.Element, "zrow", "");
            //fm.icnitMakeNode(dom, node, "varchar", "jpno"    , jpno    , "20"   );
            //fm.icnitMakeNode(dom, node, "varchar", "inuser"  , inuser  , "20"   );
            //dom.SelectSingleNode("//xmldata").AppendChild(node);

            //query = @"PAGE21_SAVE_JAN";
            //dom.SelectSingleNode("//proc").InnerText = query;
            //domList.Add(dom);

            result result = CallDB.getXmlTransAll(domList);

            return(JsonConvert.SerializeObject(result));
        }