public void Update()
{
using (CallDB db = new CallDB())
{
new UsersQuery(db).UpdateProfile(this);
}
}
public void Update2(int id)
{
using (CallDB db = new CallDB())
{
new UsersQuery(db).UpdateProduto2(this, id);
}
}
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 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 void Update(int id)
{
using (CallDB db = new CallDB())
{
new UsersQuery(db).UpdatePedido(id);
}
}
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 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 void Update(int id, string caminhoImagem)
{
using (CallDB db = new CallDB())
{
new UsersQuery(db).UpdateProduto(this, caminhoImagem, id);
}
}
public string detail_search(string param)
{
if (HttpContext.Current.Request.GetUserCookie("userid") == "")
{
return("");
}
string stno = JObject.Parse(param)["stno"].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", "stno", stno, "20");
dom.SelectSingleNode("//xmldata").AppendChild(node);
string query = @"PAGE61_DETAIL_SEARCH";
dom.SelectSingleNode("//proc").InnerText = query;
DataTable dt = CallDB.getExecuteDataTable(dom);
return(dt.ToJson());
}
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 bool Exist()
{
using (var db = new CallDB())
{
db.conexao.Open();
var exist = new LoginQuery(db).Exist(this.Email);
return(exist.Result);
}
}
public static bool EmailExist(string Email)
{
using (CallDB db = new CallDB())//Open
{
return(new DMLQuery(db).ExistData("usuario", new List <string> {
"email"
}, new List <string> {
Email
}));
}
}
public ActionResult Index(CheckoutModel model)
{
using (CallDB db = new CallDB())
{
Order order = new Order().GetCardUser(AlgeCookieController.UserID);
new Carrinho().Update(order.id_pedido);
}
return(RedirectToAction("Orders", "Home"));
}
public static void ChangePassword(string newPassword, int UserID)
{
MD5 md5hash = MD5.Create();
string passwordHashed = PasswordProcedures.ToMD5Hash(newPassword);
using (CallDB db = new CallDB())
{
new UsersQuery(db).ChangePassword(passwordHashed, UserID);
db.conexao.Close();
}
}
public static UserProfileModel GetProfileModel(int userID)
{
using (CallDB db = new CallDB())
{
var profile = new UsersQuery(db).GetProfile(userID);
if (profile == null)
{
return(new UserProfileModel());
}
return(profile);
}
}
public static void ChangeEmail(string emailFrom, string emailTo, string idUser)
{
using (CallDB db = new CallDB())
{
new DMLQuery(db).UpdateData("usuario", new List <string> {
"email"
}, new List <string> {
emailTo
}, "id_usuario =" + idUser);
db.conexao.Close();
}
}
public static RegisterModel RegisterFaturamento(RegisterModel model, int userID)
{
using (CallDB db = new CallDB())
{
new UsersQuery(db).UpdateDadosFaturamento(model, userID);
}
var Dados = GetDadosFaturamento(AlgeCookieController.UserID);
return(Dados);
}
public void RegisterProduto(string caminhoImg)
{
using (CallDB db = new CallDB())
{
this.id_produto = new UsersQuery(db).RegisteProduto(this, caminhoImg);
if (this.id_produto == 0)
{
throw new Exception();
}
}
}
public bool Login()
{
string loginPasswordHashed = ToMD5Hash(this.Senha);
using (var db = new CallDB())
{
db.conexao.OpenAsync();
var passwordHash = new LoginQuery(db).GetPasswordHash(this.Email).Result;
return(loginPasswordHashed == passwordHash);
}
}
public static void RegisterUser(RegisterModel model)
{
using (CallDB db = new CallDB())
{
model.Register_PasswordHash = PasswordProcedures.ToMD5Hash(model.Password);
model.ID = new UsersQuery(db).RegisterUser(model);
if (model.ID == 0)
{
throw new Exception();
}
}
}
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 static RegisterModel GetDadosFaturamento(int userID)
{
using (CallDB db = new CallDB())
{
if (FaturamentoExist(userID))
{
var dadosFaturamento = new UsersQuery(db).GetFaturamento(userID);
return(dadosFaturamento);
}
else
{
var dadosFaturamento = new RegisterModel();
return(dadosFaturamento);
}
}
}
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));
}
private void inserirItems(Carrinho model , int quantidade, string pedidoID ,double preco,int idproduto)
{
List<string> columns = new List<string>();
List<string> values = new List<string>();
ListHelper.AddKey(ref columns, ref values, "FK_PRODUTO", idproduto.ToString());
ListHelper.AddKey(ref columns, ref values, "FK_PEDIDO", pedidoID.ToString());
ListHelper.AddKey(ref columns, ref values, "texto_personalizado", model.texto_personalizado);
ListHelper.AddKey(ref columns, ref values, "quantidade", quantidade.ToString());
ListHelper.AddKey(ref columns, ref values, "preco_produto_unidade", preco.ToString().Replace(',','.'));
using (CallDB db = new CallDB())
{
bool insert = db.InsertData("itens_pedido", columns, values);
}
}
public IActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
if (model.Exist())
{
using (var db = new CallDB())
{
db.conexao.Open();
var loginModel = new LoginQuery(db).GetLoginModel(model.Email, model.ToMD5Hash(model.Senha)).Result;
if (loginModel != null)
{
AlgeCookieController.LoggedByAdmin = false;
AlgeCookieController.UserEmail = model.Email;
AlgeCookieController.UserStatus = "logado";
AlgeCookieController.UserID = loginModel.ID;
return RedirectToAction("Index", "Home");
}
else
{
ViewBag.ErrorMessage = "Senha incorreta";
}
}
}
else
{
ViewBag.ErrorMessage = "Usuário não encontrado";
}
return View(model);
}
else
{
return RedirectToAction("Index");
}
}
public IActionResult Detalhe(Carrinho model, int Id, int quantidade)
{
Produto produto = new Produto();
produto.texto_personalizado = model.texto_personalizado;
produto.id_produto = Id;
var itens = new UsersQuery().ReturnProdutos(Id);
List<string> columns = new List<string>();
List<string> values = new List<string>();
ListHelper.AddKey(ref columns, ref values, "fk_usuario", AlgeCookieController.UserID.ToString());
ListHelper.AddKey(ref columns, ref values, "fk_status", "5");//5 carrinho
bool retorno = new DMLQuery(new CallDB()).ExistData("pedido", columns, values);
if (retorno == false)
{
int user = AlgeCookieController.UserID;
using (CallDB db = new CallDB())
{
int pedidoID = new UsersQuery(db).RegisterCart(user);
inserirItems(model,quantidade, pedidoID.ToString(), itens.preco, itens.id_produto);
}
return RedirectToAction("Produto", "Home", new { idCarrinho = "" });
}
else
{
Order order = new Order().GetCardUser(AlgeCookieController.UserID);
inserirItems(model,quantidade, order.id_pedido.ToString(), itens.preco, itens.id_produto);
return RedirectToAction("Produto", "Home", new { idCarrinho = "" });
}
}
private void inserirItems(string pedidoID)
{
Cart cart = CartCookieController.ReturnCart();
for (int i = 0; i < cart.Product.Count; i++)
{
List <string> columns = new List <string>();
List <string> values = new List <string>();
ListHelper.AddKey(ref columns, ref values, "FK_PRODUTO", cart.Product[i].ProductID.ToString());
ListHelper.AddKey(ref columns, ref values, "FK_PEDIDO", pedidoID);
ListHelper.AddKey(ref columns, ref values, "texto_personalizado", cart.Product[i].produtoCartFormat.Texto);
ListHelper.AddKey(ref columns, ref values, "quantidade", cart.Product[i].produtoCartFormat.Quantidade.ToString());
ListHelper.AddKey(ref columns, ref values, "valor_total_itens", cart.Product[i].produtoCartFormat.Price.ToString().Replace(",", "."));
ListHelper.AddKey(ref columns, ref values, "preco_produto_unidade", cart.Product[i].produtoCartFormat.PrecoUnitario.ToString().Replace(",", "."));
CallDB db = new CallDB(DBSource.Alge_db);
bool insert = db.InsertData("itens_pedido", columns, values);
}
}
public string selone(string param)
{
string menucd = JObject.Parse(param)["menucd"].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", "menucd", menucd, "20");
dom.SelectSingleNode("//xmldata").AppendChild(node);
string query = @"PAGE16_SELONE";
dom.SelectSingleNode("//proc").InnerText = query;
DataTable dt = CallDB.getExecuteDataTable(dom);
return(dt.ToJson());
}
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 notice_search(string param)
{
string subject = JObject.Parse(param)["subject"].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", "subject", subject, "100");
dom.SelectSingleNode("//xmldata").AppendChild(node);
string query = @"NOTICE_TEST_SEARCH";
dom.SelectSingleNode("//proc").InnerText = query;
DataTable dt = CallDB.getExecuteDataTable(dom);
return(dt.ToJson());
}
