Example #1
0
        public static result getXmlTransMulti(XmlDocument dom)
        {
            //지역변수
            //string[] Result = new string[3];
            result result    = new result();
            string ItemName  = string.Empty;
            string ItemValue = string.Empty;
            string TBLKEY    = "";

            int ItemSize = 0;

            try
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    XmlNodeList nodeSet = dom.SelectNodes("//xmltable");
                    for (int nLoop = 0; nLoop < dom.SelectNodes("//xmltable").Count; nLoop++)
                    {
                        string pPackageName = nodeSet[nLoop].SelectSingleNode("proc").InnerText;                         //패키지명
                        int    ParamCnt     = nodeSet[nLoop].SelectSingleNode("xmldata").ChildNodes[0].ChildNodes.Count; //파라미터 카운트
                        int    RowCnt       = nodeSet[nLoop].SelectSingleNode("xmldata").ChildNodes.Count;               //행의 카운트

                        SqlParameter[] lac_Params = get_SqlParams(ParamCnt + 3);
                        for (int k = 0; k < RowCnt; k++)
                        {
                            XmlNode node = nodeSet[nLoop].SelectSingleNode("xmldata").ChildNodes[k];
                            for (int i = 0; i < ParamCnt; i++)
                            {
                                ItemName  = node.ChildNodes[i].Name;        //IN 파라메터 명
                                ItemValue = node.ChildNodes[i].InnerText;   //IN 파라메터 값
                                ItemSize  = ItemValue.Length;               //IN 파라메터 길이
                                if (ItemSize == 0)
                                {
                                    ItemSize = 1;
                                }
                                if (node.ChildNodes[i].Attributes["coltype"].Value == "varchar")
                                {
                                    lac_Params[i] = new SqlParameter("@" + ItemName, SqlDbType.VarChar, Int32.Parse(node.ChildNodes[i].Attributes["size"].Value));
                                }
                                else if (node.ChildNodes[i].Attributes["coltype"].Value == "char")
                                {
                                    lac_Params[i] = new SqlParameter("@" + ItemName, SqlDbType.VarChar, Int32.Parse(node.ChildNodes[i].Attributes["size"].Value));
                                }
                                else if (node.ChildNodes[i].Attributes["coltype"].Value == "int")
                                {
                                    lac_Params[i] = new SqlParameter("@" + ItemName, SqlDbType.Int);
                                }
                                else if (node.ChildNodes[i].Attributes["coltype"].Value == "numeric")
                                {
                                    lac_Params[i] = new SqlParameter("@" + ItemName, SqlDbType.Float);
                                }
                                else if (node.ChildNodes[i].Attributes["coltype"].Value == "datetime")
                                {
                                    lac_Params[i] = new SqlParameter("@" + ItemName, SqlDbType.DateTime);
                                }

                                if (node.ChildNodes[i].Attributes["coltype"].Value == "int")
                                {
                                    ItemValue = ItemValue.Replace(",", "");
                                }
                                if (node.ChildNodes[i].Attributes["coltype"].Value == "numeric")
                                {
                                    ItemValue = ItemValue.Replace(",", "");
                                }
                                lac_Params[i].Value = ItemValue;

                                if (ItemValue == "@tblkey@")
                                {
                                    ItemValue = TBLKEY;
                                }
                                //if (ItemSize == 0) ItemSize = 1;

                                //lac_Params[i] = new SqlParameter("@" + ItemName, SqlDbType.VarChar, ItemSize);
                                if (node.ChildNodes[i].Attributes["coltype"].Value == "int" && ItemValue == "")
                                {
                                    lac_Params[i].Value = null;
                                }
                                else if (node.ChildNodes[i].Attributes["coltype"].Value == "numeric" && ItemValue == "")
                                {
                                    lac_Params[i].Value = null;
                                }
                                else
                                {
                                    lac_Params[i].Value = ItemValue;
                                }
                            }
                            lac_Params[ParamCnt]           = new SqlParameter("@vo_code", SqlDbType.VarChar, 2);
                            lac_Params[ParamCnt].Direction = ParameterDirection.Output;

                            lac_Params[ParamCnt + 1]           = new SqlParameter("@vo_msg", SqlDbType.VarChar, 200);
                            lac_Params[ParamCnt + 1].Direction = ParameterDirection.Output;

                            lac_Params[ParamCnt + 2]           = new SqlParameter("@vo_val", SqlDbType.VarChar, 200);
                            lac_Params[ParamCnt + 2].Direction = ParameterDirection.Output;

                            SqlHelper.ExecuteNonQuery(constr(), CommandType.Text, pPackageName, lac_Params);

                            result.code = (string)lac_Params[ParamCnt].Value;
                            result.msg  = (string)lac_Params[ParamCnt + 1].Value;
                            result.val  = (string)lac_Params[ParamCnt + 2].Value;
                            if (nLoop == 0)
                            {
                                TBLKEY = result.val;
                            }

                            if (!result.code.Equals("OK"))
                            {
                                throw new NullReferenceException();
                            }
                        }
                    }
                    scope.Complete();
                    return(result);
                }
            }
            catch (Exception ex)
            {
                result.code = "N";
                result.msg  = ex.Message; // ex.Message;
                result.val  = ex.Message;
            }

            return(result);
        }
