コード例 #1
0
ファイル: UserSkinDA.cs プロジェクト: dandyyang/VPMS
        public Model.IModel.IModelObject SaveUserSkin(Model.IModel.IModelObject Entity)
        {
            UserSkin_urs_Info info = new UserSkin_urs_Info();

            try
            {
                using (VPMSDBDataContext db = new VPMSDBDataContext())
                {
                    info = Entity as UserSkin_urs_Info;
                    UserSkin_ur query = db.UserSkin_urs.SingleOrDefault(t => t.urs_cUserID == info.urs_cUserID);
                    if (query != null)
                    {
                        query.urs_cSkinName = info.urs_cSkinName;
                    }
                    else
                    {
                        UserSkin_ur newTab = new UserSkin_ur();
                        newTab.urs_cUserID   = info.urs_cUserID;
                        newTab.urs_cSkinName = info.urs_cSkinName;
                        db.UserSkin_urs.InsertOnSubmit(newTab);
                    }
                    db.SubmitChanges();
                }
            }
            catch (Exception Ex)
            {
                throw Ex;
            }
            return(info);
        }
コード例 #2
0
ファイル: UserSkinDA.cs プロジェクト: dandyyang/VPMS
        public Model.IModel.IModelObject GetUserSkin(Model.IModel.IModelObject Entity)
        {
            UserSkin_urs_Info info = new UserSkin_urs_Info();

            try
            {
                using (VPMSDBDataContext db = new VPMSDBDataContext())
                {
                    info = Entity as UserSkin_urs_Info;
                    info.urs_cSkinName = "Default";
                    UserSkin_ur query = db.UserSkin_urs.SingleOrDefault(t => t.urs_cUserID == info.urs_cUserID);
                    if (query != null)
                    {
                        info.urs_cSkinName = query.urs_cSkinName;
                    }
                }
            }
            catch (Exception Ex)
            {
                throw Ex;
            }
            return(info);
        }