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));
}