示例#1
0
        public IHttpActionResult PuttClass(int id, tClass tClass)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != tClass.fClassId)
            {
                return(BadRequest());
            }

            db.Entry(tClass).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!tClassExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
示例#2
0
        public List <tClass> GetClassListForCID(int cType, int CID)
        {
            List <tClass> lp  = new List <tClass>();
            string        sql = "select * from t_class where pid = " + CID + " and cType = " + cType + " and Enable = 0 order by id asc";

            using (DataTable dt = helper.GetDataTable(sql))
            {
                if (dt != null && dt.Rows.Count > 0)
                {
                    foreach (DataRow r in dt.Rows)
                    {
                        tClass b = new tClass
                        {
                            id         = Convert.ToInt16(r["Id"]),
                            pId        = Convert.ToInt16(r["pId"]),
                            cType      = Convert.ToInt16(r["cType"]),
                            name       = r["Name"].ToString(),
                            logoUrl    = r["LogoUrl"].ToString(),
                            isShow     = Convert.ToInt16(r["isShow"]),
                            sType      = Convert.ToInt16(r["sType"]),
                            defaultUrl = r["defaultUrl"].ToString(),
                            addOn      = Convert.ToDateTime(r["AddOn"])
                        };
                        lp.Add(b);
                    }
                }
            }
            return(lp);
        }
示例#3
0
        public Dictionary <int, tClass> getClassDicFObj()
        {
            Dictionary <int, tClass> Dic = new Dictionary <int, tClass>();
            string sql = "select * from t_class";

            using (DataTable dt = helper.GetDataTable(sql))
            {
                if (dt != null && dt.Rows.Count > 0)
                {
                    foreach (DataRow r in dt.Rows)
                    {
                        tClass t = new tClass
                        {
                            id         = Convert.ToInt16(r["Id"]),
                            pId        = Convert.ToInt16(r["pId"]),
                            cType      = Convert.ToInt16(r["cType"]),
                            name       = r["Name"].ToString(),
                            logoUrl    = r["LogoUrl"].ToString(),
                            isShow     = Convert.ToInt16(r["isShow"]),
                            sType      = Convert.ToInt16(r["sType"]),
                            defaultUrl = r["defaultUrl"].ToString(),
                            addOn      = Convert.ToDateTime(r["AddOn"])
                        };
                        Dic.Add(Convert.ToInt16(r["Id"]), t);
                    }
                }
            }
            return(Dic);
        }
示例#4
0
        public tClass GetClassInfo(int id)
        {
            tClass t   = null;
            string sql = "select * from t_class where id = " + id;

            using (DataTable dt = helper.GetDataTable(sql))
            {
                if (dt != null && dt.Rows.Count > 0)
                {
                    DataRow r = dt.Rows[0];
                    {
                        t = new tClass
                        {
                            id         = Convert.ToInt16(r["Id"]),
                            pId        = Convert.ToInt16(r["pId"]),
                            cType      = Convert.ToInt16(r["cType"]),
                            name       = r["Name"].ToString(),
                            logoUrl    = r["LogoUrl"].ToString(),
                            isShow     = Convert.ToInt16(r["isShow"]),
                            sType      = Convert.ToInt16(r["sType"]),
                            defaultUrl = r["defaultUrl"].ToString(),
                            addOn      = Convert.ToDateTime(r["AddOn"])
                        };
                    }
                }
            }
            return(t);
        }
示例#5
0
        public IHttpActionResult GettClass(int id)
        {
            tClass tClass = db.tClasses.Find(id);

            if (tClass == null)
            {
                return(NotFound());
            }

            return(Ok(tClass));
        }
示例#6
0
        public IHttpActionResult PosttClass(tClass tClass)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.tClasses.Add(tClass);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = tClass.fClassId }, tClass));
        }
示例#7
0
        public IHttpActionResult DeletetClass(int id)
        {
            tClass tClass = db.tClasses.Find(id);

            if (tClass == null)
            {
                return(NotFound());
            }

            db.tClasses.Remove(tClass);
            db.SaveChanges();

            return(Ok(tClass));
        }
示例#8
0
        private void SetOnlyList()
        {
            m_OnlyList.Clear();

            foreach (DataGridViewRow row in dgv_only.Rows)
            {
                tClass tc = new tClass();
                tc.bCheck = Convert.ToBoolean(row.Cells["col_only_check"].Value);
                tc.nKey   = GetKey(row.Cells["col_only_key"].Value.ToString());
                tc.nSec   = Convert.ToInt32(row.Cells["col_only_sec"].Value.ToString());
                tc.nIng   = tc.nSec;

                m_OnlyList.Add(tc);
            }
        }
示例#9
0
 public long SaveClass(tClass tClass)
 {
     mmEntities.tClasses.Add(tClass);
     mmEntities.SaveChanges();
     return tClass.ClassId;
 }
示例#10
0
 public static void SaveClass(tClass tClass, tStaffClass tStaffClass)
 {
     tStaffClass.ClassId = Wrapper.SaveClass(tClass);
     Wrapper.SaveStaffClass(tStaffClass);
 }