Example #2
0
        public static result getXmlTransAll(List <XmlDocument> domList)
        {
            //지역변수
            result result    = new result();
            string ItemName  = string.Empty;
            string ItemValue = string.Empty;
            int    ItemSize  = 0;

            try
            {
                using (TransactionScope scope = new TransactionScope())
                {
                    //-------------------------------------------------------------
                    // start : XMLDOM LOOP
                    //-------------------------------------------------------------
                    for (int x = 0; x < domList.Count; x++)
                    {
                        XmlDocument dom          = domList[x];
                        string      pPackageName = dom.SelectSingleNode("//xml/proc").InnerText;                     //패키지명
                        int         ParamCnt     = dom.SelectSingleNode("//xmldata").ChildNodes[0].ChildNodes.Count; //파라미터 카운트
                        int         RowCnt       = dom.SelectNodes("//xmldata/zrow").Count;                          //행의 카운트

                        SqlParameter[] lac_Params = get_SqlParams(ParamCnt + 3);
                        for (int k = 0; k < RowCnt; k++)
                        {
                            XmlNode node = dom.SelectSingleNode("//xml/xmldata").ChildNodes[k];

                            for (int i = 0; i < ParamCnt; i++)
                            {
                                ItemName  = node.ChildNodes[i].Name;                    //IN 파라메터 명
                                ItemValue = node.ChildNodes[i].InnerText;               //IN 파라메터 값
                                ItemSize  = ItemValue.Length;                           //IN 파라메터 길이
                                if (ItemSize == 0)
                                {
                                    ItemSize = 1;
                                }

                                if (node.ChildNodes[i].Attributes["coltype"].Value == "varchar")
                                {
                                    lac_Params[i] = new SqlParameter(ItemName, SqlDbType.VarChar, Int32.Parse(node.ChildNodes[i].Attributes["size"].Value));
                                }
                                else if (node.ChildNodes[i].Attributes["coltype"].Value == "nvarchar")
                                {
                                    lac_Params[i] = new SqlParameter(ItemName, SqlDbType.NVarChar, Int32.Parse(node.ChildNodes[i].Attributes["size"].Value));
                                }
                                else if (node.ChildNodes[i].Attributes["coltype"].Value == "char")
                                {
                                    lac_Params[i] = new SqlParameter(ItemName, SqlDbType.VarChar, Int32.Parse(node.ChildNodes[i].Attributes["size"].Value));
                                }
                                else if (node.ChildNodes[i].Attributes["coltype"].Value == "int")
                                {
                                    lac_Params[i] = new SqlParameter(ItemName, SqlDbType.Int);
                                }
                                else if (node.ChildNodes[i].Attributes["coltype"].Value == "numeric")
                                {
                                    lac_Params[i] = new SqlParameter(ItemName, SqlDbType.Float);
                                }
                                else if (node.ChildNodes[i].Attributes["coltype"].Value == "datetime")
                                {
                                    lac_Params[i] = new SqlParameter(ItemName, SqlDbType.DateTime);
                                }

                                if (node.ChildNodes[i].Attributes["output"].Value == "output")
                                {
                                    lac_Params[i].Direction = ParameterDirection.Output;
                                }

                                if (node.ChildNodes[i].Attributes["coltype"].Value == "int")
                                {
                                    ItemValue = ItemValue.Replace(",", "");
                                }
                                if (node.ChildNodes[i].Attributes["coltype"].Value == "numeric")
                                {
                                    ItemValue = ItemValue.Replace(",", "");
                                }

                                if (node.ChildNodes[i].Attributes["coltype"].Value == "int" && ItemValue == "")
                                {
                                    lac_Params[i].Value = 0;
                                }
                                else if (node.ChildNodes[i].Attributes["coltype"].Value == "numeric" && ItemValue == "")
                                {
                                    lac_Params[i].Value = 0;
                                }
                                else
                                {
                                    lac_Params[i].Value = ItemValue;
                                }
                            }
                            lac_Params[ParamCnt]           = new SqlParameter("@vo_code", SqlDbType.VarChar, 2);
                            lac_Params[ParamCnt].Direction = ParameterDirection.Output;

                            lac_Params[ParamCnt + 1]           = new SqlParameter("@vo_msg", SqlDbType.VarChar, 200);
                            lac_Params[ParamCnt + 1].Direction = ParameterDirection.Output;

                            lac_Params[ParamCnt + 2]           = new SqlParameter("@vo_val", SqlDbType.VarChar, 200);
                            lac_Params[ParamCnt + 2].Direction = ParameterDirection.Output;

                            if (dom.SelectNodes("//act").Count == 1 && dom.SelectSingleNode("//act").InnerText.ToLower() == "proc")
                            {
                                SqlHelper.ExecuteScalar(constr(), CommandType.StoredProcedure, pPackageName, lac_Params); //프로시저
                            }
                            else
                            {
                                SqlHelper.ExecuteScalar(constr(), CommandType.Text, pPackageName, lac_Params); //프로시저
                            }
                            result.code = (string)lac_Params[ParamCnt].Value;
                            result.msg  = (string)lac_Params[ParamCnt + 1].Value;
                            result.val  = (string)lac_Params[ParamCnt + 2].Value;
                            if (!result.code.Equals("OK"))
                            {
                                throw new NullReferenceException();
                            }
                        }
                    }
                    scope.Complete();
                    //-------------------------------------------------------------
                    // end : XMLDOM LOOP
                    //-------------------------------------------------------------
                    return(result);
                }
            }
            catch (Exception ex)
            {
                result.code = "N";
                result.msg  = ex.Message; // ex.Message;
                result.val  = ex.Message;
            }

            return(result);
        }