public string save(string param)
{
string mode = JObject.Parse(param)["mode"].ToString();
string planno = JObject.Parse(param)["planno"].ToString();
string plandt = JObject.Parse(param)["plandt"].ToString();
string userid = JObject.Parse(param)["userid"].ToString();
string amt = JObject.Parse(param)["amt"].ToString();
string rmk = JObject.Parse(param)["rmk"].ToString();
string inuser = "******";
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", "mode", mode, "10");
fm.icnitMakeNode(dom, node, "numeric", "planno", planno, "20");
fm.icnitMakeNode(dom, node, "varchar", "plandt", plandt, "10");
fm.icnitMakeNode(dom, node, "varchar", "userid", userid, "20");
fm.icnitMakeNode(dom, node, "numeric", "amt", amt, "20");
fm.icnitMakeNode(dom, node, "varchar", "rmk", rmk, "2000");
fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");
dom.SelectSingleNode("//xmldata").AppendChild(node);
string query = @"PAGE41_SAVE";
dom.SelectSingleNode("//proc").InnerText = query;
result result = CallDB.getXmlTrans(dom);
return(JsonConvert.SerializeObject(result));
}
public string del(string param)
{
if (HttpContext.Current.Request.GetUserCookie("userid") == "")
{
return("");
}
string stno = JObject.Parse(param)["stno"].ToString();
string inuser = "******";
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", "stno", stno, "20");
fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");
dom.SelectSingleNode("//xmldata").AppendChild(node);
string query = @"PAGE61_DEL";
dom.SelectSingleNode("//proc").InnerText = query;
result result = CallDB.getXmlTrans(dom);
return(JsonConvert.SerializeObject(result));
}
public string save(string param)
{
string mode = JObject.Parse(param)["mode"].ToString();
string gbncd = JObject.Parse(param)["gbncd"].ToString();
string code = JObject.Parse(param)["code"].ToString();
string codenm = JObject.Parse(param)["codenm"].ToString();
string codeseq = JObject.Parse(param)["codeseq"].ToString();
string useyn = JObject.Parse(param)["useyn"].ToString();
string inuser = "******";
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", "mode", mode, "10");
fm.icnitMakeNode(dom, node, "varchar", "gbncd", gbncd, "20");
fm.icnitMakeNode(dom, node, "varchar", "code", code, "20");
fm.icnitMakeNode(dom, node, "varchar", "codenm", codenm, "100");
fm.icnitMakeNode(dom, node, "int", "codeseq", codeseq, "20");
fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "1");
fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");
dom.SelectSingleNode("//xmldata").AppendChild(node);
string query = @"PAGE17_SAVE";
dom.SelectSingleNode("//proc").InnerText = query;
result result = CallDB.getXmlTrans(dom);
return(JsonConvert.SerializeObject(result));
}
public string notice_save(string param)
{
string seq = JObject.Parse(param)["seq"].ToString();
string mode = JObject.Parse(param)["mode"].ToString();
string subject = JObject.Parse(param)["subject"].ToString();
string contents = JObject.Parse(param)["contents"].ToString();
string inuser = JObject.Parse(param)["inuser"].ToString();
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", "mode", mode, "10");
fm.icnitMakeNode(dom, node, "int", "seq", seq, "20");
fm.icnitMakeNode(dom, node, "varchar", "subject", subject, "20");
fm.icnitMakeNode(dom, node, "varchar", "contents", contents, "200");
fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");
dom.SelectSingleNode("//xmldata").AppendChild(node);
string query = @"NOTICE_TEST_SAVE";
dom.SelectSingleNode("//proc").InnerText = query;
result result = CallDB.getXmlTrans(dom);
return(JsonConvert.SerializeObject(result));
}
public string save(string param)
{
string mode = JObject.Parse(param)["mode"].ToString();
string itemcd = JObject.Parse(param)["itemcd"].ToString();
string itemnm = JObject.Parse(param)["itemnm"].ToString();
string sitemnm = JObject.Parse(param)["sitemnm"].ToString();
string eitemnm = JObject.Parse(param)["eitemnm"].ToString();
string ditemcd = JObject.Parse(param)["ditemcd"].ToString();
string spec = JObject.Parse(param)["spec"].ToString();
string width = JObject.Parse(param)["width"].ToString();
string height = JObject.Parse(param)["height"].ToString();
string qty = JObject.Parse(param)["qty"].ToString();
string sqm = JObject.Parse(param)["sqm"].ToString();
string unitprice = JObject.Parse(param)["unitprice"].ToString();
string safeqty = JObject.Parse(param)["safeqty"].ToString();
string comnm = JObject.Parse(param)["comnm"].ToString();
string statuscd = JObject.Parse(param)["statuscd"].ToString();
string rmk = JObject.Parse(param)["rmk"].ToString();
string useyn = JObject.Parse(param)["useyn"].ToString();
string inuser = "******";
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", "mode", mode, "10");
fm.icnitMakeNode(dom, node, "varchar", "itemcd", itemcd, "20");
fm.icnitMakeNode(dom, node, "varchar", "itemnm", itemnm, "100");
fm.icnitMakeNode(dom, node, "varchar", "sitemnm", sitemnm, "50");
fm.icnitMakeNode(dom, node, "varchar", "eitemnm", eitemnm, "50");
fm.icnitMakeNode(dom, node, "varchar", "ditemcd", ditemcd, "20");
fm.icnitMakeNode(dom, node, "varchar", "spec", spec, "100");
fm.icnitMakeNode(dom, node, "int", "width", width, "20");
fm.icnitMakeNode(dom, node, "int", "height", height, "20");
fm.icnitMakeNode(dom, node, "numeric", "qty", qty, "20");
fm.icnitMakeNode(dom, node, "numeric", "sqm", sqm, "20");
fm.icnitMakeNode(dom, node, "numeric", "unitprice", unitprice, "20");
fm.icnitMakeNode(dom, node, "numeric", "safeqty", safeqty, "20");
fm.icnitMakeNode(dom, node, "varchar", "comnm", comnm, "200");
fm.icnitMakeNode(dom, node, "varchar", "statuscd", statuscd, "10");
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);
string query = @"PAGE12_SAVE";
dom.SelectSingleNode("//proc").InnerText = query;
result result = CallDB.getXmlTrans(dom);
return(JsonConvert.SerializeObject(result));
}
public string save(string param)
{
if (HttpContext.Current.Request.GetUserCookie("userid") == "")
{
return("");
}
string ss_userid = HttpContext.Current.Request.GetUserCookie("userid");
string mode = JObject.Parse(param)["mode"].ToString();
string locno = JObject.Parse(param)["locno"].ToString();
string whcd = JObject.Parse(param)["whcd"].ToString();
string typecd = JObject.Parse(param)["typecd"].ToString();
string typeno = JObject.Parse(param)["typeno"].ToString();
string colno = JObject.Parse(param)["colno"].ToString();
string ordseq = JObject.Parse(param)["ordseq"].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", "mode", mode, "10");
fm.icnitMakeNode(dom, node, "varchar", "locno", locno, "20");
fm.icnitMakeNode(dom, node, "varchar", "whcd", whcd, "20");
fm.icnitMakeNode(dom, node, "varchar", "typecd", typecd, "10");
fm.icnitMakeNode(dom, node, "varchar", "typeno", typeno, "20");
fm.icnitMakeNode(dom, node, "varchar", "colno", colno, "20");
fm.icnitMakeNode(dom, node, "numeric", "ordseq", ordseq, "20");
fm.icnitMakeNode(dom, node, "varchar", "rmk", rmk, "500");
fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "1");
fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");
dom.SelectSingleNode("//xmldata").AppendChild(node);
string query = @"PAGE19_SAVE";
dom.SelectSingleNode("//proc").InnerText = query;
result result = CallDB.getXmlTrans(dom);
return(JsonConvert.SerializeObject(result));
}
public string save(string param)
{
string mode = JObject.Parse(param)["mode"].ToString();
string userid = JObject.Parse(param)["userid"].ToString();
string usernm = JObject.Parse(param)["usernm"].ToString();
string email = JObject.Parse(param)["email"].ToString();
string hp = JObject.Parse(param)["hp"].ToString();
string jkcd = JObject.Parse(param)["jkcd"].ToString();
string deptcd = JObject.Parse(param)["deptcd"].ToString();
string addr = JObject.Parse(param)["addr"].ToString();
string filepath = JObject.Parse(param)["filepath"].ToString();
string pwd = JObject.Parse(param)["pwd"].ToString();
string useyn = JObject.Parse(param)["useyn"].ToString();
string inuser = "******";
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", "mode", mode, "10");
fm.icnitMakeNode(dom, node, "varchar", "userid", userid, "20");
fm.icnitMakeNode(dom, node, "varchar", "usernm", usernm, "50");
fm.icnitMakeNode(dom, node, "varchar", "email", email, "100");
fm.icnitMakeNode(dom, node, "varchar", "hp", hp, "50");
fm.icnitMakeNode(dom, node, "varchar", "jkcd", jkcd, "10");
fm.icnitMakeNode(dom, node, "varchar", "deptcd", deptcd, "20");
fm.icnitMakeNode(dom, node, "varchar", "addr", addr, "200");
fm.icnitMakeNode(dom, node, "varchar", "filepath", filepath, "200");
fm.icnitMakeNode(dom, node, "varchar", "pwd", pwd, "50");
fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "1");
fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");
dom.SelectSingleNode("//xmldata").AppendChild(node);
string query = @"PAGE14_SAVE";
dom.SelectSingleNode("//proc").InnerText = query;
result result = CallDB.getXmlTrans(dom);
return(JsonConvert.SerializeObject(result));
}
public string save(string param)
{
string mode = JObject.Parse(param)["mode"].ToString();
string whcd = JObject.Parse(param)["whcd"].ToString();
string whnm = JObject.Parse(param)["whnm"].ToString();
//string whnm2 = JObject.Parse(param)["whnm2"].ToString();
string brief = JObject.Parse(param)["brief"].ToString();
string tel = JObject.Parse(param)["tel"].ToString();
string addr = JObject.Parse(param)["addr"].ToString();
string useyn = JObject.Parse(param)["useyn"].ToString();
string inuser = "******";
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", "mode", mode, "10");
fm.icnitMakeNode(dom, node, "varchar", "whcd", whcd, "20");
fm.icnitMakeNode(dom, node, "varchar", "whnm", whnm, "50");
//fm.icnitMakeNode(dom, node, "varchar", "whnm2", whnm2, "200");
fm.icnitMakeNode(dom, node, "varchar", "brief", brief, "200");
fm.icnitMakeNode(dom, node, "varchar", "tel", tel, "50");
fm.icnitMakeNode(dom, node, "varchar", "addr", addr, "200");
fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "1");
fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");
dom.SelectSingleNode("//xmldata").AppendChild(node);
string query = @"PAGE13_SAVE";
dom.SelectSingleNode("//proc").InnerText = query;
result result = CallDB.getXmlTrans(dom);
return(JsonConvert.SerializeObject(result));
}
public string save(string param, string param2)
{
if (HttpContext.Current.Request.GetUserCookie("userid") == "")
{
return("");
}
//===========================================================================master
string stno = JObject.Parse(param)["stno"].ToString();
string iccd = JObject.Parse(param)["iccd"].ToString();
string gucd = JObject.Parse(param)["gucd"].ToString();
string stdt = JObject.Parse(param)["stdt"].ToString();
string apprdt = JObject.Parse(param)["apprdt"].ToString();
string userid = JObject.Parse(param)["userid"].ToString();
string userid2 = JObject.Parse(param)["userid2"].ToString();
string inwhcd = JObject.Parse(param)["inwhcd"].ToString();
string outwhcd = JObject.Parse(param)["outwhcd"].ToString();
string custcd = JObject.Parse(param)["custcd"].ToString();
string carnm = JObject.Parse(param)["carnm"].ToString();
string bccd = JObject.Parse(param)["bccd"].ToString();
string stno2 = JObject.Parse(param)["stno2"].ToString();
string rmk = JObject.Parse(param)["rmk"].ToString();
string useyn = JObject.Parse(param)["useyn"].ToString();
string inuser = "******";
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", "stno", stno, "20");
fm.icnitMakeNode(dom, node, "varchar", "iccd", iccd, "10");
fm.icnitMakeNode(dom, node, "varchar", "gucd", gucd, "1");
fm.icnitMakeNode(dom, node, "varchar", "stdt", stdt, "10");
fm.icnitMakeNode(dom, node, "varchar", "apprdt", apprdt, "10");
fm.icnitMakeNode(dom, node, "varchar", "userid", userid, "20");
fm.icnitMakeNode(dom, node, "varchar", "userid2", userid2, "20");
fm.icnitMakeNode(dom, node, "varchar", "inwhcd", inwhcd, "20");
fm.icnitMakeNode(dom, node, "varchar", "outwhcd", outwhcd, "20");
fm.icnitMakeNode(dom, node, "varchar", "custcd", custcd, "20");
fm.icnitMakeNode(dom, node, "varchar", "carnm", carnm, "100");
fm.icnitMakeNode(dom, node, "varchar", "bccd", bccd, "10");
fm.icnitMakeNode(dom, node, "varchar", "stno2", stno2, "20");
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);
string query = @"PAGE61_SAVE";
dom.SelectSingleNode("//proc").InnerText = query;
result result = CallDB.getXmlTrans(dom);
//return JsonConvert.SerializeObject(result);
//===========================================================================detail
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)
{
string mode = item.mode.ToString();
stno = result.val;
string stseq = item.stseq.ToString();
string itemcd = item.itemcd.ToString();
string iqty = item.iqty.ToString();
string cqty = item.cqty.ToString();
string sno = item.sno.ToString();
string statuscd = item.statuscd.ToString();
string falsecd = item.falsecd.ToString();
string filepath = item.filepath.ToString();
rmk = item.rmk.ToString();
useyn = item.useyn.ToString();
inuser = "******";
node = dom.CreateNode(XmlNodeType.Element, "zrow", "");
fm.icnitMakeNode(dom, node, "varchar", "mode", mode, "10");
fm.icnitMakeNode(dom, node, "varchar", "stno", stno, "20");
fm.icnitMakeNode(dom, node, "numeric", "stseq", stseq, "20");
fm.icnitMakeNode(dom, node, "varchar", "itemcd", itemcd, "20");
fm.icnitMakeNode(dom, node, "numeric", "iqty", iqty, "20");
fm.icnitMakeNode(dom, node, "numeric", "cqty", cqty, "20");
fm.icnitMakeNode(dom, node, "varchar", "sno", sno, "50");
fm.icnitMakeNode(dom, node, "varchar", "statuscd", statuscd, "10");
fm.icnitMakeNode(dom, node, "varchar", "falsecd", falsecd, "10");
fm.icnitMakeNode(dom, node, "varchar", "filepath", filepath, "100");
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 = @"PAGE61_DETAIL_SAVE";
dom.SelectSingleNode("//proc").InnerText = query;
result = CallDB.getXmlTrans(dom);
return(JsonConvert.SerializeObject(result));
}
public string save(string param)
{
string mode = JObject.Parse(param)["mode"].ToString();
string custcd = JObject.Parse(param)["custcd"].ToString();
string custnm = JObject.Parse(param)["custnm"].ToString();
string dcustcd = JObject.Parse(param)["dcustcd"].ToString();
string userid = JObject.Parse(param)["userid"].ToString();
string bizno = JObject.Parse(param)["bizno"].ToString();
string ceo = JObject.Parse(param)["ceo"].ToString();
string tel = JObject.Parse(param)["tel"].ToString();
string fax = JObject.Parse(param)["fax"].ToString();
string hp = JObject.Parse(param)["hp"].ToString();
string email = JObject.Parse(param)["email"].ToString();
string addr = JObject.Parse(param)["addr"].ToString();
string dotel = JObject.Parse(param)["dotel"].ToString();
string doaddr = JObject.Parse(param)["doaddr"].ToString();
string curcd = JObject.Parse(param)["curcd"].ToString();
string janamt = JObject.Parse(param)["janamt"].ToString();
string creditamt = JObject.Parse(param)["creditamt"].ToString();
string acctno = JObject.Parse(param)["acctno"].ToString();
string useyn = JObject.Parse(param)["useyn"].ToString();
string inuser = "******";
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", "mode", mode, "10");
fm.icnitMakeNode(dom, node, "varchar", "custcd", custcd, "20");
fm.icnitMakeNode(dom, node, "varchar", "custnm", custnm, "100");
fm.icnitMakeNode(dom, node, "varchar", "dcustcd", dcustcd, "20");
fm.icnitMakeNode(dom, node, "varchar", "userid", userid, "20");
fm.icnitMakeNode(dom, node, "varchar", "bizno", bizno, "50");
fm.icnitMakeNode(dom, node, "varchar", "ceo", ceo, "100");
fm.icnitMakeNode(dom, node, "varchar", "tel", tel, "50");
fm.icnitMakeNode(dom, node, "varchar", "fax", fax, "50");
fm.icnitMakeNode(dom, node, "varchar", "hp", hp, "50");
fm.icnitMakeNode(dom, node, "varchar", "email", email, "100");
fm.icnitMakeNode(dom, node, "varchar", "addr", addr, "200");
fm.icnitMakeNode(dom, node, "varchar", "dotel", dotel, "20");
fm.icnitMakeNode(dom, node, "varchar", "doaddr", doaddr, "200");
fm.icnitMakeNode(dom, node, "varchar", "curcd", curcd, "10");
fm.icnitMakeNode(dom, node, "numeric", "janamt", janamt, "20");
fm.icnitMakeNode(dom, node, "numeric", "creditamt", creditamt, "20");
fm.icnitMakeNode(dom, node, "varchar", "acctno", acctno, "50");
fm.icnitMakeNode(dom, node, "varchar", "useyn", useyn, "1");
fm.icnitMakeNode(dom, node, "varchar", "inuser", inuser, "20");
dom.SelectSingleNode("//xmldata").AppendChild(node);
string query = @"PAGE11_SAVE";
dom.SelectSingleNode("//proc").InnerText = query;
result result = CallDB.getXmlTrans(dom);
return(JsonConvert.SerializeObject(result));
}