Beispiel #1
0
        public ArrayList getAllKeyword1CuPhap(String Cum_tu_1)
        {
            ArrayList listCuPhap = new ArrayList();

            //String sql = ConfigurationManager.AppSettings["sql.getAllKeyword1CuPhap"];
            //SqlCommand objCommand = new SqlCommand(sql);
            //objCommand.Parameters.AddWithValue("@ten", ten);

            //DataTable result = DataUtil.executeQuery(objCommand);
            SqlParameter[] parameter = new SqlParameter[1];
            int            i         = 0;

            parameter[i]         = new SqlParameter("Cum_tu_1", SqlDbType.NVarChar);
            parameter[i++].Value = Cum_tu_1;

            DataTable result = DataUtil.executeStore("sp_getAllKeyword1CuPhap", parameter);

            if (result == null)
            {
                return(listCuPhap);
            }
            else
            {
                foreach (DataRow row in result.Rows)
                {
                    CuPhapMODEL cuPhapModel = new CuPhapMODEL();

                    cuPhapModel.Cum_Tu_2 = row["Cum_tu_2"].ToString();

                    listCuPhap.Add(cuPhapModel);
                }
                return(listCuPhap);
            }
        }
Beispiel #2
0
        public CuPhapMODEL getCuPhapByID(int id)
        {
            //String sql = ConfigurationManager.AppSettings["sql.getCuPhapByID"];
            //SqlCommand objCommand = new SqlCommand(sql);
            //CuPhapMODEL cuPhapModel = new CuPhapMODEL();
            //objCommand.Parameters.AddWithValue("@id",id);
            //DataTable result = DataUtil.executeQuery(objCommand);

            try
            {
                CuPhapMODEL    cuPhapModel = new CuPhapMODEL();
                SqlParameter[] parameter   = new SqlParameter[1];
                int            i           = 0;

                parameter[i]         = new SqlParameter("ID", SqlDbType.NVarChar);
                parameter[i++].Value = id;

                DataTable result = DataUtil.executeStore("sp_getCuPhapByID", parameter);

                foreach (DataRow row in result.Rows)
                {
                    cuPhapModel.Id        = row["ID"].ToString();
                    cuPhapModel.Ten       = row["Ten"].ToString();
                    cuPhapModel.Cum_Tu_1  = row["Cum_tu_1"].ToString();
                    cuPhapModel.Cum_Tu_2  = row["Cum_tu_2"].ToString();
                    cuPhapModel.Cum_Tu_3  = row["Cum_tu_3"].ToString();
                    cuPhapModel.Cum_Tu_4  = row["Cum_tu_4"].ToString();
                    cuPhapModel.Cum_Tu_5  = row["Cum_tu_5"].ToString();
                    cuPhapModel.Cum_Tu_6  = row["Cum_tu_6"].ToString();
                    cuPhapModel.Cum_Tu_7  = row["Cum_tu_7"].ToString();
                    cuPhapModel.Cum_Tu_8  = row["Cum_tu_8"].ToString();
                    cuPhapModel.Cum_Tu_9  = row["Cum_tu_9"].ToString();
                    cuPhapModel.Cum_Tu_10 = row["Cum_tu_10"].ToString();
                    cuPhapModel.Ghi_Chu   = row["Ghi_chu"].ToString();
                    ////cuPhapModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString();
                    //cuPhapModel.User11 = row["User1"].ToString();
                    //cuPhapModel.User21 = row["User2"].ToString();
                    //cuPhapModel.User31 = row["User3"].ToString();
                    //cuPhapModel.User41 = row["User4"].ToString();
                    //cuPhapModel.User51 = row["User5"].ToString();
                }

                return(cuPhapModel);
            }
            catch (Exception)
            {
                throw;
            }
        }
