예제 #1
0
 public object AddQuerySchemaName(QuerySchemaModel model)
 {
     return(SqlHelper.ExecuteScalar(@" insert into  SJUserQuerySchema(UserId,SchemaSeq,SchemaName) 
                                       values(@UserId,@SchemaSeq,@SchemaName);
                                         SELECT @@IDENTITY AS R;",
                                    new SqlParameter[] { new SqlParameter("UserId", model.UserId),
                                                         new SqlParameter("@SchemaSeq", model.SchemaSeq),
                                                         new SqlParameter("@SchemaName", model.SchemaName) }));
 }
예제 #2
0
 public int AddQuerySchemaName(QuerySchemaModel model)
 {
     return(Convert.ToInt32(dal.AddQuerySchemaName(model)));
 }