Ejemplo n.º 1
0
        public Entity.Knows[] Select_Knows(int p_Knows_ClassID, int p_Knows_LanguageID, string p_Search_Content, int p_Search_Method, int p_PageSize, int p_PageIndex)
        {
            p_Search_Content = FilterUtility.FilterSQL(p_Search_Content);

            DataTable o_DataTable = d_Knows.Select_Knows(p_Knows_ClassID, p_Knows_LanguageID, p_Search_Content, p_Search_Method, p_PageSize, p_PageIndex, ref g_TotalCount, ref g_TotalPage);
            if (o_DataTable == null)
                return null;
            else
            {
                Entity.Knows[] e_Knows = new Entity.Knows[o_DataTable.Rows.Count];

                int i = 0;
                foreach (DataRow o_DataRow in o_DataTable.Rows)
                {
                    e_Knows[i] = new Entity.Knows();

                    e_Knows[i].Knows_ID = Convert.ToInt32(o_DataRow["Knows_ID"].ToString());
                    e_Knows[i].Knows_ClassID = Convert.ToInt32(o_DataRow["Knows_ClassID"].ToString());
                    e_Knows[i].Knows_LanguageID = Convert.ToInt32(o_DataRow["Knows_LanguageID"].ToString());
                    e_Knows[i].Knows_Summary = o_DataRow["Knows_Summary"].ToString();
                    e_Knows[i].Knows_Title = o_DataRow["Knows_Title"].ToString();
                    e_Knows[i].Knows_Content = o_DataRow["Knows_Content"].ToString();
                    e_Knows[i].Knows_AddTime = DateTime.Parse(o_DataRow["Knows_AddTime"].ToString());

                    i++;
                }

                return e_Knows;
            }
        }
Ejemplo n.º 2
0
        public void Insert_Knows(int p_Knows_ClassID, int p_Knows_LanguageID, string p_Knows_Summary, string p_Knows_Title, string p_Knows_Content)
        {
            p_Knows_Summary = FilterUtility.FilterSQL(p_Knows_Summary);
            p_Knows_Title = FilterUtility.FilterSQL(p_Knows_Title);
            p_Knows_Content = FilterUtility.FilterSQL(p_Knows_Content);

            Entity.Knows o_Knows = new Entity.Knows();
            o_Knows.Knows_ClassID = p_Knows_ClassID;
            o_Knows.Knows_LanguageID = p_Knows_LanguageID;
            o_Knows.Knows_Summary = p_Knows_Summary;
            o_Knows.Knows_Title = p_Knows_Title;
            o_Knows.Knows_Content = p_Knows_Content;
            o_Knows.Knows_AddTime = DateTime.Now;

            d_Knows.Insert_Knows(o_Knows);
        }
Ejemplo n.º 3
0
        public Entity.Knows Select_Knows(int p_Knows_ID)
        {
            DataTable o_DataTable = d_Knows.Select_Knows(p_Knows_ID);
            if (o_DataTable == null)
                return null;
            else
            {
                Entity.Knows e_Knows = new Entity.Knows();
                DataRow o_DataRow = o_DataTable.Rows[0];

                e_Knows.Knows_ID = Convert.ToInt32(o_DataRow["Knows_ID"].ToString());
                e_Knows.Knows_ClassID = Convert.ToInt32(o_DataRow["Knows_ClassID"].ToString());
                e_Knows.Knows_LanguageID = Convert.ToInt32(o_DataRow["Knows_LanguageID"].ToString());
                e_Knows.Knows_Summary = o_DataRow["Knows_Summary"].ToString();
                e_Knows.Knows_Title = o_DataRow["Knows_Title"].ToString();
                e_Knows.Knows_Content = o_DataRow["Knows_Content"].ToString();
                e_Knows.Knows_AddTime = DateTime.Parse(o_DataRow["Knows_AddTime"].ToString());

                return e_Knows;
            }
        }