Beispiel #3
0
        //public  ArrayList getAllCuPhap()
        //{
        //    ArrayList listCuPhap = new ArrayList();
        //    String sql = ConfigurationManager.AppSettings["sql.getAllCuPhap"];
        //    SqlCommand objCommand = new SqlCommand(sql);

        //    DataTable result = DataUtil.executeQuery(objCommand);

        //    foreach (DataRow row in result.Rows)
        //    {
        //        CuPhapMODEL cuPhapModel = new CuPhapMODEL();

        //        cuPhapModel.Id = row["ID"].ToString();
        //        cuPhapModel.Ten = row["Ten"].ToString();
        //        cuPhapModel.Cum_Tu_1 = row["Cum_tu_1"].ToString();
        //        cuPhapModel.Cum_Tu_2 = row["Cum_tu_2"].ToString();
        //        cuPhapModel.Cum_Tu_3 = row["Cum_tu_3"].ToString();
        //        cuPhapModel.Cum_Tu_4 = row["Cum_tu_4"].ToString();
        //        cuPhapModel.Cum_Tu_5 = row["Cum_tu_5"].ToString();
        //        cuPhapModel.Cum_Tu_6 = row["Cum_tu_6"].ToString();
        //        cuPhapModel.Cum_Tu_7 = row["Cum_tu_7"].ToString();
        //        cuPhapModel.Cum_Tu_8 = row["Cum_tu_8"].ToString();
        //        cuPhapModel.Cum_Tu_9 = row["Cum_tu_9"].ToString();
        //        cuPhapModel.Cum_Tu_10 = row["Cum_tu_10"].ToString();
        //        cuPhapModel.Ghi_Chu = row["Ghi_chu"].ToString();
        //        cuPhapModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString();
        //        cuPhapModel.User11 = row["User1"].ToString();
        //        cuPhapModel.User21 = row["User2"].ToString();
        //        cuPhapModel.User31 = row["User3"].ToString();
        //        cuPhapModel.User41 = row["User4"].ToString();
        //        cuPhapModel.User51 = row["User5"].ToString();

        //        listCuPhap.Add(cuPhapModel);
        //    }
        //    return listCuPhap;
        //}

        //public static DataTable getAllCuPhapINTODataTable()
        //{

        //    String sql = ConfigurationManager.AppSettings["sql.getAllCuPhap"];
        //    SqlCommand objCommand = new SqlCommand(sql);

        //    return DataUtil.executeQuery(objCommand);
        //}

        public ArrayList getAllKeywordCuPhap()
        {
            ArrayList listCuPhap = new ArrayList();
            //String sql = ConfigurationManager.AppSettings["sql.getAllTenCuPhap"];
            //SqlCommand objCommand = new SqlCommand(sql);

            //DataTable result = DataUtil.executeQuery(objCommand);
            DataTable result = DataUtil.executeStore("sp_getAllTenCuPhap", null);

            foreach (DataRow row in result.Rows)
            {
                CuPhapMODEL cuPhapModel = new CuPhapMODEL();

                cuPhapModel.Cum_Tu_1 = row["Cum_Tu_1"].ToString();

                listCuPhap.Add(cuPhapModel);
            }
            return(listCuPhap);
        }
