コード例 #1
0
        public static string GetRow(string RowId)
        {
            if (HttpContext.Current.Session["UserName"] == null)
            {
                return("Error: You are not logged-in.");
            }

            DBClass db = new DBClass("SCM");

            db.Con.Open();
            db.Com.CommandText = "SELECT [id] ,[description] FROM [costsetupItemMainhead] WHERE [id] = '" + RowId + "'";
            SqlDataReader        dr            = db.Com.ExecuteReader();
            JavaScriptSerializer serailizer    = new JavaScriptSerializer();
            SetupLocationEntry   SetupLocation = new SetupLocationEntry();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    SetupLocation.BankCode        = dr[0].ToString();
                    SetupLocation.BankDescription = dr[1].ToString();
                }
            }

            if (dr.IsClosed == false)
            {
                dr.Close();
            }

            db.Con.Close();
            db = null;
            return(serailizer.Serialize(SetupLocation));
        }
コード例 #2
0
        public static string GetRow(string RowId)
        {
            if (HttpContext.Current.Session["UserName"] == null)
            {
                return "Error: You are not logged-in.";
            }

            DBClass db = new DBClass("SCM");
            db.Con.Open();
            db.Com.CommandText = "SELECT [id] ,[description] FROM [costsetupItemMainhead] WHERE [id] = '" + RowId + "'";
            SqlDataReader dr = db.Com.ExecuteReader();
            JavaScriptSerializer serailizer = new JavaScriptSerializer();
            SetupLocationEntry SetupLocation = new SetupLocationEntry();
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    SetupLocation.BankCode = dr[0].ToString();
                    SetupLocation.BankDescription = dr[1].ToString();
                }
            }

            if (dr.IsClosed == false)
                dr.Close();

            db.Con.Close();
            db = null;
            return serailizer.Serialize(SetupLocation);
        }