コード例 #1
0
        public int GetInsert(M_ExAttendance exAttendance)
        {
            string sqlStr = "INSERT INTO [dbo].[ZL_ExAttendance] ([Stuid],[LogTime],[Logtimeout],[Location],[StuName]) VALUES (@Stuid,@LogTime,@Logtimeout,@Location,@StuName);SET @AttID = SCOPE_IDENTITY()";

            SqlParameter[] cmdParams = initmod.GetParameters(exAttendance);
            return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams)));
        }
コード例 #2
0
 public int insert(M_ExAttendance model)
 {
     return(Sql.insert(strTableName, model.GetParameters(model), model.GetParas(), model.GetFields()));
 }
コード例 #3
0
 public bool GetUpdate(M_ExAttendance model)
 {
     return(Sql.UpdateByIDs(strTableName, PK, model.AttID.ToString(), model.GetFieldAndPara(), model.GetParameters(model)));
 }