Beispiel #4
0
        public static CuPhapMODEL getCuPhapByCumCuPhap(string cumCuPhap)
        {
            try
            {
                SqlParameter[] parameter = new SqlParameter[1];

                parameter[0]       = new SqlParameter("@cumCuPhap", SqlDbType.VarChar);
                parameter[0].Value = cumCuPhap;

                CuPhapMODEL cuPhapModel = new CuPhapMODEL();

                DataTable result = DataUtil.executeStore("sp_ISO_SMS_getCumCuPhap", parameter);

                foreach (DataRow row in result.Rows)
                {
                    cuPhapModel.Id                 = row["ID"].ToString();
                    cuPhapModel.Ten                = row["Ten"].ToString();
                    cuPhapModel.Cum_Tu_1           = row["Cum_tu_1"].ToString();
                    cuPhapModel.Cum_Tu_2           = row["Cum_tu_2"].ToString();
                    cuPhapModel.Cum_Tu_3           = row["Cum_tu_3"].ToString();
                    cuPhapModel.Cum_Tu_4           = row["Cum_tu_4"].ToString();
                    cuPhapModel.Cum_Tu_5           = row["Cum_tu_5"].ToString();
                    cuPhapModel.Cum_Tu_6           = row["Cum_tu_6"].ToString();
                    cuPhapModel.Cum_Tu_7           = row["Cum_tu_7"].ToString();
                    cuPhapModel.Cum_Tu_8           = row["Cum_tu_8"].ToString();
                    cuPhapModel.Cum_Tu_9           = row["Cum_tu_9"].ToString();
                    cuPhapModel.Cum_Tu_10          = row["Cum_tu_10"].ToString();
                    cuPhapModel.Ghi_Chu            = row["Ghi_chu"].ToString();
                    cuPhapModel.Ngay_Cap_Nhat_Cuoi = row["Ngay_cap_nhat_cuoi"].ToString();
                    cuPhapModel.User11             = row["User1"].ToString();
                    cuPhapModel.User21             = row["User2"].ToString();
                    cuPhapModel.User31             = row["User3"].ToString();
                    cuPhapModel.User41             = row["User4"].ToString();
                    cuPhapModel.User51             = row["User5"].ToString();
                }
                return(cuPhapModel);
            }
            catch (Exception)
            {
                throw;
            }
        }
Beispiel #5
0
        public Boolean updateCuPhap(CuPhapMODEL cuPhapModel)
        {
            try
            {
                SqlParameter[] parameter = new SqlParameter[19];
                int            i         = 0;

                parameter[i]         = new SqlParameter("ID", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Id;

                parameter[i]         = new SqlParameter("Ten", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Ten;

                parameter[i]         = new SqlParameter("Cum_tu_1", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Cum_Tu_1;

                parameter[i]         = new SqlParameter("Cum_tu_2", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Cum_Tu_2;

                parameter[i]         = new SqlParameter("Cum_tu_3", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Cum_Tu_3;

                parameter[i]         = new SqlParameter("Cum_tu_4", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Cum_Tu_4;

                parameter[i]         = new SqlParameter("Cum_tu_5", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Cum_Tu_5;

                parameter[i]         = new SqlParameter("Cum_tu_6", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Cum_Tu_6;

                parameter[i]         = new SqlParameter("Cum_tu_7", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Cum_Tu_7;

                parameter[i]         = new SqlParameter("Cum_tu_8", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Cum_Tu_8;

                parameter[i]         = new SqlParameter("Cum_tu_9", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Cum_Tu_9;

                parameter[i]         = new SqlParameter("Cum_tu_10", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Cum_Tu_10;

                parameter[i]         = new SqlParameter("Ghi_chu", SqlDbType.NVarChar);
                parameter[i++].Value = cuPhapModel.Ghi_Chu;

                parameter[i]         = new SqlParameter("Ngay_cap_nhat_cuoi", SqlDbType.NVarChar);
                parameter[i++].Value = "";

                parameter[i]         = new SqlParameter("User1", SqlDbType.NVarChar);
                parameter[i++].Value = "";

                parameter[i]         = new SqlParameter("User2", SqlDbType.NVarChar);
                parameter[i++].Value = "";

                parameter[i]         = new SqlParameter("User3", SqlDbType.NVarChar);
                parameter[i++].Value = "";

                parameter[i]         = new SqlParameter("User4", SqlDbType.NVarChar);
                parameter[i++].Value = "";

                parameter[i]         = new SqlParameter("User5", SqlDbType.NVarChar);
                parameter[i++].Value = "";

                Boolean kq = DataUtil.executeNonStore("sp_SMS_UpdateCuPhapByID", parameter);
                return(kq);
            }
            catch (Exception)
            {
                throw;
            }
        }