Exemple #1
0
        public static object updateStudentSubjectScore(T_StudentSubjectScore sss)
        {
            // var obj = db.Updateable<T_StudentSubjectScore>(sss).ExecuteCommand();
            // var obj = db.Updateable<T_StudentSubjectScore>().UpdateColumns(it => new { score = sss.score}).Where(it => it.studentticketid == sss.studentticketid).ExecuteCommand();
            string sql = string.Format("UPDATE dbo.T_StudentSubjectScore SET score = '{0}' WHERE studentticketid = '{1}' AND sortid = '{2}'", sss.score, sss.studentticketid, sss.sortid);

            Untity.HelperMsSQL.ExecuteQuery(sql);
            return(1);
        }
Exemple #2
0
        public static object addStudentSubjectScore(T_StudentSubjectScore sss)
        {
            var obj = db.Insertable <T_StudentSubjectScore>(sss).ExecuteCommand();

            return(obj);
        }