Пример #1
0
        public string genNextCode(EDUCATIONLEVEL_OBJ obj)
        {
            //Phải viết lại theo mô hình nào đó
            Random rnd = new Random();
            int    i   = rnd.Next(int.MaxValue);

            return((i % 10000000000).ToString());
        }
Пример #2
0
        public int Update(EDUCATIONLEVEL_OBJ obj)
        {
            int        ret = 0;
            DBBase     db  = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString());
            string     sql = @"UPDATE EDUCATIONLEVEL SET 
                    code=@code
                    ,codeview=@codeview
                    , name=@name
                    , note=@note
                    , edituser=@edituser
                    ,edittime=@edittime
                    ,lock=@lock
                    , lockdate=@lockdate
                    , theorder=@theorder
                    , comparelevel=@comparelevel
                    , whois=@whois
                    WHERE code=@code_key
                ";
            SqlCommand com = new SqlCommand();

            com.CommandText = sql;
            com.CommandType = CommandType.Text;
            com.Parameters.Add("@code", SqlDbType.VarChar).Value      = obj.CODE;
            com.Parameters.Add("@codeview", SqlDbType.VarChar).Value  = obj.CODEVIEW;
            com.Parameters.Add("@name", SqlDbType.NVarChar).Value     = obj.NAME;
            com.Parameters.Add("@note", SqlDbType.NVarChar).Value     = obj.NOTE;
            com.Parameters.Add("@edituser", SqlDbType.VarChar).Value  = obj.EDITUSER;
            com.Parameters.Add("@edittime", SqlDbType.DateTime).Value = obj.EDITTIME;
            com.Parameters.Add("@lock", SqlDbType.Int).Value          = obj.LOCK;
            com.Parameters.Add("@lockdate", SqlDbType.DateTime).Value = obj.LOCKDATE;
            com.Parameters.Add("@code_key", SqlDbType.VarChar).Value  = obj._ID.CODE;
            com.Parameters.Add("@theorder", SqlDbType.Int).Value      = obj.THEORDER;
            com.Parameters.Add("@comparelevel", SqlDbType.Int).Value  = obj.COMPARELEVEL;
            com.Parameters.Add("@whois", SqlDbType.VarChar).Value     = obj.COMPARELEVEL;
            ret = db.doCommand(ref com);
            return(ret);
        }
Пример #3
0
        public int Insert(EDUCATIONLEVEL_OBJ obj)
        {
            int        ret = 0;
            DBBase     db  = new DBBase(ConfigurationSettings.AppSettings["connectionString"].ToString());
            string     sql = "INSERT INTO EDUCATIONLEVEL(code,codeview, name, note, edituser,edittime,lock, lockdate, theorder, thetype, comparelevel, whois) VALUES(@code,@codeview, @name, @note, @edituser,@edittime,@lock, @lockdate, @theorder, @thetype, @comparelevel, @whois)";
            SqlCommand com = new SqlCommand();

            com.CommandText = sql;
            com.CommandType = CommandType.Text;
            com.Parameters.Add("@code", SqlDbType.VarChar).Value      = obj.CODE;
            com.Parameters.Add("@codeview", SqlDbType.VarChar).Value  = obj.CODEVIEW;
            com.Parameters.Add("@name", SqlDbType.NVarChar).Value     = obj.NAME;
            com.Parameters.Add("@note", SqlDbType.NVarChar).Value     = obj.NOTE;
            com.Parameters.Add("@edituser", SqlDbType.VarChar).Value  = obj.EDITUSER;
            com.Parameters.Add("@edittime", SqlDbType.DateTime).Value = obj.EDITTIME;
            com.Parameters.Add("@lock", SqlDbType.Int).Value          = obj.LOCK;
            com.Parameters.Add("@lockdate", SqlDbType.DateTime).Value = obj.LOCKDATE;
            com.Parameters.Add("@theorder", SqlDbType.Int).Value      = obj.THEORDER;
            com.Parameters.Add("@thetype", SqlDbType.VarChar).Value   = obj.THETYPE;
            com.Parameters.Add("@comparelevel", SqlDbType.Int).Value  = obj.COMPARELEVEL;
            com.Parameters.Add("@whois", SqlDbType.VarChar).Value     = obj.WHOIS;
            ret = db.doCommand(ref com);
            return(ret);
        }
Пример #4
0
        public List <EDUCATIONLEVEL_OBJ> getAll(params spParam[] listFilter)
        {
            List <EDUCATIONLEVEL_OBJ> lidata = new List <uni.EDUCATIONLEVEL_OBJ>();
            string     sql    = "SELECT * FROM educationlevel";
            string     swhere = "";
            SqlCommand cm     = new SqlCommand();

            foreach (var item in listFilter)
            {
                if (swhere != "")
                {
                    swhere += " AND ";
                }
                if (item.data == null)
                {
                    //cm.Parameters.Add("@" + f.Name, st);
                    //cm.Parameters["@" + f.Name].Value = DBNull.Value;
                    swhere += "[" + item.name + "]" + " is null";
                }
                else
                {
                    if (item.searchtype == 0)
                    {
                        swhere += "[" + item.name + "]= @" + item.name;
                        cm.Parameters.Add(new SqlParameter("@" + item.name, item.data));
                    }
                    else
                    {
                        swhere += "[" + item.name + "] LIKE @" + item.name;
                        cm.Parameters.Add(new SqlParameter("@" + item.name, "%" + item.data + "%"));
                    }
                }
            }
            if (swhere != "")
            {
                sql += " WHERE " + swhere;
            }
            cm.CommandText = sql;
            cm.CommandType = CommandType.Text;
            DataSet ds  = new DataSet();
            int     ret = db.getCommand(ref ds, "Tmp", cm);

            if (ret < 0)
            {
                return(null);
            }
            else
            {
                foreach (DataRow dr in ds.Tables["Tmp"].Rows)
                {
                    EDUCATIONLEVEL_OBJ obj = new EDUCATIONLEVEL_OBJ();

                    Type myTableObject = typeof(EDUCATIONLEVEL_OBJ);
                    System.Reflection.PropertyInfo[] selectFieldInfo = myTableObject.GetProperties();

                    Type myObjectType = typeof(EDUCATIONLEVEL_OBJ.BusinessObjectID);
                    System.Reflection.PropertyInfo[] fieldInfo = myObjectType.GetProperties();

                    //set object value
                    foreach (System.Reflection.PropertyInfo info in selectFieldInfo)
                    {
                        if (info.Name != "_ID")
                        {
                            if (dr.Table.Columns.Contains(info.Name))
                            {
                                if (!dr.IsNull(info.Name))
                                {
                                    info.SetValue(obj, dr[info.Name], null);
                                }
                            }
                        }
                        else
                        {
                            //set id value
                            EDUCATIONLEVEL_OBJ.BusinessObjectID objid;
                            objid = (EDUCATIONLEVEL_OBJ.BusinessObjectID)info.GetValue(obj, null);
                            foreach (System.Reflection.PropertyInfo info1 in fieldInfo)
                            {
                                if (dr.Table.Columns.Contains(info1.Name))
                                {
                                    info1.SetValue(objid, dr[info1.Name], null);
                                }
                            }
                            info.SetValue(obj, objid, null);
                        }
                    }
                    lidata.Add(obj);
                }
            }
            return(lidata);
        }
Пример #5
0
        public EDUCATIONLEVEL_OBJ createObject()
        {
            EDUCATIONLEVEL_OBJ obj = new EDUCATIONLEVEL_OBJ();

            return(obj);
        }